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
  }
}