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