1410 lines
67 KiB
C#
1410 lines
67 KiB
C#
namespace VECV_WebApi.Controllers.Ticket
|
|
{
|
|
using DBHelper;
|
|
using DocumentFormat.OpenXml.Bibliography;
|
|
using DocumentFormat.OpenXml.Spreadsheet;
|
|
|
|
#region Namespaces
|
|
using LoggingHelper;
|
|
using Npgsql;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Configuration;
|
|
using System.Data;
|
|
using System.Linq;
|
|
using System.Threading.Tasks;
|
|
using System.Web;
|
|
using System.Web.Http;
|
|
using VECV_WebApi.Common;
|
|
using VECV_WebApi.Models.Customer;
|
|
using VECV_WebApi.Models.EmailServices;
|
|
using VECV_WebApi.Models.Ticket;
|
|
|
|
|
|
|
|
#endregion
|
|
public class TicketDetailsController : ApiController
|
|
{
|
|
|
|
#region Global Variable
|
|
|
|
/// <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 data log file path available to this class
|
|
/// </summary>
|
|
string logtf = (ConfigurationManager.AppSettings["Log"]);
|
|
|
|
/// <summary>
|
|
/// making error log file path available to this class
|
|
/// </summary>
|
|
string errorlogtf = (ConfigurationManager.AppSettings["ErrorLog"]);
|
|
|
|
string _appName = (ConfigurationManager.AppSettings["ApplicationName"]);
|
|
|
|
/// <summary>
|
|
/// making the Database connection string available to this class
|
|
/// </summary>
|
|
private string _connStr = ConfigurationManager.ConnectionStrings["Vecv_GoData"].ToString();
|
|
TicketRepository objTicketRepository;
|
|
|
|
|
|
#endregion
|
|
|
|
public CustomerVehicleModelDBM Post([FromBody] CustomerVehicleModelDBM model)
|
|
{
|
|
GlobalRepository objGlobalRepository = new GlobalRepository("");
|
|
string engiennumber = model.Engine_number;
|
|
string regno = model.VehicleRegistrationNumber;
|
|
CustomerVehicleModelDBM objCutomerVehicle = new CustomerVehicleModelDBM();
|
|
TicketRepository objTicket = new TicketRepository(_connStr);
|
|
|
|
try
|
|
{
|
|
if (model.CustomerType == null)
|
|
{
|
|
|
|
if (model.VehicleRegistrationNumber != null && model.VehicleRegistrationNumber != "")
|
|
{
|
|
//replace "-" to blank space and than replace blank space to empty string in registration no.
|
|
model.VehicleRegistrationNumber = model.VehicleRegistrationNumber.Replace("-", " ").Replace(" ", String.Empty);
|
|
|
|
}
|
|
// check registration no in dbm database
|
|
|
|
if (System.Configuration.ConfigurationManager.AppSettings["IsDataLakeSkip"] != "true")
|
|
{
|
|
objCutomerVehicle = objTicket.CustomerVehicleModelByDBM(model);
|
|
}
|
|
else
|
|
{
|
|
objCutomerVehicle.VehicleNumberPlate = null;
|
|
}
|
|
if (objCutomerVehicle.VehicleNumberPlate == null || objCutomerVehicle.VehicleNumberPlate == "")
|
|
{
|
|
// check registration no in dbm api
|
|
objCutomerVehicle = objTicket.CustomerVehicleModelByDBMAPI(model);
|
|
if (objCutomerVehicle == null)
|
|
{
|
|
// check datalake by chassis no
|
|
objCutomerVehicle = objTicket.CustomerVehicleModelByDBMBYChassisno(model);
|
|
if (objCutomerVehicle == null)
|
|
|
|
{
|
|
|
|
VAHANAPI objVAHANAPI = new VAHANAPI();
|
|
objVAHANAPI = objTicket.getVahanDetailByRegistrationNumber(model.VehicleRegistrationNumber);
|
|
if (objVAHANAPI == null)
|
|
{
|
|
objVAHANAPI = objTicket.DetailFormVAHANApiAllDetails(model.VehicleRegistrationNumber);
|
|
if (objVAHANAPI == null)
|
|
{
|
|
objCutomerVehicle = new CustomerVehicleModelDBM();
|
|
objCutomerVehicle.VehicleRegistrationNumber = model.VehicleRegistrationNumber;
|
|
|
|
objCutomerVehicle.userType = "NonDBM";
|
|
objCutomerVehicle.vehicle_warranty = "-";
|
|
objCutomerVehicle.extended_warranty = "-";
|
|
objCutomerVehicle.warranty_end_date = "";
|
|
}
|
|
else
|
|
{
|
|
if (objVAHANAPI.chassis_number == null)
|
|
{
|
|
objCutomerVehicle = new CustomerVehicleModelDBM();
|
|
objCutomerVehicle.VehicleRegistrationNumber = model.VehicleRegistrationNumber;
|
|
|
|
objCutomerVehicle.userType = "NonDBM";
|
|
objCutomerVehicle.vehicle_warranty = "-";
|
|
objCutomerVehicle.extended_warranty = "-";
|
|
objCutomerVehicle.warranty_end_date = "";
|
|
}
|
|
else
|
|
{
|
|
model.VehicleRegistrationNumber = objVAHANAPI.Registration_Number;
|
|
model.VehicleNumberPlate = objVAHANAPI.chassis_number;
|
|
// check registration no in dbm database
|
|
objCutomerVehicle = objTicket.CustomerVehicleModelAfterVahanChassisno(model);
|
|
objCutomerVehicle.VehicleRegistrationNumber = objVAHANAPI.Registration_Number;
|
|
if (objCutomerVehicle == null)
|
|
{
|
|
// check registration no in dbm api
|
|
objCutomerVehicle = objTicket.CustomerVehicleModelByDBMAPI(model);
|
|
objCutomerVehicle.VehicleRegistrationNumber = objVAHANAPI.Registration_Number;
|
|
if (objCutomerVehicle == null)
|
|
{
|
|
// check datalake by chassis no
|
|
if (objCutomerVehicle == null)
|
|
{
|
|
objCutomerVehicle = new CustomerVehicleModelDBM();
|
|
objCutomerVehicle.VehicleRegistrationNumber = model.VehicleRegistrationNumber;
|
|
|
|
objCutomerVehicle.userType = "VahanUser";
|
|
objCutomerVehicle.vehicle_warranty = "-";
|
|
objCutomerVehicle.extended_warranty = "-";
|
|
objCutomerVehicle.warranty_end_date = "";
|
|
objCutomerVehicle.vehicleManufacturerName = objVAHANAPI.vehicleManufacturerName;
|
|
}
|
|
}
|
|
}
|
|
if (objCutomerVehicle.CustomerId == null)
|
|
{
|
|
objCutomerVehicle = new CustomerVehicleModelDBM();
|
|
objCutomerVehicle.VehicleRegistrationNumber = model.VehicleRegistrationNumber;
|
|
|
|
objCutomerVehicle.userType = "VahanUser";
|
|
objCutomerVehicle.vehicle_warranty = "-";
|
|
objCutomerVehicle.extended_warranty = "-";
|
|
objCutomerVehicle.warranty_end_date = "";
|
|
objCutomerVehicle.vehicleManufacturerName = objVAHANAPI.vehicleManufacturerName;
|
|
|
|
|
|
}
|
|
|
|
// check)
|
|
}
|
|
}
|
|
}
|
|
|
|
else
|
|
{
|
|
model.VehicleRegistrationNumber = objVAHANAPI.Registration_Number;
|
|
model.VehicleNumberPlate = objVAHANAPI.chassis_number;
|
|
// check registration no in dbm database
|
|
objCutomerVehicle = objTicket.CustomerVehicleModelAfterVahanChassisno(model);
|
|
objCutomerVehicle.VehicleRegistrationNumber = objVAHANAPI.Registration_Number;
|
|
if (objCutomerVehicle == null)
|
|
{
|
|
|
|
// check registration no in dbm api
|
|
objCutomerVehicle = objTicket.CustomerVehicleModelByDBMAPI(model);
|
|
objCutomerVehicle.VehicleRegistrationNumber = objVAHANAPI.Registration_Number;
|
|
if (objCutomerVehicle == null)
|
|
{
|
|
// check datalake by chassis no
|
|
if (objCutomerVehicle == null)
|
|
{
|
|
objCutomerVehicle = new CustomerVehicleModelDBM();
|
|
objCutomerVehicle.VehicleRegistrationNumber = model.VehicleRegistrationNumber;
|
|
|
|
objCutomerVehicle.userType = "VahanUser";
|
|
objCutomerVehicle.vehicle_warranty = "-";
|
|
objCutomerVehicle.extended_warranty = "-";
|
|
objCutomerVehicle.warranty_end_date = "";
|
|
objCutomerVehicle.vehicleManufacturerName = objVAHANAPI.vehicleManufacturerName;
|
|
}
|
|
}
|
|
}
|
|
else
|
|
{
|
|
if (objCutomerVehicle.CustomerId == null)
|
|
{
|
|
objCutomerVehicle = new CustomerVehicleModelDBM();
|
|
objCutomerVehicle.VehicleRegistrationNumber = model.VehicleRegistrationNumber;
|
|
|
|
objCutomerVehicle.userType = "VahanUser";
|
|
objCutomerVehicle.vehicle_warranty = "-";
|
|
objCutomerVehicle.extended_warranty = "-";
|
|
objCutomerVehicle.warranty_end_date = "";
|
|
objCutomerVehicle.vehicleManufacturerName = objVAHANAPI.vehicleManufacturerName;
|
|
|
|
}
|
|
}
|
|
/* if (objCutomerVehicle.CustomerVehicleCustomerId == null)
|
|
{
|
|
objCutomerVehicle = new CustomerVehicleModelDBM();
|
|
objCutomerVehicle.VehicleRegistrationNumber = model.VehicleRegistrationNumber;
|
|
|
|
objCutomerVehicle.userType = "VahanUser";
|
|
objCutomerVehicle.vehicle_warranty = "-";
|
|
objCutomerVehicle.extended_warranty = "-";
|
|
objCutomerVehicle.warranty_end_date = "";
|
|
objCutomerVehicle.vehicleManufacturerName = objVAHANAPI.vehicleManufacturerName;
|
|
|
|
|
|
}*/
|
|
|
|
// check)
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
else
|
|
{
|
|
|
|
}
|
|
|
|
// TicketRepository objTicket = new TicketRepository(_connStr);
|
|
try
|
|
{
|
|
if (objCutomerVehicle.VehicleNumberPlate == null)
|
|
{
|
|
}
|
|
else
|
|
{
|
|
Task<CustomerVehicleModelDBM> objTelematic_Model = objTicket.GetFuelDetails(objCutomerVehicle.VehicleNumberPlate);
|
|
CustomerVehicleModelDBM objCustomerVehicleModelDBMnew = objTelematic_Model.Result;
|
|
objCutomerVehicle.fuelLevelInLtr = objCustomerVehicleModelDBMnew.fuelLevelInLtr;
|
|
objCutomerVehicle.fuelLevelInPer = objCustomerVehicleModelDBMnew.fuelLevelInPer;
|
|
objCutomerVehicle.defLevelInLtr = objCustomerVehicleModelDBMnew.defLevelInLtr;
|
|
}
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
objLog.ErrorLogFile("TicketDetailsController def level", Ex.Message, path, errorlogtf);
|
|
}
|
|
try
|
|
{
|
|
if (objCutomerVehicle.VehicleNumberPlate == null)
|
|
{
|
|
}
|
|
else
|
|
{
|
|
string batteryvoltage = objTicket.getBatteryVoltage(objCutomerVehicle.VehicleNumberPlate);
|
|
objCutomerVehicle.BatteryVoltage = batteryvoltage;
|
|
}
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
objLog.ErrorLogFile("TicketDetailsController battery voltage", Ex.Message, path, errorlogtf);
|
|
}
|
|
|
|
|
|
|
|
}
|
|
else
|
|
{
|
|
if (model.CustomerType.ToLower() == "eps")
|
|
{
|
|
|
|
|
|
objCutomerVehicle = new CustomerVehicleModelDBM();
|
|
|
|
objCutomerVehicle = objTicket.CustomerEngineNoByEOS(model.Engine_number, model.VehicleRegistrationNumber);
|
|
//objCutomerVehicle.VehicleRegistrationNumber = model.VehicleRegistrationNumber;
|
|
|
|
}
|
|
else
|
|
{
|
|
if (model.VehicleRegistrationNumber != null && model.VehicleRegistrationNumber != "")
|
|
{
|
|
//replace "-" to blank space and than replace blank space to empty string in registration no.
|
|
model.VehicleRegistrationNumber = model.VehicleRegistrationNumber.Replace("-", " ").Replace(" ", String.Empty);
|
|
|
|
}
|
|
// check registration no in dbm database
|
|
|
|
if (System.Configuration.ConfigurationManager.AppSettings["IsDataLakeSkip"] != "true")
|
|
{
|
|
objCutomerVehicle = objTicket.CustomerVehicleModelByDBM(model);
|
|
}
|
|
else
|
|
{
|
|
objCutomerVehicle.VehicleNumberPlate = null;
|
|
}
|
|
if (objCutomerVehicle.VehicleNumberPlate == null || objCutomerVehicle.VehicleNumberPlate == "")
|
|
{
|
|
// check registration no in dbm api
|
|
objCutomerVehicle = objTicket.CustomerVehicleModelByDBMAPI(model);
|
|
if (objCutomerVehicle == null)
|
|
{
|
|
// check datalake by chassis no
|
|
objCutomerVehicle = objTicket.CustomerVehicleModelByDBMBYChassisno(model);
|
|
if (objCutomerVehicle == null)
|
|
|
|
{
|
|
|
|
VAHANAPI objVAHANAPI = new VAHANAPI();
|
|
objVAHANAPI = objTicket.getVahanDetailByRegistrationNumber(model.VehicleRegistrationNumber);
|
|
if (objVAHANAPI == null)
|
|
{
|
|
objVAHANAPI = objTicket.DetailFormVAHANApiAllDetails(model.VehicleRegistrationNumber);
|
|
if (objVAHANAPI == null)
|
|
{
|
|
objCutomerVehicle = new CustomerVehicleModelDBM();
|
|
objCutomerVehicle.VehicleRegistrationNumber = model.VehicleRegistrationNumber;
|
|
|
|
objCutomerVehicle.userType = "NonDBM";
|
|
objCutomerVehicle.vehicle_warranty = "-";
|
|
objCutomerVehicle.extended_warranty = "-";
|
|
objCutomerVehicle.warranty_end_date = "";
|
|
}
|
|
else
|
|
{
|
|
if (objVAHANAPI.chassis_number == null)
|
|
{
|
|
objCutomerVehicle = new CustomerVehicleModelDBM();
|
|
objCutomerVehicle.VehicleRegistrationNumber = model.VehicleRegistrationNumber;
|
|
|
|
objCutomerVehicle.userType = "NonDBM";
|
|
objCutomerVehicle.vehicle_warranty = "-";
|
|
objCutomerVehicle.extended_warranty = "-";
|
|
objCutomerVehicle.warranty_end_date = "";
|
|
}
|
|
else
|
|
{
|
|
model.VehicleRegistrationNumber = objVAHANAPI.Registration_Number;
|
|
model.VehicleNumberPlate = objVAHANAPI.chassis_number;
|
|
// check registration no in dbm database
|
|
objCutomerVehicle = objTicket.CustomerVehicleModelAfterVahanChassisno(model);
|
|
objCutomerVehicle.VehicleRegistrationNumber = objVAHANAPI.Registration_Number;
|
|
if (objCutomerVehicle == null)
|
|
{
|
|
// check registration no in dbm api
|
|
objCutomerVehicle = objTicket.CustomerVehicleModelByDBMAPI(model);
|
|
objCutomerVehicle.VehicleRegistrationNumber = objVAHANAPI.Registration_Number;
|
|
if (objCutomerVehicle == null)
|
|
{
|
|
// check datalake by chassis no
|
|
if (objCutomerVehicle == null)
|
|
{
|
|
objCutomerVehicle = new CustomerVehicleModelDBM();
|
|
objCutomerVehicle.VehicleRegistrationNumber = model.VehicleRegistrationNumber;
|
|
|
|
objCutomerVehicle.userType = "VahanUser";
|
|
objCutomerVehicle.vehicle_warranty = "-";
|
|
objCutomerVehicle.extended_warranty = "-";
|
|
objCutomerVehicle.warranty_end_date = "";
|
|
objCutomerVehicle.vehicleManufacturerName = objVAHANAPI.vehicleManufacturerName;
|
|
}
|
|
}
|
|
}
|
|
if (objCutomerVehicle.CustomerId == null)
|
|
{
|
|
objCutomerVehicle = new CustomerVehicleModelDBM();
|
|
objCutomerVehicle.VehicleRegistrationNumber = model.VehicleRegistrationNumber;
|
|
|
|
objCutomerVehicle.userType = "VahanUser";
|
|
objCutomerVehicle.vehicle_warranty = "-";
|
|
objCutomerVehicle.extended_warranty = "-";
|
|
objCutomerVehicle.warranty_end_date = "";
|
|
objCutomerVehicle.vehicleManufacturerName = objVAHANAPI.vehicleManufacturerName;
|
|
|
|
|
|
}
|
|
|
|
// check)
|
|
}
|
|
}
|
|
}
|
|
|
|
else
|
|
{
|
|
model.VehicleRegistrationNumber = objVAHANAPI.Registration_Number;
|
|
model.VehicleNumberPlate = objVAHANAPI.chassis_number;
|
|
// check registration no in dbm database
|
|
objCutomerVehicle = objTicket.CustomerVehicleModelAfterVahanChassisno(model);
|
|
objCutomerVehicle.VehicleRegistrationNumber = objVAHANAPI.Registration_Number;
|
|
if (objCutomerVehicle == null)
|
|
{
|
|
|
|
// check registration no in dbm api
|
|
objCutomerVehicle = objTicket.CustomerVehicleModelByDBMAPI(model);
|
|
objCutomerVehicle.VehicleRegistrationNumber = objVAHANAPI.Registration_Number;
|
|
if (objCutomerVehicle == null)
|
|
{
|
|
// check datalake by chassis no
|
|
if (objCutomerVehicle == null)
|
|
{
|
|
objCutomerVehicle = new CustomerVehicleModelDBM();
|
|
objCutomerVehicle.VehicleRegistrationNumber = model.VehicleRegistrationNumber;
|
|
|
|
objCutomerVehicle.userType = "VahanUser";
|
|
objCutomerVehicle.vehicle_warranty = "-";
|
|
objCutomerVehicle.extended_warranty = "-";
|
|
objCutomerVehicle.warranty_end_date = "";
|
|
objCutomerVehicle.vehicleManufacturerName = objVAHANAPI.vehicleManufacturerName;
|
|
}
|
|
}
|
|
}
|
|
else
|
|
{
|
|
if (objCutomerVehicle.CustomerId == null)
|
|
{
|
|
objCutomerVehicle = new CustomerVehicleModelDBM();
|
|
objCutomerVehicle.VehicleRegistrationNumber = model.VehicleRegistrationNumber;
|
|
|
|
objCutomerVehicle.userType = "VahanUser";
|
|
objCutomerVehicle.vehicle_warranty = "-";
|
|
objCutomerVehicle.extended_warranty = "-";
|
|
objCutomerVehicle.warranty_end_date = "";
|
|
objCutomerVehicle.vehicleManufacturerName = objVAHANAPI.vehicleManufacturerName;
|
|
|
|
}
|
|
}
|
|
/* if (objCutomerVehicle.CustomerVehicleCustomerId == null)
|
|
{
|
|
objCutomerVehicle = new CustomerVehicleModelDBM();
|
|
objCutomerVehicle.VehicleRegistrationNumber = model.VehicleRegistrationNumber;
|
|
|
|
objCutomerVehicle.userType = "VahanUser";
|
|
objCutomerVehicle.vehicle_warranty = "-";
|
|
objCutomerVehicle.extended_warranty = "-";
|
|
objCutomerVehicle.warranty_end_date = "";
|
|
objCutomerVehicle.vehicleManufacturerName = objVAHANAPI.vehicleManufacturerName;
|
|
|
|
|
|
}*/
|
|
|
|
// check)
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
else
|
|
{
|
|
|
|
}
|
|
|
|
// TicketRepository objTicket = new TicketRepository(_connStr);
|
|
try
|
|
{
|
|
if (objCutomerVehicle.VehicleNumberPlate == null)
|
|
{
|
|
}
|
|
else
|
|
{
|
|
Task<CustomerVehicleModelDBM> objTelematic_Model = objTicket.GetFuelDetails(objCutomerVehicle.VehicleNumberPlate);
|
|
CustomerVehicleModelDBM objCustomerVehicleModelDBMnew = objTelematic_Model.Result;
|
|
objCutomerVehicle.fuelLevelInLtr = objCustomerVehicleModelDBMnew.fuelLevelInLtr;
|
|
objCutomerVehicle.fuelLevelInPer = objCustomerVehicleModelDBMnew.fuelLevelInPer;
|
|
objCutomerVehicle.defLevelInLtr = objCustomerVehicleModelDBMnew.defLevelInLtr;
|
|
}
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
objLog.ErrorLogFile("TicketDetailsController def level", Ex.Message, path, errorlogtf);
|
|
}
|
|
try
|
|
{
|
|
if (objCutomerVehicle.VehicleNumberPlate == null)
|
|
{
|
|
}
|
|
else
|
|
{
|
|
string batteryvoltage = objTicket.getBatteryVoltage(objCutomerVehicle.VehicleNumberPlate);
|
|
objCutomerVehicle.BatteryVoltage = batteryvoltage;
|
|
}
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
objLog.ErrorLogFile("TicketDetailsController battery voltage", Ex.Message, path, errorlogtf);
|
|
}
|
|
|
|
}
|
|
}
|
|
|
|
return objCutomerVehicle;
|
|
|
|
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
// write error log into fil
|
|
objLog.ErrorLogFile("TicketDetailsController GetCustomerDetailsDBMChassisNo", Ex.Message, path, errorlogtf);
|
|
objCutomerVehicle = new CustomerVehicleModelDBM();
|
|
objCutomerVehicle.Status = 0;
|
|
objCutomerVehicle.Message = ConfigurationManager.AppSettings["PwdErrorMsg"].ToString() + Ex.Message;
|
|
return objCutomerVehicle;
|
|
}
|
|
return objCutomerVehicle;
|
|
}
|
|
|
|
/// <summary>
|
|
/// added comment
|
|
/// </summary>
|
|
/// <param name="isupdate"></param>
|
|
/// <param name="model"></param>
|
|
/// <returns></returns>
|
|
|
|
|
|
//old 25 sept 2024
|
|
/* public CustomerVehicleModelDBM Post([FromBody] CustomerVehicleModelDBM model)
|
|
{
|
|
GlobalRepository objGlobalRepository = new GlobalRepository("");
|
|
// CustomerVehicleModelDBM objVehicle = new CustomerVehicleModelDBM();
|
|
CustomerVehicleModelDBM objCutomerVehicle = new CustomerVehicleModelDBM();
|
|
CustomerVehicleModelDBM objCutomerVehiclewaranty = new CustomerVehicleModelDBM();
|
|
try
|
|
{
|
|
ClodantAPIModel objclodantmodel1 = new ClodantAPIModel();
|
|
objclodantmodel1.chassis_no = "MC2BFSRF0PL105830";
|
|
TicketRepository objTicket = new TicketRepository(_connStr);
|
|
string regno = model.VehicleRegistrationNumber;
|
|
if (model.VehicleRegistrationNumber != null && model.VehicleRegistrationNumber != "")
|
|
{
|
|
//replace "-" to blank space and than replace blank space to empty string in registration no.
|
|
model.VehicleRegistrationNumber = model.VehicleRegistrationNumber.Replace("-", " ").Replace(" ", String.Empty);
|
|
|
|
}
|
|
|
|
objCutomerVehicle = objTicket.GetCustomerDetailsDBM(model);
|
|
if (objCutomerVehicle.VehicleNumberPlate == null || objCutomerVehicle.VehicleNumberPlate == "")
|
|
{
|
|
try
|
|
{
|
|
var watch1 = System.Diagnostics.Stopwatch.StartNew();
|
|
string APIRegistrationNo = string.Format(ConfigurationManager.AppSettings["EOSAPIFORGETTINGCUSTOMERDATA"].ToString(), model.VehicleRegistrationNumber.ToUpper(), "");
|
|
WebRequest req = WebRequest.Create(APIRegistrationNo);
|
|
req.Method = "GET";
|
|
string userNameAndPassword = ConfigurationManager.AppSettings["EOSUSERNAMEFORGETTINGCUSTOMERDATA"].ToString() + ":" + ConfigurationManager.AppSettings["EOSPASSWORDFORGETTINGCUSTOMERDATA"].ToString();
|
|
req.Headers["Authorization"] = "Basic " + Convert.ToBase64String(Encoding.Default.GetBytes(userNameAndPassword));
|
|
req.Credentials = new NetworkCredential(ConfigurationManager.AppSettings["EOSUSERNAMEFORGETTINGCUSTOMERDATA"].ToString(), ConfigurationManager.AppSettings["EOSPASSWORDFORGETTINGCUSTOMERDATA"].ToString());
|
|
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls |
|
|
SecurityProtocolType.Tls11 |
|
|
SecurityProtocolType.Tls12;
|
|
WebResponse webRes = req.GetResponse();
|
|
HttpWebResponse resp = req.GetResponse() as HttpWebResponse;
|
|
if (resp.StatusCode == HttpStatusCode.OK)
|
|
{
|
|
StreamReader ResponseDataStream = new StreamReader(resp.GetResponseStream());
|
|
String res = ResponseDataStream.ReadToEnd();
|
|
XmlDocument XMLDoc = new XmlDocument();
|
|
XMLDoc.LoadXml(res);
|
|
XmlNodeList nodeList = XMLDoc.GetElementsByTagName("content");
|
|
XNamespace ab = "http://schemas.microsoft.com/ado/2007/08/dataservices";
|
|
string Short_Fall = string.Empty;
|
|
foreach (XmlNode node in nodeList)
|
|
{
|
|
XDocument doc = XDocument.Parse(node.InnerXml);
|
|
XElement tempElement = doc.Descendants(ab + "Vhvin").FirstOrDefault();
|
|
model.VehicleNumberPlate = tempElement.Value;//Chassis Number
|
|
////Vehicle Model Number
|
|
tempElement = doc.Descendants(ab + "Maktx").FirstOrDefault();
|
|
model.VehicleModelNumber = tempElement.Value;
|
|
//Vehicle Product Varient
|
|
tempElement = doc.Descendants(ab + "Vtext").FirstOrDefault();
|
|
model.VehicleType = tempElement.Value;
|
|
//Vehicle Installation Date
|
|
tempElement = doc.Descendants(ab + "date").FirstOrDefault();
|
|
if (!string.IsNullOrEmpty(tempElement.Value))
|
|
{
|
|
DateTime dt = DateTime.ParseExact(tempElement.Value, "yyyymmdd", CultureInfo.InvariantCulture, DateTimeStyles.AssumeLocal);
|
|
objCutomerVehicle.vehicle_installation_date = dt.ToString(ConfigurationManager.AppSettings["DateFormat"]);
|
|
}
|
|
else
|
|
{
|
|
objCutomerVehicle.vehicle_installation_date = "";
|
|
}
|
|
tempElement = doc.Descendants(ab + "Name1").FirstOrDefault();
|
|
objCutomerVehicle.CustomerName = tempElement.Value;
|
|
tempElement = doc.Descendants(ab + "CustomerId").FirstOrDefault();
|
|
objCutomerVehicle.CustomerId = tempElement.Value;
|
|
tempElement = doc.Descendants(ab + "CustomerType").FirstOrDefault();
|
|
objCutomerVehicle.CustomerType = tempElement.Value;
|
|
tempElement = doc.Descendants(ab + "Telf1").FirstOrDefault();
|
|
objCutomerVehicle.CustomerMobile1 = tempElement.Value;
|
|
tempElement = doc.Descendants(ab + "CustAddr").FirstOrDefault();
|
|
objCutomerVehicle.CustomerAddress = tempElement.Value;
|
|
tempElement = doc.Descendants(ab + "CustState").FirstOrDefault();
|
|
objCutomerVehicle.CustomerState = tempElement.Value;
|
|
tempElement = doc.Descendants(ab + "Vehicle_Warranty").FirstOrDefault();
|
|
objCutomerVehicle.vehicle_warranty = tempElement.Value;
|
|
tempElement = doc.Descendants(ab + "AMC").FirstOrDefault();
|
|
objCutomerVehicle.vehicle_amc = tempElement.Value;
|
|
tempElement = doc.Descendants(ab + "Emission_norms").FirstOrDefault();
|
|
objCutomerVehicle.VehicleEmissionNorms = tempElement.Value; tempElement = doc.Descendants(ab + "sales_date").FirstOrDefault();
|
|
objCutomerVehicle.VehicleSalesDate = tempElement.Value;
|
|
objCutomerVehicle.userType = "DBMApi";
|
|
|
|
|
|
}
|
|
}
|
|
model.VehicleNumberPlate = objCutomerVehicle.VehicleNumberPlate;
|
|
string extendedarranty = objGlobalRepository.getvehicleExtendedwarranty(model.VehicleNumberPlate);
|
|
if (extendedarranty == "")
|
|
{
|
|
}
|
|
else
|
|
{
|
|
string[] tokens = extendedarranty.Split(',');
|
|
objCutomerVehicle.extended_warranty = tokens[0];
|
|
objCutomerVehicle.warranty_end_date = tokens[1];
|
|
}
|
|
string WARRANTY = "";
|
|
WARRANTY = objGlobalRepository.getvehiclewarranty(model.VehicleRegistrationNumber);
|
|
objCutomerVehicle.vehicle_warranty = WARRANTY;
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
// objLog.ErrorLogFile("TicketDetailsController GetDummyTicketDetails call warranty api", Ex.Message, path, errorlogtf);
|
|
objCutomerVehicle = objTicket.GetCustomerDetailsDBM(model);
|
|
objTicketRepository = new TicketRepository(_connStr);
|
|
string strchassisno = objTicketRepository.GetChassisNoByRegno(model.VehicleRegistrationNumber);
|
|
model.VehicleNumberPlate = strchassisno;
|
|
|
|
objCutomerVehicle = objTicket.GetCustomerDetailsDBMChassisNo(model);
|
|
model.VehicleNumberPlate = objCutomerVehicle.VehicleNumberPlate;
|
|
//model.VehicleNumberPlate = "MC2BUERC0PL105890";
|
|
|
|
|
|
// objCutomerVehiclewaranty = objTiclaket.GetwarrantyDetailsDBM(model);lak
|
|
string WARRANTY = "";
|
|
if (strchassisno == "")
|
|
{
|
|
objCutomerVehicle.userType = "NonDBM";
|
|
objCutomerVehicle.vehicle_warranty = "-";
|
|
objCutomerVehicle.extended_warranty = "-";
|
|
objCutomerVehicle.warranty_end_date = "";
|
|
|
|
}
|
|
else
|
|
{
|
|
objCutomerVehicle.userType = "DBMDataLake";
|
|
WARRANTY = objGlobalRepository.getvehiclewarrantychassis(model.VehicleNumberPlate);
|
|
objCutomerVehicle.vehicle_warranty = WARRANTY;
|
|
model.VehicleNumberPlate = objCutomerVehicle.VehicleNumberPlate;
|
|
string extendedarranty = objGlobalRepository.getvehicleExtendedwarranty(model.VehicleNumberPlate);
|
|
if (extendedarranty == "")
|
|
{
|
|
}
|
|
else
|
|
{
|
|
string[] tokens = extendedarranty.Split(',');
|
|
objCutomerVehicle.extended_warranty = tokens[0];
|
|
objCutomerVehicle.warranty_end_date = tokens[1];
|
|
}
|
|
}
|
|
}
|
|
}
|
|
else
|
|
{
|
|
model.VehicleNumberPlate = objCutomerVehicle.VehicleNumberPlate;
|
|
objCutomerVehicle.userType = "DBMDataLake";
|
|
|
|
string extendedarranty = objGlobalRepository.getvehicleExtendedwarranty(model.VehicleNumberPlate);
|
|
if (extendedarranty == "")
|
|
{
|
|
}
|
|
else
|
|
{
|
|
string[] tokens = extendedarranty.Split(',');
|
|
objCutomerVehicle.extended_warranty = tokens[0];
|
|
objCutomerVehicle.warranty_end_date = tokens[1];
|
|
}
|
|
string WARRANTY = "";
|
|
WARRANTY = objGlobalRepository.getvehiclewarranty(model.VehicleRegistrationNumber);
|
|
objCutomerVehicle.vehicle_warranty = WARRANTY;
|
|
|
|
|
|
}
|
|
model.VehicleRegistrationNumber = regno;
|
|
|
|
objCutomerVehicle.VehicleRegistrationNumber = regno;
|
|
return objCutomerVehicle;
|
|
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
// write error log into fil
|
|
objLog.ErrorLogFile("TicketDetailsController GetCustomerDetailsDBMChassisNo", Ex.Message, path, errorlogtf);
|
|
objCutomerVehicle = new CustomerVehicleModelDBM();
|
|
objCutomerVehicle.Status = 0;
|
|
objCutomerVehicle.Message = ConfigurationManager.AppSettings["PwdErrorMsg"].ToString() + Ex.Message;
|
|
return objCutomerVehicle;
|
|
}
|
|
|
|
}
|
|
*/
|
|
|
|
public string Post([FromUri] string ticketCount, [FromUri] string ticketStatus, [FromBody] CustomerCloseTicketDetail model)
|
|
{
|
|
string cout = "";
|
|
try
|
|
{
|
|
List<CustomerCloseTicketDetail> objList = new List<CustomerCloseTicketDetail>();
|
|
objTicketRepository = new TicketRepository(_connStr);
|
|
if (model.VehicleRegisterNumber != null && model.VehicleRegisterNumber != "")
|
|
{
|
|
model.VehicleRegisterNumber = model.VehicleRegisterNumber.Replace("-", " ").Replace(" ", String.Empty);
|
|
}
|
|
|
|
|
|
cout = objTicketRepository.GetCustomerCloseTicketDetailCount(model);
|
|
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
|
|
// write error log into file
|
|
objLog.ErrorLogFile("TicketDetailsController GetCustomerCloseTicketDetailCount", Ex.Message, path, errorlogtf);
|
|
|
|
}
|
|
return cout;
|
|
|
|
}
|
|
|
|
|
|
public List<CustomerCloseTicketDetail> Post([FromUri] string ticketCount, [FromUri] string ticketStatus, [FromUri] string closeList, [FromBody] CustomerCloseTicketDetail model)
|
|
{
|
|
List<CustomerCloseTicketDetail> objList = new List<CustomerCloseTicketDetail>();
|
|
try
|
|
{
|
|
objTicketRepository = new TicketRepository(_connStr);
|
|
if (model.VehicleRegisterNumber != null && model.VehicleRegisterNumber != "")
|
|
{
|
|
model.VehicleRegisterNumber = model.VehicleRegisterNumber.Replace("-", " ").Replace(" ", String.Empty);
|
|
}
|
|
if (ticketCount == "10")
|
|
{
|
|
objList = objTicketRepository.GetCustomerCloseTicketDetailTopTen(model);
|
|
}
|
|
else
|
|
{
|
|
objList = objTicketRepository.GetCustomerCloseTicketDetailNew(model);
|
|
}
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
// write error log into file
|
|
objLog.ErrorLogFile("TicketDetailsController GetCustomerCloseTicketDetailTopTen", Ex.Message, path, errorlogtf);
|
|
|
|
}
|
|
return objList;
|
|
}
|
|
|
|
public List<DummyOpenTicketDetail> Post([FromUri] string SaveTicket, [FromUri] string ticketCount, [FromUri] string ticketStatus, [FromUri] string closeList, [FromBody] DummyOpenTicketDetail model)
|
|
{
|
|
List<DummyOpenTicketDetail> objList = new List<DummyOpenTicketDetail>();
|
|
try
|
|
{
|
|
objTicketRepository = new TicketRepository(_connStr);
|
|
if (model.VehicleRegisterNumber != null && model.VehicleRegisterNumber != "")
|
|
{
|
|
|
|
model.VehicleRegisterNumber = model.VehicleRegisterNumber.Replace("-", " ").Replace(" ", String.Empty);
|
|
}
|
|
objList = objTicketRepository.GetDummyTicketDetails(model);
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
// write error log into file
|
|
objLog.ErrorLogFile("TicketDetailsController GetDummyTicketDetails", Ex.Message, path, errorlogtf);
|
|
}
|
|
return objList;
|
|
}
|
|
public List<CustomerOpenTicketDetail> Post([FromUri] string ticketCount, [FromUri] string ticketStatus, [FromUri] string openList, [FromUri] string isopen, [FromBody] CustomerOpenTicketDetail model)
|
|
{
|
|
List<CustomerOpenTicketDetail> objList = new List<CustomerOpenTicketDetail>();
|
|
try
|
|
{
|
|
objTicketRepository = new TicketRepository(_connStr);
|
|
if (model.VehicleRegisterNumber != null && model.VehicleRegisterNumber != "")
|
|
{
|
|
model.VehicleRegisterNumber = model.VehicleRegisterNumber.Replace("-", " ").Replace(" ", String.Empty);
|
|
}
|
|
objList = objTicketRepository.GetCustomerOpenTicketDetail(model);
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
// write error log into file
|
|
objLog.ErrorLogFile("TicketDetailsController GetCustomerOpenTicketDetail", Ex.Message, path, errorlogtf);
|
|
}
|
|
return objList;
|
|
}
|
|
|
|
public CustomerModelDBM Post([FromUri] string ownerinfo, [FromUri] string ticketid, [FromUri] string Token, [FromUri] string openclose)
|
|
|
|
{
|
|
CustomerModelDBM objCust = new CustomerModelDBM();
|
|
try
|
|
{
|
|
TicketRepository objTicket = new TicketRepository(_connStr);
|
|
objTicketRepository = new TicketRepository(_connStr);
|
|
objCust = objTicketRepository.getTicketInfo(Token, ticketid, openclose);
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
// write error log into file
|
|
objLog.ErrorLogFile("TicketDetailsController getTicketInfo", Ex.Message, path, errorlogtf);
|
|
}
|
|
return objCust;
|
|
}
|
|
public EscalationLevelOutputModel Post([FromUri] string escalationinfo, [FromUri] string DelerId, [FromUri] string Token, [FromUri] string VehicleType, [FromUri] string Escalation)
|
|
{
|
|
EscalationLevelOutputModel oEscalationLevelOutputModel = new EscalationLevelOutputModel();
|
|
TicketRepository objTicket = new TicketRepository(_connStr);
|
|
try
|
|
{
|
|
objTicketRepository = new TicketRepository(_connStr);
|
|
EscalationLevelInputModel model = new EscalationLevelInputModel();
|
|
model.DelerId = DelerId;
|
|
model.VehicleType = VehicleType;
|
|
model.Token = Token;
|
|
oEscalationLevelOutputModel = objTicket.GetEscalationLevels(model);
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
objLog.ErrorLogFile("TicketDetails GetEscalationLevels", Ex.Message, path, errorlogtf);
|
|
|
|
}
|
|
return oEscalationLevelOutputModel;
|
|
}
|
|
|
|
|
|
// NEW ONE 20 AUG 2025 start
|
|
#region FOR EPS SMS NEW METHOD
|
|
|
|
public string Post([FromUri] string isupdate, [FromBody] CustomerVehicleModelDBM model)
|
|
{
|
|
string strsucess = "";
|
|
TicketRepository objTicket = new TicketRepository(_connStr);
|
|
GlobalRepository objGlobalRepository = new GlobalRepository(_connStr);
|
|
objTicketRepository = new TicketRepository(_connStr);
|
|
InsertOpenTicket modelvecv = new InsertOpenTicket();
|
|
PushData UdanPushData = new PushData();
|
|
try
|
|
{
|
|
if (isupdate == "dummy")
|
|
{
|
|
try
|
|
{
|
|
strsucess = objTicketRepository.updateDummyopenticketvalues(model);
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
objLog.ErrorLogFile("TicketDetailsController updateDummyopenticketvalues", Ex.Message, path, errorlogtf);
|
|
|
|
}
|
|
}
|
|
|
|
else
|
|
{
|
|
try
|
|
{
|
|
|
|
if (model.isEPS)
|
|
{
|
|
strsucess = objTicketRepository.updateopenticketvalueseps(model);
|
|
}
|
|
else
|
|
{
|
|
strsucess = objTicketRepository.updateopenticketvalues(model);
|
|
}
|
|
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
objLog.ErrorLogFile("TicketDetailsController updateopenticketvalues", Ex.Message, path, errorlogtf);
|
|
|
|
}
|
|
int tstatus = Convert.ToInt32(model.TicketStatusCreation);
|
|
|
|
string VehicleRegistrationNumber = "";
|
|
string ticketIdAlias = "";
|
|
string assigned_to_user_id = "";
|
|
string vehicleTagging = "";
|
|
DataSet ds = new DataSet();
|
|
DataSet ds1 = new DataSet();
|
|
DataSet ds2 = new DataSet();
|
|
DataSet ds3 = new DataSet();
|
|
string url = System.Web.Configuration.WebConfigurationManager.AppSettings["SmsUrl"].ToString();
|
|
#region Ticket assign to dealer portal
|
|
if (tstatus == 2 && model.AssignedToCreation.Trim().ToUpper() == "DEALER")
|
|
{
|
|
#region Ticket deatils
|
|
try
|
|
{
|
|
DataSet dsOpen = new DataSet();
|
|
NpgsqlParameter[] nSqlParamopen = new NpgsqlParameter[1];
|
|
nSqlParamopen[0] = new NpgsqlParameter("inticketid ", model.TicketNo);
|
|
|
|
dsOpen = NpgSqlHelper.ExecuteDataset(_connStr, CommandType.StoredProcedure, ConfigurationManager.AppSettings["usp_get_open_ticket_by_ticketid"], nSqlParamopen);
|
|
if (dsOpen.Tables[0].Rows.Count > 0)
|
|
{
|
|
ticketIdAlias = dsOpen.Tables[0].Rows[0]["_ticketid_alias"].ToString(); // getting ticket id alias
|
|
assigned_to_user_id = dsOpen.Tables[0].Rows[0]["_assigned_to_user_id"].ToString(); // getting ticket id alias
|
|
vehicleTagging = dsOpen.Tables[0].Rows[0]["_vehicle_tagging"].ToString(); // getting ticket id alias
|
|
VehicleRegistrationNumber = dsOpen.Tables[0].Rows[0]["_vehicle_registration_number"].ToString(); // getting ticket id alias
|
|
}
|
|
model.VehicleRegistrationNumber = VehicleRegistrationNumber;
|
|
modelvecv.VehicleRegistrationNumber = VehicleRegistrationNumber;
|
|
modelvecv.AssignedToUserId = assigned_to_user_id;
|
|
modelvecv.VehicleTagging = vehicleTagging;
|
|
modelvecv.TicketIdAlias = ticketIdAlias;
|
|
modelvecv.TicketId = model.TicketNo;
|
|
modelvecv.VehicleTagging = vehicleTagging;
|
|
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
objLog.ErrorLogFile("TicketDetailsController usp_get_open_ticket_by_ticketid", Ex.Message, path, errorlogtf);
|
|
|
|
}
|
|
try
|
|
{
|
|
|
|
objTicket.InsertTicketDetailOnCreationInVECV(modelvecv, ticketIdAlias, modelvecv.TicketId, modelvecv.AssignedToUserId);
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
objLog.ErrorLogFile("TicketDetailsController Error update tiketdetailcontroller InsertTicketDetailOnCreationInVECVNew:", Ex.Message, path, errorlogtf);
|
|
}
|
|
try
|
|
{
|
|
|
|
// DataSet ds = new DataSet();
|
|
// get contact details for sending sms.
|
|
NpgsqlParameter[] nSqlParam1 = new NpgsqlParameter[2];
|
|
nSqlParam1[0] = new NpgsqlParameter("inticket_id", model.TicketNo);
|
|
nSqlParam1[1] = new NpgsqlParameter("invehicle_reg", null);
|
|
ds = NpgSqlHelper.ExecuteDataset(_connStr, CommandType.StoredProcedure, ConfigurationManager.AppSettings["usp_get_contact_details_for_sms_api"], nSqlParam1);
|
|
|
|
|
|
// get sms content details.
|
|
if (model.VehicleType.ToLower() == "eps")
|
|
{
|
|
NpgsqlParameter[] nSqlParam2_ticket_info = new NpgsqlParameter[4];
|
|
nSqlParam2_ticket_info[0] = new NpgsqlParameter("inregistration_number", null);
|
|
nSqlParam2_ticket_info[1] = new NpgsqlParameter("inmobile_number", null);
|
|
nSqlParam2_ticket_info[2] = new NpgsqlParameter("inticket_number", model.TicketNo);
|
|
nSqlParam2_ticket_info[3] = new NpgsqlParameter("inEngineNumber", null);
|
|
try
|
|
{
|
|
ds1 = NpgSqlHelper.ExecuteDataset(_connStr, CommandType.StoredProcedure, ConfigurationManager.AppSettings["usp_get_customer_open_ticket_details_EPS"], nSqlParam2_ticket_info);
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
objLog.ErrorLogFile("TicketRepository InsertTicketDetailOnCreationInVECV usp_get_customer_open_ticket_details" + model.TicketNo, Ex.Message, path, errorlogtf);
|
|
}
|
|
}
|
|
else
|
|
{
|
|
NpgsqlParameter[] nSqlParamopen = new NpgsqlParameter[3];
|
|
nSqlParamopen[0] = new NpgsqlParameter("inregistration_number", null);
|
|
nSqlParamopen[1] = new NpgsqlParameter("inmobile_number", null);
|
|
nSqlParamopen[2] = new NpgsqlParameter("inticket_number", model.TicketNo);
|
|
ds1 = NpgSqlHelper.ExecuteDataset(_connStr, CommandType.StoredProcedure, ConfigurationManager.AppSettings["usp_get_customer_open_ticket_details"], nSqlParamopen);
|
|
}
|
|
NpgsqlParameter[] nSqlParamticketdetail = new NpgsqlParameter[1];
|
|
nSqlParamticketdetail[0] = new NpgsqlParameter("inticket_number", model.TicketNo);
|
|
ds2 = NpgSqlHelper.ExecuteDataset(_connStr, CommandType.StoredProcedure, ConfigurationManager.AppSettings["usp_get_customer_open_ticket_full_details_ticket_wise"], nSqlParamticketdetail);
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
|
|
objLog.ErrorLogFile("TicketDetailsController Error getting ticket details:", Ex.Message, path, errorlogtf);
|
|
}
|
|
|
|
#endregion
|
|
|
|
|
|
|
|
#region for Auto Comment
|
|
if (tstatus == 1 && model.AssignedToCreation.Trim().ToUpper() == "VAN")
|
|
{
|
|
}
|
|
else
|
|
{
|
|
try
|
|
{
|
|
DataSet dscomments = new DataSet();
|
|
NpgsqlParameter[] nSqlParamcomment = new NpgsqlParameter[1];
|
|
nSqlParamcomment[0] = new NpgsqlParameter("inticket_id", model.TicketNo);
|
|
dscomments = NpgSqlHelper.ExecuteDataset(_connStr, CommandType.StoredProcedure, ConfigurationManager.AppSettings["usp_get_assigned_comment"], nSqlParamcomment);
|
|
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
|
|
// write error log into file
|
|
objLog.ErrorLogFile("TicketDetailsController ticket comment id", model.TicketNo, path, errorlogtf);
|
|
objLog.ErrorLogFile("TicketDetailsController ticket comment", Ex.Message, path, errorlogtf);
|
|
|
|
}
|
|
|
|
try
|
|
{
|
|
objLog.AddLogFile("DBM Log 5", tstatus.ToString(), path, errorlogtf);
|
|
|
|
objLog.AddLogFile("DBM Log 4", model.VehicleRegistrationNumber, path, errorlogtf);
|
|
|
|
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
objLog.ErrorLogFile("TicketDetailsController update open ticket dbm api SendDataToSAP", Ex.Message, path, errorlogtf);
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region Sending Udaan
|
|
|
|
|
|
try
|
|
{
|
|
objLog.AddLogFile("DBM Log 1", tstatus.ToString(), path, errorlogtf);
|
|
|
|
objLog.AddLogFile("DBM Log 2", model.AssignedToCreation.Trim().ToUpper(), path, errorlogtf);
|
|
|
|
if (tstatus == 1 && model.AssignedToCreation.Trim().ToUpper() == "VAN")
|
|
{
|
|
objLog.AddLogFile("DBM Log 3", "in if", path, errorlogtf);
|
|
DataSet dsOpen = new DataSet();
|
|
NpgsqlParameter[] nSqlParamopen = new NpgsqlParameter[1];
|
|
nSqlParamopen[0] = new NpgsqlParameter("inticketid ", model.TicketNo);
|
|
|
|
dsOpen = NpgSqlHelper.ExecuteDataset(_connStr, CommandType.StoredProcedure, ConfigurationManager.AppSettings["usp_get_open_ticket_by_ticketid"], nSqlParamopen);
|
|
if (dsOpen.Tables[0].Rows.Count > 0)
|
|
{
|
|
ticketIdAlias = dsOpen.Tables[0].Rows[0]["_ticketid_alias"].ToString(); // getting ticket id alias
|
|
assigned_to_user_id = dsOpen.Tables[0].Rows[0]["_assigned_to_user_id"].ToString(); // getting ticket id alias
|
|
vehicleTagging = dsOpen.Tables[0].Rows[0]["_vehicle_tagging"].ToString(); // getting ticket id alias
|
|
VehicleRegistrationNumber = dsOpen.Tables[0].Rows[0]["_vehicle_registration_number"].ToString(); // getting ticket id alias
|
|
}
|
|
model.VehicleRegistrationNumber = VehicleRegistrationNumber;
|
|
objLog.AddLogFile("DBM Log 3", model.VehicleRegistrationNumber, path, errorlogtf);
|
|
UdanPushData.SendDataToSAP(model.VehicleRegistrationNumber, tstatus, model.TicketNo, "");
|
|
|
|
}
|
|
|
|
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
objLog.ErrorLogFile("TicketDetailsController update open ticket dbm api SendDataToSAP", Ex.Message, path, errorlogtf);
|
|
}
|
|
#endregion
|
|
if (model.VehicleType.ToLower() == "eps")
|
|
{
|
|
#region sending SMS
|
|
|
|
DataSet dsEPS = new DataSet();
|
|
NpgsqlParameter[] nSqlParam = new NpgsqlParameter[1];
|
|
nSqlParam[0] = new NpgsqlParameter("inticket_id", model.TicketNo);
|
|
dsEPS = NpgSqlHelper.ExecuteDataset(_connStr, CommandType.StoredProcedure, ConfigurationManager.AppSettings["usp_get_EPS_Email_details"], nSqlParam);
|
|
|
|
string dssmstime = objTicketRepository.getimeForSMS(model.TicketNo);
|
|
string msgOwnerforDealerTicket = System.Web.Configuration.WebConfigurationManager.AppSettings["msgEPSCustomerDealerAssignment"].ToString();
|
|
string msgDealerforDealerTicket = System.Web.Configuration.WebConfigurationManager.AppSettings["msgEPSDealerDealerAssignment"].ToString();
|
|
string msgCSMforDealerTicket = System.Web.Configuration.WebConfigurationManager.AppSettings["msgEPSCSMDealerAssignment"].ToString();
|
|
msgOwnerforDealerTicket = string.Format(msgOwnerforDealerTicket, ticketIdAlias,
|
|
dssmstime, dsEPS.Tables[0].Rows[0]["product_type"].ToString(), "("+ dsEPS.Tables[0].Rows[0]["engine_number"].ToString() + ")",// engine no
|
|
ds2.Tables[0].Rows[0]["dealer_dealer_name"].ToString()+"("+ ds.Tables[0].Rows[0]["wm_contact_no"].ToString() + ")"// dealer name wm no
|
|
|
|
);
|
|
|
|
// engine no
|
|
|
|
|
|
|
|
msgDealerforDealerTicket = string.Format(msgDealerforDealerTicket, ticketIdAlias,
|
|
dsEPS.Tables[0].Rows[0]["product_type"].ToString(), "(" + dsEPS.Tables[0].Rows[0]["engine_number"].ToString() + ")",
|
|
ds1.Tables[0].Rows[0]["breakdown_location"].ToString().Replace("&", "%26"),
|
|
ds2.Tables[0].Rows[0]["dealer_dealer_name"].ToString() + " (" + ds.Tables[0].Rows[0]["wm_contact_no"].ToString() + ")",// dealer name wm no
|
|
|
|
|
|
ds.Tables[0].Rows[0]["customer_mobile_number_1"].ToString(), // owner number
|
|
ds.Tables[0].Rows[0]["customer_contact_no"].ToString() // driver number
|
|
);
|
|
|
|
msgCSMforDealerTicket = string.Format(msgCSMforDealerTicket, ticketIdAlias,
|
|
dsEPS.Tables[0].Rows[0]["product_type"].ToString(), "(" + dsEPS.Tables[0].Rows[0]["engine_number"].ToString() + ")",
|
|
ds1.Tables[0].Rows[0]["breakdown_location"].ToString().Replace("&", "%26"),
|
|
ds2.Tables[0].Rows[0]["dealer_dealer_name"].ToString() + " (" + ds2.Tables[0].Rows[0]["dealer_contact_number1"].ToString() + ")",// dealer name wm no
|
|
ds.Tables[0].Rows[0]["customer_mobile_number_1"].ToString(), // owner number
|
|
ds.Tables[0].Rows[0]["customer_contact_no"].ToString() // driver number
|
|
);
|
|
string[] CSMContactNo = ds.Tables[0].Rows[0]["csm_contact_no"].ToString().Split(',');
|
|
|
|
for (int i = 0; i < CSMContactNo.Count(); i++)
|
|
{
|
|
string CSMsms = string.Format(url, CSMContactNo[i], msgCSMforDealerTicket);
|
|
objGlobalRepository.SendMessage(CSMsms);
|
|
}
|
|
string CustomerSms = string.Format(url, ds.Tables[0].Rows[0]["customer_contact_no"].ToString(), msgOwnerforDealerTicket);
|
|
objGlobalRepository.SendMessage(CustomerSms);
|
|
|
|
string driverSms = string.Format(url, ds.Tables[0].Rows[0]["customer_mobile_number_1"].ToString(), msgOwnerforDealerTicket);
|
|
objGlobalRepository.SendMessage(driverSms);
|
|
|
|
string[] WMContactNo = ds.Tables[0].Rows[0]["WM_contact_no"].ToString().Split(',');
|
|
|
|
for (int i = 0; i < WMContactNo.Count(); i++)
|
|
{
|
|
|
|
string WMsms = string.Format(url, WMContactNo[i], msgDealerforDealerTicket);
|
|
objGlobalRepository.SendMessage(WMsms);
|
|
|
|
}
|
|
|
|
string[] SiteIchargeContactNo = ds.Tables[0].Rows[0]["site_incharge_contact"].ToString().Split(',');
|
|
|
|
for (int i = 0; i < SiteIchargeContactNo.Count(); i++)
|
|
{
|
|
|
|
string WMsms = string.Format(url, SiteIchargeContactNo[i], msgDealerforDealerTicket);
|
|
objGlobalRepository.SendMessage(WMsms);
|
|
|
|
}
|
|
|
|
#endregion
|
|
}
|
|
else
|
|
{
|
|
#region sending SMS
|
|
|
|
string msgCustforDealerTicket = System.Web.Configuration.WebConfigurationManager.AppSettings["msgCustforDealerTicketwithOTP"].ToString();
|
|
// -------------- modify on 04-03-2021 end -----------------
|
|
string msgOwnerforDealerTicket = System.Web.Configuration.WebConfigurationManager.AppSettings["msgOwnerforDealerTicket"].ToString();
|
|
string msgDealerforDealerTicket = System.Web.Configuration.WebConfigurationManager.AppSettings["msgDealerforDealerTicket"].ToString();
|
|
string msgCSMforDealerTicket = System.Web.Configuration.WebConfigurationManager.AppSettings["msgCSMforDealerTicket"].ToString();
|
|
string msgWMforDealerTicket = System.Web.Configuration.WebConfigurationManager.AppSettings["msgWMforDealerTicket"].ToString();
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
// -------------- added on 04-03-2021 start -----------------
|
|
DataSet dsmobileotp = new DataSet();
|
|
if (!String.IsNullOrWhiteSpace(ticketIdAlias))
|
|
{
|
|
|
|
NpgsqlParameter[] nSqlParam2 = new NpgsqlParameter[2];
|
|
nSqlParam2[0] = new NpgsqlParameter("inticket_id", ticketIdAlias);
|
|
nSqlParam2[1] = new NpgsqlParameter("in_van_id", "");
|
|
|
|
|
|
dsmobileotp = NpgSqlHelper.ExecuteDataset(_connStr, CommandType.StoredProcedure, ConfigurationManager.AppSettings["usp_get_ticket_otp"], nSqlParam2);
|
|
|
|
|
|
|
|
}
|
|
// -------------- added on 04-03-2021 end -----------------
|
|
msgCustforDealerTicket = string.Format(msgCustforDealerTicket, ticketIdAlias,
|
|
ds.Tables[0].Rows[0]["vehicle_registration_number"].ToString(), ds2.Tables[0].Rows[0]["dealer_dealer_name"].ToString() + " (" + ds2.Tables[0].Rows[0]["dealer_city"].ToString() + ") ",
|
|
ConfigurationManager.AppSettings["TollFreeNo"].ToString(),
|
|
dsmobileotp.Tables[0].Rows[0][0]); // added on 04-03-2021
|
|
|
|
|
|
|
|
|
|
msgDealerforDealerTicket = string.Format(msgDealerforDealerTicket, ticketIdAlias,
|
|
ds.Tables[0].Rows[0]["vehicle_registration_number"].ToString() + "( " + ds.Tables[0].Rows[0]["customer_contact_no"].ToString() + " ) ",
|
|
ds1.Tables[0].Rows[0]["breakdown_location"].ToString().Replace("&", "%26"),
|
|
ds.Tables[0].Rows[0]["customer_mobile_number_1"].ToString(), // owner number
|
|
ds.Tables[0].Rows[0]["customer_contact_no"].ToString() // driver number
|
|
);
|
|
msgWMforDealerTicket = string.Format(msgWMforDealerTicket, ticketIdAlias,
|
|
ds.Tables[0].Rows[0]["vehicle_registration_number"].ToString() + "( " + ds.Tables[0].Rows[0]["customer_contact_no"].ToString() + " ) ",
|
|
ds1.Tables[0].Rows[0]["breakdown_location"].ToString().Replace("&", "%26"),
|
|
ds.Tables[0].Rows[0]["customer_mobile_number_1"].ToString(), // owner number
|
|
ds.Tables[0].Rows[0]["customer_contact_no"].ToString() // driver number
|
|
);
|
|
|
|
msgCSMforDealerTicket = string.Format(msgCSMforDealerTicket, ticketIdAlias,
|
|
//ds2.Tables[0].Rows[0]["dealer_dealer_name"].ToString() + " (" + ds.Tables[0].Rows[0]["_dealer_contact_number1"].ToString() + ") ", ds.Tables[0].Rows[0]["vehicle_registration_number"].ToString()
|
|
ds2.Tables[0].Rows[0]["dealer_dealer_name"].ToString(),
|
|
ds.Tables[0].Rows[0]["vehicle_registration_number"].ToString(),
|
|
ds.Tables[0].Rows[0]["customer_mobile_number_1"].ToString(), // owner number
|
|
ds.Tables[0].Rows[0]["customer_contact_no"].ToString() // driver number
|
|
);
|
|
|
|
string DealerSms = string.Format(url, ds.Tables[0].Rows[0]["_dealer_contact_number1"].ToString(), msgDealerforDealerTicket);
|
|
// get all contact no split in array.
|
|
string[] CSMContactNo = ds.Tables[0].Rows[0]["csm_contact_no"].ToString().Split(',');
|
|
|
|
for (int i = 0; i < CSMContactNo.Count(); i++)
|
|
{
|
|
string CSMsms = string.Format(url, CSMContactNo[i], msgCSMforDealerTicket);
|
|
objGlobalRepository.SendMessage(CSMsms);
|
|
}
|
|
|
|
string[] WMContactNo = ds.Tables[0].Rows[0]["WM_contact_no"].ToString().Split(',');
|
|
|
|
for (int i = 0; i < WMContactNo.Count(); i++)
|
|
{
|
|
|
|
string WMsms = string.Format(url, WMContactNo[i], msgWMforDealerTicket);
|
|
objGlobalRepository.SendMessage(WMsms);
|
|
|
|
}
|
|
|
|
string[] SiteIchargeContactNo = ds.Tables[0].Rows[0]["site_incharge_contact"].ToString().Split(',');
|
|
|
|
for (int i = 0; i < SiteIchargeContactNo.Count(); i++)
|
|
{
|
|
|
|
string WMsms = string.Format(url, SiteIchargeContactNo[i], msgWMforDealerTicket);
|
|
objGlobalRepository.SendMessage(WMsms);
|
|
|
|
}
|
|
objGlobalRepository.SendMessage(DealerSms);
|
|
|
|
string msgdriverownerAcceptedTicket = System.Web.Configuration.WebConfigurationManager.AppSettings["msgKamDealerAcceptedTicket"].ToString();
|
|
// set content in msg
|
|
string dssmstime = objTicketRepository.getimeForSMS(model.TicketNo);
|
|
string str = model.VehicleModelNumber.ToLower();
|
|
string substring = "titan";
|
|
if (str.Contains(substring))
|
|
{
|
|
|
|
string strurl = objTicketRepository.Encrypt(ticketIdAlias, "Tracking", "YourSaltValue");
|
|
//string strurl = Encrypt("W2H0524869754", "Tracking", "YourSaltValue");
|
|
string liveurl = System.Web.Configuration.WebConfigurationManager.AppSettings["base_url_live_tracking"].ToString();// + strurl;
|
|
string smsSentUrl = $"{liveurl}?{"p"}={Uri.EscapeDataString(strurl)}";
|
|
|
|
//smsSentUrl= smsSentUrl.Replace("%3D","=");
|
|
string msgestimatedVanReachTime = System.Web.Configuration.WebConfigurationManager.AppSettings["msgTitanCreationDealer"].ToString();
|
|
|
|
msgestimatedVanReachTime = string.Format(msgestimatedVanReachTime, ticketIdAlias,
|
|
dssmstime.ToString(), ds.Tables[0].Rows[0]["vehicle_registration_number"].ToString(),
|
|
ds2.Tables[0].Rows[0]["dealer_dealer_name"].ToString(), "(" + ds.Tables[0].Rows[0]["_dealer_contact_number1"].ToString() + ")",
|
|
smsSentUrl);
|
|
|
|
|
|
// ds3_ticket_info.Tables[0].Rows[0]["dealer_dealer_name"].ToString());
|
|
string OwnerSms = string.Format(url, ds.Tables[0].Rows[0]["customer_contact_no"].ToString(), msgestimatedVanReachTime);
|
|
string serviceEnginerSms = string.Format(url, ds.Tables[0].Rows[0]["customer_mobile_number_1"].ToString(), msgestimatedVanReachTime);
|
|
objLog.AddLogFile("OwnerSms", OwnerSms, path, errorlogtf);
|
|
objGlobalRepository.SendMessage(OwnerSms);
|
|
// ds3_ticket_info.Tables[0].Rows[0]["dealer_dealer_name"].ToString());
|
|
//string CustomerSms = string.Format(url, ds.Tables[0].Rows[0]["customer_contact_no"].ToString(), msgestimatedVanReachTime);
|
|
objGlobalRepository.SendMessage(serviceEnginerSms);
|
|
}
|
|
|
|
else
|
|
{
|
|
msgdriverownerAcceptedTicket = string.Format(msgdriverownerAcceptedTicket,
|
|
ticketIdAlias,
|
|
dssmstime.ToString(),// ticket id
|
|
ds.Tables[0].Rows[0]["vehicle_registration_number"].ToString(), // vehicle reg no
|
|
ds2.Tables[0].Rows[0]["dealer_dealer_name"].ToString() + " (" + ds2.Tables[0].Rows[0]["dealer_city"].ToString() + ") ", // dealer name and city
|
|
ConfigurationManager.AppSettings["TollFreeNo"].ToString() // Toll free no
|
|
);
|
|
string CustomerSms = string.Format(url, ds.Tables[0].Rows[0]["customer_contact_no"].ToString(), msgdriverownerAcceptedTicket);
|
|
objGlobalRepository.SendMessage(CustomerSms);
|
|
|
|
string driverSms = string.Format(url, ds.Tables[0].Rows[0]["customer_mobile_number_1"].ToString(), msgdriverownerAcceptedTicket);
|
|
objGlobalRepository.SendMessage(driverSms);
|
|
|
|
}
|
|
if (model.VehicleModelNumber == "6016" || model.VehicleModelNumber == "6019")
|
|
{
|
|
msgWMforDealerTicket = System.Web.Configuration.WebConfigurationManager.AppSettings["msgWMforDealerTicket"].ToString();
|
|
|
|
DataSet dsbusspoke = new DataSet();
|
|
NpgsqlParameter[] nSqlParamdsbusspoke = new NpgsqlParameter[1];
|
|
nSqlParamdsbusspoke[0] = new NpgsqlParameter("inticket_id", model.TicketNo);
|
|
dsbusspoke = NpgSqlHelper.ExecuteDataset(_connStr, CommandType.StoredProcedure, ConfigurationManager.AppSettings["usp_get_details_bus_spoke"], nSqlParamdsbusspoke);
|
|
string[] BusSpokeContactNo = dsbusspoke.Tables[0].Rows[0]["_bus_spoke_contact_no"].ToString().Split(',');
|
|
string[] BusSpokeContactNo2 = dsbusspoke.Tables[0].Rows[0]["_bus_spoke_contact_no2"].ToString().Split(',');
|
|
|
|
for (int i = 0; i < BusSpokeContactNo.Count(); i++)
|
|
{
|
|
|
|
string WMsms = string.Format(url, BusSpokeContactNo[i], msgWMforDealerTicket);
|
|
objGlobalRepository.SendMessage(WMsms);
|
|
|
|
}
|
|
|
|
for (int i = 0; i < BusSpokeContactNo2.Count(); i++)
|
|
{
|
|
|
|
string WMsms = string.Format(url, BusSpokeContactNo2[i], msgWMforDealerTicket);
|
|
objGlobalRepository.SendMessage(WMsms);
|
|
|
|
}
|
|
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
}
|
|
|
|
}
|
|
|
|
objLog.ErrorLogFile("udaan ticket id", model.TicketNo, path, errorlogtf);
|
|
objLog.ErrorLogFile("udaan ticket status", tstatus.ToString(), path, errorlogtf);
|
|
|
|
if (tstatus == 1)
|
|
{
|
|
DataSet dsOpen = new DataSet();
|
|
NpgsqlParameter[] nSqlParamopen = new NpgsqlParameter[1];
|
|
nSqlParamopen[0] = new NpgsqlParameter("inticketid ", model.TicketNo);
|
|
|
|
dsOpen = NpgSqlHelper.ExecuteDataset(_connStr, CommandType.StoredProcedure, ConfigurationManager.AppSettings["usp_get_open_ticket_by_ticketid"], nSqlParamopen);
|
|
if (dsOpen.Tables[0].Rows.Count > 0)
|
|
{
|
|
ticketIdAlias = dsOpen.Tables[0].Rows[0]["_ticketid_alias"].ToString(); // getting ticket id alias
|
|
assigned_to_user_id = dsOpen.Tables[0].Rows[0]["_assigned_to_user_id"].ToString(); // getting ticket id alias
|
|
vehicleTagging = dsOpen.Tables[0].Rows[0]["_vehicle_tagging"].ToString(); // getting ticket id alias
|
|
VehicleRegistrationNumber = dsOpen.Tables[0].Rows[0]["_vehicle_registration_number"].ToString(); // getting ticket id alias
|
|
}
|
|
model.VehicleRegistrationNumber = VehicleRegistrationNumber;
|
|
objLog.ErrorLogFile("udaan reg no 1", model.VehicleRegistrationNumber, path, errorlogtf);
|
|
|
|
UdanPushData.SendDataToSAP(model.VehicleRegistrationNumber, tstatus, model.TicketNo, "");
|
|
|
|
// UdanPushData.SendDataToSAP(model.VehicleRegistrationNumber, tstatus, model.TicketNo, "");
|
|
}
|
|
|
|
if (tstatus == 2)
|
|
{
|
|
try
|
|
{
|
|
DataSet dsOpen = new DataSet();
|
|
NpgsqlParameter[] nSqlParamopen = new NpgsqlParameter[1];
|
|
nSqlParamopen[0] = new NpgsqlParameter("inticketid ", model.TicketNo);
|
|
|
|
dsOpen = NpgSqlHelper.ExecuteDataset(_connStr, CommandType.StoredProcedure, ConfigurationManager.AppSettings["usp_get_open_ticket_by_ticketid"], nSqlParamopen);
|
|
if (dsOpen.Tables[0].Rows.Count > 0)
|
|
{
|
|
ticketIdAlias = dsOpen.Tables[0].Rows[0]["_ticketid_alias"].ToString(); // getting ticket id alias
|
|
assigned_to_user_id = dsOpen.Tables[0].Rows[0]["_assigned_to_user_id"].ToString(); // getting ticket id alias
|
|
vehicleTagging = dsOpen.Tables[0].Rows[0]["_vehicle_tagging"].ToString(); // getting ticket id alias
|
|
VehicleRegistrationNumber = dsOpen.Tables[0].Rows[0]["_vehicle_registration_number"].ToString(); // getting ticket id alias
|
|
}
|
|
model.VehicleRegistrationNumber = VehicleRegistrationNumber;
|
|
modelvecv.VehicleRegistrationNumber = VehicleRegistrationNumber;
|
|
modelvecv.AssignedToUserId = assigned_to_user_id;
|
|
modelvecv.VehicleTagging = vehicleTagging;
|
|
modelvecv.TicketIdAlias = ticketIdAlias;
|
|
modelvecv.TicketId = model.TicketNo;
|
|
modelvecv.VehicleTagging = vehicleTagging;
|
|
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
objLog.ErrorLogFile("TicketDetailsController usp_get_open_ticket_by_ticketid", Ex.Message, path, errorlogtf);
|
|
|
|
}
|
|
objLog.ErrorLogFile("udaan reg no 2", model.VehicleRegistrationNumber, path, errorlogtf);
|
|
|
|
UdanPushData.SendDataToSAP(model.VehicleRegistrationNumber, tstatus, model.TicketNo, "");
|
|
}
|
|
|
|
#endregion
|
|
|
|
|
|
|
|
}
|
|
|
|
////
|
|
|
|
}
|
|
catch (Exception Ex)
|
|
{
|
|
|
|
// write error log into file
|
|
objLog.ErrorLogFile("TicketDetailsController update open ticket using ajax", Ex.Message, path, errorlogtf);
|
|
|
|
}
|
|
|
|
return strsucess;
|
|
}
|
|
|
|
// NEW ONE 20 AUG 2025 End here
|
|
|
|
|
|
#endregion
|
|
}
|
|
}
|