namespace VECV_WebApi.Models.Ticket
{
  using DocumentFormat.OpenXml;
  using DocumentFormat.OpenXml.Packaging;
  using DocumentFormat.OpenXml.Spreadsheet;
  using LoggingHelper;
  #region Namespaces

  using System;
  using System.Collections.Generic;
  using System.ComponentModel.DataAnnotations;
  using System.Configuration;
  using System.Data;
  using System.Diagnostics;
  using System.IO.IsolatedStorage;
  using System.Linq;
  using System.Reflection;
  using System.Web;

  #endregion

  #region Model Classes

  public class ConsolidatedReportModelClosed
  {
    public string ticketid_alias { get; set; }
    public string call_assigned_to { get; set; }
    public string created_by { get; set; }
    //[DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:dd MMM yyyy HH:mm:ss}")]
    //public DateTime creation_time { get; set; }
    public string creation_time { get; set; }
    public string time_slot { get; set; }
    public string customer_name { get; set; }
    public string customer_contact_no { get; set; }
    public string organization { get; set; }
    public string state { get; set; }
    public string city { get; set; }
    public string language_name { get; set; }
    public string owner_name { get; set; }
    public string owner_contact_number { get; set; }
    public string customer_vehicle_regn_no { get; set; }
    public string vehicle_name { get; set; }
    public string vehicle_type { get; set; }
    public string chassis_number { get; set; }
    public string vehicle_instalation_date { get; set; }
    public string breakdown_location { get; set; }
    public string landmark { get; set; }
    public string warranty { get; set; }
    public string how_did_you_come_to_know_of_eos { get; set; }
    public string type_of_load_carried { get; set; }
    public string nature_of_problem { get; set; }
    public string estimated_cost_string
    {
      get
      {
        if (Convert.ToString(call_assigned_to).ToLower().Trim() != "dealer")
          return estimated_cost;
        else
          return "NA";
      }
      set
      { }
    }
    public string estimated_time_string
    {
      get
      {
        if (Convert.ToString(call_assigned_to).ToLower().Trim() != "dealer")
          return estimated_time;
        else
          return "NA";
      }
      set
      { }

    }
    public string dealer_code { get; set; }
    public string dealer_name { get; set; }
    /// <summary>
    /// get or set wm name
    /// </summary>
    public string wm_name { get; set; }
    public string dealer_contact_no { get; set; }
    public string eos_team_member_and_van { get; set; }
    public string open_call_hrs { get; set; }
    public string time_stamps_status_1 { get; set; }
    public string time_stamps_status_3 { get; set; }
    public string time_stamps_status_4 { get; set; }
    public string time_stamps_status_5 { get; set; }
    public string escalation_level_van_not_move_1 { get; set; }
    public string escalation_level_ticket_closer_1 { get; set; }
    public string call_closure_status { get; set; }//reason for 24 hrs
    public string KmCovered { get; set; }
    public string feedback_taken { get; set; }//feedback
    public string feedback_ease_of_getting_call { get; set; }
    public string feedback_response_of_call_center { get; set; }
    public string feedback_timely_updation_by_dealer { get; set; }
    public string feedback_total_repair_time { get; set; }
    public string feedback_eos_charges { get; set; }
    public string feedback_over_all_experience { get; set; }
    public string closure_remarks { get; set; }
    public string response_string
    {
      get
      {
        if (Convert.ToString(call_assigned_to).ToLower().Trim() != "dealer")
          return response;
        else
          return "NA";
      }
      set
      { }
    }
    public string feedback_count { get; set; }
    public string call_status { get; set; }
    public string complaints { get; set; }
    public string suggestion { get; set; }
    public string feedback_agent { get; set; }
    public string other_remarks { get; set; }
    public string DealerTicketOtherRemark { get; set; }
    public string estimated_distance { get; set; }

    public string van_covered_distance { get; set; }

    public string trip_start_time { get; set; }

    public string trip_end_time { get; set; }



    public string _eicher_promise { get; set; }
    public string opportunity_loss { get; set; }
    public string opportunity_loss_remark { get; set; }
    public string opportunity_lost_remarks { get; set; }

    public string remark_ticket_not_closed_24_hours { get; set; }

    public string remark_ticket_not_closed_24_hours_remarks { get; set; }
    public int reopen_count { get; set; }
    public string ChassisNo { get; set; }
    public double OdometerReading { get; set; }

    public string _call_closed_within_24_hours { get; set; }
    //public string Region { get; set; }
    public string load_carried { get; set; }
    public string feedback_parameter_wise_score { get; set; }
    public string total_inbound_calls { get; set; }
    public string total_outbound_calls { get; set; }
    public string time_stamps_status_2 { get; set; }
    public string escalation_level_van_not_move_2 { get; set; }
    public string escalation_level_van_not_move_3 { get; set; }
    public string escalation_level_van_not_move_4 { get; set; }
    public string escalation_level_van_not_move_5 { get; set; }
    public string escalation_level_van_not_move_6 { get; set; }
    public string escalation_level_van_not_move_7 { get; set; }
    public string escalation_level_van_not_move_8 { get; set; }
    public string escalation_level_van_not_move_9 { get; set; }
    public string escalation_level_van_not_move_10 { get; set; }
    public string escalation_level_ticket_closer_2 { get; set; }
    public string escalation_level_ticket_closer_3 { get; set; }
    public string escalation_level_ticket_closer_4 { get; set; }
    public string escalation_level_ticket_closer_5 { get; set; }
    public string escalation_level_ticket_closer_6 { get; set; }
    public string escalation_level_ticket_closer_7 { get; set; }
    public string escalation_level_ticket_closer_8 { get; set; }
    public string escalation_level_ticket_closer_9 { get; set; }
    public string escalation_level_ticket_closer_10 { get; set; }
    public string month_name { get; set; }
    public string default_sla_time { get; set; }

    public string region { get; set; }
    public string vehicle_model { get; set; }
    public List<kendoChartModel> CloseTicketCountInTimeSlot { get; set; }
    public string estimated_time { get; set; }
    public string response { get; set; }
    public string estimated_cost { get; set; }
    public string ticket_id { get; set; }

    /// <summary>
    /// Get or set last updated time(for consolidate report)
    /// </summary>
    [Display(Name = "Reassignment Date and Time")]
    public string last_Updated_Time { get; set; }

    /// <summary>
    /// Get or set are_you_satisfied
    /// </summary>
    [Display(Name = "Overall Customer Satisfied")]
    public string are_you_satisfied { get; set; }
    /// <summary>
    /// Get or set not_satisfied_option
    /// </summary>
    [Display(Name = "Reason for dissatisfaction")]
    public string not_satisfied_option { get; set; }
    /// <summary>
    /// Get or set not_satisfied_reason
    /// </summary>
    [Display(Name = "Feedback Comments")]
    public string not_satisfied_reason { get; set; }

    public double? response_time_reassignment { get; set; }


    //added on 03/12/2020
    public string vehicle_warranty { get; set; }
    public string vehicle_amc { get; set; }
    public string vehicle_emission_norms { get; set; }
    public string vehicle_sales_date { get; set; }
    //ended on 03/12/2020

    public string van_reached_punch_time { get; set; } //added on 23-12-2020

    public string ticket_closed_reason { get; set; }   //added on 25-11-2020
    [Display(Name = "Location change Reassignment Date and Time")]
    public string location_change_time { get; set; }

    [Display(Name = "Is Location changed")]
    public string is_location_change { get; set; }

    [Display(Name = "Dealer Change Reason")]
    public string dealer_change_reason { get; set; }

    [Display(Name = "Dealer Change Reason Remarks")]
    public string dealer_change_reason_other_remark { get; set; }

    [Display(Name = "Vehicle Status")]
    public string vehicle_status { get; set; }
    [Display(Name = "Fuel Type")]
    public string fuel_type { get; set; }

    public string breakdown_latitude { get; set; }

    public string breakdown_longitude { get; set; }

  }


  public class WhatupAPIModel
  {
    public string templateId { get; set; }
    public string mobileNumber { get; set; }
    public int? Status { get; set; }

    public string Message { get; set; }
  }
    public class WhatupModel
  {

    
    public string Token { get; set; }
    public string MobileNumber { get; set; }

    public double Latitude { get; set; }

    public double Longitude { get; set; }
    public int? Status { get; set; }

    public string Message { get; set; }
    public string errorMessage { get; set; }
  }

  /// <summary>
  /// This class contain customer ehicle properties
  /// </summary>
  public class CustomerVehicleModel
  {
    /// <summary>
    /// Get or set token
    /// </summary>
    public string Token { get; set; }

    /// <summary>
    /// Get or set Status
    /// </summary>
    public int? Status { get; set; }

    /// <summary>
    /// Get or set  Utc Minute
    /// </summary>
    public int? UtcMinute { get; set; }

    /// <summary>
    /// Get or set  Message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// Get or set Ticket No
    /// </summary>
    public string TicketNo { get; set; }

    /// <summary>
    /// Get or set  Customer Id
    /// </summary>
    public string CustomerId { get; set; }

    /// <summary>
    /// Get or set Customer Name
    /// </summary>
    public string CustomerName { get; set; }

    /// <summary>
    /// Get or set Customer Alias
    /// </summary>
    public string CustomerAlias { get; set; }

    /// <summary>
    /// Get or set CustomerMobile1
    /// </summary>
    public string CustomerMobile1 { get; set; }

    /// Get or set CustomerMobile2
    /// </summary>
    public string CustomerMobile2 { get; set; }

    /// <summary>
    /// Get or set CustomerMobile3
    /// </summary>
    public string CustomerMobile3 { get; set; }

    /// <summary>
    /// Get or set CustomerAddress
    /// </summary>
    public string CustomerAddress { get; set; }

    /// <summary>
    /// Get or set CustomerEmailId
    /// </summary>
    public string CustomerEmailId { get; set; }

    /// <summary>
    /// Get or set CustomerCity
    /// </summary>
    public string CustomerCity { get; set; }

    /// <summary>
    /// Get or set CustomerState
    /// </summary>
    public string CustomerState { get; set; }

    /// <summary>
    /// Get or set CustomerVehicleCustomerId
    /// </summary>
    public string CustomerVehicleCustomerId { get; set; }

    /// <summary>
    /// Get or set CustomerVehicleVehicleId
    /// </summary>
    public string CustomerVehicleVehicleId { get; set; }

    /// <summary>
    /// Get or set CustomerVehicleIsOwnwer
    /// </summary>
    public Boolean? CustomerVehicleIsOwnwer { get; set; }

    /// <summary>
    /// Get or set VehicleId
    /// </summary>
    public string VehicleId { get; set; }

    /// <summary>
    /// Get or set VehicleRegistrationNumber
    /// </summary>
    public string VehicleRegistrationNumber { get; set; }

    /// <summary>
    /// Get or set VehicleNumberPlate
    /// </summary>
    public string VehicleNumberPlate { get; set; }

    /// <summary>
    /// Get or set VehicleModelNumber
    /// </summary>
    public string VehicleModelNumber { get; set; }

    /// <summary>
    /// Get or set Vehicle Type
    /// </summary>
    public string VehicleType { get; set; }
  }

  public class Response
  {
    public VehicleData[] vehicleData { get; set; }
    public string errorMessage { get; set; }
  }


  public class VehicleData
  {
    public string vehicleNo { get; set; }
    public string chassisNo { get; set; }
    public double latitude { get; set; }
    public double longitude { get; set; }
    public string deviceStatus { get; set; }
    public long lastUpdated { get; set; }
    public double vehicleSpeed { get; set; }
    public string lifeTimeFuelLtr { get; set; }
    public double engineOperatingHours { get; set; }
    public double odometer { get; set; }
    public double heading { get; set; }
    public double fuelLevelInPer { get; set; }
    public double fuelLevelInLtr { get; set; }
    public double defLevelInLtr { get; set; }
    public string deviceId { get; set; }
  }
  public class DeviceData
  {
    public string DeviceId { get; set; }
    public string EDateTime { get; set; }
    public string MainInputVoltage { get; set; }
    public string vehicleBattery { get; set; }
  }

  public class Telematic_Model
  {

    public string status { get; set; }
    public string latitude { get; set; }
    public string longitude { get; set; }
    public string chassis_no { get; set; }
    public string positionDateTime { get; set; }
    public string odometer { get; set; }
    public string lastdate { get; set; }

  }




  public class Telematic_Model_new
  {

    public string status { get; set; }
    public string latitude { get; set; }
    public string longitude { get; set; }
    public string chassis_no { get; set; }
    public string positionDateTime { get; set; }
    // public DateTime positionDateTime { get; set; }
    public string odometer { get; set; }
    public string lastdate { get; set; }

  }


  /// <summary>
  /// This class contain open ticket properties
  /// </summary>
  public class TicketOpenModel
  {

    /// </summary>
    [Display(Name = "ASM")]
    public string ASMName { get; set; }
    /// <summary>
    /// Get or set Customer Contact No.
    /// </summary>
    [Display(Name = "ASM Contact No.")]
    public string ASMNo { get; set; }
    /// <summary>
    /// Get or set customer name
    /// </summary>
    [Display(Name = "CSM")]
    public string CSMName { get; set; }
    /// <summary>
    /// Get or set Customer Contact No.
    /// </summary>
    [Display(Name = "CSM Contact No.")]
    public string CSMNo { get; set; }
    /// <summary>
    /// Get or set customer name
    /// </summary>
    [Display(Name = "RSM")]
    public string RSMName { get; set; }
    /// <summary>
    /// Get or set Customer Contact No.
    /// </summary>
    [Display(Name = "RSM Contact No.")]
    public string RSMNo { get; set; }

    [Display(Name = "Dealer 1s code")]
    public string dealer1scode { get; set; }
    private string _PreClosureTime = "";
    /// <summary>
    /// Get or set Token
    /// </summary>
    public String Token { get; set; }

    /// <summary>
    /// Get or set KAM Id
    /// </summary>
    public string KamId { get; set; }

    /// <summary>
    /// Get or set ticket id alias
    /// </summary>
    public string ticketid_alias { get; set; }

    //--- added on 06-01-2020 start -----------

    //public string vehicle_warranty { get; set; }

    //public string vehicle_amc { get; set; }

    public double odometer_reading { get; set; }

    //public string vehicle_sales_date { get; set; }

    public string ticket_source { get; set; }

    public string customer_id { get; set; }

    public string customer_type { get; set; }

    public string owner_name { get; set; }

    public Boolean? is_kam { get; set; }

    public string NewVehicleType { get; set; }  //added on 11-01-2021

    //--- added on 06-01-2020 end -------------

    /// <summary>
    /// Get or set Status
    /// </summary>
    public string Status { get; set; }

    /// <summary>
    /// Get or set Message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// Get or set Id
    /// </summary>
    public string Id { get; set; }

    /// <summary>
    /// Get or set Description
    /// </summary>
    public string Description { get; set; }

    /// <summary>
    /// Get or set Assigned To
    /// </summary>
    public string AssignedTo { get; set; }

    /// <summary>
    /// Get or set Reported Via
    /// </summary>
    public string ReportedVia { get; set; }

    /// <summary>
    /// Get or set Ticket Status
    /// </summary>
    public int? TicketStatus { get; set; }

    /// <summary>
    /// Get or set Priority
    /// </summary>
    public int? Priority { get; set; }

    /// <summary>
    /// Get or set Cutomer Score
    /// </summary>
    public string CutomerScore { get; set; }

    /// <summary>
    /// Get or set Created By
    /// </summary>
    public string CreatedBy { get; set; }

    /// <summary>
    /// Get or set Creation Time
    /// </summary>
    public string CreationTime { get; set; }

    /// <summary>
    /// Get or set Last Modified By
    /// </summary>
    public string LastModifiedBy { get; set; }

    /// <summary>
    /// Get or set Last Modified Time
    /// </summary>
    public string LastModifiedTime { get; set; }

    /// <summary>
    /// Get or set Break Down Location
    /// </summary>
    public string BreakDownLocation { get; set; }

    /// <summary>
    /// Get or set Breack Down Longitude
    /// </summary>
    public string BreackDownLongitude { get; set; }

    /// <summary>
    /// Get or set Breack Down Latitude
    /// </summary>
    public string BreackDownLatitude { get; set; }

    /// <summary>
    /// Get or set Assigned To User Id
    /// </summary> 
    public string AssignedToUserId { get; set; }

    /// <summary>
    /// Get or set Assigned To User Longitude
    /// </summary>
    public string AssignedToUserLongitude { get; set; }

    /// <summary>
    /// Get or set Assigned To User Latitude
    /// </summary>
    public string AssignedToUserLatitude { get; set; }

    /// <summary>
    /// Get or set Is Declined
    /// </summary>
    public Boolean? IsDeclined { get; set; }

    /// <summary>
    /// Get or set Estimated Time For Job Complition
    /// </summary>
    public int? EstimatedTimeForJobComplition { get; set; }

    /// <summary>
    /// Get or set Total Ticket Life Cycle Time Slab
    /// </summary>
    public int? TotalTicketLifeCycleTimeSlab { get; set; }

    /// <summary>
    /// Get or set Estimated Time For Job Complition Submit Time
    /// </summary>
    public string EstimatedTimeForJobComplitionSubmitTime { get; set; }

    /// <summary>
    /// Get or set Vehicle Registration No
    /// </summary>
    public string VehicleRegistrationNo { get; set; }

    /// <summary>
    /// Get or set Estimated Time For Job Completion Submit Time
    /// </summary>
    public string EstimatedTimeForJobCompletionSubmitTime { get; set; }

    /// <summary>
    /// Get or set Break down Location Landmark
    /// </summary>
    public string BreakdownLocationLandmark { get; set; }

    /// <summary>
    /// Get or set Activity Tickets Open Created By
    /// </summary>
    public string ActivityTicketsOpenCreatedBy { get; set; }

    /// <summary>
    /// Get or set Activity Tickets Open Creation Time
    /// </summary>
    public string ActivityTicketsOpenCreationTime { get; set; }

    /// <summary>
    /// Get or set Remarks
    /// </summary>
    public string Remarks { get; set; }

    /// <summary>
    /// Get or set Ticket Activity Status
    /// </summary>
    public string TicketActivityStatus { get; set; }

    /// <summary>
    /// Get or set Ticket Status Alias
    /// </summary> 
    public string TicketStatusAlias { get; set; }

    /// <summary>
    /// Get or set Ticket Status Sequence Order
    /// </summary>
    public string TicketStatusSequenceOrder { get; set; }

    /// <summary>
    /// Get or set Ticket Status  Name
    /// </summary>
    public string TicketStatusStatusName { get; set; }

    /// <summary>
    /// Get or set User Id
    /// </summary>
    public string UserId { get; set; }

    /// <summary>
    /// Get or set Auth Engine Id
    /// </summary>
    public string AuthEngineId { get; set; }

    /// <summary>
    /// Get or set User Name
    /// </summary>
    public string UserName { get; set; }

    /// <summary>
    /// Get or set Designation
    /// </summary>
    public string Designation { get; set; }

    /// <summary>
    /// Get or set Object Id
    /// </summary>
    public string ObjectId { get; set; }

    /// <summary>
    /// Get or set Organization Id
    /// </summary>
    public int? OrganizationId { get; set; }

    /// <summary>
    /// Get or set City
    /// </summary>
    public string City { get; set; }

    /// <summary>
    /// Get or set State
    /// </summary>
    public string State { get; set; }

    /// <summary>
    /// Get or set Region
    /// </summary>
    public string Region { get; set; }

    /// <summary>
    /// Get or set Language
    /// </summary>
    public string Language { get; set; }

    /// <summary>
    /// Get or set Timezone Id
    /// </summary>
    public Int64? TimezoneId { get; set; }

    /// <summary>
    /// Get or set Display Name
    /// </summary>
    public string DisplayName { get; set; }

    /// <summary>
    /// Get or set Offset In Minutes
    /// </summary>
    public string OffsetInMinutes { get; set; }

    /// <summary>
    /// Get or set Display Id
    /// </summary>
    public string DisplayId { get; set; }

    /// <summary>
    /// Get or set User Organization Name
    /// </summary>
    public string UserOrganizationName { get; set; }

    /// <summary>
    /// Get or set User Organization Alias
    /// </summary>
    public string UserOrganizationAlias { get; set; }

    /// <summary>
    /// Get or set User Organization City
    /// </summary>
    public string UserOrganizationCity { get; set; }

    /// <summary>
    /// Get or set User Organization State
    /// </summary>
    public string UserOrganizationState { get; set; }

    /// <summary>
    /// Get or set User Asorganization Country
    /// </summary>
    public string UserAsorganizationCountry { get; set; }

    /// <summary>
    /// Get or set User Organization Description
    /// </summary>
    public string UserOrganizationDescription { get; set; }

    /// <summary>
    /// Get or set User Org Path
    /// </summary>
    public string UserOrgPath { get; set; }

    /// <summary>
    /// Get or set User Org Depth
    /// </summary>
    public string UserOrgDepth { get; set; }

    /// <summary>
    /// Get or set User Org Color
    /// </summary>
    public string UserOrgColor { get; set; }

    /// <summary>
    /// Get or set User Organization Region
    /// </summary>
    public string UserOrganizationRegion { get; set; }

    /// <summary>
    /// Get or set Dealer Id
    /// </summary>
    public string DealerId { get; set; }

    /// <summary>
    /// Get or set Organization Id
    /// </summary>
    public int? DealerOrganizationId { get; set; }

    /// <summary>
    /// Get or set Dealer Name
    /// </summary>
    public string DealerDealerName { get; set; }

    /// <summary>
    /// Get or set Dealer City
    /// </summary>
    public string DealerCity { get; set; }

    /// <summary>
    /// Get or set Dealer State
    /// </summary> 
    public string DealerState { get; set; }

    /// <summary>
    /// Get or set Dealer Default Lattitude 
    /// </summary>
    public string DealerDealerDefaultLattitude { get; set; }

    /// <summary>
    /// Get or set Dealer Default Longitude
    /// </summary>
    public string DealerDealerDefaultLongitude { get; set; }

    /// <summary>
    /// Get or set Van Id
    /// </summary>
    public string VanId { get; set; }

    /// <summary>
    /// Get or set Van Alias
    /// </summary>
    public string VanAlias { get; set; }

    /// <summary>
    /// Get or set Van Default Lattitude
    /// </summary>
    public string VanVanDefaultLattitude { get; set; }

    /// <summary>
    /// Get or set Van Default Longitude
    /// </summary>
    public string VanVanDefaultLongitude { get; set; }

    /// <summary>
    /// Get or set Van City
    /// </summary>
    public string VanCity { get; set; }

    /// <summary>
    /// Get or set Van State
    /// </summary>
    public string VanState { get; set; }

    /// <summary>
    /// Get or set Van Model
    /// </summary>
    public string VanVanModel { get; set; }

    /// <summary>
    /// Get or set Van Registration Number
    /// </summary>
    public string VanRegistrationNumber { get; set; }

    /// <summary>
    /// Get or set Van Registered As
    /// </summary>
    public string VanVanRegisteredAs { get; set; }

    /// <summary>
    /// Get or set Organization Name
    /// </summary>
    public string DealerVanOrganizationName { get; set; }

    /// <summary>
    /// Get or set Organization Alias
    /// </summary>
    public string DealerVanOrganizationOrganizationAlias { get; set; }

    /// <summary>
    /// Get or set Organization City
    /// </summary>
    public string DealerVanOrganizationOrganizationCity { get; set; }

    /// <summary>
    /// Get or set Organization State
    /// </summary>
    public string DealerVanOrganizationOrganizationState { get; set; }

    /// <summary>
    /// Get or set Organization Country
    /// </summary>
    public string DealerVanOrganizationOrganizationCountry { get; set; }

    /// <summary>
    /// Get or set Organization Description
    /// </summary>
    public string DealerVanOrganizationOrganizationDescription { get; set; }

    /// <summary>
    /// Get or set Organization Path
    /// </summary>
    public string DealerVanOrganizationOrganizationPath { get; set; }

    /// <summary>
    /// Get or set Organization Depth
    /// </summary>
    public string DealerVanOrganizationOrganizationDepth { get; set; }

    /// <summary>
    /// Get or set Organization Color
    /// </summary>
    public string DealerVanOrganizationOrganizationColor { get; set; }

    /// <summary>
    /// Get or set Organization Region
    /// </summary>
    public string DealerVanOrganizationOrganizationRegion { get; set; }

    /// <summary>
    /// Get or set Service Engineer Id
    /// </summary>
    public string ServiceEngineerId { get; set; }

    /// <summary>
    /// Get or set Service Engineer Name
    /// </summary>
    public string ServiceEngineerName { get; set; }

    /// <summary>
    /// Get or set Service Engineer Alias
    /// </summary>
    public string ServiceEngineerAlias { get; set; }

    /// <summary>
    /// Get or set Service Engineer Imei Number
    /// </summary>
    public string ServiceEngineerImeiNumber { get; set; }

    /// <summary>
    /// Get or set Service Engineer Contact Number
    /// </summary>
    public string ServiceEngineerContactNumber { get; set; }

    /// <summary>
    /// Get or set Service Engineer Application License Key
    /// </summary>
    public string ServiceEngineerApplicationLicenseKey { get; set; }

    /// <summary>
    /// Get or set Service Engineer Mobile Application Blocked
    /// </summary>
    public Boolean? ServiceEngineerMobileApplicationBlocked { get; set; }

    /// <summary>
    /// Get or set Service Engineer Device Alias
    /// </summary>
    public Int64? ServiceEngineerDeviceAlias { get; set; }

    /// <summary>
    /// Get or set Service Engineer Pin Password
    /// </summary>
    public string ServiceEngineerPinPassword { get; set; }

    /// <summary>
    /// Get or set Route Id
    /// </summary>
    public int? RouteId { get; set; }

    /// <summary>
    /// Get or set Custome Contact_no
    /// </summary>
    public string CustomeContact_no { get; set; }

    /// <summary>
    /// Get or set Vehicle Type
    /// </summary>
    public string VehicleType { get; set; }

    /// <summary>
    /// Get or set Repair Cost
    /// </summary>
    public string RepairCost { get; set; }

    /// <summary>
    /// Get or set Default Sla Time
    /// </summary>
    public int? DefaultSlaTime { get; set; }

    /// <summary>
    /// Get or set Device Alias
    /// </summary>
    public int? DeviceAlias { get; set; }

    /// <summary>
    /// Get or set Iemi number
    /// </summary>
    public string Ieminumber { get; set; }

    /// <summary>
    /// Get or set Sla Missed Reason
    /// </summary>
    public string SlaMissedReason { get; set; }

    /// <summary>
    /// Get or set Suggestion Comment
    /// </summary>
    public string SuggestionComment { get; set; }

    /// <summary>
    /// Get or set Job Complete Response Time
    /// </summary>
    public string JobCompleteResponseTime { get; set; }

    /// <summary>
    /// Get or set Default Col 2
    /// </summary>
    public string DefaultCol2 { get; set; }

    /// <summary>
    /// Get or set Default Col 3
    /// </summary>
    public string DefaultCol3 { get; set; }

    /// <summary>
    /// Get or set Vehicle Tagging
    /// </summary>
    public string VehicleTagging { get; set; }

    /// <summary> 
    /// Get or set Customer Name
    /// </summary>
    public string CustomerName { get; set; }
    /// <summary> 
    /// Get or set 
    /// </summary>
    public string EstimatedDistance { get; set; }

    /// <summary> 
    /// Get or set Age(Ticket life cycle time creation to closed time)
    /// </summary>
    public double? Age { get; set; }

    /// <summary>
    /// Get or set Custome Contact_no
    /// </summary>
    public string OwnerContact_no { get; set; }

    /// <summary>
    /// Get or set Custome Contact_no
    /// </summary>
    public string CallStatus { get; set; }

    /// <summary>
    /// Get or set Custome Contact_no
    /// </summary>
    public string caller_language { get; set; }

    /// <summary>
    /// Get or set Security Token
    /// </summary>
    public string feedback_call_status { get; set; }

    /// <summary>
    /// Get or set Status
    /// </summary>
    public string total_count { get; set; }
    public string reopen_count { get; set; }


    /// <summary>
    /// Get or set Message
    /// </summary>
    public string gps_status { get; set; }

    public string PreClosureTime
    {
      get
      {
        if (_PreClosureTime == "01 Jan 0001 05:30:00")
        {
          _PreClosureTime = "";

        }
        return _PreClosureTime;
      }
      set { _PreClosureTime = value; }
    }
    /// <summary>
    /// Get or set Is Deleted
    /// </summary>
    public bool? IsDeleted { get; set; }
    public string Score { get; set; }
    public string current_latitude { get; set; }
    public string current_longitude { get; set; }

    public string ChassisNo { get; set; }
    public double OdometerReading { get; set; }
    //added on 25-09-2020

    public string VanReachedPunchTime { get; set; }    //added on 23-12-2020

    public string VanLatitudeAtTripStart { get; set; }


    //[Display(Name = "Van Trip Start Longitude")]
    public string VanLongitudeAtTripStart { get; set; }

    //[Display(Name = "Van Reached Latitude")]
    public string VanLatitudeAtVanReached { get; set; }

    //[Display(Name = "Van Reached Longitude")]
    public string VanLongitudeAtVanReached { get; set; }

    //[Display(Name = "Van Trip End Latitude")]
    public string VanLatitudeAtTripEnd { get; set; }

    //[Display(Name = "Van Reached Longitude")]
    public string VanLongitudeAtTripEnd { get; set; }

    public string BreakdownLocationLatitude { get; set; }

    public string BreakdownLocationLongitude { get; set; }

    public string TicketClosedReason { get; set; }  //added on 25-11-2020

    //added on 03/12/2020
    public string vehicle_warranty { get; set; }
    public string vehicle_amc { get; set; }
    public string vehicle_emission_norms { get; set; }
    public string vehicle_sales_date { get; set; }
    public string WM_Contact_No { get; set; }
    public string WM_Name { get; set; }
    public string plant_code { get; set; }
    public string caseid { get; set; }


    //ended on 03/12/2020
  }
  public class TicketOpenModelWise
  {

    public List<TicketOpenModel> ModelList { get; set; }
  }
  /// <summary>
  /// contains properties for close ticket details
  /// </summary>
  public class TicketCloseModel
  {
    /// <summary>
    /// Get or set Token
    /// </summary>
    public String Token { get; set; }

    /// <summary>
    /// Get or set Status
    /// </summary>
    public string Status { get; set; }

    /// <summary>
    /// Get or set Message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// Get or set Id
    /// </summary>
    public string Id { get; set; }

    /// <summary>
    /// Get or set Description
    /// </summary>
    public string Description { get; set; }

    /// <summary>
    /// Get or set Assigned To
    /// </summary>
    public string AssignedTo { get; set; }

