public JsonResult GetCompanyByIdForDisplaying(int _id)
 {
     try
     {
         var company = CompanyDB.GetInstance().GetCompanyByIdForDisplaying(_id);
         return(Json(company));
     }
     catch (Exception)
     {
         throw;
     }
 }
 public JsonResult DeleteCompany(int _id)
 {
     try
     {
         CompanyDB.GetInstance().DeleteCompany(_id);
         return(Json(true));
     }
     catch (Exception)
     {
         throw;
     }
     return(Json(false));
 }
 public ActionResult GetCompanyList(int _kullanimDurumu, int _firmaTipi, string _firmaKodu)
 {
     try
     {
         _firmaKodu = _firmaKodu == null ? "" : _firmaKodu;
         var companyList = CompanyDB.GetInstance().GetCompanyList(userObj, _kullanimDurumu, _firmaTipi, _firmaKodu);
         return(PartialView("_CompanyList", companyList));
     }
     catch (Exception exc)
     {
         throw exc;
     }
 }
        public IActionResult ExportFile()
        {
            var companyList = CompanyDB.GetInstance().GetAllDBCompaniesForExcel();
            var stream      = new MemoryStream();

            using (var package = new ExcelPackage(stream))
            {
                var sheet = package.Workbook.Worksheets.Add("Şirketler");
                sheet.Cells.LoadFromCollection(companyList, true);
                package.Save();
            }
            stream.Position = 0;
            var fileName = $"Şirketler_{DateTime.Now.ToString("yyyyMMddHHmmss")}.xlsx";

            return(File(stream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName));
        }
        public IActionResult Index()
        {
            //CompanyList = CompanyDB.Instance.GetCompanyList(),
            var returnModel = new CompanyViewModel()
            {
                CompanyTypeList = CompanyTypeDB.GetInstance().GetAllCompanyTypes(),
                CompanyList     = CompanyDB.GetInstance().GetAllCompaniesForAdminPanel(userObj),
                Platforms       = PlatformDB.GetInstance().GetAllPlatforms(),
                Sectors         = SectorDB.GetInstance().GetAllSectors(),
                /*Users = UserDB.GetInstance().GetAllUsers(),*/
                Distributors    = DistributorDB.GetInstance().GetAllDistributors(userObj),
                CompanyPartners = CompanyPartnerDB.GetInstance().GetAllCompanyPartners()
            };

            return(View(returnModel));
        }
