EOS-WebAPI/Models/Ticket/TicketModel.cs
Nidhi Bhargava d0ac8a7790 Code Commit
2025-09-04 17:30:22 +05:30

9536 lines
260 KiB
C#

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
}