    /// <summary>
    /// Get or set Reported Via
    /// </summary>
    public string ReportedVia { get; set; }

    /// <summary>
    /// Get or set Ticket Status
    /// </summary>
    public int? TicketStatus { get; set; }

    /// <summary>
    /// Get or set Priority
    /// </summary>
    public int? Priority { get; set; }

    /// <summary>
    /// Get or set Cutomer Score
    /// </summary>
    public string CutomerScore { get; set; }

    /// <summary>
    /// Get or set Created By
    /// </summary>
    public string CreatedBy { get; set; }

    /// <summary>
    /// Get or set Creation Time
    /// </summary>
    public string CreationTime { get; set; }

    /// <summary>
    /// Get or set Last Modified By
    /// </summary>
    public string LastModifiedBy { get; set; }

    /// <summary>
    /// Get or set Last Modified Time
    /// </summary>
    public string LastModifiedTime { get; set; }

    /// <summary>
    /// Get or set Break Down Location
    /// </summary>
    public string BreakDownLocation { get; set; }

    /// <summary>
    /// Get or set Breack Down Longitude
    /// </summary>
    public string BreackDownLongitude { get; set; }

    /// <summary>
    /// Get or set Breack Down Latitude
    /// </summary>
    public string BreackDownLatitude { get; set; }

    /// <summary>
    /// Get or set Assigned To User Id
    /// </summary> 
    public string AssignedToUserId { get; set; }

    /// <summary>
    /// Get or set Assigned To User Longitude
    /// </summary>
    public string AssignedToUserLongitude { get; set; }

    /// <summary>
    /// Get or set Assigned To User Latitude
    /// </summary>
    public string AssignedToUserLatitude { get; set; }

    /// <summary>
    /// Get or set Is Declined
    /// </summary>
    public Boolean? IsDeclined { get; set; }

    /// <summary>
    /// Get or set Estimated Time For Job Complition
    /// </summary>
    public int? EstimatedTimeForJobComplition { get; set; }

    /// <summary>
    /// Get or set Total Ticket Life Cycle Time Slab
    /// </summary>
    public int? TotalTicketLifeCycleTimeSlab { get; set; }

    /// <summary>
    /// Get or set Estimated Time For Job Complition Submit Time
    /// </summary>
    public string EstimatedTimeForJobComplitionSubmitTime { get; set; }

    /// <summary>
    /// Get or set Vehicle Registration No
    /// </summary>
    public string VehicleRegistrationNo { get; set; }

    /// <summary>
    /// Get or set Estimated Time For Job Completion Submit Time
    /// </summary>
    public string EstimatedTimeForJobCompletionSubmitTime { get; set; }

    /// <summary>
    /// Get or set Break down Location Landmark
    /// </summary>
    public string BreakdownLocationLandmark { get; set; }

    /// <summary>
    /// Get or set Activity Tickets Open Created By
    /// </summary>
    public string ActivityTicketsOpenCreatedBy { get; set; }

    /// <summary>
    /// Get or set Activity Tickets Open Creation Time
    /// </summary>
    public string ActivityTicketsOpenCreationTime { get; set; }

    /// <summary>
    /// Get or set Remarks
    /// </summary>
    public string Remarks { get; set; }

    /// <summary>
    /// Get or set Ticket Activity Status
    /// </summary>
    public string TicketActivityStatus { get; set; }

    /// <summary>
    /// Get or set Ticket Status Alias
    /// </summary> 
    public string TicketStatusAlias { get; set; }

    /// <summary>
    /// Get or set Ticket Status Sequence Order
    /// </summary>
    public string TicketStatusSequenceOrder { get; set; }

    /// <summary>
    /// Get or set Ticket Status  Name
    /// </summary>
    public string TicketStatusStatusName { get; set; }

    /// <summary>
    /// Get or set User Id
    /// </summary>
    public string UserId { get; set; }

    /// <summary>
    /// Get or set Auth Engine Id
    /// </summary>
    public string AuthEngineId { get; set; }

    /// <summary>
    /// Get or set User Name
    /// </summary>
    public string UserName { get; set; }

    /// <summary>
    /// Get or set Designation
    /// </summary>
    public string Designation { get; set; }

    /// <summary>
    /// Get or set Object Id
    /// </summary>
    public string ObjectId { get; set; }

    /// <summary>
    /// Get or set Organization Id
    /// </summary>
    public int? OrganizationId { get; set; }

    /// <summary>
    /// Get or set City
    /// </summary>
    public string City { get; set; }

    /// <summary>
    /// Get or set State
    /// </summary>
    public string State { get; set; }

    /// <summary>
    /// Get or set Region
    /// </summary>
    public string Region { get; set; }

    /// <summary>
    /// Get or set Language
    /// </summary>
    public string Language { get; set; }

    /// <summary>
    /// Get or set Timezone Id
    /// </summary>
    public Int64? TimezoneId { get; set; }

    /// <summary>
    /// Get or set Display Name
    /// </summary>
    public string DisplayName { get; set; }

    /// <summary>
    /// Get or set Offset In Minutes
    /// </summary>
    public string OffsetInMinutes { get; set; }

    /// <summary>
    /// Get or set Display Id
    /// </summary>
    public string DisplayId { get; set; }

    /// <summary>
    /// Get or set User Organization Name
    /// </summary>
    public string UserOrganizationName { get; set; }

    /// <summary>
    /// Get or set User Organization Alias
    /// </summary>
    public string UserOrganizationAlias { get; set; }

    /// <summary>
    /// Get or set User Organization City
    /// </summary>
    public string UserOrganizationCity { get; set; }

    /// <summary>
    /// Get or set User Organization State
    /// </summary>
    public string UserOrganizationState { get; set; }

    /// <summary>
    /// Get or set User Asorganization Country
    /// </summary>
    public string UserAsorganizationCountry { get; set; }

    /// <summary>
    /// Get or set User Organization Description
    /// </summary>
    public string UserOrganizationDescription { get; set; }

    /// <summary>
    /// Get or set User Org Path
    /// </summary>
    public string UserOrgPath { get; set; }

    /// <summary>
    /// Get or set User Org Depth
    /// </summary>
    public string UserOrgDepth { get; set; }

    /// <summary>
    /// Get or set User Org Color
    /// </summary>
    public string UserOrgColor { get; set; }

    /// <summary>
    /// Get or set User Organization Region
    /// </summary>
    public string UserOrganizationRegion { get; set; }

    /// <summary>
    /// Get or set Dealer Id
    /// </summary>
    public string DealerId { get; set; }

    /// <summary>
    /// Get or set Organization Id
    /// </summary>
    public int? DealerOrganizationId { get; set; }

    /// <summary>
    /// Get or set Dealer Name
    /// </summary>
    public string DealerDealerName { get; set; }

    /// <summary>
    /// Get or set Dealer City
    /// </summary>
    public string DealerCity { get; set; }

    /// <summary>
    /// Get or set Dealer State
    /// </summary> 
    public string DealerState { get; set; }

    /// <summary>
    /// Get or set Dealer Default Lattitude 
    /// </summary>
    public string DealerDealerDefaultLattitude { get; set; }

    /// <summary>
    /// Get or set Dealer Default Longitude
    /// </summary>
    public string DealerDealerDefaultLongitude { get; set; }

    /// <summary>
    /// Get or set Van Id
    /// </summary>
    public string VanId { get; set; }

    /// <summary>
    /// Get or set Van Alias
    /// </summary>
    public string VanAlias { get; set; }

    /// <summary>
    /// Get or set Van Default Lattitude
    /// </summary>
    public string VanVanDefaultLattitude { get; set; }

    /// <summary>
    /// Get or set Van Default Longitude
    /// </summary>
    public string VanVanDefaultLongitude { get; set; }

    /// <summary>
    /// Get or set Van City
    /// </summary>
    public string VanCity { get; set; }

    /// <summary>
    /// Get or set Van State
    /// </summary>
    public string VanState { get; set; }

    /// <summary>
    /// Get or set Van Model
    /// </summary>
    public string VanVanModel { get; set; }

    /// <summary>
    /// Get or set Van Registration Number
    /// </summary>
    public string VanRegistrationNumber { get; set; }

    /// <summary>
    /// Get or set Van Registered As
    /// </summary>
    public string VanVanRegisteredAs { get; set; }

    /// <summary>
    /// Get or set Organization Name
    /// </summary>
    public string DealerVanOrganizationName { get; set; }

    /// <summary>
    /// Get or set Organization Alias
    /// </summary>
    public string DealerVanOrganizationOrganizationAlias { get; set; }

    /// <summary>
    /// Get or set Organization City
    /// </summary>
    public string DealerVanOrganizationOrganizationCity { get; set; }

    /// <summary>
    /// Get or set Organization State
    /// </summary>
    public string DealerVanOrganizationOrganizationState { get; set; }

    /// <summary>
    /// Get or set Organization Country
    /// </summary>
    public string DealerVanOrganizationOrganizationCountry { get; set; }

    /// <summary>
    /// Get or set Organization Description
    /// </summary>
    public string DealerVanOrganizationOrganizationDescription { get; set; }

    /// <summary>
    /// Get or set Organization Path
    /// </summary>
    public string DealerVanOrganizationOrganizationPath { get; set; }

    /// <summary>
    /// Get or set Organization Depth
    /// </summary>
    public string DealerVanOrganizationOrganizationDepth { get; set; }

    /// <summary>
    /// Get or set Organization Color
    /// </summary>
    public string DealerVanOrganizationOrganizationColor { get; set; }

    /// <summary>
    /// Get or set Organization Region
    /// </summary>
    public string DealerVanOrganizationOrganizationRegion { get; set; }

    /// <summary>
    /// Get or set Service Engineer Id
    /// </summary>
    public string ServiceEngineerId { get; set; }

    /// <summary>
    /// Get or set Service Engineer Name
    /// </summary>
    public string ServiceEngineerName { get; set; }

    /// <summary>
    /// Get or set Service Engineer Alias
    /// </summary>
    public string ServiceEngineerAlias { get; set; }

    /// <summary>
    /// Get or set Service Engineer Imei Number
    /// </summary>
    public string ServiceEngineerImeiNumber { get; set; }

    /// <summary>
    /// Get or set Service Engineer Contact Number
    /// </summary>
    public string ServiceEngineerContactNumber { get; set; }

    /// <summary>
    /// Get or set Service Engineer Application License Key
    /// </summary>
    public string ServiceEngineerApplicationLicenseKey { get; set; }

    /// <summary>
    /// Get or set Service Engineer Mobile Application Blocked
    /// </summary>
    public Boolean? ServiceEngineerMobileApplicationBlocked { get; set; }

    /// <summary>
    /// Get or set Service Engineer Device Alias
    /// </summary>
    public Int64? ServiceEngineerDeviceAlias { get; set; }

    /// <summary>
    /// Get or set Service Engineer Pin Password
    /// </summary>
    public string ServiceEngineerPinPassword { get; set; }
  }

  /// <summary>
  /// This class contain customer ticket history properties
  /// </summary>
  public class CustomerTicketHistory
  {
    /// <summary>
    /// Get or set  Status
    /// </summary>
    public string Status { get; set; }

    /// <summary> 
    /// Get or set Message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// Get or set  List of Open Ticket
    /// </summary>
    public List<TicketOpenModel> ListOpenTicket { get; set; }

    /// <summary>
    /// Get or set  List of close Ticket
    /// </summary>
    public List<TicketCloseModel> ListCloseTicket { get; set; }
  }

  /// <summary>
  /// This class contain ticket status properties
  /// </summary>
  public class TicketStatus
  {
    /// <summary>
    /// Get or set id
    /// </summary>
    public Int64? Id { get; set; }

    /// <summary>
    /// Get or set  alias
    /// </summary>
    public string Alias { get; set; }

    /// <summary>
    /// Get or set Sequence No
    /// </summary>
    public int? SequenceNo { get; set; }

    /// <summary>
    /// Get or set Status Name
    /// </summary>
    public string StatusName { get; set; }

    /// <summary>
    /// Get or set Status
    /// </summary>
    public string Status { get; set; }

    /// <summary>
    /// Get or set Token
    /// </summary>
    public string Token { get; set; }

    /// <summary>
    /// Get or set  Message
    /// </summary>
    public String Message { get; set; }
  }

  /// <summary>
  /// contains properties for van-dealer list
  /// </summary>
  public class VanDealerListStateWise
  {
    /// <summary>
    /// Get or set user id
    /// </summary>
    public int? UserId { get; set; }

    /// <summary>
    /// Get or set state name
    /// </summary>
    public string StateName { get; set; }

    /// <summary>
    /// Get or set limit
    /// </summary>
    public string Limit { get; set; }

    /// <summary>
    /// Get or set dealer van id
    /// </summary>
    public string DealerSCode { get; set; }
    /// <summary>
    /// Get or set dealer van id
    /// </summary>
    public string DealerOrVanContactNo { get; set; }
    /// <summary>
    /// Get or set dealer van id
    /// </summary>
    public string DealerVanId { get; set; }

    /// <summary>
    /// Get or set dealer van name
    /// </summary>
    public string DealerVanName { get; set; }

    /// <summary>
    /// Get or set dealer van latitude
    /// </summary>
    public string DealerVanLattitude { get; set; }

    /// <summary>
    /// Get or set dealer van longitude
    /// </summary>
    public string DealerVanLongitude { get; set; }

    /// <summary>
    /// Get or set dealer van city
    /// </summary>
    public string DealerVanCity { get; set; }

    /// <summary>
    /// Get or set dealer van state
    /// </summary>
    public string DealerVanState { get; set; }

    /// <summary>
    /// Get or set device alias
    /// </summary>
    public string DeviceAlias { get; set; }

    /// <summary>
    /// Get or set no. of assigned ticket
    /// </summary>
    public Int64? NoOfAssignedTicket { get; set; }

    /// <summary>
    /// Get or set remaining time
    /// </summary>
    public string RemainingTime { get; set; }

    /// <summary>
    /// Get or set type
    /// </summary>
    public string Type { get; set; }

    /// <summary>
    /// Get or set device status
    /// </summary>
    public string DeviceStatus { get; set; }

    /// <summary>
    /// Get or set security token
    /// </summary>
    public string Token { get; set; }

    /// <summary>
    /// Get or set status
    /// </summary>
    public string Status { get; set; }

    /// <summary>
    /// Get or set message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// Get or set message
    /// </summary>
    public string Fuel_type { get; set; }
    /// <summary>
    /// Get or set UTC minute
    /// </summary>
    public int UtcMinute { get; set; }
    public bool islocationChange { get; set; }
  }
  public class SVCDetails
  {
    /// <summary>
    /// Get or set KAM ticket id
    /// </summary>
    public string CustomerName { get; set; }
    public string CustomerNumber { get; set; }
    public string Address { get; set; }
    public string isoem { get; set; }
    public string oemName { get; set; }
    public string CreatedBy { get; set; }
    public string creation_time { get; set; }
    public string Quantity { get; set; }


  }
  public class AccidentalDetails
  {
    /// <summary>
    /// Get or set KAM ticket id
    /// </summary>
    public string CustomerName { get; set; }
    public string CustomerNumber { get; set; }
    public string Location { get; set; }
    public string isabulancesupportrequired { get; set; }
    public string isdealersupportrequired { get; set; }

    public string Dealer_Connect { get; set; }
    public string CreatedBy { get; set; }
    public string creation_time { get; set; }
    public string Registration_number { get; set; }



  }


  public class EPSSalesDetails
  {
    /// <summary>
    /// Get or set KAM ticket id
    /// </summary>
    public string CustomerName { get; set; }
    public string CustomerNumber { get; set; }
    public string Location { get; set; }
    public string ProductType { get; set; }
    public string Qunatity { get; set; }

    public string CreatedBy { get; set; }
    public string creation_time { get; set; }
    



  }

  /// <summary>
  /// Get or set ticket id
  /// </summary>
  /// }
  /// <summary>
  /// contains properties for open ticket
  /// </summary>
  /// 
  public class InsertOpenTicket
  {
    /// <summary>
    /// Get or set KAM ticket id
    /// </summary>
    public string KamTicketId { get; set; }
    /// <summary>
    /// Get or set ticket id
    /// </summary>
    public string TicketId { get; set; }

    /// <summary>
    /// Get or set description
    /// </summary>
    public string Description { get; set; }

    /// <summary>
    /// Get or set assigned to 
    /// </summary>
    public string AssignedTo { get; set; }

    /// <summary>
    /// Get or set reported via
    /// </summary>
    public string ReportedVia { get; set; }

    /// <summary>
    /// Get or set ticket status
    /// </summary>
    public int? TicketStatus { get; set; }

    /// <summary>
    /// Get or set priority
    /// </summary>
    public int? Priority { get; set; }

    /// <summary>
    /// Get or set customer score
    /// </summary>
    public string CustomerScore { get; set; }

    /// <summary>
    /// Get or set created by
    /// </summary>
    public string CreatedBy { get; set; }

    /// <summary>
    /// Get or set creation time
    /// </summary>
    public DateTime? CreationTime { get; set; }

    /// <summary>
    /// Get or set last modified by
    /// </summary>
    public string LastModifiedBy { get; set; }

    /// <summary>
    /// Get or set last modified time
    /// </summary>
    public DateTime? LastModifiedTime { get; set; }

    /// <summary>
    /// Get or set breakdown location
    /// </summary>
    public string BreakdownLocation { get; set; }

    /// <summary>
    /// Get or set breakdown longitude
    /// </summary>
    public string BreakdownLongitude { get; set; }

    /// <summary>
    /// Get or set breakdown latitude
    /// </summary>
    public string BreakdownLattitude { get; set; }

    /// <summary>
    /// Get or set assigned to user id
    /// </summary>
    public string AssignedToUserId { get; set; }

    /// <summary>
    /// Get or set assigned to user latitude
    /// </summary>
    public string AssignedToUserLattitude { get; set; }

    /// <summary>
    /// Get or set assigned to user longitude
    /// </summary>
    public string AssignedToUserLongitude { get; set; }

    /// <summary>
    /// Get or set IsDeclined
    /// </summary>
    public Boolean? IsDeclined { get; set; }

    /// <summary>
    /// Get or set estimated time for job completion
    /// </summary>
    public int? EstimatedTimeForJobCompletion { get; set; }

    /// <summary>
    /// Get or set ticket life cycle time
    /// </summary>
    public int? TotalTicketLifecycleTimeSla { get; set; }

    /// <summary>
    /// Get or set estimated time for job completion
    /// </summary>
    public DateTime? EstimatedTimeForJobCompletionSubmitTime { get; set; }

    /// <summary>
    /// Get or set vehicle registration number
    /// </summary>
    //[RegularExpression(@"[a-zA-Z][a-zA-Z]\d\d[a-zA-Z]{1,2}\d\d\d\d", ErrorMessage = "Entered Registration Number format is not valid.")]
    public string VehicleRegistrationNumber { get; set; }

    /// <summary>
    /// Get or set breakdown landmark
    /// </summary>
    public string BreakdownLocationLandmark { get; set; }

    /// <summary>
    /// Get or set route id
    /// </summary>
    public int? RouteId { get; set; }

    /// <summary>
    /// Get or set customer contact number
    /// </summary>
    //[Required(ErrorMessage = "*")]
    [RegularExpression(@"^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$", ErrorMessage = "Entered phone format is not valid.")]
    public string CustomerContactNo { get; set; }

    /// <summary>
    /// Get or set repair cost
    /// </summary>
    public string RepairCost { get; set; }

    /// <summary>
    /// Get or set default sla time
    /// </summary>
    public int? DefaultSlaTime { get; set; }

    /// <summary>
    /// Get or set sla missed reason
    /// </summary>
    public string SlaMissedReason { get; set; }

    /// <summary>
    /// Get or set suggestion comment
    /// </summary>
    public string SuggestionComment { get; set; }

    /// <summary>
    /// Get or set job complete response time
    /// </summary>
    public string JobCompleteResponseTime { get; set; }

    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string DefaultCol2 { get; set; }

    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string DefaultCol3 { get; set; }

    /// <summary>
    /// Get or set security token
    /// </summary>
    public string Token { get; set; }

    /// <summary>
    /// Get or set status
    /// </summary>
    public string Status { get; set; }

    /// <summary>
    /// Get or set message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// Get or set UTC minute
    /// </summary>
    public int UtcMinute { get; set; }

    /// <summary>
    /// Get or set sender id
    /// </summary>
    public string SenderId { get; set; }

    /// <summary>
    /// Get or set state name
    /// </summary>
    public string StateName { get; set; }

    /// <summary>
    /// Get or set city name
    /// </summary>
    public string CityName { get; set; }

    /// <summary>
    /// Get or set caller language
    /// </summary>
    public string CallerLanguage { get; set; }

    /// <summary>
    /// Get or set warrenty
    /// </summary>
    public string Warranty { get; set; }

    /// <summary>
    /// Get or set toll free number source
    /// </summary>
    public string TollFreeeNoSource { get; set; }

    /// <summary>
    /// Get or set opportunity lost
    /// </summary>
    public string OpportunityLost { get; set; }

    /// <summary>
    /// Get or set 24 hrs reason
    /// </summary>
    public string _24HrsReason { get; set; }

    /// <summary>
    /// Get or set Vehicle Tagging like(LMD,BUS,HD)
    /// </summary>
    public string VehicleTagging { get; set; }

    /// <summary>
    /// Get or set distance between brackdown loction and service engg.
    /// </summary>
    public string EstimateDistance { get; set; }

    /// <summary>
    /// Get or set km covered
    /// </summary>
    public double KmCovered { get; set; }

    /// <summary>
    /// Get or set km Ticket Id Alias
    /// </summary>
    public string TicketIdAlias { get; set; }

    public string OtherRemarks { get; set; }

    public string Flag { get; set; }

    public string TicketPrevStatusAliasId { get; set; }


    public string ChassisNo { get; set; }
    public double OdometerReading { get; set; }

    public double PreviousOdometerReading { get; set; }
    public string VehicleType { get; set; }
    public string OdometerUnit { get; set; }
    public string EOSMessage { get; set; }

    //added on 13-07-2020
    /// <summary>
    /// Get or set IsKamUser
    /// </summary> 
    public bool IsKamUser { get; set; }

    ///// <summary>
    ///// Get or set Comments
    ///// </summary>
    public string Comments { get; set; }

    /// <summary>
    /// Get or set reported via
    /// </summary>
    public string TollFreeNoSource { get; set; }

    /// <summary>
    /// Get or set customer contact number
    /// </summary>
    [Required(ErrorMessage = "*")]
    [RegularExpression(@"^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$", ErrorMessage = "Entered phone format is not valid.")]
    public string DriverContactNo { get; set; }

    public string DriverName { get; set; }

    public string VanLatitude { get; set; }

    public string VanLongitude { get; set; }

    //added on 26/11/2020
    public string vehicle_warranty { get; set; }
    public string vehicle_amc { get; set; }
    public string vehicle_emission_norms { get; set; }
    public string vehicle_sales_date { get; set; }
    //ended on 26/11/2020
    public string TicketClosedReason { get; set; }   //added on 25-11-2020

    //added on 2/1/2021
    public string KamChampId { get; set; }
    public string KamChampName { get; set; }
    public string KamChampTel { get; set; }
    public string KamChampEmail { get; set; }
    public string KamRegHId { get; set; }
    public string KamRegHName { get; set; }
    public string KamRegHTel { get; set; }
    public string KamRegHEmail { get; set; }
    public string KamNatHId { get; set; }
    public string KamNatHName { get; set; }
    public string KamNatHTel { get; set; }
    public string KamNatHEmail { get; set; }
    public DateTime positionDateTime { get; set; }//added on 23/06/2021 Telematic insert
                                                  //added on 13-07-2020
    /// <summary>
    /// Get or set IsKamUser
    /// </summary> 
    public Boolean? IsMobileRequest { get; set; }

    public string estimatedVAnReachTime { get; set; }

    /// <summary>
    /// Get or set KAM ticket id
    /// </summary>
    public string preclosure_reason { get; set; }

    /// <summary>
    /// Get or set KAM ticket id
    /// </summary>
    public string TicketStatusAlias { get; set; }

    public string TicketStatusPrevious { get; set; }

    public string DBMData { get; set; }

    public string sendMessage { get; set; }
        //added by mayuri khandelwal on 28 July 2025
        public bool IsEPS { get; set; }
        public string EPS_prod_type { get; set; }

    }


  //---------------added on 23-12-2020(start)-----------------------------
  public class VanReachedTimeModel
  {
    public string Token { get; set; }
    //public string VanReachedTime { get; set; }
    public DateTime? VanReachedTime { get; set; }
    public string TicketIdAlias { get; set; }
    public string Status { get; set; }
    public string Message { get; set; }

  }
  //---------------added on 23-12-2020 (end)----------------------------------