Beispiel #6
0
        public IActionResult Index()
        {
            var model = new DeviceViewModel()
            {
                //Devices = DeviceDB.GetInstance().GetAllDevices(userObj),
                TerminalProtocols  = TerminalProtocolDB.GetInstance().GetAllTerminalProtocols(),
                Gateways           = GatewayDB.GetInstance().GetAllGateways(),
                DeviceMontageTypes = DeviceMontageTypeDB.GetInstance().GetAllDeviceMontageTypes(),
                RefTelemetryTypes  = RefTelemetryTypeDB.GetInstance().GetAllRefTelemetryTypes(),
                ServiceTypes       = ServiceTypeDB.GetInstance().GetAllServiceTypes(),
                TerminalTypes      = TerminalTypeDB.GetInstance().GetAllTerminalTypes(),
                UsingStatus        = UsingStatusDB.GetInstance().GetAllUsingStatuses(),
                Vehicles           = VehicleDB.GetInstance().GetAllVehicles(),
                WocheckerFlags     = WocheckerFlagDB.GetInstance().GetAllWocheckerFlags(),
                Companies          = CompanyDB.GetInstance().GetAllCompaniesForAdminPanel(userObj),
                Messagings         = MessagingDB.GetInstance().GetAllMessagings(),
                CompanyTypes       = CompanyTypeDB.GetInstance().GetAllCompanyTypes()
            };

            return(View(model));
        }
        public JsonResult ImportFile(string _excelData)
        {
            _excelData = HttpUtility.HtmlDecode(_excelData);
            var list2 = JsonConvert.DeserializeObject <List <CompanyExcelObject> >(_excelData);

            try
            {
                foreach (var item in list2)
                {
                    Company company = new Company()
                    {
                        CompanyCode        = item.SirketKodu,
                        CompanyDescription = item.SirketKodu,
                        MobileCount        = item.MobilSayisi,
                        Address1           = item.Adres1,
                        Address2           = item.Adres2,
                        Phone             = item.Telefon,
                        Fax               = item.Fax,
                        PersonInCharge    = item.YetkiliKisi,
                        CompanyPartnerId  = !string.IsNullOrEmpty(item.IsOrtagi) ? CompanyPartnerDB.GetInstance().GetCompanyPartnerByNameOrInsert(item.IsOrtagi).Id : 0,
                        DistributorId     = DistributorDB.GetInstance().GetDistributorIdByName(item.BayiAdi),
                        PlatformId        = !string.IsNullOrEmpty(item.Platform) ? PlatformDB.GetInstance().GetPlatformByNameOrInsert(item.Platform).Id : 0,
                        SectorId          = !string.IsNullOrEmpty(item.Sektor) ? SectorDB.GetInstance().GetSectorByNameOrInsert(item.Sektor).Id : 0,
                        LoginUrl          = item.LoginUrl,
                        BaseMap           = item.BaseMap,
                        TechnicalReport   = item.TeknikRapor == "Aktif" ? true : false,
                        TaxAdministration = item.VergiDairesi,
                        TaxNumber         = item.VergiNo,
                        EntranceDate      = GetExcelDateTime(item.GirisZamani),
                        ExitDate          = GetExcelDateTime(item.CikisZamani),
                        AlarmSms          = item.AlarmSms == "Aktif" ? true : false,
                        PasswordControl   = item.SifreKontrol == "Aktif" ? true : false,
                        InfoSense         = item.InfoSense == "Aktif" ? true : false,
                        AccountingCode    = item.MuhasebeHesKodu,
                        Status            = 1,
                        CompanyStatus     = true,
                        CreationDate      = DateTime.Now,
                        UserStatus        = true
                    };
                    var  companyAdmin = ConvertToEngStandarts(company.CompanyCode);
                    bool isUserExist  = UserDB.GetInstance().CheckIfUserExist(companyAdmin);
                    if (isUserExist)
                    {
                        continue;
                    }
                    CompanyDB.GetInstance().AddNewCompany(company);
                    if (!isUserExist)
                    {
                        if (companyAdmin != "")
                        {
                            User user = new User()
                            {
                                UserTypeId = 1,
                                UserCode   = companyAdmin,
                                Password   = "******",
                                Status     = 1
                            };
                            UserDB.GetInstance().AddNewUser(user);
                            CompanyUser companyUser = new CompanyUser()
                            {
                                CompanyId      = company.Id,
                                IsCompanyAdmin = true,
                                Status         = 1,
                                UserId         = user.Id
                            };
                            CompanyUserDB.GetInstance().AddNewCompanyUser(companyUser);
                        }
                    }
                }
                return(Json(true));
            }
            catch (Exception exc)
            {
                throw exc;
            }
        }
        public JsonResult SaveCompany(int _id, int _mainCompanyId, int _companyTypeId, int _companyPartnerId, int _platformId, int _distributorId, int _sectorId, int _companyReportId, string _companyCode, string _companyDescription, string _address1, string _phone, string _userName, string _userSurname, string _userPhone, string _userEmail, bool _technicalReport, string _technicalEmail1, string _technicalEmail2, string _technicalEmail3, bool _companyStatus, bool _alarmSms, bool _passwordControl, string _userCode, string _userPassword, bool _userStatus, bool _companyVehicleProgramming, string _companyGroupName, int _userId, string _accountingCode)
        {
            try
            {
                if (_id == 0)
                {
                    var user = new User()
                    {
                        Name       = _userName,
                        Surname    = _userSurname,
                        UserCode   = _userCode,
                        Mail       = _userEmail,
                        Password   = _userPassword,
                        Telephone  = _userPhone,
                        Status     = 1,
                        UserTypeId = 1,
                        GeographicalAuthorityId = 1,
                        HomepageRefreshTime     = 60000
                    };


                    UserDB.GetInstance().AddNewUser(user);
                    Company company = new Company()
                    {
                        MainCompanyId      = _mainCompanyId,
                        CompanyTypeId      = _companyTypeId,
                        CompanyPartnerId   = _companyPartnerId,
                        PlatformId         = _platformId,
                        DistributorId      = _distributorId,
                        SectorId           = _sectorId,
                        CompanyReportId    = _companyReportId,
                        CompanyCode        = _companyCode,
                        CompanyDescription = _companyDescription,
                        Address1           = _address1,
                        Phone                     = _phone,
                        TechnicalReport           = _technicalReport,
                        TechnicalEmail1           = _technicalEmail1,
                        TechnicalEmail2           = _technicalEmail2,
                        TechnicalEmail3           = _technicalEmail3,
                        CompanyStatus             = _companyStatus,
                        AlarmSms                  = _alarmSms,
                        PasswordControl           = _passwordControl,
                        CompanyVehicleProgramming = _companyVehicleProgramming,
                        CompanyGroupName          = _companyGroupName,
                        CreationDate              = DateTime.Now,
                        Status                    = 1,
                        UserStatus                = _userStatus,
                        AccountingCode            = _accountingCode
                    };

                    var result = CompanyDB.GetInstance().AddNewCompany(company);

                    CompanyUser compUser = new CompanyUser()
                    {
                        IsCompanyAdmin = true,
                        UserId         = user.Id,
                        Status         = 1,
                        CompanyId      = company.Id
                    };


                    CompanyUserDB.GetInstance().AddNewCompanyUser(compUser);

                    return(Json(result != null));
                }
                else
                {
                    var user = UserDB.GetInstance().GetUserById(_userId);
                    user.Name      = _userName;
                    user.Surname   = _userSurname;
                    user.UserCode  = _userCode;
                    user.Mail      = _userEmail;
                    user.Telephone = _userPhone;
                    var isPasswordGoingToBeDifferent = 0;
                    if (user.Password.Trim().ToLower() == _userPassword.Trim().ToLower())
                    {
                        isPasswordGoingToBeDifferent = 0;
                    }
                    if (user.Password.Trim().ToLower() != _userPassword.Trim().ToLower())
                    {
                        user.Password = _userPassword;
                        isPasswordGoingToBeDifferent = 1;
                    }
                    UserDB.GetInstance().UpdateUser(user, isPasswordGoingToBeDifferent);
                    Company company = new Company()
                    {
                        Id                        = _id,
                        MainCompanyId             = _mainCompanyId,
                        CompanyTypeId             = _companyTypeId,
                        CompanyPartnerId          = _companyPartnerId,
                        PlatformId                = _platformId,
                        DistributorId             = _distributorId,
                        SectorId                  = _sectorId,
                        CompanyReportId           = _companyReportId,
                        CompanyCode               = _companyCode,
                        CompanyDescription        = _companyDescription,
                        Address1                  = _address1,
                        Phone                     = _phone,
                        TechnicalReport           = _technicalReport,
                        TechnicalEmail1           = _technicalEmail1,
                        TechnicalEmail2           = _technicalEmail2,
                        TechnicalEmail3           = _technicalEmail3,
                        CompanyStatus             = _companyStatus,
                        AlarmSms                  = _alarmSms,
                        PasswordControl           = _passwordControl,
                        CompanyVehicleProgramming = _companyVehicleProgramming,
                        CompanyGroupName          = _companyGroupName,
                        CreationDate              = DateTime.Now,
                        Status                    = 1,
                        UserStatus                = _userStatus,
                        AccountingCode            = _accountingCode
                    };

                    var result = CompanyDB.GetInstance().UpdateCompany(company);
                    return(Json(result != null));
                }
            }
            catch (Exception exc)
            {
                throw exc;
            }
        }
        public JsonResult UploadFile(IFormFile file)
        {
            if (file == null)
            {
                return(Json(false));
            }

            if (file.FileName.EndsWith(".xlsx") || file.FileName.EndsWith(".xls"))
            {
                var fileName = Path.Combine(_env.WebRootPath, "Content", "TempUploads", Guid.NewGuid().ToString().Replace("-", "") + Path.GetExtension(file.FileName));

                try
                {
                    using (var fileStream = new FileStream(fileName, FileMode.Create))
                    {
                        var task = file.CopyToAsync(fileStream);
                        task.Wait();
                    }

                    Workbook workbook = new Workbook();
                    workbook.LoadFromFile(fileName);
                    Worksheet sheet = workbook.Worksheets[0];
                    var       dt    = sheet.ExportDataTable();

                    foreach (DataRow dr in dt.Rows)
                    {
                        var companyCode        = dr["Şirket Kodu"].ToString();
                        var companyDescription = dr["Şirket"].ToString().Trim();
                        var mobileCount        = dr["Mobil Sayısı"].ToString().Trim();
                        var address1           = dr["Adres 1"].ToString().Trim();
                        var address2           = dr["Adres 2"].ToString().Trim();
                        var phone             = dr["Telefon"].ToString().Trim();
                        var fax               = dr["Fax"].ToString().Trim();
                        var personInCharge    = dr["Yetkili Kişi"].ToString().Trim();
                        var companyPartner    = dr["İş Ortağı"].ToString().Trim();
                        var distributorName   = dr["Bayi Adı"].ToString().Trim();
                        var platform          = dr["Platform"].ToString().Trim();
                        var sector            = dr["Sektör"].ToString().Trim();
                        var loginUrl          = dr["Login Url"].ToString().Trim();
                        var baseMap           = dr["BaseMap"].ToString().Trim();
                        var technicalReport   = dr["Teknik Rapor"].ToString().Trim();
                        var companyStatus     = dr["Kullanım Durumu"].ToString().Trim();
                        var taxAdministration = dr["Vergi Dairesi"].ToString().Trim();
                        var taxNumber         = dr["Vergi No"].ToString().Trim();
                        var entranceDate      = dr["Giriş Zamanı"].ToString().Trim();
                        var exitDate          = dr["Çıkış Zamanı"].ToString().Trim();
                        var alarmSms          = dr["Alarm Sms"].ToString().Trim();
                        var passwordControl   = dr["Şifre Kontrol"].ToString().Trim();
                        var infoSense         = dr["InfoSense"].ToString().Trim();
                        var accountingCode    = dr["Muhasebe Hes Kodu"].ToString().Trim();


                        //USER INFORMATİONSS NEEDED???????????


                        var company = new Company()
                        {
                            CompanyCode        = companyCode,
                            CompanyDescription = companyDescription,
                            MobileCount        = Convert.ToInt32(mobileCount),
                            Address1           = address1,
                            Address2           = address2,
                            Phone = phone,
                            Fax   = fax,
                            //PersonInCharge = personInCharge, //buradaki yetkili kişi userdaki yetkili kişi ??
                            CompanyPartnerId  = CompanyPartnerDB.GetInstance().GetCompanyPartnerByNameOrInsert(companyPartner).Id,
                            DistributorId     = DistributorDB.GetInstance().GetDistributorIdByName(distributorName),
                            PlatformId        = PlatformDB.GetInstance().GetPlatformByNameOrInsert(platform).Id,
                            SectorId          = SectorDB.GetInstance().GetSectorByNameOrInsert(sector).Id,
                            LoginUrl          = loginUrl,
                            BaseMap           = baseMap,
                            TechnicalReport   = technicalReport == "Aktif" ? true : false,
                            CompanyStatus     = companyStatus == "Aktif" ? true : false,
                            TaxAdministration = taxAdministration,
                            TaxNumber         = taxNumber,
                            EntranceDate      = GetExcelDateTime(entranceDate),
                            ExitDate          = GetExcelDateTime(exitDate),
                            AlarmSms          = alarmSms == "Aktif" ? true : false,
                            PasswordControl   = passwordControl == "Aktif" ? true : false,
                            InfoSense         = infoSense == "Aktif" ? true : false,
                            AccountingCode    = accountingCode
                        };

                        var result = CompanyDB.GetInstance().AddNewCompany(company);
                    }

                    if (System.IO.File.Exists(fileName))
                    {
                        System.IO.File.Delete(fileName);
                    }

                    return(Json(true));
                }
                catch (Exception exc)
                {
                    if (System.IO.File.Exists(fileName))
                    {
                        System.IO.File.Delete(fileName);
                    }

                    return(Json(exc.Message));
                }
            }

            else
            {
                return(Json(false));
            }
        }
        public JsonResult ImportFile(string _excelData)
        {
            _excelData = HttpUtility.HtmlDecode(_excelData);
            var list2 = JsonConvert.DeserializeObject <List <DeviceExcelObject> >(_excelData);

            try
            {
                foreach (var item in list2)
                {
                    Device device = new Device()
                    {
                        CompanyId                  = CompanyDB.GetInstance().GetCompanyByName(item.Sirket).Id,
                        CarPlateNumber             = item.Plaka,
                        CustomerPlateNumber        = item.MusteriPlakasi,
                        DeviceId                   = item.CihazId,
                        DeviceGsmNumber            = item.CihazGsmNo,
                        IMEINumber                 = item.IMEINo,
                        VehiclePhone               = item.AracTelefonu,
                        AveaPlaka                  = item.AveaPlaka,
                        TerminalProtocolId         = TerminalProtocolDB.GetInstance().GetTerminalProtocolByNameOrInsert(item.TerminalProtokol).Id,
                        GatewayId                  = GatewayDB.GetInstance().GetGatewayByNameOrInsert(item.Gateway).Id,
                        TerminalTypeId             = TerminalTypeDB.GetInstance().GetTerminalTypeByNameOrInsert(item.TerminalTipi).Id,
                        SoftwareVersionId          = SoftwareVersionDB.GetInstance().GetSoftwareVersionByNameOrInsert(item.YazilimVers, TerminalTypeDB.GetInstance().GetTerminalTypeByNameOrInsert(item.TerminalTipi).Id).Id,
                        OdometreStatusId           = OdometreStatusDB.GetInstance().GetOdometreStatusByNameOrInsert(item.OdometreDurumu).Id,
                        ProgrammedLocationSendTime = Convert.ToInt32(item.ProgramlananKonumSuresi.Trim()),
                        ProgrammedLocationDistance = Convert.ToInt32(item.ProgramlananKonumMesafe.Trim()),
                        ProgrammedSpeedLimit       = Convert.ToInt32(item.ProgramlananHizLimiti.Trim()),
                        ProgrammedHeartBeat        = Convert.ToInt32(item.ProgramlananHeartBeat.Trim()),
                        ProgrammedWaitingTime      = Convert.ToInt32(item.ProgramlananBekleme.Trim()),
                        ActivityTime               = Convert.ToInt32(item.AktiflikSuresi.Trim()),
                        Journey          = item.Sefer.Trim() == "Var" ? true : false,
                        MessagingId      = MessagingDB.GetInstance().GetMessagingByNameOrInsert(item.Mesajlasma).Id,
                        Telemetry        = item.Telemetri.Trim() == "Var" ? true : false,
                        HeatSensor       = item.IsiSensoru.Trim() == "Var" ? true : false,
                        DoorSensor       = item.KapiSensoru.Trim() == "Var" ? true : false,
                        ConstantMobile   = item.SabitMobil.Trim() == "Aktif" ? true : false,
                        ConstantLatitude = item.SabitLatitude,
                        //ConstantLongitude= ?????????????????????????????????????????????
                        WocheckerFlagId       = WocheckerFlagDB.GetInstance().GetWocheckerFlagByNameOrInsert(item.WocheckerFlag).Id,
                        MobileNote            = item.MobilNot,
                        TechnicalNote         = item.TeknikNot,
                        MontageDate           = GetExcelDateTime(item.MontajTarihi),
                        MontagePerson         = item.MontajiYapan,
                        DeviceMontageTypeId   = DeviceMontageTypeDB.GetInstance().GetDeviceMontageTypeByNameOrInsert(item.CihazMontajTuru).Id,
                        EngineBlock           = item.MotorBlokaji.Trim() == "Var" ? true : false,
                        EngineBlockStatus     = item.MotorBlokajDurumu.Trim() == "Aktif" ? true : false,
                        GSensor               = item.GSensor.Trim() == "Var" ? true : false,
                        DriverScoring         = item.SurucuSkorlama.Trim() == "Var" ? true : false,
                        RFIDEngineBlock       = item.RFIDMotorBlokaj.Trim() == "Var" ? true : false,
                        RFIDEngineBlockStatus = item.RFIDMotorBlokajDurumu.Trim() == "Aktif" ? true : false,
                        CreationDate          = DateTime.Now,
                        Status = 1
                    };
                    if (device != null)
                    {
                        DeviceDB.GetInstance().AddNewDevice(device);
                    }
                }
                return(Json(true));
            }
            catch (Exception exc)
            {
                throw exc;
            }
        }
        public JsonResult UploadFile(IFormFile file)
        {
            if (file == null)
            {
                return(Json(false));
            }

            if (file.FileName.EndsWith(".xlsx") || file.FileName.EndsWith(".xls"))
            {
                var fileName = Path.Combine(_env.WebRootPath, "Content", "TempUploads", Guid.NewGuid().ToString().Replace("-", "") + Path.GetExtension(file.FileName));

                try
                {
                    using (var fileStream = new FileStream(fileName, FileMode.Create))
                    {
                        var task = file.CopyToAsync(fileStream);
                        task.Wait();
                    }

                    Workbook workbook = new Workbook();
                    workbook.LoadFromFile(fileName);
                    Worksheet sheet = workbook.Worksheets[0];
                    var       dt    = sheet.ExportDataTable();

                    foreach (DataRow dr in dt.Rows)
                    {
                        var company             = dr["Şirket"].ToString().Trim();
                        var carPlateNumber      = dr["Plaka"].ToString().Trim();
                        var customerPlateNumber = dr["Müşteri Plakası"].ToString().Trim();
                        var deviceId            = dr["Cihaz ID (Comm_id)"].ToString().Trim();
                        var deviceGsmNumber     = dr["Cihaz Gsm No"].ToString().Trim();
                        var imei                       = dr["IMEI No"].ToString().Trim();
                        var carPhoneNumber             = dr["Araç Telefonu"].ToString().Trim();
                        var aveaPlaka                  = dr["Avea Plaka"].ToString().Trim();
                        var terminalProtocol           = dr["Terminal Protokol"].ToString().Trim();
                        var gateway                    = dr["Gateway"].ToString().Trim();
                        var terminalType               = dr["Terminal Tipi"].ToString().Trim();
                        var odometreStatus             = dr["Odometre Durumu"].ToString().Trim();
                        var softwareVersion            = dr["Yazılım Ver."].ToString().Trim();
                        var programmedLocationSendTime = dr["Programlanan Konum Süresi(dk)"].ToString().Trim();
                        var programmedLocationDistance = dr["Programlanan Konum Mesafe(mt)"].ToString().Trim();
                        var programmedSpeedLimit       = dr["Programlanan Hız Limiti(km)"].ToString().Trim();
                        var ProgrammedWaitingTime      = dr["Programlanan Bekleme(dk)"].ToString().Trim();
                        var ProgrammedHeartBeat        = dr["Programlanan HeartBeat(sn)"].ToString().Trim();
                        var activityTime               = dr["Aktiflik Süresi(dk)"].ToString().Trim();
                        var journey                    = dr["Sefer"].ToString().Trim();
                        var messaging                  = dr["Mesajlaşma"].ToString().Trim();
                        var telemetry                  = dr["Telemetri"].ToString().Trim();
                        var heatSensor                 = dr["Isı Sensörü"].ToString().Trim();
                        var doorSensor                 = dr["Kapı Sensörü"].ToString().Trim();
                        var constantMobile             = dr["Sabit Mobil"].ToString().Trim();
                        var lastActivityTime           = dr["Son Aktiflik Zamanı"].ToString().Trim();
                        var constantLatitude           = dr["Sabit Lat. (DD.DDDDDD)"].ToString().Trim();
                        var wocheckerFlag              = dr["WocheckerFlag"].ToString().Trim();
                        var mobileNote                 = dr["Mobil Not"].ToString().Trim();
                        var techinalNote               = dr["Teknik Not"].ToString().Trim();
                        var montageDate                = dr["Montaj Tarihi"].ToString().Trim();
                        var montagePerson              = dr["Montajı Yapan"].ToString().Trim();
                        var deviceMontageType          = dr["Cihaz Montaj Türü"].ToString().Trim();
                        var engineBlock                = dr["Motor Blokajı"].ToString().Trim();
                        var engineBlockStatus          = dr["Motor Blokaj Durumu"].ToString().Trim();
                        var vehicleBlock               = dr["Araç Blokajı"].ToString().Trim();
                        var refTelemetryType           = dr["Ref. Telemetri Reçetesi"].ToString().Trim();
                        var gSensor                    = dr["G Sensör"].ToString().Trim();
                        var driverScoring              = dr["Sürücü Skorlama"].ToString().Trim();
                        var rfidEngineBlock            = dr["RFID Motor Blokaj"].ToString().Trim();
                        var rfidEngineBlockStatus      = dr["RFID Motor Blokaj Durumu"].ToString().Trim();

                        var device = new Device()
                        {
                            CompanyId                  = CompanyDB.GetInstance().GetCompanyByName(company).Id,
                            CarPlateNumber             = carPlateNumber,
                            CustomerPlateNumber        = customerPlateNumber,
                            DeviceId                   = deviceId,
                            DeviceGsmNumber            = deviceGsmNumber,
                            IMEINumber                 = imei,
                            CarPhoneNumber             = carPhoneNumber,
                            AveaPlaka                  = aveaPlaka,
                            TerminalProtocolId         = TerminalProtocolDB.GetInstance().GetTerminalProtocolByNameOrInsert(terminalProtocol).Id,
                            GatewayId                  = GatewayDB.GetInstance().GetGatewayByNameOrInsert(gateway).Id,
                            TerminalTypeId             = TerminalTypeDB.GetInstance().GetTerminalTypeByNameOrInsert(terminalType).Id,
                            SoftwareVersionId          = SoftwareVersionDB.GetInstance().GetSoftwareVersionByNameOrInsert(softwareVersion, TerminalTypeDB.GetInstance().GetTerminalTypeByNameOrInsert(terminalType).Id).Id,
                            OdometreStatusId           = OdometreStatusDB.GetInstance().GetOdometreStatusByNameOrInsert(odometreStatus).Id,
                            ProgrammedLocationSendTime = Convert.ToInt32(programmedLocationSendTime),
                            ProgrammedLocationDistance = Convert.ToInt32(programmedLocationDistance),
                            ProgrammedSpeedLimit       = Convert.ToInt32(programmedSpeedLimit),
                            ProgrammedWaitingTime      = Convert.ToInt32(ProgrammedWaitingTime),
                            ProgrammedHeartBeat        = Convert.ToInt32(ProgrammedHeartBeat),
                            ActivityTime               = Convert.ToInt32(activityTime),
                            Journey               = journey == "Var" ? true : false,
                            MessagingId           = MessagingDB.GetInstance().GetMessagingByNameOrInsert(messaging).Id,
                            Telemetry             = telemetry == "Var" ? true : false,
                            HeatSensor            = heatSensor == "Var" ? true : false,
                            DoorSensor            = doorSensor == "Var" ? true : false,
                            ConstantMobile        = constantMobile == "Aktif" ? true : false,
                            LastActivityTime      = GetExcelDateTime(lastActivityTime),
                            ConstantLatitude      = constantLatitude,
                            WocheckerFlagId       = WocheckerFlagDB.GetInstance().GetWocheckerFlagByNameOrInsert(wocheckerFlag).Id,
                            MobileNote            = mobileNote,
                            TechnicalNote         = techinalNote,
                            MontageDate           = GetExcelDateTime(montageDate),
                            MontagePerson         = montagePerson,
                            DeviceMontageTypeId   = DeviceMontageTypeDB.GetInstance().GetDeviceMontageTypeByNameOrInsert(deviceMontageType).Id,
                            EngineBlock           = engineBlock == "Var" ? true : false,
                            EngineBlockStatus     = engineBlockStatus == "Aktif" ? true : false,
                            VehicleBlock          = vehicleBlock == "Var" ? true : false,
                            RefTelemetryRecipeId  = RefTelemetryTypeDB.GetInstance().GetRefTelemetryTypeByNameOrInsert(refTelemetryType).Id,
                            GSensor               = gSensor == "Var" ? true : false,
                            DriverScoring         = driverScoring == "Var" ? true : false,
                            RFIDEngineBlock       = rfidEngineBlock == "Var" ? true : false,
                            RFIDEngineBlockStatus = rfidEngineBlockStatus == "Var" ? true : false,
                            CreationDate          = DateTime.Now,
                            Status = 1,
                        };

                        var result = DeviceDB.GetInstance().AddNewDevice(device);
                    }

                    if (System.IO.File.Exists(fileName))
                    {
                        System.IO.File.Delete(fileName);
                    }

                    return(Json(true));
                }
                catch (Exception exc)
                {
                    if (System.IO.File.Exists(fileName))
                    {
                        System.IO.File.Delete(fileName);
                    }

                    return(Json(exc.Message));
                }
            }
            else
            {
                return(Json(false));
            }
        }