  /// <summary>
  /// This class contain ticket full details properties.
  /// </summary>
  public class CustomerOpenTicketFullDetailsTicketWise
  {
    private string _SuggestionComment = "";
    /// <summary>
    /// Get or set id
    /// </summary>
    public string Id { get; set; }
    /// <summary>
    /// Get or set ticket id
    /// </summary>
    public string KamTicketId { get; set; }
    /// <summary>
    /// Get or set ticket id
    /// </summary>
    public string TicketId { get; set; }
    /// <summary>
    /// Get or set ticket id alias
    /// </summary>
    public string TicketIdAlias { get; set; }
    /// <summary>
    /// Get or set description
    /// </summary>
    public string Description { get; set; }
    /// <summary>
    /// Get or set assigned to 
    /// </summary>
    public string AssignedTo { get; set; }
    /// <summary>
    /// Get or set reported via
    /// </summary>
    public string ReportedVia { get; set; }
    /// <summary>
    /// Get or set ticket status
    /// </summary>
    public int? TicketStatus { get; set; }
    /// <summary>
    /// Get or set priority
    /// </summary>
    public int? Priority { get; set; }
    /// <summary>
    /// Get or set customer source
    /// </summary>
    public string CustomerScore { get; set; }
    /// <summary>
    /// Get or set craeted by
    /// </summary>
    public string CreatedBy { get; set; }
    /// <summary>
    /// Get or set creation time
    /// </summary>
    public string CreationTime { get; set; }
    /// <summary>
    /// Get or set last modified by
    /// </summary>
    public string LastModifiedBy { get; set; }
    /// <summary>
    /// Get or set last modified time
    /// </summary>
    public string LastModifiedTime { get; set; }
    /// <summary>
    /// Get or set Breakdown Location
    /// </summary>
    public string BreakdownLocation { get; set; }
    /// <summary>
    /// Get or set Breakdown longitude
    /// </summary>
    public string BreakdownLongitude { get; set; }
    /// <summary>
    /// Get or set Breakdown latitide
    /// </summary>
    public string BreakdownLattitude { get; set; }
    /// <summary>
    /// Get or set assigned to user id
    /// </summary>
    public string AssignedToUserId { get; set; }
    /// <summary>
    /// Get or set assigned to user latutude
    /// </summary>
    public string AssignedToUserLattitude { get; set; }
    /// <summary>
    /// Get or set assigned to user longitude
    /// </summary>
    public string AssignedToUserLongitude { get; set; }
    /// <summary>
    /// Get or set IsDeclined
    /// </summary>
    public Boolean? Isdeclined { get; set; }
    /// <summary>
    /// Get or set estimated time for job completion
    /// </summary>
    public int? EstimatedTimeForJobCompletion { get; set; }
    /// <summary>
    /// Get or set ticket life cycle time
    /// </summary>
    public int? TotalTicketLifecycleTimeSla { get; set; }
    /// <summary>
    /// Get or set estimated time for job completion submit time
    /// </summary>
    public string EstimatedTimeForJobCompletionSubmitTime { get; set; }
    /// <summary>
    /// Get or set vehicle registration number
    /// </summary>
    public string VehicleRegisterNumber { get; set; }
    /// <summary>
    /// Get or set Breakdown landmark
    /// </summary>
    public string BreakdownLocationLandmark { get; set; }
    /// <summary>
    /// Get or set Breakdown state
    /// </summary>
    public string BreakdownLocationState { get; set; }
    /// <summary>
    /// Get or set Breakdown city
    /// </summary>
    public string BreakdownLocationCity { get; set; }
    /// <summary>
    /// Get or set route id
    /// </summary>
    public int? RouteId { get; set; }
    /// <summary>
    /// Get or set customer conatct number
    /// </summary>
    public string CustomerContactNo { get; set; }
    /// <summary>
    /// Get or set user id
    /// </summary>
    public long? UsersId { get; set; }
    /// <summary>
    /// Get or set user auth engine id
    /// </summary>
    public string UsersAuthEngineId { get; set; }
    /// <summary>
    /// Get or set user name
    /// </summary>
    public string UsersUserName { get; set; }
    /// <summary>
    /// Get or set user designation
    /// </summary>
    public string UsersDesignation { get; set; }
    /// <summary>
    /// Get or set user object id
    /// </summary>
    public string UsersObjectId { get; set; }
    /// <summary>
    /// Get or set user city
    /// </summary>
    public string UsersCity { get; set; }
    /// <summary>
    /// Get or set user state
    /// </summary>
    public string UsersState { get; set; }
    /// <summary>
    /// Get or set user region
    /// </summary>
    public string UsersRegion { get; set; }
    /// <summary>
    /// Get or set user language
    /// </summary>
    public string UsersLanguage { get; set; }
    /// <summary>
    /// Get or set timezone info display name
    /// </summary>
    public string TimezoneInfoDisplayName { get; set; }
    /// <summary>
    /// Get or set user organization name
    /// </summary>
    public string UserOrganizationName { get; set; }
    /// <summary>
    /// Get or set user organization alias
    /// </summary>
    public string UserOrganizationAlias { get; set; }
    /// <summary>
    /// Get or set user organization city
    /// </summary>
    public string UserOrganizationCity { get; set; }
    /// <summary>
    /// Get or set user organization state
    /// </summary>
    public string UserOrganizationState { get; set; }
    /// <summary>
    /// Get or set user organization country
    /// </summary>
    public string UserOrganizationCountry { get; set; }
    /// <summary>
    /// Get or set user organization region
    /// </summary>
    public string UserOrganizationRegion { get; set; }
    /// <summary>
    /// Get or set dealer/van id
    /// </summary>
    public string DealerOrVanId { get; set; }
    /// <summary>
    /// Get or set dealer/van name
    /// </summary>
    public string DealerOrVanName { get; set; }
    /// <summary>
    /// Get or set dealer/van latitude
    /// </summary>
    public string DealerOrVanDefaultLattitude { get; set; }
    /// <summary>
    /// Get or set dealer/van longitude
    /// </summary>
    public string DealerOrVanDefaultLongitude { get; set; }
    /// <summary>
    /// Get or set dealer/van city
    /// </summary>
    public string DealerOrVanCity { get; set; }
    /// <summary>
    /// Get or set dealer/van state
    /// </summary>
    public string DealerOrVanState { get; set; }
    /// <summary>
    /// Get or set ticket status alias
    /// </summary>
    public string TicketStatusAlias { get; set; }
    /// <summary>
    /// Get or set repair cost
    /// </summary>
    public string RepairCost { get; set; }
    /// <summary>
    /// Get or set default sla time
    /// </summary>
    public int? DefaultSlaTime { get; set; }
    /// <summary>
    /// Get or set sla missed reason
    /// </summary>
    public string SlaMissedReason { get; set; }
    /// <summary>
    /// Get or set suggestion comment
    /// </summary>
    public string SuggestionComment
    {
      get
      {
        if (!string.IsNullOrEmpty(_SuggestionComment))
        {
          _SuggestionComment = _SuggestionComment.Replace("/", "");
          _SuggestionComment = _SuggestionComment.Replace(@"\", "");
        }
        return _SuggestionComment;
      }
      set { _SuggestionComment = value; }
    }
    public string TicketClosedReason { get; set; }   //added on 25-11-2020
    /// <summary>
    /// Get or set job complete response time
    /// </summary>
    public string JobCompleteResponseTime { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string DefaultCol2 { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string DefaultCol3 { get; set; }
    /// <summary>
    /// Get or set security token
    /// </summary>
    public string Token { get; set; }
    /// <summary>
    /// Get or set status
    /// </summary>
    public string Status { get; set; }
    /// <summary>
    /// Get or set message
    /// </summary>
    public string Message { get; set; }
    /// <summary>
    /// Get or set UTC minute
    /// </summary>
    public int UtcMinute { get; set; }
    /// <summary>
    /// Get or set openClose ticket status
    /// </summary>
    public string OpenCloseStatus { get; set; }
    /// <summary>
    /// Get or set dealer/service engineer contact number
    /// </summary>
    public string DealerOrServiceEnggContactNumber { get; set; }
    /// <summary>
    /// Get or set opoortunity lost reason
    /// </summary>
    public string OpportunityLossReason { get; set; }
    /// <summary>
    /// Get or set estimated distance
    /// </summary>
    public string EstimatedDistance { get; set; }
    /// <summary>
    /// Get or set dealer name
    /// </summary>
    public string Dealerdealer_name { get; set; }
    /// <summary>
    /// Get or set dealer contact number
    /// </summary>
    public string DealerContactNumber1 { get; set; }
    /// <summary>
    /// Get or set dealer city
    /// </summary>
    public string DealerCity { get; set; }
    /// <summary>
    /// Get or set dealer state
    /// </summary>
    public string DealerState { get; set; }
    /// <summary>
    /// Get or set chasis number
    /// </summary>
    public string ChassisNo { get; set; }
    /// <summary>
    /// Get or set KMs covered
    /// </summary>
    public double? KmCovered { get; set; }
    /// <summary>
    /// Get or set actual distance
    /// </summary>
    public string ActualDistance { get; set; }
    /// <summary>
    /// Get or set WM name
    /// </summary>
    public string WM_Name { get; set; }
    /// <summary>
    /// Get or set dealer id
    /// </summary>
    public string Dealer_Id { get; set; }
    /// <summary>
    /// Get or set vehicle tagging
    /// </summary>
    public string Vehicle_tagging { get; set; }
    /// <summary>
    /// Get or set van device alias
    /// </summary>
    public string Device_Alias { get; set; }
    /// <summary>
    /// Get or set van Caller Language
    /// </summary>
    public string CallerLanguage { get; set; }
    /// <summary>
    /// Get or set van warrenty
    /// </summary>
    public string Warrenty { get; set; }
    /// <summary>
    /// Get or set van Toll Free No Source
    /// </summary>
    public string TollFreeNoSource { get; set; }
    /// <summary>
    /// Get or set Reason For More Than 24 Hrs
    /// </summary>
    public string ReasonForMoreThan24Hrs { get; set; }
    /// <summary>
    /// Get or set Call Status
    /// </summary>
    public string CallStatus { get; set; }
    /// <summary>
    /// Get or set Suggestion Complaint
    /// </summary>
    public string SuggestionComplaint { get; set; }
    /// <summary>
    /// Get or set Driver Name
    /// </summary>
    public string CustomerCustomerName { get; set; }

    public string TripStart { get; set; }

    public string TripEnd { get; set; }

    public double? VanKmCovered { get; set; }

    public string RemarkTicketNotClosed24Hours { get; set; }

    public string current_lat { get; set; }

    public string current_long { get; set; }

    public string ChassisNumber { get; set; }
    public double OdoMeter { get; set; }

    public double PreviousOdometerReading { get; set; }
    public string VehicleType { get; set; }
    //added on 06-05-2020
    public string FeedbackCallStatus { get; set; }


    //added on 27/11/2020
    public string vehicle_warranty { get; set; }
    public string vehicle_amc { get; set; }
    public string vehicle_emission_norms { get; set; }
    public string vehicle_sales_date { get; set; }
    public string customer_type { get; set; }
    //ended on 27/11/2020

    //Mobile OTP CR
    public string OTP { get; set; }
    //Mobile OTP CR

    public string van_reached_punched_time { get; set; } //added on 23-12-2020
  }

  /// <summary>
  /// contains properties for customer open tickets
  /// </summary>
  public class CustomerOpenTicketDetail
  {
    /// <summary>
    /// Get or set ticket id
    /// </summary>
    public string TicketId { get; set; }
    /// <summary>
    /// Get or set ticket id alias
    /// </summary>
    public string TicketIdAlias { get; set; }
    /// <summary>
    /// Get or set description
    /// </summary>
    public string Description { get; set; }
    /// <summary>
    /// Get or set assigned to
    /// </summary>
    public string AssignedTo { get; set; }
    /// <summary>
    /// Get or set reported via
    /// </summary>
    public string ReportedVia { get; set; }
    /// <summary>
    /// Get or set ticket status
    /// </summary>
    public int? TicketStatus { get; set; }
    /// <summary>
    /// Get or set priority
    /// </summary>
    public int? Priority { get; set; }
    /// <summary>
    /// Get or set customer score
    /// </summary>
    public string CustomerScore { get; set; }
    /// <summary>
    /// Get or set created by
    /// </summary>
    public string CreatedBy { get; set; }
    /// <summary>
    /// Get or set creation time
    /// </summary>
    public string CreationTime { get; set; }
    /// <summary>
    /// Get or set last modified by
    /// </summary>
    public string LastModifiedBy { get; set; }
    /// <summary>
    /// Get or set last modified time
    /// </summary>
    public string LastModifiedTime { get; set; }
    /// <summary>
    /// Get or set breakdown location
    /// </summary>
    public string BreakdownLocation { get; set; }
    /// <summary>
    /// Get or set breakdown longitude
    /// </summary>
    public string BreakdownLongitude { get; set; }
    /// <summary>
    /// Get or set breakdown latitude
    /// </summary>
    public string BreakdownLattitude { get; set; }
    /// <summary>
    /// Get or set assigned to user id
    /// </summary>
    public string AssignedToUserId { get; set; }
    /// <summary>
    /// Get or set assigned to user latitude
    /// </summary>
    public string AssignedToUserLattitude { get; set; }
    /// <summary>
    /// Get or set assigned to user longitude
    /// </summary>
    public string AssignedToUserLongitude { get; set; }
    /// <summary>
    /// Get or set IsDeclined bit
    /// </summary>
    public Boolean? Isdeclined { get; set; }
    /// <summary>
    /// Get or set estimated time for job completion
    /// </summary>
    public int? EstimatedTimeForJobCompletion { get; set; }
    /// <summary>
    /// Get or set ticket life cycle time
    /// </summary>
    public int? TotalTicketLifecycleTimeSla { get; set; }
    /// <summary>
    /// Get or set estimated time for job completion submit time
    /// </summary>
    public string EstimatedTimeForJobCompletionSubmitTime { get; set; }
    /// <summary>
    /// Get or set vehicle registration number
    /// </summary>
    public string VehicleRegisterNumber { get; set; }
    /// <summary>
    /// Get or set breakdown landmark
    /// </summary>
    public string BreakdownLocationLandmark { get; set; }
    /// <summary>
    /// Get or set Breakdown state
    /// </summary>
    public string BreakdownLocationState { get; set; }
    /// <summary>
    /// Get or set Breakdown city
    /// </summary>
    public string BreakdownLocationCity { get; set; }
    /// <summary>
    /// Get or set route id
    /// </summary>
    public int? RouteId { get; set; }
    /// <summary>
    /// Get or set customer contact number
    /// </summary>
    public string CustomerContactNo { get; set; }
    /// <summary>
    /// Get or set ticket status alias
    /// </summary>
    public string TicketStatusAlias { get; set; }
    /// <summary>
    /// Get or set repair cost
    /// </summary>
    public string RepairCost { get; set; }
    /// <summary>
    /// Get or set defalut sla time
    /// </summary>
    public int? DefaultSlaTime { get; set; }
    /// <summary>
    /// Get or set sla missed reason
    /// </summary>
    public string SlaMissedReason { get; set; }
    /// <summary>
    /// Get or set suggestion comment
    /// </summary>
    public string SuggestionComment { get; set; }
    /// <summary>
    /// Get or set job complete response time
    /// </summary>
    public string JobCompleteResponseTime { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string DefaultCol2 { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string DefaultCol3 { get; set; }
    /// <summary>
    /// Get or set security token
    /// </summary>
    public string Token { get; set; }
    /// <summary>
    /// Get or set status
    /// </summary>
    public string Status { get; set; }
    /// <summary>
    /// Get or set message
    /// </summary>
    public string Message { get; set; }
    /// <summary>
    /// Get or set UTC minute
    /// </summary>
    public int UtcMinute { get; set; }


    public string Engine_number { get; set; }

    public bool isEPS { get; set; }



    public string van_reached_punch_time { get; set; } //added on 23-12-2020
  }

  /// <summary>
  /// contains properties for Customer Close tickets
  /// </summary>
  public class CustomerCloseTicketDetail
  {
    /// <summary>
    /// Get or set ticket id
    /// </summary>
    public string TicketId { get; set; }
    /// <summary>
    /// Get or set ticket id alias
    /// </summary>
    public string TicketIdAlias { get; set; }
    /// <summary>
    /// Get or set description
    /// </summary>
    public string Description { get; set; }
    /// <summary>
    /// Get or set assinged to 
    /// </summary>
    public string AssignedTo { get; set; }
    /// <summary>
    /// Get or set reported via
    /// </summary>
    public string ReportedVia { get; set; }
    /// <summary>
    /// Get or set ticket status
    /// </summary>
    public int? TicketStatus { get; set; }
    /// <summary>
    /// Get or set priority
    /// </summary>
    public int? Priority { get; set; }
    /// <summary>
    /// Get or set customer score
    /// </summary>
    public string CustomerScore { get; set; }
    /// <summary>
    /// Get or set created by
    /// </summary>
    public string CreatedBy { get; set; }
    /// <summary>
    /// Get or set creation time
    /// </summary>
    public string CreationTime { get; set; }
    /// <summary>
    /// Get or set last modified by
    /// </summary>
    public string LastModifiedBy { get; set; }
    /// <summary>
    /// Get or set last modified time
    /// </summary>
    public string LastModifiedTime { get; set; }
    /// <summary>
    /// Get or set breakdown location
    /// </summary>
    public string BreakdownLocation { get; set; }
    /// <summary>
    /// Get or set breakdown longitude
    /// </summary>
    public string BreakdownLongitude { get; set; }
    /// <summary>
    /// Get or set breakdown latitude
    /// </summary>
    public string BreakdownLattitude { get; set; }
    /// <summary>
    /// Get or set assigned to user id
    /// </summary>
    public string AssignedToUserId { get; set; }
    /// <summary>
    /// Get or set assigned to user latitude
    /// </summary>
    public string AssignedToUserLattitude { get; set; }
    /// <summary>
    /// Get or set assigned to longitude
    /// </summary>
    public string AssignedToUserLongitude { get; set; }
    /// <summary>
    /// Get or set IsDeclined bit
    /// </summary>
    public Boolean? Isdeclined { get; set; }
    /// <summary>
    /// Get or set estimated time for job completion
    /// </summary>
    public int? EstimatedTimeForJobCompletion { get; set; }
    /// <summary>
    /// Get or set ticket life cycle time
    /// </summary>
    public int? TotalTicketLifecycleTimeSla { get; set; }
    /// <summary>
    /// Get or set estimated time for job compeltion submit time
    /// </summary>
    public string EstimatedTimeForJobCompletionSubmitTime { get; set; }
    /// <summary>
    /// Get or set vehicle registration number
    /// </summary>
    public string VehicleRegisterNumber { get; set; }
    /// <summary>
    /// Get or set breakdown landmark
    /// </summary>
    public string BreakdownLocationLandmark { get; set; }
    /// <summary>
    /// Get or set route id
    /// </summary>
    public int? RouteId { get; set; }
    /// <summary>
    /// Get or set customer contact number
    /// </summary>
    public string CustomerContactNo { get; set; }
    /// <summary>
    /// Get or set ticket status alias
    /// </summary>
    public string TicketStatusAlias { get; set; }
    /// <summary>
    /// Get or set repair cost
    /// </summary>
    public string RepairCost { get; set; }
    /// <summary>
    /// Get or set default sla time
    /// </summary>
    public int? DefaultSlaTime { get; set; }
    /// <summary>
    /// Get or set sla missed rason
    /// </summary>
    public string SlaMissedReason { get; set; }
    /// <summary>
    /// Get or set suggestion
    /// </summary>
    public string SuggestionComment { get; set; }
    /// <summary>
    /// Get or set job completed response time
    /// </summary>
    public string JobCompleteResponseTime { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string DefaultCol2 { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string DefaultCol3 { get; set; }
    /// <summary>
    /// Get or set security token
    /// </summary>
    public string Token { get; set; }
    /// <summary>
    /// Get or set status
    /// </summary>
    public string Status { get; set; }
    /// <summary>
    /// Get or set message
    /// </summary>
    public string Message { get; set; }
    /// <summary>
    /// Get or set UTC minute
    /// </summary>
    public int UtcMinute { get; set; }
    /// <summary>
    /// Get or set total ticket closed hours
    /// </summary>
    public double? TotalTicketCloseHours { get; set; }
    /// <summary>
    /// Get or set feedback agent name
    /// </summary>
    public string FeedBackAgenName { get; set; }
    /// <summary>
    /// Get or set call status
    /// </summary>
    public string CallStatus { get; set; }
    /// <summary>
    /// Get or set reason > 24 hrs
    /// </summary>
    public string ReasonBeyond24Hrs { get; set; }

    public string van_reached_punch_time { get; set; } //added on 23-12-2020
    public bool isEPS { get; set; }
    public string Engine_Number { get; set; }



  }

  /// <summary>
  /// contains properties for ticket notifications
  /// </summary>
  public class TicketNotificationModel
  {
    /// <summary>
    /// Get or set id
    /// </summary>
    public string Id { get; set; }
    /// <summary>
    /// Get or set keyname
    /// </summary>
    public string KeyName { get; set; }
    /// <summary>
    /// Get or set key value
    /// </summary>
    public int? KeyValue { get; set; }
    /// <summary>
    /// Get or set ticket status
    /// </summary>
    public int? TicketStatus { get; set; }
    /// <summary>
    /// Get or set security token
    /// </summary>
    public string Token { get; set; }
    /// <summary>
    /// Get or set message
    /// </summary>
    public string Message { get; set; }
  }

  /// <summary>
  /// contains for open + close ticket notification
  /// </summary>
  public class CloseOpenNotification
  {
    /// <summary>
    /// Get or set ticket status
    /// </summary>
    public int? TicketStatus { get; set; }
    /// <summary>
    /// Get or set ticket id
    /// </summary>
    public string TicketId { get; set; }
    /// <summary>
    /// Get or set security token
    /// </summary>
    public string Token { get; set; }
    /// <summary>
    /// Get or set status
    /// </summary>
    public string Status { get; set; }
    /// <summary>
    /// Get or set mesage
    /// </summary>
    public string Message { get; set; }
    /// <summary>
    /// Get or set notification id
    /// </summary>
    public Int64? NotificationId { get; set; }
  }

  /// <summary>
  /// contains properties for ticket notifications
  /// </summary>
  public class TicketNotificationsWithTicketId
  {
    /// <summary>
    /// Get or set ticket id
    /// </summary>
    public string TicketId { get; set; }
    /// <summary>
    /// Get or set ticket id alias
    /// </summary>
    public string TicketIdAlias { get; set; }
    /// <summary>
    /// Get or set ticket status
    /// </summary>
    public int? TicketStatus { get; set; }
    /// <summary>
    /// Get or set ticket status alias
    /// </summary>
    public string TickeStatusAlias { get; set; }
    /// <summary>
    /// Get or set notification time
    /// </summary>
    public string NotificationTime { get; set; }
    /// <summary>
    /// Get or set dealer name
    /// </summary>
    public string DealerDealerName { get; set; }
    /// <summary>
    /// Get or set van id
    /// </summary>
    public string VanId { get; set; }
    /// <summary>
    /// Get or set van registration number
    /// </summary>
    public string VanRegistrationNumber { get; set; }
    /// <summary>
    /// Get or set service engineer name
    /// </summary>
    public string ServiceEngineerName { get; set; }
    /// <summary>
    /// Get or set creation time
    /// </summary>
    public string CreationTime { get; set; }
    /// <summary>
    /// Get or set created by
    /// </summary>
    public string CreatedBy { get; set; }
    /// <summary>
    /// Get or set UTC minute
    /// </summary>
    public int UtcMinute { get; set; }
    /// <summary>
    /// Get or set security token
    /// </summary>
    public string Token { get; set; }
    /// <summary>
    /// Get or set message
    /// </summary>
    public string Message { get; set; }
    /// <summary>
    /// Get or set user id
    /// </summary>
    public int? UserId { get; set; }
    /// <summary>
    /// Get or set notification id
    /// </summary>
    public Int64? NotificationId { get; set; }
  }

  /// <summary>
  /// THis class contain ticket request properties
  /// </summary>
  public class TicketRequestModel
  {
    /// <summary>
    /// Get or set Ticket Type
    /// </summary>
    public string TicketType { get; set; }

    /// <summary>
    /// Get or set KAM Ticket Id
    /// </summary>
    public int KamTicketId
    {
      get; set;
    }

    /// <summary>
    /// Get or set Token
    /// </summary>
    public string Token { get; set; }

    /// <summary>
    /// Get or set Status
    /// </summary>
    public string Status { get; set; }

    /// <summary>
    /// Get or set Message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// Get or set User Id
    /// </summary>
    public int? UserId { get; set; }

    /// <summary>
    /// Get or set User Id
    /// </summary>
    public string KamUserId { get; set; }

    /// <summary>
    /// Get or set From Date
    /// </summary>
    public DateTime FromDate { get; set; }

    /// <summary>
    /// Get or set To Date
    /// </summary>
    public DateTime ToDate { get; set; }

    /// <summary>
    /// Get or set  Limit
    /// </summary>
    public int? Limit { get; set; }

    /// <summary>
    /// Get or set OffSet
    /// </summary>
    public int? OffSet { get; set; }

    /// <summary>
    /// Get or set Ticket List
    /// </summary>
    public List<TicketOpenModel> TicketList { get; set; }

    /// <summary>
    /// Get or set Ticket List
    /// </summary>
    public List<DummyOpenTicketDetail> DummyTicketList { get; set; }

    /// <summary>
    /// Get or set
    /// </summary>
    public List<ConsolidatedReportModel> ConsolidatedReportModelList { get; set; }

    /// <summary>
    /// Get or set
    /// </summary>
    public Int64? TicketCount { get; set; }

    /// <summary>
    /// Get or set
    /// </summary>
    public string Condition { get; set; }

    /// <summary>
    /// Get or set
    /// </summary>
    public int? UtcMinute { get; set; }

    /// <summary>
    /// get or set vehicle type
    /// </summary>
    public string VehicleType { get; set; }

    /// <summary>
    /// get or set organization
    /// </summary>
    public string Organization { get; set; }

    /// <summary>
    /// Get or set Ticket Type
    /// </summary>
    public string StartDate { get; set; }

    /// <summary>
    /// Get or set Ticket Type
    /// </summary>
    public string EndDate { get; set; }


    public string consolidaetype { get; set; }
  }

  /// <summary>
  /// contains property for consolidated report
  /// </summary>
  public class ConsolidatedReportModel
  {
    /// <summary>
    /// Get or set ticket id
    /// </summary>
    public string ticket_id { get; set; }
    /// <summary>
    /// Get or set customer name
    /// </summary>
    public string customer_name { get; set; }
    /// <summary>
    /// Get or set customer contact number
    /// </summary>
    public string customer_contact_no { get; set; }
    /// <summary>
    /// Get or set customer vehicle regitration number
    /// </summary>
    public string customer_vehicle_regn_no { get; set; }
    /// <summary>
    /// Get or set vehicle type
    /// </summary>
    public string vehicle_type { get; set; }
    /// <summary>
    /// Get or set chasis number
    /// </summary>
    public string chassis_number { get; set; }
    /// <summary>
    /// Get or set vehicle installation date
    /// </summary>
    public string vehicle_instalation_date { get; set; }
    /// <summary>
    /// Get or set breakdown location
    /// </summary>
    public string breakdown_location { get; set; }
    /// <summary>
    /// Get or set dwaler code
    /// </summary>
    public string dealer_code { get; set; }
    /// <summary>
    /// Get or set dealer name
    /// </summary>
    public string dealer_name { get; set; }
    /// <summary>
    /// Get or set dealer contact number
    /// </summary>
    public string dealer_contact_no { get; set; }
    /// <summary>
    /// Get or set created by
    /// </summary>
    public string created_by { get; set; }
    /// <summary>
    /// Get or set creation time
    /// </summary>
    public string creation_time { get; set; }
    /// <summary>
    /// Get or set city
    /// </summary>
    public string city { get; set; }
    /// <summary>
    /// Get or set state
    /// </summary>
    public string state { get; set; }
    /// <summary>
    /// Get or set language name
    /// </summary>
    public string language_name { get; set; }
    /// <summary>
    /// Get or set open call hrs
    /// </summary>
    public string open_call_hrs { get; set; }
    /// <summary>
    /// Get or set landmark
    /// </summary>
    public string landmark { get; set; }
    /// <summary>
    /// Get or set warrenty
    /// </summary>
    public string warranty { get; set; }
    /// <summary>
    /// Get or set vehicle model
    /// </summary>
    public string vehicle_model { get; set; }
    /// <summary>
    /// Get or set load carried
    /// </summary>
    public string load_carried { get; set; }
    /// <summary>
    /// Get or set type of load carried
    /// </summary>
    public string type_of_load_carried { get; set; }
    /// <summary>
    /// Get or set call assigned to
    /// </summary>
    public string call_assigned_to { get; set; }
    /// <summary>
    /// Get or set owner name
    /// </summary>
    public string owner_name { get; set; }
    /// <summary>
    /// Get or set owner conatct number
    /// </summary>
    public string owner_contact_number { get; set; }
    /// <summary>
    /// Get or set nature of problem
    /// </summary>
    public string nature_of_problem { get; set; }
    /// <summary>
    /// Get or set estimated cost
    /// </summary>
    public string estimated_cost { get; set; }
    /// <summary>
    /// Get or set estimated time
    /// </summary>
    public string estimated_time { get; set; }
    /// <summary>
    /// Get or set feedback taken
    /// </summary>
    public string feedback_taken { get; set; }
    /// <summary>
    /// Get or set call closure status
    /// </summary>
    public string call_closure_status { get; set; }
    /// <summary>
    /// Get or set feedback Qs no 1
    /// </summary>
    public string how_did_you_come_to_know_of_eos { get; set; }
    /// <summary>
    /// Get or set feedback Qs no 2
    /// </summary>
    public string feedback_parameter_wise_score { get; set; }
    /// <summary>
    /// Get or set feedback Qs no 3
    /// </summary>
    public string feedback_ease_of_getting_call { get; set; }
    /// <summary>
    /// Get or set feedback Qs no 4
    /// </summary>
    public string feedback_response_of_call_center { get; set; }
    /// <summary>
    /// Get or set feedback Qs no 5
    /// </summary>
    public string feedback_timely_updation_by_dealer { get; set; }
    /// <summary>
    /// Get or set feedback total repair time
    /// </summary>
    public string feedback_total_repair_time { get; set; }
    /// <summary>
    /// Get or set feedback eos charges
    /// </summary>
    public string feedback_eos_charges { get; set; }
    /// <summary>
    /// Get or set feedback overall experience
    /// </summary>
    public string feedback_over_all_experience { get; set; }
    /// <summary>
    /// Get or set other remarks
    /// </summary>
    public string other_remarks { get; set; }
    /// <summary>
    /// Get or set feedback agent
    /// </summary>
    public string feedback_agent { get; set; }
    /// <summary>
    /// Get or set total inbound calls
    /// </summary>
    public string total_inbound_calls { get; set; }
    /// <summary>
    /// Get or set total outbound calls
    /// </summary>
    public string total_outbound_calls { get; set; }
    /// <summary>
    /// Get or set time stamp status 1
    /// </summary>
    public string time_stamps_status_1 { get; set; }
    /// <summary>
    /// Get or set time stamp status 2
    /// </summary>
    public string time_stamps_status_2 { get; set; }
    /// <summary>
    /// Get or set time stamp status 3
    /// </summary>
    public string time_stamps_status_3 { get; set; }
    /// <summary>
    /// Get or set time stamp status 4
    /// </summary>
    public string time_stamps_status_4 { get; set; }
    /// <summary>
    /// Get or set time stamp status 5
    /// </summary>
    public string time_stamps_status_5 { get; set; }
    /// <summary>
    /// Get or set escalation level van not move 1
    /// </summary>
    public string escalation_level_van_not_move_1 { get; set; }
    /// <summary>
    /// Get or set escalation level van not move 2
    /// </summary>
    public string escalation_level_van_not_move_2 { get; set; }
    /// <summary>
    /// Get or set escalation level van not move 3
    /// </summary>
    public string escalation_level_van_not_move_3 { get; set; }
    /// <summary>
    /// Get or set escalation level van not move 4
    /// </summary>
    public string escalation_level_van_not_move_4 { get; set; }
    /// <summary>
    /// Get or set escalation level van not move 5
    /// </summary>
    public string escalation_level_van_not_move_5 { get; set; }
    /// <summary>
    /// Get or set escalation level van not move 6
    /// </summary>
    public string escalation_level_van_not_move_6 { get; set; }
    /// <summary>
    /// Get or set escalation level van not move 7
    /// </summary>
    public string escalation_level_van_not_move_7 { get; set; }
    /// <summary>
    /// Get or set escalation level van not move 8
    /// </summary>
    public string escalation_level_van_not_move_8 { get; set; }
    /// <summary>
    /// Get or set escalation level van not move 9
    /// </summary>
    public string escalation_level_van_not_move_9 { get; set; }
    /// <summary>
    /// Get or set escalation level van not move 10
    /// </summary>
    public string escalation_level_van_not_move_10 { get; set; }
    /// <summary>
    /// Get or set escalation level ticket closure 1
    /// </summary>
    public string escalation_level_ticket_closer_1 { get; set; }
    /// <summary>
    /// Get or set escalation level ticket closure 2
    /// </summary>
    public string escalation_level_ticket_closer_2 { get; set; }
    /// <summary>
    /// Get or set escalation level ticket closure 3
    /// </summary>
    public string escalation_level_ticket_closer_3 { get; set; }
    /// <summary>
    /// Get or set escalation level ticket closure 4
    /// </summary>
    public string escalation_level_ticket_closer_4 { get; set; }
    /// <summary>
    /// Get or set escalation level ticket closure 5
    /// </summary>
    public string escalation_level_ticket_closer_5 { get; set; }
    /// <summary>
    /// Get or set escalation level ticket closure 6
    /// </summary>
    public string escalation_level_ticket_closer_6 { get; set; }
    /// <summary>
    /// Get or set escalation level ticket closure 7
    /// </summary>
    public string escalation_level_ticket_closer_7 { get; set; }
    /// <summary>
    /// Get or set escalation level ticket closure 8
    /// </summary>
    public string escalation_level_ticket_closer_8 { get; set; }
    /// <summary>
    /// Get or set escalation level ticket closure 9
    /// </summary>
    public string escalation_level_ticket_closer_9 { get; set; }
    /// <summary>
    /// Get or set escalation level ticket closure 10
    /// </summary>
    public string escalation_level_ticket_closer_10 { get; set; }
    /// <summary>
    /// Get or set month name
    /// </summary>
    public string month_name { get; set; }
    /// <summary>
    /// Get or set default sla time
    /// </summary>
    public string default_sla_time { get; set; }
    /// <summary>
    /// Get or set response
    /// </summary>
    public string response { get; set; }
    /// <summary>
    /// Get or set eos team member and van
    /// </summary>
    public string eos_team_member_and_van { get; set; }
    /// <summary>
    /// Get or set tme slot
    /// </summary>
    public string time_slot { get; set; }
    /// <summary>
    /// Get or set region
    /// </summary>
    public string region { get; set; }
    /// <summary>
    /// Get or set closure remarks
    /// </summary>
    public string closure_remarks { get; set; }
    /// <summary>
    /// Get or set vehicle name
    /// </summary>
    public string vehicle_name { get; set; }
    /// <summary>
    /// Get or set organiation
    /// </summary>
    public string organization { get; set; }
    /// <summary>
    /// get or set call status
    /// </summary>
    public string call_status { get; set; }
    /// <summary>
    /// get or set complaints
    /// </summary>
    public string complaints { get; set; }
    /// <summary>
    /// get or set suggestions
    /// </summary>
    public string suggestion { get; set; }
    /// <summary>
    /// get or set feedback count
    /// </summary>
    public string feedback_count { get; set; }
    /// <summary>
    /// get or set ticket Id alias
    /// </summary>
    public string ticketid_alias { get; set; }
    /// <summary>
    /// get or set wm name
    /// </summary>
    public string wm_name { get; set; }
    /// <summary>
    /// get or set wm name
    /// </summary>
    public string DealerTicketOtherRemark { get; set; }
    public string KmCovered { get; set; }

    public string estimated_distance { get; set; }

    public string van_covered_distance { get; set; }

    public string trip_start_time { get; set; }

    public string trip_end_time { get; set; }

    public string _call_closed_within_24_hours { get; set; }

    public string _eicher_promise { get; set; }

    public string opportunity_loss_remark { get; set; }
    public string opportunity_loss { get; set; }
    public string remark_ticket_not_closed_24_hours { get; set; }
    public int reopen_count { get; set; }
    public string remark_ticket_not_closed_24_hours_remarks { get; set; }
    public string opportunity_lost_remarks { get; set; }
    public string ChassisNo { get; set; }
    public double OdometerReading { get; set; }

    /// <summary>
    /// Get or set last updated time
    /// </summary>
    public string last_Updated_Time { get; set; }


    /// <summary>
    /// Get or set are_you_satisfied
    /// </summary>
    public string are_you_satisfied { get; set; }
    /// <summary>
    /// Get or set not_satisfied_option
    /// </summary>
    public string not_satisfied_option { get; set; }
    /// <summary>
    /// Get or set not_satisfied_reason
    /// </summary>
    public string not_satisfied_reason { get; set; }
    /// <summary>
    /// Get or set response_time_reassignment
    /// </summary>
    public double? response_time_reassignment { get; set; }


    //added on 03/12/2020
    public string vehicle_warranty { get; set; }
    public string vehicle_amc { get; set; }
    public string vehicle_emission_norms { get; set; }
    public string vehicle_sales_date { get; set; }
    //ended on 03/12/2020

    public string van_reached_punch_time { get; set; } //added on 23-12-2020


    public string ticket_closed_reason { get; set; }   //added on 25-11-2020

    public string product_variant_name { get; set; }   //added on 25-11-2020

  }

  #region Offline Model

  /// <summary>
  /// This class is used for insert bulk ticket detail in database
  /// </summary>
  public class OfflineTicket
  {
    /// <summary>
    /// Get or set Token
    /// </summary>
    public string Token { get; set; }

    /// <summary>
    /// Get or set Message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// Get or set status
    /// </summary>
    public string Status { get; set; }

    /// <summary>
    /// Get or set Bulk Ticket Detail
    /// </summary>
    public List<String> BulkTicketDetail { get; set; }

    /// <summary>
    /// get or set Bulk ticket string
    /// </summary>
    public String BulkTicketStr { get; set; }

    /// <summary>
    /// Get or set utc minute
    /// </summary>
    public int UtcMinute { get; set; }
  }

  #endregion

  /// <summary>
  /// contains properties ticket report details
  /// </summary>
  public class TicketReportModel
  {
    /// <summary>
    /// Get or set Token
    /// </summary>
    public String Token { get; set; }

    /// <summary>
    /// Get or set Status
    /// </summary>
    public string Status { get; set; }

    /// <summary>
    /// Get or set Message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// Get or set Id
    /// </summary>
    public string id { get; set; }

    /// <summary>
    /// Get or set Description
    /// </summary>
    public string _customer_customer_name { get; set; }

    /// <summary>
    /// Get or set Assigned To
    /// </summary>
    public int? total_ticket_lifecycle_time_sla { get; set; }

    /// <summary>
    /// Get or set Reported Via
    /// </summary>
    public string customer_contact_no { get; set; }

    /// <summary>
    /// Get or set Ticket Status
    /// </summary>
    public int? default_sla_time { get; set; }

    /// <summary>
    /// Get or set Priority
    /// </summary>
    public string assigned_to_user_id { get; set; }

    /// <summary>
    /// Get or set Cutomer Score
    /// </summary>
    public string vehicle_registration_number { get; set; }

    /// <summary>
    /// Get or set Created By
    /// </summary>
    public string ticket_status_alias { get; set; }

    /// <summary>
    /// Get or set Creation Time
    /// </summary>
    public string name { get; set; }

    /// <summary>
    /// Get or set Last Modified By
    /// </summary>
    public string dealer_name { get; set; }

    /// <summary>
    /// Get or set Last Modified Time
    /// </summary>
    public string dealer_contact_number1 { get; set; }

    /// <summary>
    /// Get or set Break Down Location
    /// </summary>
    public string customer_vehicle_model_tagging { get; set; }

    /// <summary>
    /// Get or set Breack Down Longitude
    /// </summary>
    public string BreackDownLongitude { get; set; }

    /// <summary>
    /// Get or set Breack Down Latitude
    /// </summary>
    public string BreackDownLatitude { get; set; }

    /// <summary>
    /// Get or set Assigned To User Id
    /// </summary> 
    public string AssignedToUserId { get; set; }

    /// <summary>
    /// Get or set Assigned To User Longitude
    /// </summary>
    public string AssignedToUserLongitude { get; set; }

    /// <summary>
    /// Get or set Assigned To User Latitude
    /// </summary>
    public string AssignedToUserLatitude { get; set; }
  }

  /// <summary>
  /// contains Escalation level input properties
  /// </summary>
  public class EscalationLevelInputModel
  {
    /// <summary>
    /// get or set security token
    /// </summary>
    public string Token { get; set; }

    /// <summary>
    /// get or set message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// get or set deler id
    /// </summary>
    public string DelerId { get; set; }

    /// <summary>
    /// get or set vehicle type
    /// </summary>
    public string VehicleType { get; set; }

    /// <summary>
    /// get or set vehicle type
    /// </summary>
    public string ProductVariant { get; set; }

    public string ModelNumber { get; set; }

  }

  public class sendSMSInputModel
  {
    /// <summary>
    /// get or set security token
    /// </summary>
    public string Token { get; set; }

    /// <summary>
    /// get or set message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// get or set deler id
    /// </summary>
    public string DelerId { get; set; }

    /// <summary>
    /// get or set vehicle type
    /// </summary>
    public string MobileNumber { get; set; }

    /// <summary>
    /// get or set vehicle type
    /// </summary>
    public string DealerName { get; set; }

    public string ManagerName { get; set; }

    public string ManagerNo { get; set; }
  }


  /// <summary>
  /// contains escalation level properties
  /// </summary>
  public class EscalationLevel
  {
    /// <summary>
    /// get or set delaer id
    /// </summary>
    public string DelaerId { get; set; }

    /// <summary>
    /// get or set manager name
    /// </summary>
    public string ManagerName { get; set; }

    /// <summary>
    /// get or set manager level
    /// </summary>
    public string ManagerLevel { get; set; }

    /// <summary>
    /// get or set manager phone number
    /// </summary>
    public string ManagerPhoneNo { get; set; }

    /// <summary>
    /// get or set vehicle type
    /// </summary>
    public string VehicleType { get; set; }
  }

  /// <summary>
  /// contains Escalation level output properties and lists
  /// </summary>
  public class EscalationLevelOutputModel
  {
    /// <summary>
    /// get or set message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// get or set status
    /// </summary>
    public string Status { get; set; }

    /// <summary>
    /// get or set escalation levels list
    /// </summary>
    public List<EscalationLevel> EscalationLevelList { get; set; }
  }

  /// <summary>
  /// contains properties for customer open tickets
  /// </summary>
  public class DummyOpenTicketDetail
  {
    public string _CreationTime = "";
    public string _DurationTime = "";
    /// <summary> 
    /// Get or set extra property
    /// </summary>
    public Int32 DummyId { get; set; }
    /// <summary>
    /// Get or set ticket id
    /// </summary>
    public string TicketId { get; set; }
    /// <summary>
    /// Get or set ticket id alias
    /// </summary>
    public string TicketIdAlias { get; set; }
    /// <summary>
    /// Get or set description
    /// </summary>
    public string Description { get; set; }
    /// <summary>
    /// Get or set assigned to
    /// </summary>
    public string AssignedTo { get; set; }
    /// <summary>
    /// Get or set reported via
    /// </summary>
    public string ReportedVia { get; set; }
    /// <summary>
    /// Get or set ticket status
    /// </summary>
    public int? TicketStatus { get; set; }
    /// <summary>
    /// Get or set priority
    /// </summary>
    public int? Priority { get; set; }
    /// <summary>
    /// Get or set customer score
    /// </summary>
    public string CustomerScore { get; set; }
    /// <summary>
    /// Get or set created by
    /// </summary>
    public string CreatedBy { get; set; }
    /// <summary>
    /// Get or set creation time
    /// </summary>
    public string CreationTime { get { return _CreationTime; } set { _CreationTime = value; } }
    /// <summary>
    /// Get or set last modified by
    /// </summary>
    public string LastModifiedBy { get; set; }
    /// <summary>
    /// Get or set last modified time
    /// </summary>
    public string LastModifiedTime { get; set; }
    /// <summary>
    /// Get or set breakdown location
    /// </summary>
    public string BreakdownLocation { get; set; }
    /// <summary>
    /// Get or set breakdown longitude
    /// </summary>
    public string BreakdownLongitude { get; set; }
    /// <summary>
    /// Get or set breakdown latitude
    /// </summary>
    public string BreakdownLattitude { get; set; }
    /// <summary>
    /// Get or set assigned to user id
    /// </summary>
    public string AssignedToUserId { get; set; }
    /// <summary>
    /// Get or set assigned to user latitude
    /// </summary>
    public string AssignedToUserLattitude { get; set; }
    /// <summary>
    /// Get or set assigned to user longitude
    /// </summary>
    public string AssignedToUserLongitude { get; set; }
    /// <summary>
    /// Get or set IsDeclined bit
    /// </summary>
    public Boolean? Isdeclined { get; set; }
    /// <summary>
    /// Get or set estimated time for job completion
    /// </summary>
    public int? EstimatedTimeForJobCompletion { get; set; }
    /// <summary>
    /// Get or set ticket life cycle time
    /// </summary>
    public int? TotalTicketLifecycleTimeSla { get; set; }
    /// <summary>
    /// Get or set estimated time for job completion submit time
    /// </summary>
    public string EstimatedTimeForJobCompletionSubmitTime { get; set; }
    /// <summary>
    /// Get or set vehicle registration number
    /// </summary>
    public string VehicleRegisterNumber { get; set; }
    /// <summary>
    /// Get or set breakdown landmark
    /// </summary>
    public string BreakdownLocationLandmark { get; set; }
    /// <summary>
    /// Get or set Breakdown state
    /// </summary>
    public string BreakdownLocationState { get; set; }
    /// <summary>
    /// Get or set Breakdown city
    /// </summary>
    public string BreakdownLocationCity { get; set; }
    /// <summary>
    /// Get or set route id
    /// </summary>
    public int? RouteId { get; set; }
    /// <summary>
    /// Get or set customer contact number
    /// </summary>
    public string CustomerContactNo { get; set; }
    /// <summary>
    /// Get or set ticket status alias
    /// </summary>
    public string TicketStatusAlias { get; set; }
    /// <summary>
    /// Get or set repair cost
    /// </summary>
    public string RepairCost { get; set; }
    /// <summary>
    /// Get or set defalut sla time
    /// </summary>
    public int? DefaultSlaTime { get; set; }
    /// <summary>
    /// Get or set sla missed reason
    /// </summary>
    public string SlaMissedReason { get; set; }
    /// <summary>
    /// Get or set suggestion comment
    /// </summary>
    public string SuggestionComment { get; set; }
    /// <summary>
    /// Get or set job complete response time
    /// </summary>
    public string JobCompleteResponseTime { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string DefaultCol2 { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string DefaultCol3 { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string CallerLanguage { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string Warranty { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string TollFreeNoSource { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string StateName { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string CityName { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string EstimatedDistance { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string OpportunityLoss { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string KmCovered { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string VehicleTagging { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string ReasonForMoreThan24Hours { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string CallStatus { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string SuggestionComplaint { get; set; }
    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string CustomerName { get; set; }
    /// <summary>
    /// Get or set security token
    /// </summary>
    public string Token { get; set; }
    /// <summary>
    /// Get or set status
    /// </summary>
    public string Status { get; set; }
    /// <summary>
    /// Get or set message
    /// </summary>
    public string Message { get; set; }
    /// <summary>
    /// Get or set UTC minute
    /// </summary>
    public int UtcMinute { get; set; }

    public string DurationTime
    {
      get
      {
        if (!string.IsNullOrEmpty(_CreationTime))
        {
          DateTime durationDate;
          if (DateTime.TryParse(_CreationTime, out durationDate))
          {
            TimeSpan difference = DateTime.Now - durationDate;

            _DurationTime = Math.Floor(difference.TotalHours).ToString("N0") + ":" + difference.Minutes;

          }

        }
        return _DurationTime;
      }
    }




    public string vehicle_model_number { get; set; }
    public string customer_id { get; set; }
    public string customer_address_id { get; set; }
    public string product_variant { get; set; }
    public string customer_mobile_number { get; set; }
    public string driver_mobile_number { get; set; }
    public string driver_name { get; set; }
    public string vehicle_installation_date { get; set; }
    public string iskam { get; set; }
    public string customer_address { get; set; }
    public string vehicle_emission_norms { get; set; }
    public string vehicle_warranty { get; set; }
    public string vehicle_type { get; set; }
    public string customer_type { get; set; }
  }

  public class AppModel
  {
    /// <summary>
    /// Get or set token
    /// </summary>
    public string Token { get; set; }

    /// <summary>
    /// Get or set Status
    /// </summary>
    public int? Status { get; set; }

    /// <summary>
    /// Get or set  Utc Minute
    /// </summary>
    public int? UtcMinute { get; set; }

    /// <summary>
    /// Get or set  Message
    /// </summary>
    public string Message { get; set; }
    public string AppCode { get; set; }
    public string AppVersion { get; set; }
    public string AppName { get; set; }
    public string ModifiedDate { get; set; }
  }

  /// <summary>
  /// CMS login model
  /// </summary>
  public class CustomerOpenTicketFullDetailTicketWise
  {
    public string AssignedTo { get; set; }
    public string BreakdownLocation { get; set; }
    public string ChassisNo { get; set; }
    public string CustomerContactNo { get; set; }
    public string CustomerCustomerName { get; set; }
    public string DealerCode { get; set; }
    public string DealerContactNumber1 { get; set; }
    public string DealerOrServiceEnggContactNumber { get; set; }
    public string Dealerdealer_name { get; set; }
    public string KmCovered { get; set; }
    public string ModelNumber { get; set; }

    public string OpenCloseStatus { get; set; }
    public string ProductVarient { get; set; }
    public string TicketIdAlias { get; set; }
    public string TripEnd { get; set; }
    public string TripStart { get; set; }
    public string VehicleRegisterNumber { get; set; }

  }

  // added on 18-06-2020
  /// <summary>
  /// contains properties for open ticket
  /// </summary>
  /// 
  public class GetDummyTicket
  {
    /// <summary>
    /// Get or set KAM ticket id
    /// </summary>
    public string KamTicketId { get; set; }
    /// <summary>
    /// Get or set ticket id
    /// </summary>
    public int DummyTicketId { get; set; }

    /// <summary>
    /// Get or set description
    /// </summary>
    public string Description { get; set; }

    /// <summary>
    /// Get or set assigned to 
    /// </summary>
    public string AssignedTo { get; set; }

    /// <summary>
    /// Get or set reported via
    /// </summary>
    public string ReportedVia { get; set; }

    /// <summary>
    /// Get or set ticket status
    /// </summary>
    public int? TicketStatus { get; set; }

    /// <summary>
    /// Get or set priority
    /// </summary>
    public int? Priority { get; set; }

    /// <summary>
    /// Get or set customer score
    /// </summary>
    public string CustomerScore { get; set; }

    /// <summary>
    /// Get or set created by
    /// </summary>
    public string CreatedBy { get; set; }

    /// <summary>
    /// Get or set creation time
    /// </summary>
    //public DateTime? CreationTime { get; set; }
    public string CreationTime { get; set; }       //added on 26-10-2020


    /// <summary>
    /// Get or set last modified by
    /// </summary>
    public string LastModifiedBy { get; set; }

    /// <summary>
    /// Get or set last modified time
    /// </summary>
    public DateTime? LastModifiedTime { get; set; }

    /// <summary>
    /// Get or set breakdown location
    /// </summary>
    public string BreakdownLocation { get; set; }

    /// <summary>
    /// Get or set breakdown longitude
    /// </summary>
    public string BreakdownLongitude { get; set; }

    /// <summary>
    /// Get or set breakdown latitude
    /// </summary>
    public string BreakdownLattitude { get; set; }

    /// <summary>
    /// Get or set assigned to user id
    /// </summary>
    public string AssignedToUserId { get; set; }

    /// <summary>
    /// Get or set assigned to user latitude
    /// </summary>
    public string AssignedToUserLattitude { get; set; }

    /// <summary>
    /// Get or set assigned to user longitude
    /// </summary>
    public string AssignedToUserLongitude { get; set; }

    /// <summary>
    /// Get or set IsDeclined
    /// </summary>
    public Boolean? IsDeclined { get; set; }

    /// <summary>
    /// Get or set estimated time for job completion
    /// </summary>
    public int? EstimatedTimeForJobCompletion { get; set; }

    /// <summary>
    /// Get or set ticket life cycle time
    /// </summary>
    public int? TotalTicketLifecycleTimeSla { get; set; }

    /// <summary>
    /// Get or set estimated time for job completion
    /// </summary>
    public DateTime? EstimatedTimeForJobCompletionSubmitTime { get; set; }

    /// <summary>
    /// Get or set vehicle registration number
    /// </summary>
    public string VehicleRegistrationNumber { get; set; }

    /// <summary>
    /// Get or set breakdown landmark
    /// </summary>
    public string BreakdownLocationLandmark { get; set; }

    /// <summary>
    /// Get or set route id
    /// </summary>
    public int? RouteId { get; set; }

    /// <summary>
    /// Get or set customer contact number
    /// </summary>
    public string CustomerContactNo { get; set; }

    /// <summary>
    /// Get or set repair cost
    /// </summary>
    public string RepairCost { get; set; }

    /// <summary>
    /// Get or set default sla time
    /// </summary>
    public int? DefaultSlaTime { get; set; }

    /// <summary>
    /// Get or set sla missed reason
    /// </summary>
    public string SlaMissedReason { get; set; }

    /// <summary>
    /// Get or set suggestion comment
    /// </summary>
    public string SuggestionComment { get; set; }

    /// <summary>
    /// Get or set job complete response time
    /// </summary>
    public string JobCompleteResponseTime { get; set; }

    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string DefaultCol2 { get; set; }

    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string DefaultCol3 { get; set; }

    /// <summary>
    /// Get or set security token
    /// </summary>
    public string Token { get; set; }

    /// <summary>
    /// Get or set status
    /// </summary>
    public string Status { get; set; }

    /// <summary>
    /// Get or set message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// Get or set UTC minute
    /// </summary>
    public int UtcMinute { get; set; }

    /// <summary>
    /// Get or set sender id
    /// </summary>
    public string SenderId { get; set; }

    /// <summary>
    /// Get or set state name
    /// </summary>
    public string StateName { get; set; }

    /// <summary>
    /// Get or set city name
    /// </summary>
    public string CityName { get; set; }

    /// <summary>
    /// Get or set caller language
    /// </summary>
    public string CallerLanguage { get; set; }

    /// <summary>
    /// Get or set warrenty
    /// </summary>
    public string Warranty { get; set; }

    /// <summary>
    /// Get or set toll free number source
    /// </summary>
    public string TollFreeeNoSource { get; set; }

    /// <summary>
    /// Get or set opportunity lost
    /// </summary>
    public string OpportunityLost { get; set; }

    /// <summary>
    /// Get or set 24 hrs reason
    /// </summary>
    public string _24HrsReason { get; set; }

    /// <summary>
    /// Get or set Vehicle Tagging like(LMD,BUS,HD)
    /// </summary>
    public string VehicleTagging { get; set; }

    /// <summary>
    /// Get or set distance between brackdown loction and service engg.
    /// </summary>
    public string EstimateDistance { get; set; }

    /// <summary>
    /// Get or set km covered
    /// </summary>
    public double KmCovered { get; set; }

    /// <summary>
    /// Get or set km Ticket Id Alias
    /// </summary>
    public string TicketIdAlias { get; set; }

    public string OtherRemarks { get; set; }

    public string Flag { get; set; }

    public string TicketPrevStatusAliasId { get; set; }


    public string ChassisNo { get; set; }
    public double OdometerReading { get; set; }

    public double PreviousOdometerReading { get; set; }
    public string VehicleType { get; set; }
    public string OdometerUnit { get; set; }
    public string EOSMessage { get; set; }

    //added on 18-06-2020
    /// <summary>
    /// Get or set Customer or Owner Name
    /// </summary> 
    public string CustomerCustomerName { get; set; }

    /// <summary>
    /// Get or set ModelNumber
    /// </summary>
    public string ModelNumber { get; set; }
    /// <summary>
    /// Get or set Vehicle Number Plate
    /// </summary>
    public string VehicleNumberPlate { get; set; }

    public string Comments { get; set; }

    public bool? KamUser { get; set; }
    public string DriverName { get; set; }
  }


  public class InsertDraftTicket
  {
    /// <summary>
    /// Get or set KAM ticket id
    /// </summary>
    public string KamTicketId { get; set; }
    /// <summary>
    /// Get or set ticket id
    /// </summary>
    public string TicketId { get; set; }

    /// <summary>
    /// Get or set description
    /// </summary>
    public string Description { get; set; }

    /// <summary>
    /// Get or set assigned to 
    /// </summary>
    public string AssignedTo { get; set; }

    /// <summary>
    /// Get or set reported via
    /// </summary>
    public string ReportedVia { get; set; }

    /// <summary>
    /// Get or set ticket status
    /// </summary>
    public int? TicketStatus { get; set; }

    /// <summary>
    /// Get or set priority
    /// </summary>
    public int? Priority { get; set; }

    /// <summary>
    /// Get or set customer score
    /// </summary>
    public string CustomerScore { get; set; }

    /// <summary>
    /// Get or set created by
    /// </summary>
    public string CreatedBy { get; set; }

    /// <summary>
    /// Get or set creation time
    /// </summary>
    public DateTime? CreationTime { get; set; }

    /// <summary>
    /// Get or set last modified by
    /// </summary>
    public string LastModifiedBy { get; set; }

    /// <summary>
    /// Get or set last modified time
    /// </summary>
    public DateTime? LastModifiedTime { get; set; }

    /// <summary>
    /// Get or set breakdown location
    /// </summary>
    public string BreakdownLocation { get; set; }

    /// <summary>
    /// Get or set breakdown longitude
    /// </summary>
    public string BreakdownLongitude { get; set; }

    /// <summary>
    /// Get or set breakdown latitude
    /// </summary>
    public string BreakdownLattitude { get; set; }

    /// <summary>
    /// Get or set assigned to user id
    /// </summary>
    public string AssignedToUserId { get; set; }

    /// <summary>
    /// Get or set assigned to user latitude
    /// </summary>
    public string AssignedToUserLattitude { get; set; }

    /// <summary>
    /// Get or set assigned to user longitude
    /// </summary>
    public string AssignedToUserLongitude { get; set; }

    /// <summary>
    /// Get or set IsDeclined
    /// </summary>
    public Boolean? IsDeclined { get; set; }

    /// <summary>
    /// Get or set estimated time for job completion
    /// </summary>
    public int? EstimatedTimeForJobCompletion { get; set; }

    /// <summary>
    /// Get or set ticket life cycle time
    /// </summary>
    public int? TotalTicketLifecycleTimeSla { get; set; }

    /// <summary>
    /// Get or set estimated time for job completion
    /// </summary>
    public DateTime? EstimatedTimeForJobCompletionSubmitTime { get; set; }

    /// <summary>
    /// Get or set vehicle registration number
    /// </summary>
    public string VehicleRegistrationNumber { get; set; }

    /// <summary>
    /// Get or set breakdown landmark
    /// </summary>
    public string BreakdownLocationLandmark { get; set; }

    /// <summary>
    /// Get or set route id
    /// </summary>
    public int? RouteId { get; set; }

    /// <summary>
    /// Get or set customer contact number
    /// </summary>
    public string CustomerContactNo { get; set; }

    /// <summary>
    /// Get or set repair cost
    /// </summary>
    public string RepairCost { get; set; }

    /// <summary>
    /// Get or set default sla time
    /// </summary>
    public int? DefaultSlaTime { get; set; }

    /// <summary>
    /// Get or set sla missed reason
    /// </summary>
    public string SlaMissedReason { get; set; }

    /// <summary>
    /// Get or set suggestion comment
    /// </summary>
    public string SuggestionComment { get; set; }

    /// <summary>
    /// Get or set job complete response time
    /// </summary>
    public string JobCompleteResponseTime { get; set; }

    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string DefaultCol2 { get; set; }

    /// <summary>
    /// Get or set extra property
    /// </summary>
    public string DefaultCol3 { get; set; }

    /// <summary>
    /// Get or set security token
    /// </summary>
    public string Token { get; set; }

    /// <summary>
    /// Get or set status
    /// </summary>
    public string Status { get; set; }

    /// <summary>
    /// Get or set message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// Get or set UTC minute
    /// </summary>
    public int UtcMinute { get; set; }

    /// <summary>
    /// Get or set sender id
    /// </summary>
    public string SenderId { get; set; }

    /// <summary>
    /// Get or set state name
    /// </summary>
    public string StateName { get; set; }

    /// <summary>
    /// Get or set city name
    /// </summary>
    public string CityName { get; set; }

    /// <summary>
    /// Get or set caller language
    /// </summary>
    public string CallerLanguage { get; set; }

    /// <summary>
    /// Get or set warrenty
    /// </summary>
    public string Warranty { get; set; }

    /// <summary>
    /// Get or set toll free number source
    /// </summary>
    public string TollFreeeNoSource { get; set; }

    /// <summary>
    /// Get or set opportunity lost
    /// </summary>
    public string OpportunityLost { get; set; }

    /// <summary>
    /// Get or set 24 hrs reason
    /// </summary>
    public string _24HrsReason { get; set; }

    /// <summary>
    /// Get or set Vehicle Tagging like(LMD,BUS,HD)
    /// </summary>
    public string VehicleTagging { get; set; }

    /// <summary>
    /// Get or set distance between brackdown loction and service engg.
    /// </summary>
    public string EstimateDistance { get; set; }

    /// <summary>
    /// Get or set km covered
    /// </summary>
    public double KmCovered { get; set; }

    /// <summary>
    /// Get or set km Ticket Id Alias
    /// </summary>
    public string TicketIdAlias { get; set; }

    public string OtherRemarks { get; set; }

    public string Flag { get; set; }

    public string TicketPrevStatusAliasId { get; set; }


    public string ChassisNo { get; set; }
    public double OdometerReading { get; set; }

    public double PreviousOdometerReading { get; set; }
    public string VehicleType { get; set; }
    public string OdometerUnit { get; set; }
    public string EOSMessage { get; set; }


  }

  public class GetVanReachDetails
  {
    /// <summary>
    /// Get or set status
    /// </summary>
    // public string Status { get; set; }

    /// <summary>
    /// Get or set message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// Get or set message
    /// </summary>
    public string Token { get; set; }

    /// <summary>
    /// Get or set message
    /// </summary>
    public string TicketId { get; set; }

    /// <summary>
    /// Get or set message
    /// </summary>
    public string assigned_to_user_longitude { get; set; }
    /// <summary>
    /// Get or set message
    /// </summary>
    public string assigned_to_user_lattitude { get; set; }
    /// <summary>
    /// Get or set message
    /// </summary>
    public string ticketid_alias { get; set; }
    /// <summary>
    /// Get or set message
    /// </summary>
    public string service_engineer_name { get; set; }
    /// <summary>
    /// Get or set message
    /// </summary>
    public string contact_number { get; set; }

  }

  public class DraftTicketResponseModel
  {
    /// <summary>
    /// Get or set KAM ticket id
    /// </summary>
    public string TicketId { get; set; }

    /// <summary>
    /// Get or set  Message
    /// </summary>
    public string Message { get; set; }


  }


  //------ added on 19-01-2021 start---------------------
  public class DraftTicketDetailModel
  {
    public string Token { get; set; }
    public int DraftTicketId { get; set; }
    public string TollFreeNoSource { get; set; }
    public string RegistrationNumber { get; set; }
    public string ChassisNumber { get; set; }
    public string Message { get; set; }
    public string Status { get; set; }
    public string DraftTicketCancelReasonID { get; set; }
    public string DraftTicketCancelReason { get; set; }
    public string OthersReason { get; set; }
  }
  //------ added on 19-01-2021 end ----------------------

  //------- added on 09-03-2021 start --------------------
  public class CancelledDraftTicketModel
  {
    public string Token { get; set; }
    public string Message { get; set; }
    public int UtcMinute { get; set; }
    public int DraftTicketId { get; set; }
    public string VehicleRegistrationNumber { get; set; }
    public string ChassisNumber { get; set; }
    public string Comments { get; set; }
    public string ContactNumber { get; set; }
    public string DriverName { get; set; }
    public bool? KamUser { get; set; }
    public string CreationTime { get; set; }
    public string TollFreeNoSource { get; set; }
    public string TicketCancelReason { get; set; }
    public string TicketCancelRemark { get; set; }
  }

  public class CancelledDraftTicketReportModel
  {
    public string Token { get; set; }
    public string Status { get; set; }
    public string Message { get; set; }
    public int UtcMinute { get; set; }
    public List<CancelledDraftTicketModel> CancelledDraftTicketList { get; set; }
  }


  //------- added on 09-03-2021 end ----------------------

  // Added by Priya for consolidate report download
  // 
  public class ConsolidatedReportModelNew
  {
    public string ticketid_alias { get; set; }
    public string call_assigned_to { get; set; }
    public string created_by { get; set; }
    //[DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:dd MMM yyyy HH:mm:ss}")]
    //public DateTime creation_time { get; set; }
    public string creation_time { get; set; }
    public string time_slot { get; set; }
    public string customer_name { get; set; }
    public string customer_contact_no { get; set; }
    public string organization { get; set; }
    public string state { get; set; }
    public string city { get; set; }
    public string language_name { get; set; }
    public string owner_name { get; set; }
    public string owner_contact_number { get; set; }
    public string customer_vehicle_regn_no { get; set; }
    public string vehicle_name { get; set; }
    public string vehicle_type { get; set; }
    public string chassis_number { get; set; }
    public string vehicle_instalation_date { get; set; }
    public string breakdown_location { get; set; }
    public string landmark { get; set; }
    public string warranty { get; set; }
    public string how_did_you_come_to_know_of_eos { get; set; }
    public string type_of_load_carried { get; set; }
    public string nature_of_problem { get; set; }
    public string estimated_cost_string
    {
      get
      {
        if (Convert.ToString(call_assigned_to).ToLower().Trim() != "dealer")
          return estimated_cost;
        else
          return "NA";
      }
      set
      { }
    }
    public string estimated_time_string
    {
      get
      {
        if (Convert.ToString(call_assigned_to).ToLower().Trim() != "dealer")
          return estimated_time;
        else
          return "NA";
      }
      set
      { }

    }
    public string dealer_code { get; set; }
    public string dealer_name { get; set; }
    /// <summary>
    /// get or set wm name
    /// </summary>
    public string wm_name { get; set; }
    public string dealer_contact_no { get; set; }
    public string eos_team_member_and_van { get; set; }
    public string open_call_hrs { get; set; }
    public string time_stamps_status_1 { get; set; }
    public string time_stamps_status_3 { get; set; }
    public string time_stamps_status_4 { get; set; }
    public string time_stamps_status_5 { get; set; }
    public string escalation_level_van_not_move_1 { get; set; }
    public string escalation_level_ticket_closer_1 { get; set; }
    public string call_closure_status { get; set; }//reason for 24 hrs
    public string KmCovered { get; set; }
    public string feedback_taken { get; set; }//feedback
    public string feedback_ease_of_getting_call { get; set; }
    public string feedback_response_of_call_center { get; set; }
    public string feedback_timely_updation_by_dealer { get; set; }
    public string feedback_total_repair_time { get; set; }
    public string feedback_eos_charges { get; set; }
    public string feedback_over_all_experience { get; set; }
    public string closure_remarks { get; set; }
    public string response_string
    {
      get
      {
        if (Convert.ToString(call_assigned_to).ToLower().Trim() != "dealer")
          return response;
        else
          return "NA";
      }
      set
      { }
    }
    public string feedback_count { get; set; }
    public string call_status { get; set; }
    public string complaints { get; set; }
    public string suggestion { get; set; }
    public string feedback_agent { get; set; }
    public string other_remarks { get; set; }
    public string DealerTicketOtherRemark { get; set; }
    public string estimated_distance { get; set; }

    public string van_covered_distance { get; set; }

    public string trip_start_time { get; set; }

    public string trip_end_time { get; set; }



    public string _eicher_promise { get; set; }
    public string opportunity_loss { get; set; }
    public string opportunity_loss_remark { get; set; }
    public string opportunity_lost_remarks { get; set; }

    public string remark_ticket_not_closed_24_hours { get; set; }

    public string remark_ticket_not_closed_24_hours_remarks { get; set; }
    public int reopen_count { get; set; }
    public string ChassisNo { get; set; }
    public double OdometerReading { get; set; }

    public string _call_closed_within_24_hours { get; set; }
    //public string Region { get; set; }
    public string load_carried { get; set; }
    public string feedback_parameter_wise_score { get; set; }
    public string total_inbound_calls { get; set; }
    public string total_outbound_calls { get; set; }
    public string time_stamps_status_2 { get; set; }
    public string escalation_level_van_not_move_2 { get; set; }
    public string escalation_level_van_not_move_3 { get; set; }
    public string escalation_level_van_not_move_4 { get; set; }
    public string escalation_level_van_not_move_5 { get; set; }
    public string escalation_level_van_not_move_6 { get; set; }
    public string escalation_level_van_not_move_7 { get; set; }
    public string escalation_level_van_not_move_8 { get; set; }
    public string escalation_level_van_not_move_9 { get; set; }
    public string escalation_level_van_not_move_10 { get; set; }
    public string escalation_level_ticket_closer_2 { get; set; }
    public string escalation_level_ticket_closer_3 { get; set; }
    public string escalation_level_ticket_closer_4 { get; set; }
    public string escalation_level_ticket_closer_5 { get; set; }
    public string escalation_level_ticket_closer_6 { get; set; }
    public string escalation_level_ticket_closer_7 { get; set; }
    public string escalation_level_ticket_closer_8 { get; set; }
    public string escalation_level_ticket_closer_9 { get; set; }
    public string escalation_level_ticket_closer_10 { get; set; }
    public string month_name { get; set; }
    public string default_sla_time { get; set; }

    public string region { get; set; }
    public string vehicle_model { get; set; }
    public List<kendoChartModel> CloseTicketCountInTimeSlot { get; set; }
    public string estimated_time { get; set; }
    public string response { get; set; }
    public string estimated_cost { get; set; }
    public string ticket_id { get; set; }

    /// <summary>
    /// Get or set last updated time(for consolidate report)
    /// </summary>
    [Display(Name = "Reassignment Date and Time")]
    public string last_Updated_Time { get; set; }

    /// <summary>
    /// Get or set are_you_satisfied
    /// </summary>
    [Display(Name = "Overall Customer Satisfied")]
    public string are_you_satisfied { get; set; }
    /// <summary>
    /// Get or set not_satisfied_option
    /// </summary>
    [Display(Name = "Reason for dissatisfaction")]
    public string not_satisfied_option { get; set; }
    /// <summary>
    /// Get or set not_satisfied_reason
    /// </summary>
    [Display(Name = "Feedback Comments")]
    public string not_satisfied_reason { get; set; }

    public double? response_time_reassignment { get; set; }


    //added on 03/12/2020
    public string vehicle_warranty { get; set; }
    public string vehicle_amc { get; set; }
    public string vehicle_emission_norms { get; set; }
    public string vehicle_sales_date { get; set; }
    //ended on 03/12/2020

    public string van_reached_punch_time { get; set; } //added on 23-12-2020

    public string ticket_closed_reason { get; set; }   //added on 25-11-2020
    [Display(Name = "Location change Reassignment Date and Time")]
    public string location_change_time { get; set; }

    [Display(Name = "Is Location changed")]
    public string is_location_change { get; set; }

    [Display(Name = "Dealer Change Reason")]
    public string dealer_change_reason { get; set; }

    [Display(Name = "Dealer Change Reason Remarks")]
    public string dealer_change_reason_other_remark { get; set; }

    [Display(Name = "Vehicle Status")]
    public string vehicle_status { get; set; }
    [Display(Name = "Fuel Type")]
    public string fuel_type { get; set; }

  }


  public class kendoChartModel
  {
    public int Id { get; set; }
    public string xAxis { get; set; }
    public int yAxis { get; set; }
  }

  public class ReportOpenTicketModel
  {
    public string TicketType { get; set; }
    public string Token { get; set; }
    public string Status { get; set; }
    public string Message { get; set; }
    public string UserId { get; set; }
    public string FromDate { get; set; }
    public string ToDate { get; set; }
    public string Limit { get; set; }
    public string OffSet { get; set; }
    public Int32 TicketCount { get; set; }
    public List<TicketList> TicketList { get; set; }
    public List<TicketListOpenTickets> TicketopenList { get; set; }
    public List<TicketListCloseTickets> TicketcloseList { get; set; }



    public List<TicketListNew> TicketListNew { get; set; }
    // public List<TicketListForScore> TicketScoreList { get; set; }
    public List<ConsolidatedReportModelNew> ConsolidatedReportModelList { get; set; }
    public List<TicketOpenModelNew> TicketOpenModelList { get; set; }
  }


  /*  public class TicketListOpenTickets
    {
        public string _CreationTime = "";
        /// <summary>
        /// Get or set Ticket id
        /// </summary>
        [Display(Name = "Ticket Id")]
        public string ticketid_alias { get; set; }
        /// <summary>
        /// Get or set Ticket status alias
        /// </summary>
        [Display(Name = "Ticket Status")]
        public string TicketStatusAlias { get; set; }
        /// <summary>
        /// Get or set creation time of ticket
        /// </summary>
        [Display(Name = "Ticket Creation Time")]
        public string CreationTime { get { return _CreationTime; } set { _CreationTime = value; } }
        /// <summary>
        /// Get or set customer name
        /// </summary>
        [Display(Name = "Customer Name")]
        public string CustomerName { get; set; }
        /// <summary>
        /// Get or set Customer Contact No.
        /// </summary>
        [Display(Name = "Customer Contact No.")]
        public string CustomeContact_no { get; set; }
        /// <summary>
        /// Get or set customer's vehicle registration no.
        /// </summary>
        public string VehicleRegistrationNo { get; set; }
        /// <summary>
        /// Get or set Vehicle Tagging
        /// </summary>
        public string VehicleTagging { get; set; }
        /// <summary>
        /// Get or set Default SLA Time
        /// </summary>
        public int DefaultSlaTime { get; set; }
        /// <summary>
        /// Get or set Response Time
        /// </summary>
        [Display(Name = "Response(In min)")]
        public int? TotalTicketLifeCycleTimeSlab { get; set; }
        /// <summary>
        /// Get or set Service Engineer Name
        /// </summary>
        // [Display(Name = "Van SE Name")]
        public string ServiceEngineerName { get; set; }
        /// <summary>
        /// Get or set Dealer Name
        /// </summary>
        [Display(Name = "Dealer Name")]
        public string DealerDealerName { get; set; }
        /// <summary>
        /// Get or set Dealer Contact No.
        /// </summary>
        [Display(Name = "Dealer Contact No.")]
        public string ServiceEngineerContactNumber { get; set; }
        public string caller_language { get; set; }
        /// <summary>
        /// Get or set default column
        /// </summary>
        public string PreClosureTime { get; set; }
        public string ChassisNo { get; set; }
        public double OdometerReading { get; set; }

        public string VanReachedPunchTime { get; set; }    //added on 23-12-2020

        /// <summary>
        /// Get or set Description
        /// </summary>

        [Display(Name = "Nature of Problem")] 
        public string Description { get; set; }
        /// <summary>
        /// Get or set remarks
        /// </summary>

        [Display(Name = "Last Remarks")] 
        public string Remarks { get; set; }

        /// <summary>
        /// Get or set customer name
        /// </summary>
        [Display(Name = "ASM")]
        public string ASMName { get; set; }
        /// <summary>
        /// Get or set Customer Contact No.
        /// </summary>
        [Display(Name = "ASM Contact No.")]
        public string ASMNo { get; set; }
        /// <summary>
        /// Get or set customer name
        /// </summary>
        [Display(Name = "CSM")]
        public string CSMName { get; set; }
        /// <summary>
        /// Get or set Customer Contact No.
        /// </summary>
        [Display(Name = "CSM Contact No.")]
        public string CSMNo { get; set; }
        /// <summary>
        /// Get or set customer name
        /// </summary>
        [Display(Name = "RSM")]
        public string RSMName { get; set; }
        /// <summary>
        /// Get or set Customer Contact No.
        /// </summary>
        [Display(Name = "RSM Contact No.")]
        public string RSMNo { get; set; }

        [Display(Name = "Dealer 1s code")]
        public string dealer1scode { get; set; }

        [Display(Name = "Assigned to")]
        public string assigned_to { get; set; }


        [Display(Name = "Vehicle Status")]
        public string Vehicle_Status { get; set; }

        /// <summary>
        /// Get or set Last Modified Time
        /// </summary>
        public string LastModifiedTime { get; set; }

        /// <summary>
        /// Get or set assigned to
        /// </summary>
        public string AssignedTo { get; set; }
        public string vehicle_warranty { get; set; }
        public string vehicle_amc { get; set; }
        public string vehicle_emission_norms { get; set; }
        public string vehicle_sales_date { get; set; }
        //ended on 03/12/2020
        /// <summary>
        /// Get or set assigned van/dealer longitude
        /// </summary>
        public string AssignedToUserLongitude { get; set; }
        /// <summary>
        /// Get or set assigned van/dealer latitude
        /// </summary>
        public string AssignedToUserLatitude { get; set; }
        /// <summary>
        /// Get or set Breack Down Longitude
        /// </summary>
        public string BreackDownLongitude { get; set; }

        /// <summary>
        /// Get or set Security Token
        /// </summary>
        public string feedback_call_status { get; set; }

        /// <summary>
        /// Get or set Estimated Time For Job Complition
        /// </summary>
        public int? EstimatedTimeForJobComplition { get; set; }
        /// <summary>
        /// Get or set Status
        /// </summary>
        public string total_count { get; set; }
        public string reopen_count { get; set; }
        public string Score { get; set; }

        /// <summary> 
        /// Get or set Age(Ticket life cycle time creation to closed time)
        /// </summary>
        public double? Age { get; set; }
        /// <summary>
        /// Get or set Default Col 2
        /// </summary>
        public string DefaultCol2 { get; set; }

        /// <summary>
        /// Get or set Custome Contact_no
        /// </summary>
        public string CallStatus { get; set; }

        /// <summary>
        /// Get or set Default Col 3
        /// </summary>
        public string DefaultCol3 { get; set; }

        public string Id { get; set; }
        //added on 25-09-2020
        //[Display(Name = "Van Trip Start Latitude")]
        public string VanLatitudeAtTripStart { get; set; }

        //[Display(Name = "Van Trip Start Longitude")]
        public string VanLongitudeAtTripStart { get; set; }

        //[Display(Name = "Van Reached Latitude")]
        public string VanLatitudeAtVanReached { get; set; }

        //[Display(Name = "Van Reached Longitude")]
        public string VanLongitudeAtVanReached { get; set; }

        //[Display(Name = "Van Trip End Latitude")]
        public string VanLatitudeAtTripEnd { get; set; }

        //[Display(Name = "Van Reached Longitude")]
        public string VanLongitudeAtTripEnd { get; set; }
        public string BreakdownLocationLatitude { get; set; }

        public string BreakdownLocationLongitude { get; set; }
        public string TicketClosedReason { get; set; }  //added on 25-11-2020
    }

    */
  public class TicketListOpenTickets
  {
    public string _CreationTime = "";
    /// <summary>
    /// Get or set Ticket id
    /// </summary>
    [Display(Name = "Ticket Id")]
    public string ticketid_alias { get; set; }

    public string CreatedBy { get; set; }
    /// <summary>
    /// Get or set Ticket status alias
    /// </summary>
    [Display(Name = "Ticket Status")]
    public string TicketStatusAlias { get; set; }
    /// <summary>
    /// Get or set creation time of ticket
    /// </summary>
    [Display(Name = "Ticket Creation Time")]
    public string CreationTime { get { return _CreationTime; } set { _CreationTime = value; } }

    public string caller_language { get; set; }


    [Display(Name = "Nature of Problem")]
    public string Description { get; set; }

    /// <summary>
    /// Get or set customer's vehicle registration no.
    /// </summary>
    public string VehicleRegistrationNo { get; set; }

    public string ChassisNo { get; set; }
    /// <summary>
    /// Get or set Vehicle Tagging
    /// </summary>
    public string VehicleTagging { get; set; }

    public string vehicle_emission_norms { get; set; }

    [Display(Name = "Vehicle Status")]
    public string Vehicle_Status { get; set; }
    public double OdometerReading { get; set; }



    /// <summary>
    /// Get or set customer name
    /// </summary>
    [Display(Name = "Customer Name")]
    public string CustomerName { get; set; }
    /// <summary>
    /// Get or set Customer Contact No.
    /// </summary>
    [Display(Name = "Customer Contact No.")]
    public string CustomeContact_no { get; set; }


    /// <summary>
    /// Get or set Region
    /// </summary>
    public string Region { get; set; }
    [Display(Name = "Dealer 1s code")]
    public string dealer1scode { get; set; }
    /// <summary>
    /// Get or set Dealer Name
    /// </summary>
    [Display(Name = "Dealer Name")]
    public string DealerDealerName { get; set; }
    /// <summary>
    /// Get or set Dealer Contact No.
    /// </summary>
    [Display(Name = "Dealer Contact No.")]
    public string ServiceEngineerContactNumber { get; set; }

    /// <summary>
    /// Get or set Service Engineer Name
    /// </summary>
    // [Display(Name = "Van SE Name")]
    public string ServiceEngineerName { get; set; }

    [Display(Name = "CSM")]
    public string CSMName { get; set; }
    /// <summary>
    /// Get or set Customer Contact No.
    /// </summary>
    [Display(Name = "CSM Contact No.")]
    public string CSMNo { get; set; }
    [Display(Name = "ASM")]
    public string ASMName { get; set; }
    /// <summary>
    /// Get or set Customer Contact No.
    /// </summary>
    [Display(Name = "ASM Contact No.")]
    public string ASMNo { get; set; }

    /// <summary>
    /// Get or set customer name
    /// </summary>
    [Display(Name = "RSM")]
    public string RSMName { get; set; }
    /// <summary>
    /// Get or set Customer Contact No.
    /// </summary>
    [Display(Name = "RSM Contact No.")]
    public string RSMNo { get; set; }

    [Display(Name = "Last Remarks")]
    public string Remarks { get; set; }
    /// <summary>
    /// Get or set Default SLA Time
    /// </summary>
    public int DefaultSlaTime { get; set; }
    /// <summary>
    /// Get or set Response Time
    /// </summary>
    [Display(Name = "Response(In min)")]
    public int? TotalTicketLifeCycleTimeSlab { get; set; }




    /// <summary>
    /// Get or set default column
    /// </summary>
    public string PreClosureTime { get; set; }


    public string VanReachedPunchTime { get; set; }    //added on 23-12-2020

    [Display(Name = "Assigned to")]
    public string assigned_to { get; set; }


    [Display(Name = "Fuel Type")]
    public string fuel_type { get; set; }


    [Display(Name = "Vehicle Model Number")]
    public string model_number { get; set; }

    [Display(Name = "Battery Volatge")]
    public string battery_voltage { get; set; }

    // public string fuelLevelInPer { get; set; }


    public string fuelLevelInLtr { get; set; }


    public string defLevelInLtr { get; set; }

    public string preclosurereason { get; set; }
  }

  public class TicketListCloseTickets
  {
    public string _CreationTime = "";
    /// <summary>
    /// Get or set Ticket id
    /// </summary>
    [Display(Name = "Ticket Id")]
    public string ticketid_alias { get; set; }
    /// <summary>
    /// Get or set Ticket status alias
    /// </summary>
    [Display(Name = "Ticket Status")]
    public string TicketStatusAlias { get; set; }
    /// <summary>
    /// Get or set creation time of ticket
    /// </summary>
    [Display(Name = "Ticket Creation Time")]
    public string CreationTime { get { return _CreationTime; } set { _CreationTime = value; } }
    /// <summary>
    /// Get or set customer name
    /// </summary>
    [Display(Name = "Customer Name")]
    public string CustomerName { get; set; }
    /// <summary>
    /// Get or set Customer Contact No.
    /// </summary>
    [Display(Name = "Customer Contact No.")]
    public string CustomeContact_no { get; set; }
    /// <summary>
    /// Get or set customer's vehicle registration no.
    /// </summary>
    public string VehicleRegistrationNo { get; set; }
    /// <summary>
    /// Get or set Vehicle Tagging
    /// </summary>
    public string VehicleTagging { get; set; }
    /// <summary>
    /// Get or set Default SLA Time
    /// </summary>
    public int DefaultSlaTime { get; set; }
    /// <summary>
    /// Get or set Response Time
    /// </summary>
    [Display(Name = "Response(In min)")]
    public int? TotalTicketLifeCycleTimeSlab { get; set; }
    /// <summary>
    /// Get or set Service Engineer Name
    /// </summary>
    // [Display(Name = "Van SE Name")]
    public string ServiceEngineerName { get; set; }
    /// <summary>
    /// Get or set Dealer Name
    /// </summary>
    [Display(Name = "Dealer Name")]
    public string DealerDealerName { get; set; }
    /// <summary>
    /// Get or set Dealer Contact No.
    /// </summary>
    [Display(Name = "Dealer Contact No.")]
    public string ServiceEngineerContactNumber { get; set; }
    public string caller_language { get; set; }
    /// <summary>
    /// Get or set default column
    /// </summary>
    public string DefaultCol2 { get; set; }
    /// <summary>
    /// Get or set Security Token
    /// </summary>
    public string feedback_call_status { get; set; }
    /// <summary>
    /// Get or set Status
    /// </summary>
    public string total_count { get; set; }
    public string reopen_count { get; set; }

    public string PreClosureTime { get; set; }
    public string ChassisNo { get; set; }
    public double OdometerReading { get; set; }

    public string VanReachedPunchTime { get; set; }    //added on 23-12-2020


    //added on 25-09-2020
    //[Display(Name = "Van Trip Start Latitude")]
    public string VanLatitudeAtTripStart { get; set; }

    //[Display(Name = "Van Trip Start Longitude")]
    public string VanLongitudeAtTripStart { get; set; }

    //[Display(Name = "Van Reached Latitude")]
    public string VanLatitudeAtVanReached { get; set; }

    //[Display(Name = "Van Reached Longitude")]
    public string VanLongitudeAtVanReached { get; set; }

    //[Display(Name = "Van Trip End Latitude")]
    public string VanLatitudeAtTripEnd { get; set; }

    //[Display(Name = "Van Reached Longitude")]
    public string VanLongitudeAtTripEnd { get; set; }

    public string BreakdownLocationLatitude { get; set; }

    public string BreakdownLocationLongitude { get; set; }


    //added on 03/12/2020
    public string vehicle_warranty { get; set; }
    public string vehicle_amc { get; set; }
    public string vehicle_emission_norms { get; set; }
    public string vehicle_sales_date { get; set; }
    //ended on 03/12/2020

    public string TicketClosedReason { get; set; }  //added on 25-11-2020

    public string LastModifiedTime { get; set; }
    public string EstimatedVanReachTime { get; set; }

    public string fuel_type { get; set; }

    [Display(Name = "Vehicle Model Number")]
    public string model_number { get; set; }

    [Display(Name = "Battery Volatge")]
    public string battery_voltage { get; set; }

    public string fuelLevelInLtr { get; set; }


    public string defLevelInLtr { get; set; }

    public string TripENDBY { get; set; }
    public string VanAssignedLat { get; set; }


    public string VanAssignedLong { get; set; }





    /// <summary>
    /// Get or set Message
    /// </summary>
    public string gps_status { get; set; }


    public string Score { get; set; }
    /// <summary>
    /// Get or set Security Token
    /// </summary>
    public string Token { get; set; }
    /// <summary>
    /// Get or set Status
    /// </summary>
    public string Status { get; set; }
    /// <summary>
    /// Get or set Message
    /// </summary>
    public string Message { get; set; }
    /// <summary>
    /// Get or set Description
    /// </summary>
    public string Description { get; set; }
    /// <summary>
    /// Get or set ticket assigned to (van/dealer)
    /// </summary>
    public string AssignedTo { get; set; }
    /// <summary>
    /// Get or set Reported bu which user
    /// </summary>
    public string ReportedVia { get; set; }
    /// <summary>
    /// Get or set Ticket status
    /// </summary>
    public string TicketStatus { get; set; }
    /// <summary>
    /// Get or set priority
    /// </summary>
    public string Priority { get; set; }
    /// <summary>
    /// Get or set customer score
    /// </summary>
    public string CutomerScore { get; set; }
    /// <summary>
    /// Get or set created by which user
    /// </summary>
    public string CreatedBy { get; set; }
    /// <summary>




    /// Get or set last modified by which user
    /// </summary>
    public string LastModifiedBy { get; set; }
    /// <summary>
    /// Get or set last modified time
    /// </summary>
    // public string LastModifiedTime { get; set; }
    /// <summary>
    /// Get or set breakdown location
    /// </summary>
    public string BreakDownLocation { get; set; }
    /// <summary>
    /// Get or set breakdown longitude
    /// </summary>
    public string BreackDownLongitude { get; set; }
    /// <summary>
    /// Get or set breakdown latitude
    /// </summary>
    public string BreackDownLatitude { get; set; }
    /// <summary>
    /// Get or set assigned to van/dealer id
    /// </summary>
    public string AssignedToUserId { get; set; }
    /// <summary>
    /// Get or set assigned van/dealer longitude
    /// </summary>
    public string AssignedToUserLongitude { get; set; }
    /// <summary>
    /// Get or set assigned van/dealer latitude
    /// </summary>
    public string AssignedToUserLatitude { get; set; }
    /// <summary>
    /// Get or set is declined bit
    /// </summary>
    public string IsDeclined { get; set; }
    /// <summary>
    /// Get or set Estimated Time For Job Completion
    /// </summary>
    public int? EstimatedTimeForJobComplition { get; set; }

    /// <summary>
    /// Get or set submit time 
    /// </summary>
    public string EstimatedTimeForJobComplitionSubmitTime { get; set; }
    /// <summary>
    /// Get or set submit time 
    /// </summary>
    public string EstimatedTimeForJobCompletionSubmitTime { get; set; }
    /// <summary>
    /// Get or set breakdown location landmark
    /// </summary>
    public string BreakdownLocationLandmark { get; set; }
    /// <summary>
    /// Get or set open ticket activity created by
    /// </summary>
    public string ActivityTicketsOpenCreatedBy { get; set; }
    /// <summary>
    /// Get or set open ticket activity creation time
    /// </summary>
    public string ActivityTicketsOpenCreationTime { get; set; }
    /// <summary>
    /// Get or set remarks
    /// </summary>
    public string Remarks { get; set; }
    /// <summary>
    /// Get or set Ticket activity status
    /// </summary>
    public string TicketActivityStatus { get; set; }
    /// <summary>
    /// Get or set Ticket status sequence for activity
    /// </summary>
    public string TicketStatusSequenceOrder { get; set; }
    /// <summary>
    /// Get or set Ticket status name
    /// </summary>
    public string TicketStatusStatusName { get; set; }
    /// <summary>
    /// Get or set user id
    /// </summary>
    public string UserId { get; set; }
    /// <summary>
    /// Get or set auth engine id/email id
    /// </summary>
    public string AuthEngineId { get; set; }
    /// <summary>
    /// Get or set User name
    /// </summary>
    public string UserName { get; set; }
    /// <summary>
    /// Get or set Designation
    /// </summary>
    public string Designation { get; set; }
    /// <summary>
    /// Get or set Object Id
    /// </summary>
    public string ObjectId { get; set; }
    /// <summary>
    /// Get or set Organization Id
    /// </summary>
    public string OrganizationId { get; set; }
    /// <summary>
    /// Get or set City
    /// </summary>
    public string City { get; set; }
    /// <summary>
    /// Get or set State
    /// </summary>
    public string State { get; set; }
    /// <summary>
    /// Get or set Region
    /// </summary>
    public string Region { get; set; }
    /// <summary>
    /// Get or set Language
    /// </summary>
    public string Language { get; set; }
    /// <summary>
    /// Get or set Time Zone ID
    /// </summary>
    public string TimezoneId { get; set; }
    /// <summary>
    /// Get or set display name
    /// </summary>
    public string DisplayName { get; set; }
    /// <summary>
    /// Get or set off set minutes for server side paging
    /// </summary>
    public string OffsetInMinutes { get; set; }
    /// <summary>
    /// Get or set Display Id
    /// </summary>
    public string DisplayId { get; set; }
    /// <summary>
    /// Get or set User Organization Name
    /// </summary>
    public string UserOrganizationName { get; set; }
    /// <summary>
    /// Get or set User Organization Alias
    /// </summary>
    public string UserOrganizationAlias { get; set; }
    /// <summary>
    /// Get or set User Organization City
    /// </summary>
    public string UserOrganizationCity { get; set; }
    /// <summary>
    /// Get or set User Organization State
    /// </summary>
    public string UserOrganizationState { get; set; }
    /// <summary>
    /// Get or set User Organization Country
    /// </summary>
    public string UserAsorganizationCountry { get; set; }
    /// <summary>
    /// Get or set User Organization Description
    /// </summary>
    public string UserOrganizationDescription { get; set; }
    /// <summary>
    /// Get or set User Organization Path
    /// </summary>
    public string UserOrgPath { get; set; }
    /// <summary>
    /// Get or set User Organization Depth (Levels)
    /// </summary>
    public string UserOrgDepth { get; set; }
    /// <summary>
    /// Get or set User Organization Color code
    /// </summary>
    public string UserOrgColor { get; set; }
    /// <summary>
    /// Get or set User Organization Region
    /// </summary>
    public string UserOrganizationRegion { get; set; }
    /// <summary>
    /// Get or set Dealer Id
    /// </summary>
    public string DealerId { get; set; }
    /// <summary>
    /// Get or set Dealer Organization Id
    /// </summary>
    public string DealerOrganizationId { get; set; }
    /// <summary>
    /// Get or set Dealer City
    /// </summary>
    public string DealerCity { get; set; }
    /// <summary>
    /// Get or set Dealer State
    /// </summary>
    public string DealerState { get; set; }
    /// <summary>
    /// Get or set Dealer Default latitude
    /// </summary>
    public string DealerDealerDefaultLattitude { get; set; }
    /// <summary>
    /// Get or set Dealer Default longitude
    /// </summary>
    public string DealerDealerDefaultLongitude { get; set; }
    /// <summary>
    /// Get or set van id
    /// </summary>
    public string VanId { get; set; }
    /// <summary>
    /// Get or set van alias
    /// </summary>
    public string VanAlias { get; set; }
    /// <summary>
    /// Get or set van Default latitude
    /// </summary>
    public string VanVanDefaultLattitude { get; set; }
    /// <summary>
    /// Get or set van Default longitude
    /// </summary>
    public string VanVanDefaultLongitude { get; set; }
    /// <summary>
    /// Get or set van city
    /// </summary>
    public string VanCity { get; set; }
    /// <summary>
    /// Get or set van state
    /// </summary>
    public string VanState { get; set; }
    /// <summary>
    /// Get or set van model
    /// </summary>
    public string VanVanModel { get; set; }
    /// <summary>
    /// Get or set van registration no.
    /// </summary>
    public string VanRegistrationNumber { get; set; }
    /// <summary>
    /// Get or set van registration no.
    /// </summary>
    public string VanVanRegisteredAs { get; set; }
    /// <summary>
    /// Get or set van/dealer organization name
    /// </summary>
    public string DealerVanOrganizationName { get; set; }
    /// <summary>
    /// Get or set van/dealer organization alias
    /// </summary>
    public string DealerVanOrganizationOrganizationAlias { get; set; }
    /// <summary>
    /// Get or set van/dealer organization city
    /// </summary>
    public string DealerVanOrganizationOrganizationCity { get; set; }
    /// <summary>
    /// Get or set van/dealer organization state
    /// </summary>
    public string DealerVanOrganizationOrganizationState { get; set; }
    /// <summary>
    /// Get or set van/dealer organization country
    /// </summary>
    public string DealerVanOrganizationOrganizationCountry { get; set; }
    /// <summary>
    /// Get or set van/dealer organization description
    /// </summary>
    public string DealerVanOrganizationOrganizationDescription { get; set; }
    /// <summary>
    /// Get or set van/dealer organization path
    /// </summary>
    public string DealerVanOrganizationOrganizationPath { get; set; }
    /// <summary>
    /// Get or set van/dealer organization depth
    /// </summary>
    public string DealerVanOrganizationOrganizationDepth { get; set; }
    /// <summary>
    /// Get or set van/dealer organization color code
    /// </summary>
    public string DealerVanOrganizationOrganizationColor { get; set; }
    /// <summary>
    /// Get or set van/dealer organization region
    /// </summary>
    public string DealerVanOrganizationOrganizationRegion { get; set; }
    /// <summary>
    /// Get or set service engineer id
    /// </summary>
    public string ServiceEngineerId { get; set; }
    /// <summary>
    /// Get or set service engineer alias
    /// </summary>
    public string ServiceEngineerAlias { get; set; }
    /// <summary>
    /// Get or set service engineer imei no.
    /// </summary>
    public string ServiceEngineerImeiNumber { get; set; }
    /// <summary>
    /// Get or set service engineer license key
    /// </summary>
    public string ServiceEngineerApplicationLicenseKey { get; set; }
    /// <summary>
    /// Get or set service engineer Mobile Application Blocked (true/false)
    /// </summary>
    public string ServiceEngineerMobileApplicationBlocked { get; set; }
    /// <summary>
    /// Get or set service engineer device alias
    /// </summary>
    public string ServiceEngineerDeviceAlias { get; set; }
    /// <summary>
    /// Get or set service engineer pin password
    /// </summary>
    public string ServiceEngineerPinPassword { get; set; }
    /// <summary>
    /// Get or set route id
    /// </summary>
    public string RouteId { get; set; }
    /// <summary>
    /// Get or set vehicle type
    /// </summary>
    public string VehicleType { get; set; }
    /// <summary>
    /// Get or set repair cost
    /// </summary>
    public string RepairCost { get; set; }
    /// <summary>
    /// Get or set device alias
    /// </summary>
    public string DeviceAlias { get; set; }
    /// <summary>
    /// Get or set imei no.
    /// </summary>
    public string Ieminumber { get; set; }
    /// <summary>
    /// Get or set SLA missed reason
    /// </summary>
    public string SlaMissedReason { get; set; }
    /// <summary>
    /// Get or set suggestion comment
    /// </summary>
    public string SuggestionComment { get; set; }
    /// <summary>
    /// Get or set Job Complete Response Time
    /// </summary>
    public string JobCompleteResponseTime { get; set; }
    /// <summary>
    /// Get or set default column
    /// </summary>
    public string DefaultCol3 { get; set; }
    // public string CustomerName { get; set; }

    /// <summary>
    /// Get or set Estimated Distance
    /// </summary>
    public string EstimatedDistance { get; set; }
    /// <summary>
    /// Get or set age
    /// </summary>
    public double? Age { get; set; }
    public string CallStatus { get; set; }
    public string Id { get; set; }

    public bool CreationTimeMorethan24Hrs
    {
      get
      {
        bool _CreationTimeMorethan24Hrs = false;
        if (_CreationTime != "")
        {
          DateTime dtNow = DateTime.Parse(_CreationTime);
          double dtDiff = (DateTime.Now - dtNow).TotalMinutes;
          if (dtDiff > 1440)
          {
            _CreationTimeMorethan24Hrs = true;

          }
        }
        return _CreationTimeMorethan24Hrs;
      }
    }




  }


  public class TicketList
  {
    public string _CreationTime = "";
    /// <summary>
    /// Get or set Ticket id
    /// </summary>
    [Display(Name = "Ticket Id")]
    public string ticketid_alias { get; set; }
    /// <summary>
    /// Get or set Ticket status alias
    /// </summary>
    [Display(Name = "Ticket Status")]
    public string TicketStatusAlias { get; set; }
    /// <summary>
    /// Get or set creation time of ticket
    /// </summary>
    [Display(Name = "Ticket Creation Time")]
    public string CreationTime { get { return _CreationTime; } set { _CreationTime = value; } }
    /// <summary>
    /// Get or set customer name
    /// </summary>
    [Display(Name = "Customer Name")]
    public string CustomerName { get; set; }
    /// <summary>
    /// Get or set Customer Contact No.
    /// </summary>
    [Display(Name = "Customer Contact No.")]
    public string CustomeContact_no { get; set; }
    /// <summary>
    /// Get or set customer's vehicle registration no.
    /// </summary>
    public string VehicleRegistrationNo { get; set; }
    /// <summary>
    /// Get or set Vehicle Tagging
    /// </summary>
    public string VehicleTagging { get; set; }
    /// <summary>
    /// Get or set Default SLA Time
    /// </summary>
    public int DefaultSlaTime { get; set; }
    /// <summary>
    /// Get or set Response Time
    /// </summary>
    [Display(Name = "Response(In min)")]
    public int? TotalTicketLifeCycleTimeSlab { get; set; }
    /// <summary>
    /// Get or set Service Engineer Name
    /// </summary>
    // [Display(Name = "Van SE Name")]
    public string ServiceEngineerName { get; set; }
    /// <summary>
    /// Get or set Dealer Name
    /// </summary>
    [Display(Name = "Dealer Name")]
    public string DealerDealerName { get; set; }
    /// <summary>
    /// Get or set Dealer Contact No.
    /// </summary>
    [Display(Name = "Dealer Contact No.")]
    public string ServiceEngineerContactNumber { get; set; }
    public string caller_language { get; set; }
    /// <summary>
    /// Get or set default column
    /// </summary>
    public string DefaultCol2 { get; set; }
    /// <summary>
    /// Get or set Security Token
    /// </summary>
    public string feedback_call_status { get; set; }
    /// <summary>
    /// Get or set Status
    /// </summary>
    public string total_count { get; set; }
    public string reopen_count { get; set; }

    public string PreClosureTime { get; set; }
    public string ChassisNo { get; set; }
    public double OdometerReading { get; set; }

    public string VanReachedPunchTime { get; set; }    //added on 23-12-2020


    //added on 25-09-2020
    //[Display(Name = "Van Trip Start Latitude")]
    public string VanLatitudeAtTripStart { get; set; }

    //[Display(Name = "Van Trip Start Longitude")]
    public string VanLongitudeAtTripStart { get; set; }

    //[Display(Name = "Van Reached Latitude")]
    public string VanLatitudeAtVanReached { get; set; }

    //[Display(Name = "Van Reached Longitude")]
    public string VanLongitudeAtVanReached { get; set; }

    //[Display(Name = "Van Trip End Latitude")]
    public string VanLatitudeAtTripEnd { get; set; }

    //[Display(Name = "Van Reached Longitude")]
    public string VanLongitudeAtTripEnd { get; set; }

    public string BreakdownLocationLatitude { get; set; }

    public string BreakdownLocationLongitude { get; set; }


    //added on 03/12/2020
    public string vehicle_warranty { get; set; }
    public string vehicle_amc { get; set; }
    public string vehicle_emission_norms { get; set; }
    public string vehicle_sales_date { get; set; }
    //ended on 03/12/2020

    public string TicketClosedReason { get; set; }  //added on 25-11-2020

    public string LastModifiedTime { get; set; }


    /// <summary>
    /// Get or set Message
    /// </summary>
    public string gps_status { get; set; }


    public string Score { get; set; }
    /// <summary>
    /// Get or set Security Token
    /// </summary>
    public string Token { get; set; }
    /// <summary>
    /// Get or set Status
    /// </summary>
    public string Status { get; set; }
    /// <summary>
    /// Get or set Message
    /// </summary>
    public string Message { get; set; }
    /// <summary>
    /// Get or set Description
    /// </summary>
    public string Description { get; set; }
    /// <summary>
    /// Get or set ticket assigned to (van/dealer)
    /// </summary>
    public string AssignedTo { get; set; }
    /// <summary>
    /// Get or set Reported bu which user
    /// </summary>
    public string ReportedVia { get; set; }
    /// <summary>
    /// Get or set Ticket status
    /// </summary>
    public string TicketStatus { get; set; }
    /// <summary>
    /// Get or set priority
    /// </summary>
    public string Priority { get; set; }
    /// <summary>
    /// Get or set customer score
    /// </summary>
    public string CutomerScore { get; set; }
    /// <summary>
    /// Get or set created by which user
    /// </summary>
    public string CreatedBy { get; set; }
    /// <summary>




    /// Get or set last modified by which user
    /// </summary>
    public string LastModifiedBy { get; set; }
    /// <summary>
    /// Get or set last modified time
    /// </summary>
    // public string LastModifiedTime { get; set; }
    /// <summary>
    /// Get or set breakdown location
    /// </summary>
    public string BreakDownLocation { get; set; }
    /// <summary>
    /// Get or set breakdown longitude
    /// </summary>
    public string BreackDownLongitude { get; set; }
    /// <summary>
    /// Get or set breakdown latitude
    /// </summary>
    public string BreackDownLatitude { get; set; }
    /// <summary>
    /// Get or set assigned to van/dealer id
    /// </summary>
    public string AssignedToUserId { get; set; }
    /// <summary>
    /// Get or set assigned van/dealer longitude
    /// </summary>
    public string AssignedToUserLongitude { get; set; }
    /// <summary>
    /// Get or set assigned van/dealer latitude
    /// </summary>
    public string AssignedToUserLatitude { get; set; }
    /// <summary>
    /// Get or set is declined bit
    /// </summary>
    public string IsDeclined { get; set; }
    /// <summary>
    /// Get or set Estimated Time For Job Completion
    /// </summary>
    public string EstimatedTimeForJobComplition { get; set; }
    /// <summary>
    /// Get or set submit time 
    /// </summary>
    public string EstimatedTimeForJobComplitionSubmitTime { get; set; }
    /// <summary>
    /// Get or set submit time 
    /// </summary>
    public string EstimatedTimeForJobCompletionSubmitTime { get; set; }
    /// <summary>
    /// Get or set breakdown location landmark
    /// </summary>
    public string BreakdownLocationLandmark { get; set; }
    /// <summary>
    /// Get or set open ticket activity created by
    /// </summary>
    public string ActivityTicketsOpenCreatedBy { get; set; }
    /// <summary>
    /// Get or set open ticket activity creation time
    /// </summary>
    public string ActivityTicketsOpenCreationTime { get; set; }
    /// <summary>
    /// Get or set remarks
    /// </summary>
    public string Remarks { get; set; }
    /// <summary>
    /// Get or set Ticket activity status
    /// </summary>
    public string TicketActivityStatus { get; set; }
    /// <summary>
    /// Get or set Ticket status sequence for activity
    /// </summary>
    public string TicketStatusSequenceOrder { get; set; }
    /// <summary>
    /// Get or set Ticket status name
    /// </summary>
    public string TicketStatusStatusName { get; set; }
    /// <summary>
    /// Get or set user id
    /// </summary>
    public string UserId { get; set; }
    /// <summary>
    /// Get or set auth engine id/email id
    /// </summary>
    public string AuthEngineId { get; set; }
    /// <summary>
    /// Get or set User name
    /// </summary>
    public string UserName { get; set; }
    /// <summary>
    /// Get or set Designation
    /// </summary>
    public string Designation { get; set; }
    /// <summary>
    /// Get or set Object Id
    /// </summary>
    public string ObjectId { get; set; }
    /// <summary>
    /// Get or set Organization Id
    /// </summary>
    public string OrganizationId { get; set; }
    /// <summary>
    /// Get or set City
    /// </summary>
    public string City { get; set; }
    /// <summary>
    /// Get or set State
    /// </summary>
    public string State { get; set; }
    /// <summary>
    /// Get or set Region
    /// </summary>
    public string Region { get; set; }
    /// <summary>
    /// Get or set Language
    /// </summary>
    public string Language { get; set; }
    /// <summary>
    /// Get or set Time Zone ID
    /// </summary>
    public string TimezoneId { get; set; }
    /// <summary>
    /// Get or set display name
    /// </summary>
    public string DisplayName { get; set; }
    /// <summary>
    /// Get or set off set minutes for server side paging
    /// </summary>
    public string OffsetInMinutes { get; set; }
    /// <summary>
    /// Get or set Display Id
    /// </summary>
    public string DisplayId { get; set; }
    /// <summary>
    /// Get or set User Organization Name
    /// </summary>
    public string UserOrganizationName { get; set; }
    /// <summary>
    /// Get or set User Organization Alias
    /// </summary>
    public string UserOrganizationAlias { get; set; }
    /// <summary>
    /// Get or set User Organization City
    /// </summary>
    public string UserOrganizationCity { get; set; }
    /// <summary>
    /// Get or set User Organization State
    /// </summary>
    public string UserOrganizationState { get; set; }
    /// <summary>
    /// Get or set User Organization Country
    /// </summary>
    public string UserAsorganizationCountry { get; set; }
    /// <summary>
    /// Get or set User Organization Description
    /// </summary>
    public string UserOrganizationDescription { get; set; }
    /// <summary>
    /// Get or set User Organization Path
    /// </summary>
    public string UserOrgPath { get; set; }
    /// <summary>
    /// Get or set User Organization Depth (Levels)
    /// </summary>
    public string UserOrgDepth { get; set; }
    /// <summary>
    /// Get or set User Organization Color code
    /// </summary>
    public string UserOrgColor { get; set; }
    /// <summary>
    /// Get or set User Organization Region
    /// </summary>
    public string UserOrganizationRegion { get; set; }
    /// <summary>
    /// Get or set Dealer Id
    /// </summary>
    public string DealerId { get; set; }
    /// <summary>
    /// Get or set Dealer Organization Id
    /// </summary>
    public string DealerOrganizationId { get; set; }
    /// <summary>
    /// Get or set Dealer City
    /// </summary>
    public string DealerCity { get; set; }
    /// <summary>
    /// Get or set Dealer State
    /// </summary>
    public string DealerState { get; set; }
    /// <summary>
    /// Get or set Dealer Default latitude
    /// </summary>
    public string DealerDealerDefaultLattitude { get; set; }
    /// <summary>
    /// Get or set Dealer Default longitude
    /// </summary>
    public string DealerDealerDefaultLongitude { get; set; }
    /// <summary>
    /// Get or set van id
    /// </summary>
    public string VanId { get; set; }
    /// <summary>
    /// Get or set van alias
    /// </summary>
    public string VanAlias { get; set; }
    /// <summary>
    /// Get or set van Default latitude
    /// </summary>
    public string VanVanDefaultLattitude { get; set; }
    /// <summary>
    /// Get or set van Default longitude
    /// </summary>
    public string VanVanDefaultLongitude { get; set; }
    /// <summary>
    /// Get or set van city
    /// </summary>
    public string VanCity { get; set; }
    /// <summary>
    /// Get or set van state
    /// </summary>
    public string VanState { get; set; }
    /// <summary>
    /// Get or set van model
    /// </summary>
    public string VanVanModel { get; set; }
    /// <summary>
    /// Get or set van registration no.
    /// </summary>
    public string VanRegistrationNumber { get; set; }
    /// <summary>
    /// Get or set van registration no.
    /// </summary>
    public string VanVanRegisteredAs { get; set; }
    /// <summary>
    /// Get or set van/dealer organization name
    /// </summary>
    public string DealerVanOrganizationName { get; set; }
    /// <summary>
    /// Get or set van/dealer organization alias
    /// </summary>
    public string DealerVanOrganizationOrganizationAlias { get; set; }
    /// <summary>
    /// Get or set van/dealer organization city
    /// </summary>
    public string DealerVanOrganizationOrganizationCity { get; set; }
    /// <summary>
    /// Get or set van/dealer organization state
    /// </summary>
    public string DealerVanOrganizationOrganizationState { get; set; }
    /// <summary>
    /// Get or set van/dealer organization country
    /// </summary>
    public string DealerVanOrganizationOrganizationCountry { get; set; }
    /// <summary>
    /// Get or set van/dealer organization description
    /// </summary>
    public string DealerVanOrganizationOrganizationDescription { get; set; }
    /// <summary>
    /// Get or set van/dealer organization path
    /// </summary>
    public string DealerVanOrganizationOrganizationPath { get; set; }
    /// <summary>
    /// Get or set van/dealer organization depth
    /// </summary>
    public string DealerVanOrganizationOrganizationDepth { get; set; }
    /// <summary>
    /// Get or set van/dealer organization color code
    /// </summary>
    public string DealerVanOrganizationOrganizationColor { get; set; }
    /// <summary>
    /// Get or set van/dealer organization region
    /// </summary>
    public string DealerVanOrganizationOrganizationRegion { get; set; }
    /// <summary>
    /// Get or set service engineer id
    /// </summary>
    public string ServiceEngineerId { get; set; }
    /// <summary>
    /// Get or set service engineer alias
    /// </summary>
    public string ServiceEngineerAlias { get; set; }
    /// <summary>
    /// Get or set service engineer imei no.
    /// </summary>
    public string ServiceEngineerImeiNumber { get; set; }
    /// <summary>
    /// Get or set service engineer license key
    /// </summary>
    public string ServiceEngineerApplicationLicenseKey { get; set; }
    /// <summary>
    /// Get or set service engineer Mobile Application Blocked (true/false)
    /// </summary>
    public string ServiceEngineerMobileApplicationBlocked { get; set; }
    /// <summary>
    /// Get or set service engineer device alias
    /// </summary>
    public string ServiceEngineerDeviceAlias { get; set; }
    /// <summary>
    /// Get or set service engineer pin password
    /// </summary>
    public string ServiceEngineerPinPassword { get; set; }
    /// <summary>
    /// Get or set route id
    /// </summary>
    public string RouteId { get; set; }
    /// <summary>
    /// Get or set vehicle type
    /// </summary>
    public string VehicleType { get; set; }
    /// <summary>
    /// Get or set repair cost
    /// </summary>
    public string RepairCost { get; set; }
    /// <summary>
    /// Get or set device alias
    /// </summary>
    public string DeviceAlias { get; set; }
    /// <summary>
    /// Get or set imei no.
    /// </summary>
    public string Ieminumber { get; set; }
    /// <summary>
    /// Get or set SLA missed reason
    /// </summary>
    public string SlaMissedReason { get; set; }
    /// <summary>
    /// Get or set suggestion comment
    /// </summary>
    public string SuggestionComment { get; set; }
    /// <summary>
    /// Get or set Job Complete Response Time
    /// </summary>
    public string JobCompleteResponseTime { get; set; }
    /// <summary>
    /// Get or set default column
    /// </summary>
    public string DefaultCol3 { get; set; }
    // public string CustomerName { get; set; }

    /// <summary>
    /// Get or set Estimated Distance
    /// </summary>
    public string EstimatedDistance { get; set; }
    /// <summary>
    /// Get or set age
    /// </summary>
    public double? Age { get; set; }
    public string CallStatus { get; set; }
    public string Id { get; set; }

    public bool CreationTimeMorethan24Hrs
    {
      get
      {
        bool _CreationTimeMorethan24Hrs = false;
        if (_CreationTime != "")
        {
          DateTime dtNow = DateTime.Parse(_CreationTime);
          double dtDiff = (DateTime.Now - dtNow).TotalMinutes;
          if (dtDiff > 1440)
          {
            _CreationTimeMorethan24Hrs = true;

          }
        }
        return _CreationTimeMorethan24Hrs;
      }
    }




  }

  public class TicketListNew
  {
    public string _CreationTime = "";
    /// <summary>
    /// Get or set Ticket id
    /// </summary>
    [Display(Name = "Ticket Id")]
    public string ticketid_alias { get; set; }
    /// <summary>
    /// Get or set Ticket status alias
    /// </summary>
    [Display(Name = "Ticket Status")]
    public string TicketStatusAlias { get; set; }
    /// <summary>
    /// Get or set creation time of ticket
    /// </summary>
    [Display(Name = "Ticket Creation Time")]
    public string CreationTime { get { return _CreationTime; } set { _CreationTime = value; } }
    /// <summary>
    /// Get or set customer name
    /// </summary>
    [Display(Name = "Customer Name")]
    public string CustomerName { get; set; }
    /// <summary>
    /// Get or set Customer Contact No.
    /// </summary>
    [Display(Name = "Customer Contact No.")]
    public string CustomeContact_no { get; set; }
    /// <summary>
    /// Get or set customer's vehicle registration no.
    /// </summary>
    public string VehicleRegistrationNo { get; set; }
    /// <summary>
    /// Get or set Vehicle Tagging
    /// </summary>
    public string VehicleTagging { get; set; }
    /// <summary>
    /// Get or set Default SLA Time
    /// </summary>
    public int DefaultSlaTime { get; set; }
    /// <summary>
    /// Get or set Response Time
    /// </summary>
    [Display(Name = "Response(In min)")]
    public int? TotalTicketLifeCycleTimeSlab { get; set; }
    /// <summary>
    /// Get or set Service Engineer Name
    /// </summary>
    // [Display(Name = "Van SE Name")]
    public string ServiceEngineerName { get; set; }
    /// <summary>
    /// Get or set Dealer Name
    /// </summary>
    [Display(Name = "Dealer Name")]
    public string DealerDealerName { get; set; }
    /// <summary>
    /// Get or set Dealer Contact No.
    /// </summary>
    [Display(Name = "Dealer Contact No.")]
    public string ServiceEngineerContactNumber { get; set; }
    public string caller_language { get; set; }
    /// <summary>
    /// Get or set default column
    /// </summary>
    public string DefaultCol2 { get; set; }
    /// <summary>
    /// Get or set Security Token
    /// </summary>
    public string feedback_call_status { get; set; }
    /// <summary>
    /// Get or set Status
    /// </summary>
    public string total_count { get; set; }
    public string reopen_count { get; set; }

    public string PreClosureTime { get; set; }
    public string ChassisNo { get; set; }
    public double OdometerReading { get; set; }

    public string VanReachedPunchTime { get; set; }    //added on 23-12-2020


    //added on 25-09-2020
    //[Display(Name = "Van Trip Start Latitude")]
    public string VanLatitudeAtTripStart { get; set; }

    //[Display(Name = "Van Trip Start Longitude")]
    public string VanLongitudeAtTripStart { get; set; }

    //[Display(Name = "Van Reached Latitude")]
    public string VanLatitudeAtVanReached { get; set; }

    //[Display(Name = "Van Reached Longitude")]
    public string VanLongitudeAtVanReached { get; set; }

    //[Display(Name = "Van Trip End Latitude")]
    public string VanLatitudeAtTripEnd { get; set; }

    //[Display(Name = "Van Reached Longitude")]
    public string VanLongitudeAtTripEnd { get; set; }

    public string BreakdownLocationLatitude { get; set; }

    public string BreakdownLocationLongitude { get; set; }


    //added on 03/12/2020
    public string vehicle_warranty { get; set; }
    public string vehicle_amc { get; set; }
    public string vehicle_emission_norms { get; set; }
    public string vehicle_sales_date { get; set; }
    //ended on 03/12/2020

    public string TicketClosedReason { get; set; }  //added on 25-11-2020

    public string LastModifiedTime { get; set; }


    /// <summary>
    /// Get or set Message
    /// </summary>
    public string gps_status { get; set; }


    public string Score { get; set; }
    /// <summary>
    /// Get or set Security Token
    /// </summary>
    public string Token { get; set; }
    /// <summary>
    /// Get or set Status
    /// </summary>
    public string Status { get; set; }
    /// <summary>
    /// Get or set Message
    /// </summary>
    public string Message { get; set; }
    /// <summary>
    /// Get or set Description
    /// </summary>
    public string Description { get; set; }
    /// <summary>
    /// Get or set ticket assigned to (van/dealer)
    /// </summary>
    public string AssignedTo { get; set; }
    /// <summary>
    /// Get or set Reported bu which user
    /// </summary>
    public string ReportedVia { get; set; }
    /// <summary>
    /// Get or set Ticket status
    /// </summary>
    public string TicketStatus { get; set; }
    /// <summary>
    /// Get or set priority
    /// </summary>
    public string Priority { get; set; }
    /// <summary>
    /// Get or set customer score
    /// </summary>
    public string CutomerScore { get; set; }
    /// <summary>
    /// Get or set created by which user
    /// </summary>
    public string CreatedBy { get; set; }
    /// <summary>




    /// Get or set last modified by which user
    /// </summary>
    public string LastModifiedBy { get; set; }
    /// <summary>
    /// Get or set last modified time
    /// </summary>
    // public string LastModifiedTime { get; set; }
    /// <summary>
    /// Get or set breakdown location
    /// </summary>
    public string BreakDownLocation { get; set; }
    /// <summary>
    /// Get or set breakdown longitude
    /// </summary>
    public string BreackDownLongitude { get; set; }
    /// <summary>
    /// Get or set breakdown latitude
    /// </summary>
    public string BreackDownLatitude { get; set; }
    /// <summary>
    /// Get or set assigned to van/dealer id
    /// </summary>
    public string AssignedToUserId { get; set; }
    /// <summary>
    /// Get or set assigned van/dealer longitude
    /// </summary>
    public string AssignedToUserLongitude { get; set; }
    /// <summary>
    /// Get or set assigned van/dealer latitude
    /// </summary>
    public string AssignedToUserLatitude { get; set; }
    /// <summary>
    /// Get or set is declined bit
    /// </summary>
    public string IsDeclined { get; set; }
    /// <summary>
    /// Get or set Estimated Time For Job Completion
    /// </summary>
    public string EstimatedTimeForJobComplition { get; set; }
    /// <summary>
    /// Get or set submit time 
    /// </summary>
    public string EstimatedTimeForJobComplitionSubmitTime { get; set; }
    /// <summary>
    /// Get or set submit time 
    /// </summary>
    public string EstimatedTimeForJobCompletionSubmitTime { get; set; }
    /// <summary>
    /// Get or set breakdown location landmark
    /// </summary>
    public string BreakdownLocationLandmark { get; set; }
    /// <summary>
    /// Get or set open ticket activity created by
    /// </summary>
    public string ActivityTicketsOpenCreatedBy { get; set; }
    /// <summary>
    /// Get or set open ticket activity creation time
    /// </summary>
    public string ActivityTicketsOpenCreationTime { get; set; }
    /// <summary>
    /// Get or set remarks
    /// </summary>
    public string Remarks { get; set; }
    /// <summary>
    /// Get or set Ticket activity status
    /// </summary>
    public string TicketActivityStatus { get; set; }
    /// <summary>
    /// Get or set Ticket status sequence for activity
    /// </summary>
    public string TicketStatusSequenceOrder { get; set; }
    /// <summary>
    /// Get or set Ticket status name
    /// </summary>
    public string TicketStatusStatusName { get; set; }
    /// <summary>
    /// Get or set user id
    /// </summary>
    public string UserId { get; set; }
    /// <summary>
    /// Get or set auth engine id/email id
    /// </summary>
    public string AuthEngineId { get; set; }
    /// <summary>
    /// Get or set User name
    /// </summary>
    public string UserName { get; set; }
    /// <summary>
    /// Get or set Designation
    /// </summary>
    public string Designation { get; set; }
    /// <summary>
    /// Get or set Object Id
    /// </summary>
    public string ObjectId { get; set; }
    /// <summary>
    /// Get or set Organization Id
    /// </summary>
    public string OrganizationId { get; set; }
    /// <summary>
    /// Get or set City
    /// </summary>
    public string City { get; set; }
    /// <summary>
    /// Get or set State
    /// </summary>
    public string State { get; set; }
    /// <summary>
    /// Get or set Region
    /// </summary>
    public string Region { get; set; }
    /// <summary>
    /// Get or set Language
    /// </summary>
    public string Language { get; set; }
    /// <summary>
    /// Get or set Time Zone ID
    /// </summary>
    public string TimezoneId { get; set; }
    /// <summary>
    /// Get or set display name
    /// </summary>
    public string DisplayName { get; set; }
    /// <summary>
    /// Get or set off set minutes for server side paging
    /// </summary>
    public string OffsetInMinutes { get; set; }
    /// <summary>
    /// Get or set Display Id
    /// </summary>
    public string DisplayId { get; set; }
    /// <summary>
    /// Get or set User Organization Name
    /// </summary>
    public string UserOrganizationName { get; set; }
    /// <summary>
    /// Get or set User Organization Alias
    /// </summary>
    public string UserOrganizationAlias { get; set; }
    /// <summary>
    /// Get or set User Organization City
    /// </summary>
    public string UserOrganizationCity { get; set; }
    /// <summary>
    /// Get or set User Organization State
    /// </summary>
    public string UserOrganizationState { get; set; }
    /// <summary>
    /// Get or set User Organization Country
    /// </summary>
    public string UserAsorganizationCountry { get; set; }
    /// <summary>
    /// Get or set User Organization Description
    /// </summary>
    public string UserOrganizationDescription { get; set; }
    /// <summary>
    /// Get or set User Organization Path
    /// </summary>
    public string UserOrgPath { get; set; }
    /// <summary>
    /// Get or set User Organization Depth (Levels)
    /// </summary>
    public string UserOrgDepth { get; set; }
    /// <summary>
    /// Get or set User Organization Color code
    /// </summary>
    public string UserOrgColor { get; set; }
    /// <summary>
    /// Get or set User Organization Region
    /// </summary>
    public string UserOrganizationRegion { get; set; }
    /// <summary>
    /// Get or set Dealer Id
    /// </summary>
    public string DealerId { get; set; }
    /// <summary>
    /// Get or set Dealer Organization Id
    /// </summary>
    public string DealerOrganizationId { get; set; }
    /// <summary>
    /// Get or set Dealer City
    /// </summary>
    public string DealerCity { get; set; }
    /// <summary>
    /// Get or set Dealer State
    /// </summary>
    public string DealerState { get; set; }
    /// <summary>
    /// Get or set Dealer Default latitude
    /// </summary>
    public string DealerDealerDefaultLattitude { get; set; }
    /// <summary>
    /// Get or set Dealer Default longitude
    /// </summary>
    public string DealerDealerDefaultLongitude { get; set; }
    /// <summary>
    /// Get or set van id
    /// </summary>
    public string VanId { get; set; }
    /// <summary>
    /// Get or set van alias
    /// </summary>
    public string VanAlias { get; set; }
    /// <summary>
    /// Get or set van Default latitude
    /// </summary>
    public string VanVanDefaultLattitude { get; set; }
    /// <summary>
    /// Get or set van Default longitude
    /// </summary>
    public string VanVanDefaultLongitude { get; set; }
    /// <summary>
    /// Get or set van city
    /// </summary>
    public string VanCity { get; set; }
    /// <summary>
    /// Get or set van state
    /// </summary>
    public string VanState { get; set; }
    /// <summary>
    /// Get or set van model
    /// </summary>
    public string VanVanModel { get; set; }
    /// <summary>
    /// Get or set van registration no.
    /// </summary>
    public string VanRegistrationNumber { get; set; }
    /// <summary>
    /// Get or set van registration no.
    /// </summary>
    public string VanVanRegisteredAs { get; set; }
    /// <summary>
    /// Get or set van/dealer organization name
    /// </summary>
    public string DealerVanOrganizationName { get; set; }
    /// <summary>
    /// Get or set van/dealer organization alias
    /// </summary>
    public string DealerVanOrganizationOrganizationAlias { get; set; }
    /// <summary>
    /// Get or set van/dealer organization city
    /// </summary>
    public string DealerVanOrganizationOrganizationCity { get; set; }
    /// <summary>
    /// Get or set van/dealer organization state
    /// </summary>
    public string DealerVanOrganizationOrganizationState { get; set; }
    /// <summary>
    /// Get or set van/dealer organization country
    /// </summary>
    public string DealerVanOrganizationOrganizationCountry { get; set; }
    /// <summary>
    /// Get or set van/dealer organization description
    /// </summary>
    public string DealerVanOrganizationOrganizationDescription { get; set; }
    /// <summary>
    /// Get or set van/dealer organization path
    /// </summary>
    public string DealerVanOrganizationOrganizationPath { get; set; }
    /// <summary>
    /// Get or set van/dealer organization depth
    /// </summary>
    public string DealerVanOrganizationOrganizationDepth { get; set; }
    /// <summary>
    /// Get or set van/dealer organization color code
    /// </summary>
    public string DealerVanOrganizationOrganizationColor { get; set; }
    /// <summary>
    /// Get or set van/dealer organization region
    /// </summary>
    public string DealerVanOrganizationOrganizationRegion { get; set; }
    /// <summary>
    /// Get or set service engineer id
    /// </summary>
    public string ServiceEngineerId { get; set; }
    /// <summary>
    /// Get or set service engineer alias
    /// </summary>
    public string ServiceEngineerAlias { get; set; }
    /// <summary>
    /// Get or set service engineer imei no.
    /// </summary>
    public string ServiceEngineerImeiNumber { get; set; }
    /// <summary>
    /// Get or set service engineer license key
    /// </summary>
    public string ServiceEngineerApplicationLicenseKey { get; set; }
    /// <summary>
    /// Get or set service engineer Mobile Application Blocked (true/false)
    /// </summary>
    public string ServiceEngineerMobileApplicationBlocked { get; set; }
    /// <summary>
    /// Get or set service engineer device alias
    /// </summary>
    public string ServiceEngineerDeviceAlias { get; set; }
    /// <summary>
    /// Get or set service engineer pin password
    /// </summary>
    public string ServiceEngineerPinPassword { get; set; }
    /// <summary>
    /// Get or set route id
    /// </summary>
    public string RouteId { get; set; }
    /// <summary>
    /// Get or set vehicle type
    /// </summary>
    public string VehicleType { get; set; }
    /// <summary>
    /// Get or set repair cost
    /// </summary>
    public string RepairCost { get; set; }
    /// <summary>
    /// Get or set device alias
    /// </summary>
    public string DeviceAlias { get; set; }
    /// <summary>
    /// Get or set imei no.
    /// </summary>
    public string Ieminumber { get; set; }
    /// <summary>
    /// Get or set SLA missed reason
    /// </summary>
    public string SlaMissedReason { get; set; }
    /// <summary>
    /// Get or set suggestion comment
    /// </summary>
    public string SuggestionComment { get; set; }
    /// <summary>
    /// Get or set Job Complete Response Time
    /// </summary>
    public string JobCompleteResponseTime { get; set; }
    /// <summary>
    /// Get or set default column
    /// </summary>
    public string DefaultCol3 { get; set; }
    // public string CustomerName { get; set; }

    /// <summary>
    /// Get or set Estimated Distance
    /// </summary>
    public string EstimatedDistance { get; set; }
    /// <summary>
    /// Get or set age
    /// </summary>
    public double? Age { get; set; }
    public string CallStatus { get; set; }
    public string Id { get; set; }

    public bool CreationTimeMorethan24Hrs
    {
      get
      {
        bool _CreationTimeMorethan24Hrs = false;
        if (_CreationTime != "")
        {
          DateTime dtNow = DateTime.Parse(_CreationTime);
          double dtDiff = (DateTime.Now - dtNow).TotalMinutes;
          if (dtDiff > 1440)
          {
            _CreationTimeMorethan24Hrs = true;

          }
        }
        return _CreationTimeMorethan24Hrs;
      }
    }




  }


  public class TicketOpenModelNew
  {
    private string _PreClosureTime = "";
    /// <summary>
    /// Get or set Token
    /// </summary>
    public String Token { get; set; }

    /// <summary>
    /// Get or set KAM Id
    /// </summary>
    public string KamId { get; set; }

    /// <summary>
    /// Get or set ticket id alias
    /// </summary>
    public string ticketid_alias { get; set; }

    //--- added on 06-01-2020 start -----------

    //public string vehicle_warranty { get; set; }

    //public string vehicle_amc { get; set; }

    public double odometer_reading { get; set; }

    //public string vehicle_sales_date { get; set; }

    public string ticket_source { get; set; }

    public string customer_id { get; set; }

    public string customer_type { get; set; }

    public string owner_name { get; set; }

    public Boolean? is_kam { get; set; }

    public string NewVehicleType { get; set; }  //added on 11-01-2021

    //--- added on 06-01-2020 end -------------

    /// <summary>
    /// Get or set Status
    /// </summary>
    public string Status { get; set; }

    /// <summary>
    /// Get or set Message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// Get or set Id
    /// </summary>
    public string Id { get; set; }

    /// <summary>
    /// Get or set Description
    /// </summary>
    public string Description { get; set; }

    /// <summary>
    /// Get or set Assigned To
    /// </summary>
    public string AssignedTo { get; set; }

    /// <summary>
    /// Get or set Reported Via
    /// </summary>
    public string ReportedVia { get; set; }

    /// <summary>
    /// Get or set Ticket Status
    /// </summary>
    public int? TicketStatus { get; set; }

    /// <summary>
    /// Get or set Priority
    /// </summary>
    public int? Priority { get; set; }

    /// <summary>
    /// Get or set Cutomer Score
    /// </summary>
    public string CutomerScore { get; set; }

    /// <summary>
    /// Get or set Created By
    /// </summary>
    public string CreatedBy { get; set; }

    /// <summary>
    /// Get or set Creation Time
    /// </summary>
    public string CreationTime { get; set; }

    /// <summary>
    /// Get or set Last Modified By
    /// </summary>
    public string LastModifiedBy { get; set; }

    /// <summary>
    /// Get or set Last Modified Time
    /// </summary>
    public string LastModifiedTime { get; set; }

    /// <summary>
    /// Get or set Break Down Location
    /// </summary>
    public string BreakDownLocation { get; set; }

    /// <summary>
    /// Get or set Breack Down Longitude
    /// </summary>
    public string BreackDownLongitude { get; set; }

    /// <summary>
    /// Get or set Breack Down Latitude
    /// </summary>
    public string BreackDownLatitude { get; set; }

    /// <summary>
    /// Get or set Assigned To User Id
    /// </summary> 
    public string AssignedToUserId { get; set; }

    /// <summary>
    /// Get or set Assigned To User Longitude
    /// </summary>
    public string AssignedToUserLongitude { get; set; }

    /// <summary>
    /// Get or set Assigned To User Latitude
    /// </summary>
    public string AssignedToUserLatitude { get; set; }

    /// <summary>
    /// Get or set Is Declined
    /// </summary>
    public Boolean? IsDeclined { get; set; }

    /// <summary>
    /// Get or set Estimated Time For Job Complition
    /// </summary>
    public int? EstimatedTimeForJobComplition { get; set; }

    /// <summary>
    /// Get or set Total Ticket Life Cycle Time Slab
    /// </summary>
    public int? TotalTicketLifeCycleTimeSlab { get; set; }

    /// <summary>
    /// Get or set Estimated Time For Job Complition Submit Time
    /// </summary>
    public string EstimatedTimeForJobComplitionSubmitTime { get; set; }

    /// <summary>
    /// Get or set Vehicle Registration No
    /// </summary>
    public string VehicleRegistrationNo { get; set; }

    /// <summary>
    /// Get or set Estimated Time For Job Completion Submit Time
    /// </summary>
    public string EstimatedTimeForJobCompletionSubmitTime { get; set; }

    /// <summary>
    /// Get or set Break down Location Landmark
    /// </summary>
    public string BreakdownLocationLandmark { get; set; }

    /// <summary>
    /// Get or set Activity Tickets Open Created By
    /// </summary>
    public string ActivityTicketsOpenCreatedBy { get; set; }

    /// <summary>
    /// Get or set Activity Tickets Open Creation Time
    /// </summary>
    public string ActivityTicketsOpenCreationTime { get; set; }

    /// <summary>
    /// Get or set Remarks
    /// </summary>
    public string Remarks { get; set; }

    /// <summary>
    /// Get or set Ticket Activity Status
    /// </summary>
    public string TicketActivityStatus { get; set; }

    /// <summary>
    /// Get or set Ticket Status Alias
    /// </summary> 
    public string TicketStatusAlias { get; set; }

    /// <summary>
    /// Get or set Ticket Status Sequence Order
    /// </summary>
    public string TicketStatusSequenceOrder { get; set; }

    /// <summary>
    /// Get or set Ticket Status  Name
    /// </summary>
    public string TicketStatusStatusName { get; set; }

    /// <summary>
    /// Get or set User Id
    /// </summary>
    public string UserId { get; set; }

    /// <summary>
    /// Get or set Auth Engine Id
    /// </summary>
    public string AuthEngineId { get; set; }

    /// <summary>
    /// Get or set User Name
    /// </summary>
    public string UserName { get; set; }

    /// <summary>
    /// Get or set Designation
    /// </summary>
    public string Designation { get; set; }

    /// <summary>
    /// Get or set Object Id
    /// </summary>
    public string ObjectId { get; set; }

    /// <summary>
    /// Get or set Organization Id
    /// </summary>
    public int? OrganizationId { get; set; }

    /// <summary>
    /// Get or set City
    /// </summary>
    public string City { get; set; }

    /// <summary>
    /// Get or set State
    /// </summary>
    public string State { get; set; }

    /// <summary>
    /// Get or set Region
    /// </summary>
    public string Region { get; set; }

    /// <summary>
    /// Get or set Language
    /// </summary>
    public string Language { get; set; }

    /// <summary>
    /// Get or set Timezone Id
    /// </summary>
    public Int64? TimezoneId { get; set; }

    /// <summary>
    /// Get or set Display Name
    /// </summary>
    public string DisplayName { get; set; }

    /// <summary>
    /// Get or set Offset In Minutes
    /// </summary>
    public string OffsetInMinutes { get; set; }

    /// <summary>
    /// Get or set Display Id
    /// </summary>
    public string DisplayId { get; set; }

    /// <summary>
    /// Get or set User Organization Name
    /// </summary>
    public string UserOrganizationName { get; set; }

    /// <summary>
    /// Get or set User Organization Alias
    /// </summary>
    public string UserOrganizationAlias { get; set; }

    /// <summary>
    /// Get or set User Organization City
    /// </summary>
    public string UserOrganizationCity { get; set; }

    /// <summary>
    /// Get or set User Organization State
    /// </summary>
    public string UserOrganizationState { get; set; }

    /// <summary>
    /// Get or set User Asorganization Country
    /// </summary>
    public string UserAsorganizationCountry { get; set; }

    /// <summary>
    /// Get or set User Organization Description
    /// </summary>
    public string UserOrganizationDescription { get; set; }

    /// <summary>
    /// Get or set User Org Path
    /// </summary>
    public string UserOrgPath { get; set; }

    /// <summary>
    /// Get or set User Org Depth
    /// </summary>
    public string UserOrgDepth { get; set; }

    /// <summary>
    /// Get or set User Org Color
    /// </summary>
    public string UserOrgColor { get; set; }

    /// <summary>
    /// Get or set User Organization Region
    /// </summary>
    public string UserOrganizationRegion { get; set; }

    /// <summary>
    /// Get or set Dealer Id
    /// </summary>
    public string DealerId { get; set; }

    /// <summary>
    /// Get or set Organization Id
    /// </summary>
    public int? DealerOrganizationId { get; set; }

    /// <summary>
    /// Get or set Dealer Name
    /// </summary>
    public string DealerDealerName { get; set; }

    /// <summary>
    /// Get or set Dealer City
    /// </summary>
    public string DealerCity { get; set; }

    /// <summary>
    /// Get or set Dealer State
    /// </summary> 
    public string DealerState { get; set; }

    /// <summary>
    /// Get or set Dealer Default Lattitude 
    /// </summary>
    public string DealerDealerDefaultLattitude { get; set; }

    /// <summary>
    /// Get or set Dealer Default Longitude
    /// </summary>
    public string DealerDealerDefaultLongitude { get; set; }

    /// <summary>
    /// Get or set Van Id
    /// </summary>
    public string VanId { get; set; }

    /// <summary>
    /// Get or set Van Alias
    /// </summary>
    public string VanAlias { get; set; }

    /// <summary>
    /// Get or set Van Default Lattitude
    /// </summary>
    public string VanVanDefaultLattitude { get; set; }

    /// <summary>
    /// Get or set Van Default Longitude
    /// </summary>
    public string VanVanDefaultLongitude { get; set; }

    /// <summary>
    /// Get or set Van City
    /// </summary>
    public string VanCity { get; set; }

    /// <summary>
    /// Get or set Van State
    /// </summary>
    public string VanState { get; set; }

    /// <summary>
    /// Get or set Van Model
    /// </summary>
    public string VanVanModel { get; set; }

    /// <summary>
    /// Get or set Van Registration Number
    /// </summary>
    public string VanRegistrationNumber { get; set; }

    /// <summary>
    /// Get or set Van Registered As
    /// </summary>
    public string VanVanRegisteredAs { get; set; }

    /// <summary>
    /// Get or set Organization Name
    /// </summary>
    public string DealerVanOrganizationName { get; set; }

    /// <summary>
    /// Get or set Organization Alias
    /// </summary>
    public string DealerVanOrganizationOrganizationAlias { get; set; }

    /// <summary>
    /// Get or set Organization City
    /// </summary>
    public string DealerVanOrganizationOrganizationCity { get; set; }

    /// <summary>
    /// Get or set Organization State
    /// </summary>
    public string DealerVanOrganizationOrganizationState { get; set; }

    /// <summary>
    /// Get or set Organization Country
    /// </summary>
    public string DealerVanOrganizationOrganizationCountry { get; set; }

    /// <summary>
    /// Get or set Organization Description
    /// </summary>
    public string DealerVanOrganizationOrganizationDescription { get; set; }

    /// <summary>
    /// Get or set Organization Path
    /// </summary>
    public string DealerVanOrganizationOrganizationPath { get; set; }

    /// <summary>
    /// Get or set Organization Depth
    /// </summary>
    public string DealerVanOrganizationOrganizationDepth { get; set; }

    /// <summary>
    /// Get or set Organization Color
    /// </summary>
    public string DealerVanOrganizationOrganizationColor { get; set; }

    /// <summary>
    /// Get or set Organization Region
    /// </summary>
    public string DealerVanOrganizationOrganizationRegion { get; set; }

    /// <summary>
    /// Get or set Service Engineer Id
    /// </summary>
    public string ServiceEngineerId { get; set; }

    /// <summary>
    /// Get or set Service Engineer Name
    /// </summary>
    public string ServiceEngineerName { get; set; }

    /// <summary>
    /// Get or set Service Engineer Alias
    /// </summary>
    public string ServiceEngineerAlias { get; set; }

    /// <summary>
    /// Get or set Service Engineer Imei Number
    /// </summary>
    public string ServiceEngineerImeiNumber { get; set; }

    /// <summary>
    /// Get or set Service Engineer Contact Number
    /// </summary>
    public string ServiceEngineerContactNumber { get; set; }

    /// <summary>
    /// Get or set Service Engineer Application License Key
    /// </summary>
    public string ServiceEngineerApplicationLicenseKey { get; set; }

    /// <summary>
    /// Get or set Service Engineer Mobile Application Blocked
    /// </summary>
    public Boolean? ServiceEngineerMobileApplicationBlocked { get; set; }

    /// <summary>
    /// Get or set Service Engineer Device Alias
    /// </summary>
    public Int64? ServiceEngineerDeviceAlias { get; set; }

    /// <summary>
    /// Get or set Service Engineer Pin Password
    /// </summary>
    public string ServiceEngineerPinPassword { get; set; }

    /// <summary>
    /// Get or set Route Id
    /// </summary>
    public int? RouteId { get; set; }

    /// <summary>
    /// Get or set Custome Contact_no
    /// </summary>
    public string CustomeContact_no { get; set; }

    /// <summary>
    /// Get or set Vehicle Type
    /// </summary>
    public string VehicleType { get; set; }

    /// <summary>
    /// Get or set Repair Cost
    /// </summary>
    public string RepairCost { get; set; }

    /// <summary>
    /// Get or set Default Sla Time
    /// </summary>
    public int? DefaultSlaTime { get; set; }

    /// <summary>
    /// Get or set Device Alias
    /// </summary>
    public int? DeviceAlias { get; set; }

    /// <summary>
    /// Get or set Iemi number
    /// </summary>
    public string Ieminumber { get; set; }

    /// <summary>
    /// Get or set Sla Missed Reason
    /// </summary>
    public string SlaMissedReason { get; set; }

    /// <summary>
    /// Get or set Suggestion Comment
    /// </summary>
    public string SuggestionComment { get; set; }

    /// <summary>
    /// Get or set Job Complete Response Time
    /// </summary>
    public string JobCompleteResponseTime { get; set; }

    /// <summary>
    /// Get or set Default Col 2
    /// </summary>
    public string DefaultCol2 { get; set; }

    /// <summary>
    /// Get or set Default Col 3
    /// </summary>
    public string DefaultCol3 { get; set; }

    /// <summary>
    /// Get or set Vehicle Tagging
    /// </summary>
    public string VehicleTagging { get; set; }

    /// <summary> 
    /// Get or set Customer Name
    /// </summary>
    public string CustomerName { get; set; }
    /// <summary> 
    /// Get or set 
    /// </summary>
    public string EstimatedDistance { get; set; }

    /// <summary> 
    /// Get or set Age(Ticket life cycle time creation to closed time)
    /// </summary>
    public double? Age { get; set; }

    /// <summary>
    /// Get or set Custome Contact_no
    /// </summary>
    public string OwnerContact_no { get; set; }

    /// <summary>
    /// Get or set Custome Contact_no
    /// </summary>
    public string CallStatus { get; set; }

    /// <summary>
    /// Get or set Custome Contact_no
    /// </summary>
    public string caller_language { get; set; }

    /// <summary>
    /// Get or set Security Token
    /// </summary>
    public string feedback_call_status { get; set; }

    /// <summary>
    /// Get or set Status
    /// </summary>
    public string total_count { get; set; }
    public string reopen_count { get; set; }


    /// <summary>
    /// Get or set Message
    /// </summary>
    public string gps_status { get; set; }

    public string PreClosureTime
    {
      get
      {
        if (_PreClosureTime == "01 Jan 0001 05:30:00")
        {
          _PreClosureTime = "";

        }
        return _PreClosureTime;
      }
      set { _PreClosureTime = value; }
    }
    /// <summary>
    /// Get or set Is Deleted
    /// </summary>
    public bool? IsDeleted { get; set; }
    public string Score { get; set; }
    public string current_latitude { get; set; }
    public string current_longitude { get; set; }

    public string ChassisNo { get; set; }
    public double OdometerReading { get; set; }
    //added on 25-09-2020

    public string VanReachedPunchTime { get; set; }    //added on 23-12-2020

    public string VanLatitudeAtTripStart { get; set; }


    //[Display(Name = "Van Trip Start Longitude")]
    public string VanLongitudeAtTripStart { get; set; }

    //[Display(Name = "Van Reached Latitude")]
    public string VanLatitudeAtVanReached { get; set; }

    //[Display(Name = "Van Reached Longitude")]
    public string VanLongitudeAtVanReached { get; set; }

    //[Display(Name = "Van Trip End Latitude")]
    public string VanLatitudeAtTripEnd { get; set; }

    //[Display(Name = "Van Reached Longitude")]
    public string VanLongitudeAtTripEnd { get; set; }

    public string BreakdownLocationLatitude { get; set; }

    public string BreakdownLocationLongitude { get; set; }

    public string TicketClosedReason { get; set; }  //added on 25-11-2020

    //added on 03/12/2020
    public string vehicle_warranty { get; set; }
    public string vehicle_amc { get; set; }
    public string vehicle_emission_norms { get; set; }
    public string vehicle_sales_date { get; set; }
    //ended on 03/12/2020
  }

  public class RabittMqDataModel
  {
    public string temporary_eos_ticket_number { get; set; }
    public string eos_ticket_number { get; set; }
    public int? ticket_status { get; set; }
    public string ticket_status_description { get; set; }
    public string assigned_to_user_id { get; set; }
    public string van_number { get; set; }
    public string technician_name { get; set; }
    public string technician_number { get; set; }
    public string last_modified_time { get; set; }
    public string eos_ticket_closure_comment { get; set; }
    public string vehicle_registration_number { get; set; }
    public string chassis_number { get; set; }
    public string dealer_code { get; set; }
    public string breakdown_location { get; set; }
    public string breakdown_longitude { get; set; }
    public string breakdown_lattitude { get; set; }

  }

  public class VECVReportRequestModel
  {
    public string Token { get; set; }

    public string Status { get; set; }

    public string Message { get; set; }

    public int? UserId { get; set; }

    public string KamUserId { get; set; }

    public DateTime FromDate { get; set; }

    public DateTime ToDate { get; set; }

    public int? Limit { get; set; }

    public int? OffSet { get; set; }

    public List<VECVCalculation> TicketList { get; set; }

    public int? UtcMinute { get; set; }

    public string EndDate { get; set; }

    public string StartDate { get; set; }
  }

  public class ReportRequestModel
  {
    public string Token { get; set; }

    public string Status { get; set; }

    public string Message { get; set; }

    public int? UserId { get; set; }

    public string KamUserId { get; set; }

    public DateTime FromDate { get; set; }

    public DateTime ToDate { get; set; }

    public int? Limit { get; set; }

    public int? OffSet { get; set; }

    public List<VanReport> VanList { get; set; }

    public List<DealerReport> DelearList { get; set; }

    public List<ModelReport> MoodelList { get; set; }

    public List<TechnicianReport> TechnicianReport { get; set; }

    public List<ReassignmentReportNew> ReassignmentReportNew { get; set; }

    public List<ReassignmentReport> ReassignmentReport { get; set; }

    public List<DTCReport> DTCReport { get; set; }


    public List<VAHANAPIError> VAHANAPIErrorReport { get; set; }

    public List<VAHANAPI> VAHANAPIReport { get; set; }


    public int? UtcMinute { get; set; }

    public string EndDate { get; set; }

    public string StartDate { get; set; }
  }
  public class ReassignmentReport
  {

    public string TicketIdAlias { get; set; }

    public string CreationTime { get; set; }

    public string Dealer1SCode { get; set; }

    public string DealerName { get; set; }

    public string TicketStatus { get; set; }

    public string Reassign_to { get; set; }

    public string Reassign_Reason { get; set; }
    public string ReassignTime { get; set; }

    public string ReassignStatus { get; set; }
  }

  public class ReassignmentReportNew
  {

    public string TicketIdAlias { get; set; }

    public string CreationTime { get; set; }

    public string Dealer1SCode { get; set; }

    public string DealerName { get; set; }

    public string TicketStatus { get; set; }

    public string Reassign_to { get; set; }

    public string Reassign_Reason { get; set; }
    public string ReassignTime { get; set; }

    public string reassignstatus { get; set; }
    public string ReassignRemarks { get; set; }

    public string Fuel_type { get; set; }
    public string organization { get; set; }
    public string state { get; set; }

    public string Vehicle_Owner_Name { get; set; }
    public string Vehicle_Owner_Contact_No { get; set; }
    public string Vehicle_Reg_No { get; set; }
    public string Vehicle_Model { get; set; }
    public string Vehicle_Type { get; set; }
    public string BreakDownLocation { get; set; }
    public string BreackDownLatitude { get; set; }
    public string BreackDownLongitude { get; set; }

    public string BreakDownLandmark { get; set; }
    public string nature_of_problem { get; set; }
    public string opportunity_loss { get; set; }
    public string opportunity_loss_remark { get; set; }
    public string assigned_to { get; set; }
    public string call_preclosed { get; set; }
    public string pre_closure_remarks { get; set; }
    public string isPreclosed { get; set; }



    public string call_closure { get; set; }
    public string estimated_distance { get; set; }
    public string ticket_accepted { get; set; }
    public string time_slot { get; set; }
    public string Preclosure_reason { get; set; }


  }
  public class DTCReport
  {


    public string TicketIdAlias { get; set; }

    public string CreationTime { get; set; }

    public string Organization { get; set; }

    public string Dealer1SCode { get; set; }

    public string DealerName { get; set; }

    public string Opp_lost { get; set; }

    public string Opp_lost_reason { get; set; }

    public string DTC_CODE { get; set; }
    public string DTC_Description { get; set; }

    public string DTC_Occurance_Date { get; set; }

    public string Occurence_count { get; set; }

    public string Registration_no { get; set; }
    /// <summary>
    /// Get or set vehicle type
    /// </summary>
    public string vehicle_type { get; set; }
    /// <summary>
    /// Get or set chasis number
    /// </summary>
    public string chassis_number { get; set; }
    /// <summary>
    /// Get or set vehicle installation date/Vehicle Type/Vehicle Emission Norms
    /// </summary>
    public string Vehicle_Model { get; set; }
    public string Vehicle_Emission_Norms { get; set; }
    public string status { get; set; }

  }

  public class VECVCalculation
  {
    public string TicketIdAlias { get; set; }

    public string AssignedTo { get; set; }

    public string TicketStatus { get; set; }

    public string TicketStatusAlias { get; set; }

    public string CreationTime { get; set; }

    public string VanReachedTime { get; set; }

    public string AssignedToUserId { get; set; }

    public string LastModifiedTime { get; set; }

    public string Ticket_Accepted { get; set; }

    public string Call_Preclosed { get; set; }

    public string Call_Closure { get; set; }

    public string Reassignment_Time { get; set; }

    public string DealerCode { get; set; }

    public string Dealer_name { get; set; }

    public string Van_Reached { get; set; }
  }


  public class DealerReport
  {
    public string Dealer1Scode { get; set; }

    public string DealerName { get; set; }

    public string State { get; set; }

    public string City { get; set; }

    public string Latitude { get; set; }

    public string Longitude { get; set; }

    public string FuelType { get; set; }

    public string Organisation { get; set; }

    public string AppVersion { get; set; }

  }
  public class TechnicianReport
  {
    public string TicketIdAlias { get; set; }

    public string CreationTime { get; set; }
    public string TechnicianNumber { get; set; }

    public string Ticket_status { get; set; }
  }


  public class ModelReport
  {
    public string ticketid_alias { get; set; }
    public string ServiceEngineerAlias { get; set; }
    public string CreationTime { get; set; }
    public string Description { get; set; }
    public string ChassisNo { get; set; }
    public string Dealer1Scode { get; set; }
    public string VehicleRegistrationNo { get; set; }
    public string ServiceEngineerContactNumber { get; set; }
    public string VanVanModel { get; set; }
    public string WM_Contact_No { get; set; }
    public string WM_Name { get; set; }
    public string plant_code { get; set; }
    public string CaseId { get; set; }
    public string TicketStatus { get; set; }


  }


  public class VanReport
  {
    public string Dealer1Scode { get; set; }

    public string DealerName { get; set; }

    public string State { get; set; }

    public string City { get; set; }

    public string LicenseKey { get; set; }

    public string RegistrationNumber { get; set; }

    public string FuelType { get; set; }

    public string MobileNumber { get; set; }

    public string TechnicianName { get; set; }

    public string VanStatus { get; set; }

    public string AppVersion { get; set; }


  }

  public class TicketOpenModelCogentAPI
  {
    public string TicketIdAlias { get; set; }


    public string TicketStatus { get; set; }

    public string TicketStatusAlias { get; set; }

    public string CustomeContact_no { get; set; }

    public string CustomerName { get; set; }

    public string VehicleRegistrationNo { get; set; }

    public string Status { get; set; }

    public string Message { get; set; }

    public bool isExists { get; set; }





  }

  public class VanDealerListStateWiseGetAllVan
  {
    /// <summary>
    /// Get or set user id
    /// </summary>
    public int? UserId { get; set; }

    /// <summary>
    /// Get or set state name
    /// </summary>
    public string StateName { get; set; }

    /// <summary>
    /// Get or set limit
    /// </summary>
    public string Limit { get; set; }

    /// <summary>
    /// Get or set dealer van id
    /// </summary>
    public string DealerSCode { get; set; }
    /// <summary>
    /// Get or set dealer van id
    /// </summary>
    public string DealerOrVanContactNo { get; set; }
    /// <summary>
    /// Get or set dealer van id
    /// </summary>
    public string DealerVanId { get; set; }

    /// <summary>
    /// Get or set dealer van name
    /// </summary>
    public string DealerVanName { get; set; }

    /// <summary>
    /// Get or set dealer van latitude
    /// </summary>
    public string DealerVanLattitude { get; set; }

    /// <summary>
    /// Get or set dealer van longitude
    /// </summary>
    public string DealerVanLongitude { get; set; }

    /// <summary>
    /// Get or set dealer van city
    /// </summary>
    public string DealerVanCity { get; set; }

    /// <summary>
    /// Get or set dealer van state
    /// </summary>
    public string DealerVanState { get; set; }

    /// <summary>
    /// Get or set device alias
    /// </summary>
    public string DeviceAlias { get; set; }

    /// <summary>
    /// Get or set no. of assigned ticket
    /// </summary>
    public Int64? NoOfAssignedTicket { get; set; }

    /// <summary>
    /// Get or set remaining time
    /// </summary>
    public string RemainingTime { get; set; }

    /// <summary>
    /// Get or set type
    /// </summary>
    public string Type { get; set; }

    /// <summary>
    /// Get or set device status
    /// </summary>
    public string DeviceStatus { get; set; }

    /// <summary>
    /// Get or set security token
    /// </summary>
    public string Token { get; set; }



    /// <summary>
    /// Get or set UTC minute
    /// </summary>
    public int UtcMinute { get; set; }

    /// <summary>
    /// Get or set Log id
    /// </summary>
    public int LogId { get; set; }

    /// <summary>
    /// Get or set latitude value
    /// </summary>
    public string Latitude { get; set; }
    /// <summary>
    /// Get or set logitude value
    /// </summary>
    public string Longitude { get; set; }
    /// <summary>
    /// Get or set log time
    /// </summary>
    public string LogTime { get; set; }

    /// <summary>
    /// Get or set security token value for service access
    /// </summary>
    // public List<string> TrackingDetail { get; set; }

    /// <summary>
    /// Get or set isconnected flag
    /// </summary>
    public string IsConnected { get; set; }

    /// <summary>
    /// Get or set x cordinate
    /// </summary>
    public string Xcordinate { get; set; }

    /// <summary>
    /// Get or set y cordinate
    /// </summary>
    public string Ycordinate { get; set; }

    /// <summary>
    /// Get or set z cordinate
    /// </summary>
    public string Zcordinate { get; set; }

    /// <summary>
    /// Get or set creation time
    /// </summary>
    public string CreationTime { get; set; }
    /// <summary>
    /// Get or set BatteryStatus
    /// </summary>
    public string BatteryStatus { get; set; }
    /// <summary>
    /// Get or set GpsStatus
    /// </summary>
    public string GpsStatus { get; set; }
    /// <summary>
    /// Get or set IsCharging
    /// </summary>
    public string IsCharging { get; set; }

    /// <summary>
    /// Get or set IsPowerSaving
    /// </summary>
    public string IsPowerSaving { get; set; }

    /// <summary>
    /// Get or set status
    /// </summary>
    public string status { get; set; }

    /// <summary>
    /// Get or set Message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// Get or set trackind detail
    /// </summary>
    public List<String> BulkTrackngDetail { get; set; }


  }
  public class PaymentDropDown
  {

    /// <summary>
    /// Get or set token
    /// </summary>
    public string Name { get; set; }

    /// <summary>
    /// Get or set Status
    /// </summary>
    public int? Id { get; set; }
  }



  public class EPSEmailSendModel
  {

    public string TicketId { get; set; }

    public string Creation_time { get; set; }


    public string City { get; set; }
    public string State { get; set; }
    public string Product_type { get; set; }
        public string EngineNumber { get; set; }
        public string DealerCode { get; set; }
        public string Description { get; set; }
        public string ContactNo { get; set; }
        //Added by Mayuri Khandelwal
        public string Region { get; set; }
        
    
  }
  public class CustomerVehicleModelDBM
  {
    /// <summary>
    /// Get or set token
    /// </summary>
    public string Token { get; set; }

    /// <summary>
    /// Get or set Status
    /// </summary>
    public int? Status { get; set; }

    /// <summary>
    /// Get or set  Utc Minute
    /// </summary>
    public int? UtcMinute { get; set; }

    /// <summary>
    /// Get or set  Message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// Get or set Ticket No
    /// </summary>
    public string TicketNo { get; set; }

    /// <summary>
    /// Get or set  Customer Id
    /// </summary>
    public string CustomerId { get; set; }

    /// <summary>
    /// Get or set Customer Name
    /// </summary>
    public string CustomerName { get; set; }

    /// <summary>
    /// Get or set Customer Alias
    /// </summary>
    public string OdoMeterReading { get; set; }

    /// <summary>
    /// Get or set CustomerMobile1
    /// </summary>
    public string CustomerMobile1 { get; set; }

    /// Get or set CustomerMobile2
    /// </summary>
    public string CustomerMobile2 { get; set; }

    /// <summary>
    /// Get or set CustomerMobile3
    /// </summary>
    public string CustomerMobile3 { get; set; }

    /// <summary>
    /// Get or set CustomerAddress
    /// </summary>
    public string CustomerAddress { get; set; }

    /// <summary>
    /// Get or set CustomerEmailId
    /// </summary>
    public string CustomerType { get; set; }




    public string VehicleSalesDate { get; set; }

    public string VehicleFuelType { get; set; }

    public string VehicleEmissionNorms { get; set; }

    /// Get or set CustomerCity

    /// <summary>
    /// 
    /// </summary>
    public string CustomerCity { get; set; }

    /// <summary>
    /// Get or set CustomerState
    /// </summary>
    public string CustomerState { get; set; }

    /// <summary>
    /// Get or set CustomerVehicleCustomerId
    /// </summary>
    public string CustomerVehicleCustomerId { get; set; }

    /// <summary>
    /// Get or set CustomerVehicleVehicleId
    /// </summary>
    public string CustomerVehicleVehicleId { get; set; }

    /// <summary>
    /// Get or set CustomerVehicleIsOwnwer
    /// </summary>
    public Boolean? CustomerVehicleIsOwnwer { get; set; }

    /// <summary>
    /// Get or set VehicleId
    /// </summary>
    public string VehicleId { get; set; }

    /// <summary>
    /// Get or set VehicleRegistrationNumber
    /// </summary>
    public string VehicleRegistrationNumber { get; set; }

    /// <summary>
    /// Get or set VehicleNumberPlate
    /// </summary>
    public string VehicleNumberPlate { get; set; }

    /// <summary>
    /// Get or set VehicleModelNumber
    /// </summary>
    public string VehicleModelNumber { get; set; }

    /// <summary>
    /// Get or set Vehicle Type
    /// </summary>
    public string VehicleType { get; set; }

    public string vehicle_warranty { get; set; }
    public string product_variant { get; set; }

    public string vehicle_amc { get; set; }

    public string vehicle_installation_date { get; set; }

    public string AMCType { get; set; }
    public string AMCDate { get; set; }

    public string extended_warranty { get; set; }

    public string warranty_end_date { get; set; }
    /// <summary>
    /// Get or set token
    /// </summary>
    public string userType { get; set; }

    public string TicketStatusCreation { get; set; }

    public string AssignedToCreation { get; set; }


    public string BatteryVoltage { get; set; }

    public string vehicleManufacturerName { get; set; }

    public string fuelLevelInPer { get; set; }


    public string fuelLevelInLtr { get; set; }


    public string defLevelInLtr { get; set; }

    public bool isEPS { get; set; }

    public string Engine_number { get; set; }


    public string SALES_DATE { get; set; }

    public string Fert { get; set; }
  }

  public class VAHANAPIError

  {
    public string message { get; set; }
    public string status { get; set; }
    public string reason { get; set; }
    public string type { get; set; }
    public string statusCode { get; set; }
    public string registration_number { get; set; }
    // public string chassis_number { get; set; }
    public string creation_time { get; set; }

  }
  public class ErrorResponse
  {

    public VAHANAPIError Error { get; set; }
  }


  public class DBMPayloadCreation

  {


    public string Creation_Time { get; set; }
    public string Vehicle_Owner_Contact_No { get; set; }
    public string Dealer_SCode { get; set; }

    public string Ticket_Id { get; set; }
    public string Vehicle_Model { get; set; }

    public string Vehicle_Reg_No { get; set; }
    public string Vehicle_Owner_Name { get; set; }
    /// <summary>
    /// Get or set token
    /// </summary>
    public string Vehicle_Type { get; set; }

    public string fuel_type { get; set; }
    public string Van_Reached { get; set; }





  }

  public class DBMPayloadClosed
  {
    public string Ticket_Id { get; set; }
    public string Estimated_KM { get; set; }
    public string Van_Reached { get; set; }
    public string fuel_type { get; set; }

  }
  public class DBMPayloadTripEnd

  {
    public string Ticket_Id { get; set; }
    public string Actual_KM { get; set; }
    public string Estimated_KM { get; set; }
    public string fuel_type { get; set; }
    public string Van_Reached { get; set; }
  }
  public class PaymentDetailsModel
  {

    /// <summary>
    /// Get or set token
    /// </summary>
    public string DateAlias { get; set; }
    /// <summary>
    /// Get or set token
    /// </summary>
    public string TimeAlias { get; set; }

    /// <summary>
    /// Get or set Customer Name
    /// </summary>
    public string CustomerName { get; set; }
    /// <summary>
    /// Get or set  Customer Id
    /// </summary>
    public string CustomerMobileNumber { get; set; }

    /// <summary>
    /// Get or set Customer Alias
    /// </summary>

    public string Amount { get; set; }

    public string ModeOfPayment { get; set; }
    /// <summary>
    /// Get or set creation time
    /// </summary>
    public string remarks { get; set; }

    /// <summary>
    /// Get or set Ticket No
    /// </summary>
    public string TicketId_Alias { get; set; }

    /// <summary>
    /// Get or set Ticket No
    /// </summary>
    public string Created_By { get; set; }



    /// <summary>
    /// Get or set Ticket No
    /// </summary>
    public string Created_By_type { get; set; }
    /// <summary>
    /// Get or set token
    /// </summary>
    public string addstatus { get; set; }

    /// <summary>
    /// Get or set token
    /// </summary>
    public string Token { get; set; }
    /// <summary>
    /// Get or set Status
    /// </summary>
    public int? Status { get; set; }

    /// <summary>
    /// Get or set  Utc Minute
    /// </summary>
    public int? UtcMinute { get; set; }

    /// <summary>
    /// Get or set  Message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// Get or set Ticket No
    /// </summary>
    public string TicketId { get; set; }


    /// <summary>
    /// Get or set utc minute
    /// </summary>
    public int UtcMinutes { get; set; }
    /// <summary>
    /// Get or set creation time
    /// </summary>
    public string creation_time { get; set; }

    /// <summary>
    /// Get or set creation time
    /// </summary>
    public DateTime payment_date { get; set; }

    public string RegistrationNumber { get; set; }

    public string DealerName { get; set; }



  }

  public class LiveTrackingDetailsModel
  {

    public string VehicleTagging { get; set; }
    /// <summary>
    /// Get or set token
    /// </summary>
    public string WMName { get; set; }
    /// <summary>
    /// Get or set token
    /// </summary>
    public string WMNumber { get; set; }

    /// <summary>
    /// Get or set Customer Name
    /// </summary>
    public string TechnicianName { get; set; }
    /// <summary>
    /// Get or set  Customer Id
    /// </summary>
    public string TechnicianMobileNumber { get; set; }

    /// <summary>
    /// Get or set Customer Alias
    /// </summary>

    public string SiteInchargeName { get; set; }

    public string SiteInchargeNo { get; set; }
    /// <summary>
    /// Get or set creation time
    /// </summary>
    public string BreakdownLat { get; set; }
    /// <summary>
    /// Get or set creation time
    /// </summary>
    public string mobileOTP { get; set; }

    /// <summary>
    /// Get or set Ticket No
    /// </summary>
    public string TicketId_Alias { get; set; }

    /// <summary>
    /// Get or set Ticket No
    /// </summary>
    public string BreakdownLong { get; set; }

    /// <summary>
    /// Get or set Ticket No
    /// </summary>
    public string tabLiveLat { get; set; }
    /// <summary>
    /// Get or set token
    /// </summary>
    public string tabLiveLong { get; set; }

    /// <summary>
    /// Get or set Ticket No
    /// </summary>
    public string tabLat { get; set; }
    /// <summary>
    /// Get or set token
    /// </summary>
    public string tabLong { get; set; }

    /// <summary>
    /// Get or set token
    /// </summary>
    public string Token { get; set; }
    /// <summary>
    /// Get or set Status
    /// </summary>
    public int? Status { get; set; }

    /// <summary>
    /// Get or set  Utc Minute
    /// </summary>
    public int? UtcMinute { get; set; }

    /// <summary>
    /// Get or set  Message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// Get or set Ticket No
    /// </summary>
    public string TicketId { get; set; }


    /// <summary>
    /// Get or set Ticket No
    /// </summary>
    public string brkLocation { get; set; }

    /// <summary>
    /// Get or set utc minute
    /// </summary>
    public int UtcMinutes { get; set; }
    /// <summary>
    /// Get or set creation time
    /// </summary>
    public string creation_time { get; set; }
    public string RegistrationNumber { get; set; }
    public string DealerName { get; set; }

  }

  public class ParttDetailsModel
  {

    /// <summary>
    /// Get or set token
    /// </summary>
    public string DateAliascreation { get; set; }
    /// <summary>
    /// Get or set token
    /// </summary>
    public string TimeAliascreation { get; set; }

    public string DateAliasupdation { get; set; }
    /// <summary>
    /// Get or set token
    /// </summary>
    public string TimeAliasupdation { get; set; }
    /// <summary>
    /// Get or set Customer Name
    /// </summary>
    public string PartName { get; set; }
    /// <summary>
    /// Get or set  Customer Id
    /// </summary>
    public string PartNumber { get; set; }

    /// <summary>
    /// Get or set Customer Alias
    /// </summary>

    public string QuantityReturned { get; set; }

    public Int32 QuantityIssued { get; set; }
    /// <summary>
    /// Get or set creation time
    /// </summary>
    public string remarks { get; set; }

    /// <summary>
    /// Get or set Ticket No
    /// </summary>
    public string TicketId_Alias { get; set; }

    /// <summary>
    /// Get or set Ticket No
    /// </summary>
    public string Created_By { get; set; }
    /// <summary>
    /// Get or set token
    /// </summary>
    public string Token { get; set; }
    /// <summary>
    /// Get or set Status
    /// </summary>
    public int? Status { get; set; }

    /// <summary>
    /// Get or set  Utc Minute
    /// </summary>
    public int? UtcMinute { get; set; }

    /// <summary>
    /// Get or set  Message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// Get or set Ticket No
    /// </summary>
    public string TicketId { get; set; }

    /// <summary>
    /// Get or set Ticket No
    /// </summary>
    public Int64? PartId { get; set; }
    /// <summary>
    /// Get or set utc minute
    /// </summary>
    public int UtcMinutes { get; set; }
    /// <summary>
    /// Get or set creation time
    /// </summary>
    public string creation_date { get; set; }

    /// <summary>
    /// Get or set creation time
    /// </summary>
    public string update_date { get; set; }
    /// <summary>
    /// Get or set token
    /// </summary>
    public string addstatus { get; set; }



  }
  public class CaseManagementAPIModel
  {

    /// <summary>
    /// Get or set token
    /// </summary>
    public string EOS_Ticket_Id { get; set; }

    public string Dealer_Code { get; set; }
    public string Dealer_Name { get; set; }
    public string Registration_number { get; set; }
    public string Dealer_Contact_Number { get; set; }

    public string CSM_Name { get; set; }
    public string ASM_Name { get; set; }

    public string RSM_Name { get; set; }

    public string WM_Name { get; set; }

    public string CSM_Contact { get; set; }

    public string ASM_Contact { get; set; }

    public string RSM_contact { get; set; }

    public string WM_contact { get; set; }
    public string creation_time { get; set; }

    public string EOS_Aging_Hrs { get; set; }

    public string Latest_Remark { get; set; }

    public string EOS_Ticket_Status { get; set; }

    public string chassis_no { get; set; }

    public string VehicleTagging { get; set; }

    public string ModelNumber { get; set; }

    public string CutomerType { get; set; }

    public string Region { get; set; }


  }
  public class APIValueModel
  {

    /// <summary>
    /// Get or set token
    /// </summary>
    public string ticket_Id { get; set; }

    public string subject { get; set; }


    public string body { get; set; }

    public string recipients { get; set; }

    public string caseId { get; set; }

    public string caseType { get; set; }

    public string ticketIdAlias { get; set; }
    public string dealerName { get; set; }
    public string dealerId { get; set; }
    public string creation_time { get; set; }
    public string VehicleRegistrationNumber { get; set; }
    public string ownerName { get; set; }

    public string VehicleModelNumber { get; set; }



  }

  public class ApiResponse
  {
    public string Message { get; set; }
    public data data { get; set; }
  }
  public class SMSApiResponse
  {
    public string VehicleType { get; set; }

    public string ProductVariant { get; set; }

    public string WmNo { get; set; }

    public string WMName { get; set; }

    public string EOSSiteNo { get; set; }

    public string DealerName { get; set; }
    public string DealerNo { get; set; }
    public string EOSSiteName { get; set; }
    public string ModelNumber { get; set; }
    public string OTP { get; set; }
    public string ticket_id { get; set; }

    public string Customer_name { get; set; }

    public string Dealer_code { get; set; }

  }


  public class ClodantAPIModel
  {

    public string ticket_id { get; set; }

    public string chassis_no { get; set; }
    /// <summary>
    /// Get or set token
    /// </summary>
    public string packet_info { get; set; }

    public string device_id { get; set; }

    public long startdate { get; set; }

    public long enddate { get; set; }
  }
  public class data
  {
    public string case_number { get; set; }
    public string case_status { get; set; }
    public string created_at { get; set; }
  }

  public class ElectricServiceStationModel
  {
    public string token { get; set; }
    public string lattitude { get; set; }
    public string longitude { get; set; }
    public string name { get; set; }
    public string city { get; set; }
    public string state { get; set; }
    public string address { get; set; }
    public string MobileNumber { get; set; }


  }
  public class ValueModel
  {

    /// <summary>
    /// Get or set token
    /// </summary>
    public string dealerId { get; set; }
    /// <summary>
    /// Get or set token
    /// </summary>
    public string fuelId { get; set; }
    /// <summary>
    /// Get or set token
    /// </summary>
    public string fuelValue { get; set; }

    /// <summary>
    /// Get or set to
    /// </summary>
    public string regNo { get; set; }
  }

  public class VAHANAPI
  {
    public string chassis_number { get; set; }
    public string vehicleManufacturerName { get; set; }
    public string model { get; set; }
    public string normsType { get; set; }
    public string type { get; set; }
    public string owner { get; set; }
    public string creation_time { get; set; }
    public string Registration_Number { get; set; }

  }
  public class TicketInfoModel
  {
    /// <summary>
    /// Get or set Ticket Type
    /// </summary>
    public string TicketStatusAlias { get; set; }
    public string CreationTime { get; set; }
    public string VehicleRegistrationNo { get; set; }
    public string ticketid_alias { get; set; }
    public string ChassisNo { get; set; }
    public string TicketStatus { get; set; }
    public string Status { get; set; }

    public string Message { get; set; }
    public string TicketStatusId { get; set; }
    
  }
  public class VanDealerListStateWiseVanSearch
  {
    /// <summary>
    /// Get or set user id
    /// </summary>
    public int? UserId { get; set; }

    /// <summary>
    /// Get or set state name
    /// </summary>
    public string StateName { get; set; }

    /// <summary>
    /// Get or set limit
    /// </summary>
    public string Limit { get; set; }

    /// <summary>
    /// Get or set dealer van id
    /// </summary>
    public string DealerSCode { get; set; }
    /// <summary>
    /// Get or set dealer van id
    /// </summary>
    public string DealerOrVanContactNo { get; set; }
    /// <summary>
    /// Get or set dealer van id
    /// </summary>
    public string DealerVanId { get; set; }

    /// <summary>
    /// Get or set dealer van name
    /// </summary>
    public string DealerVanName { get; set; }

    /// <summary>
    /// Get or set dealer van latitude
    /// </summary>
    public string DealerVanLattitude { get; set; }

    /// <summary>
    /// Get or set dealer van longitude
    /// </summary>
    public string DealerVanLongitude { get; set; }

    /// <summary>
    /// Get or set dealer van city
    /// </summary>
    public string DealerVanCity { get; set; }

    /// <summary>
    /// Get or set dealer van state
    /// </summary>
    public string DealerVanState { get; set; }

    /// <summary>
    /// Get or set device alias
    /// </summary>
    public string DeviceAlias { get; set; }

    /// <summary>
    /// Get or set no. of assigned ticket
    /// </summary>
    public Int64? NoOfAssignedTicket { get; set; }

    /// <summary>
    /// Get or set remaining time
    /// </summary>
    public string RemainingTime { get; set; }

    /// <summary>
    /// Get or set type
    /// </summary>
    public string Type { get; set; }

    /// <summary>
    /// Get or set device status
    /// </summary>
    public string DeviceStatus { get; set; }

    /// <summary>
    /// Get or set security token
    /// </summary>
    public string Token { get; set; }

    /// <summary>
    /// Get or set status
    /// </summary>
    public string Status { get; set; }

    /// <summary>
    /// Get or set message
    /// </summary>
    public string Message { get; set; }

    /// <summary>
    /// Get or set message
    /// </summary>
    public string Fuel_type { get; set; }
    /// <summary>
    /// Get or set UTC minute
    /// </summary>
    public int UtcMinute { get; set; }
    public bool islocationChange { get; set; }
  }

  #region for excel report
  public static class ListToDatatableHelper
  {
    /// <summary>
    /// Converts a list to data-table
    /// </summary>
    /// <typeparam name="TSource">type of list</typeparam>
    /// <param name="data">list</param>
    /// <returns>data-table</returns>
    public static DataTable ToDataTable<TSource>(this IList<TSource> data)
    {
      DataTable dataTable = new DataTable(typeof(TSource).Name);
      PropertyInfo[] props = typeof(TSource).GetProperties(BindingFlags.Public | BindingFlags.Instance);
      foreach (PropertyInfo prop in props)
      {
        dataTable.Columns.Add(prop.Name, Nullable.GetUnderlyingType(prop.PropertyType) ??
            prop.PropertyType);
      }

      foreach (TSource item in data)
      {
        var values = new object[props.Length];
        for (int i = 0; i < props.Length; i++)
        {
          values[i] = props[i].GetValue(item, null);
        }
        dataTable.Rows.Add(values);
      }
      return dataTable;
    }
  }
  public class CreateExcelFile
  {
    public static bool CreateExcelDocument<T>(List<T> list, string xlsxFilePath)
    {
      DataSet ds = new DataSet();
      ds.Tables.Add(ListToDataTable(list));

      return CreateExcelDocument(ds, xlsxFilePath);
    }
    #region HELPER_FUNCTIONS
    //  This function is adapated from: http://www.codeguru.com/forum/showthread.php?t=450171
    //  My thanks to Carl Quirion, for making it "nullable-friendly".
    public static DataTable ListToDataTable<T>(List<T> list)
    {
      DataTable dt = new DataTable();

      foreach (PropertyInfo info in typeof(T).GetProperties())
      {
        dt.Columns.Add(new DataColumn(info.Name, GetNullableType(info.PropertyType)));
      }
      foreach (T t in list)
      {
        DataRow row = dt.NewRow();
        foreach (PropertyInfo info in typeof(T).GetProperties())
        {
          if (!IsNullableType(info.PropertyType))
            row[info.Name] = info.GetValue(t, null);
          else
            row[info.Name] = (info.GetValue(t, null) ?? DBNull.Value);
        }
        dt.Rows.Add(row);
      }
      return dt;
    }
    private static Type GetNullableType(Type t)
    {
      Type returnType = t;
      if (t.IsGenericType && t.GetGenericTypeDefinition().Equals(typeof(Nullable<>)))
      {
        returnType = Nullable.GetUnderlyingType(t);
      }
      return returnType;
    }
    private static bool IsNullableType(Type type)
    {
      return (type == typeof(string) ||
              type.IsArray ||
              (type.IsGenericType &&
               type.GetGenericTypeDefinition().Equals(typeof(Nullable<>))));
    }

    public static bool CreateExcelDocument(DataTable dt, string xlsxFilePath)
    {
      DataSet ds = new DataSet();
      ds.Tables.Add(dt);
      bool result = CreateExcelDocument(ds, xlsxFilePath);
      ds.Tables.Remove(dt);
      return result;
    }
    #endregion

    //  End of "INCLUDE_WEB_FUNCTIONS" section
    /// <summary>
    /// Create an Excel file, and write it to a file.
    /// </summary>
    /// <param name="ds">DataSet containing the data to be written to the Excel.</param>
    /// <param name="excelFilename">Name of file to be written.</param>
    /// <returns>True if successful, false if something went wrong.</returns>
    public static bool CreateExcelDocument(DataSet ds, string excelFilename)
    {
      /// <summary>
      /// making object of LoggingUtility class available to this class
      /// </summary>
      LoggingUtility objLog = new LoggingUtility();

      /// <summary>
      /// making the data-log file path available to this class
      /// </summary>
      string path = HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["PathLog"]);

      /// <summary>
      /// making error log file path available to this class
      /// </summary>
      string errorlogtf = (ConfigurationManager.AppSettings["ErrorLog"]);

      /// <summary>
      /// making data log file path available to this class
      /// </summary>
      string logtf = (ConfigurationManager.AppSettings["Log"]);
      try
      {

        using (SpreadsheetDocument document = SpreadsheetDocument.Create(excelFilename, SpreadsheetDocumentType.Workbook))
        {
          WriteExcelFile(ds, document);
        }

        Trace.WriteLine("Successfully created: " + excelFilename);
        return true;
      }
      catch (Exception ex)
      {
        Trace.WriteLine("Failed, exception thrown: " + ex.Message);
        objLog.ErrorLogFile("ConsolidatedDataReport excel CreateExcelDocument", ex.StackTrace + "message :" + ex.Message, path, errorlogtf);
        return false;
      }
    }

    private static void WriteExcelFile(DataSet ds, SpreadsheetDocument spreadsheet)
    {
      //  Create the Excel file contents.  This function is used when creating an Excel file either writing 
      //  to a file, or writing to a MemoryStream.
      spreadsheet.AddWorkbookPart();
      spreadsheet.WorkbookPart.Workbook = new DocumentFormat.OpenXml.Spreadsheet.Workbook();

      //  My thanks to James Miera for the following line of code (which prevents crashes in Excel 2010)
      spreadsheet.WorkbookPart.Workbook.Append(new BookViews(new WorkbookView()));

      //  If we don't add a "WorkbookStylesPart", OLEDB will refuse to connect to this .xlsx file !
      WorkbookStylesPart workbookStylesPart = spreadsheet.WorkbookPart.AddNewPart<WorkbookStylesPart>("rIdStyles");
      Stylesheet stylesheet = new Stylesheet();
      workbookStylesPart.Stylesheet = stylesheet;

      //  Loop through each of the DataTables in our DataSet, and create a new Excel Worksheet for each.
      uint worksheetNumber = 1;
      foreach (DataTable dt in ds.Tables)
      {
        //  For each worksheet you want to create
        string workSheetID = "rId" + worksheetNumber.ToString();
        string worksheetName = dt.TableName;

        WorksheetPart newWorksheetPart = spreadsheet.WorkbookPart.AddNewPart<WorksheetPart>();
        newWorksheetPart.Worksheet = new DocumentFormat.OpenXml.Spreadsheet.Worksheet();

        // create sheet data
        newWorksheetPart.Worksheet.AppendChild(new DocumentFormat.OpenXml.Spreadsheet.SheetData());

        // save worksheet
        WriteDataTableToExcelWorksheet(dt, newWorksheetPart);
        newWorksheetPart.Worksheet.Save();

        // create the worksheet to workbook relation
        if (worksheetNumber == 1)
          spreadsheet.WorkbookPart.Workbook.AppendChild(new DocumentFormat.OpenXml.Spreadsheet.Sheets());

        spreadsheet.WorkbookPart.Workbook.GetFirstChild<DocumentFormat.OpenXml.Spreadsheet.Sheets>().AppendChild(new DocumentFormat.OpenXml.Spreadsheet.Sheet()
        {
          Id = spreadsheet.WorkbookPart.GetIdOfPart(newWorksheetPart),
          SheetId = (uint)worksheetNumber,
          Name = dt.TableName
        });

        worksheetNumber++;
      }

      spreadsheet.WorkbookPart.Workbook.Save();
    }


    private static void WriteDataTableToExcelWorksheet(DataTable dt, WorksheetPart worksheetPart)
    {
      var worksheet = worksheetPart.Worksheet;
      var sheetData = worksheet.GetFirstChild<SheetData>();

      string cellValue = "";

      //  Create a Header Row in our Excel file, containing one header for each Column of data in our DataTable.
      //
      //  We'll also create an array, showing which type each column of data is (Text or Numeric), so when we come to write the actual
      //  cells of data, we'll know if to write Text values or Numeric cell values.
      int numberOfColumns = dt.Columns.Count;
      bool[] IsNumericColumn = new bool[numberOfColumns];

      string[] excelColumnNames = new string[numberOfColumns];
      for (int n = 0; n < numberOfColumns; n++)
        excelColumnNames[n] = GetExcelColumnName(n);

      //
      //  Create the Header row in our Excel Worksheet
      //
      uint rowIndex = 1;

      var headerRow = new Row { RowIndex = rowIndex };  // add a row at the top of spreadsheet
      sheetData.Append(headerRow);

      for (int colInx = 0; colInx < numberOfColumns; colInx++)
      {
        DataColumn col = dt.Columns[colInx];
        AppendTextCell(excelColumnNames[colInx] + "1", col.ColumnName, headerRow);
        IsNumericColumn[colInx] = (col.DataType.FullName == "System.Decimal") || (col.DataType.FullName == "System.Int32");
      }

      //
      //  Now, step through each row of data in our DataTable...
      //
      double cellNumericValue = 0;
      foreach (DataRow dr in dt.Rows)
      {
        // ...create a new row, and append a set of this row's data to it.
        ++rowIndex;
        var newExcelRow = new Row { RowIndex = rowIndex };  // add a row at the top of spreadsheet
        sheetData.Append(newExcelRow);

        for (int colInx = 0; colInx < numberOfColumns; colInx++)
        {
          cellValue = dr.ItemArray[colInx].ToString();

          // Create cell with data
          if (IsNumericColumn[colInx])
          {
            //  For numeric cells, make sure our input data IS a number, then write it out to the Excel file.
            //  If this numeric value is NULL, then don't write anything to the Excel file.
            cellNumericValue = 0;
            if (double.TryParse(cellValue, out cellNumericValue))
            {
              cellValue = cellNumericValue.ToString();
              AppendNumericCell(excelColumnNames[colInx] + rowIndex.ToString(), cellValue, newExcelRow);
            }
          }
          else
          {
            //  For text cells, just write the input data straight out to the Excel file.
            AppendTextCell(excelColumnNames[colInx] + rowIndex.ToString(), cellValue, newExcelRow);
          }
        }
      }
    }

    private static void AppendTextCell(string cellReference, string cellStringValue, Row excelRow)
    {
      //  Add a new Excel Cell to our Row 
      Cell cell = new Cell() { CellReference = cellReference, DataType = CellValues.String };
      CellValue cellValue = new CellValue();
      cellValue.Text = cellStringValue;
      cell.Append(cellValue);
      excelRow.Append(cell);
    }

    private static void AppendNumericCell(string cellReference, string cellStringValue, Row excelRow)
    {
      //  Add a new Excel Cell to our Row 
      Cell cell = new Cell() { CellReference = cellReference };
      CellValue cellValue = new CellValue();
      cellValue.Text = cellStringValue;
      cell.Append(cellValue);
      excelRow.Append(cell);
    }

    private static string GetExcelColumnName(int columnIndex)
    {
      //  Convert a zero-based column index into an Excel column reference  (A, B, C.. Y, Y, AA, AB, AC... AY, AZ, B1, B2..)
      //
      //  eg  GetExcelColumnName(0) should return "A"
      //      GetExcelColumnName(1) should return "B"
      //      GetExcelColumnName(25) should return "Z"
      //      GetExcelColumnName(26) should return "AA"
      //      GetExcelColumnName(27) should return "AB"
      //      ..etc..
      //
      if (columnIndex < 26)
        return ((char)('A' + columnIndex)).ToString();

      char firstChar = (char)('A' + (columnIndex / 26) - 1);
      char secondChar = (char)('A' + (columnIndex % 26));

      return string.Format("{0}{1}", firstChar, secondChar);
    }

    /// <summary>
    /// This class contain customer ehicle properties
    /// </summary>


  }
  #endregion
  #endregion
}