public IActionResult Index() { var model = new DistributorViewModel() { Distributors = DistributorDB.GetInstance().GetAllDistributors(userObj), //Companies = CompanyDB.GetInstance().GetCompanyList(userObj), CompanyPartners = CompanyPartnerDB.GetInstance().GetAllCompanyPartners() }; return(View(model)); }
public JsonResult GetDistributorByIdForDisplaying(int _id) { try { var distributor = DistributorDB.GetInstance().GetDistributorByIdForDisplaying(_id); return(Json(distributor)); } catch (Exception) { throw; } }
public JsonResult DeleteDistributor(int _id) { try { DistributorDB.GetInstance().DeleteDistributor(_id); return(Json(true)); } catch (Exception) { throw; } return(Json(false)); }
public IActionResult GetDistributorList(string _bayiAdi) { try { _bayiAdi = _bayiAdi == null ? "" : _bayiAdi; var distributorList = DistributorDB.GetInstance().GetAllDistributors(userObj, _bayiAdi); return(PartialView("_DistributorList", distributorList)); } catch (Exception) { throw; } }
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 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 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 SaveDistributor(int _id, string _name, int _companyPartnerId, string _entranceDate, string _exitDate, int _activity, string _phone1, string _phone2, string _fax, string _city, string _personInCharge, string _code, string _address, string _userCode, string _userPassword, string _userName, string _userSurname, string _userEmail, string _userPhone, int _userId) { try { if (_id == 0) { var user = new User() { Name = _userName, Surname = _userSurname, UserCode = _userCode, Telephone = _userPhone, Mail = _userEmail, Password = _userPassword, UserTypeId = 2, Status = 1 }; UserDB.GetInstance().AddNewUser(user); Distributor distributor = new Distributor() { Name = _name, UserId = user.Id, CompanyPartnerId = _companyPartnerId, EntranceDate = String.IsNullOrEmpty(_entranceDate) ? null : (DateTime?)DateTime.ParseExact(_entranceDate, "yyyy-MM-dd", CultureInfo.InvariantCulture), ExitDate = String.IsNullOrEmpty(_exitDate) ? null : (DateTime?)DateTime.ParseExact(_entranceDate, "yyyy-MM-dd", CultureInfo.InvariantCulture), Activity = _activity == 1, Phone1 = _phone1, Phone2 = _phone2, Fax = _fax, City = _city, PersonInCharge = _personInCharge, Code = _code, Address = _address, CreationDate = DateTime.Now, Status = 1 }; var result = DistributorDB.GetInstance().AddNewDistributor(distributor); 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); Distributor distributor = new Distributor() { Id = _id, Name = _name, CompanyPartnerId = _companyPartnerId, EntranceDate = String.IsNullOrEmpty(_entranceDate) ? null : (DateTime?)DateTime.ParseExact(_entranceDate, "yyyy-MM-dd", CultureInfo.InvariantCulture), ExitDate = String.IsNullOrEmpty(_exitDate) ? null : (DateTime?)DateTime.ParseExact(_exitDate, "yyyy-MM-dd", CultureInfo.InvariantCulture), Activity = _activity == 1, Phone1 = _phone1, Phone2 = _phone2, Fax = _fax, City = _city, PersonInCharge = _personInCharge, Code = _code, Address = _address, CreationDate = DateTime.Now, Status = 1, UserId = user.Id }; var result = DistributorDB.GetInstance().UpdateDistributor(distributor); return(Json(result != null)); } } catch (Exception) { throw; } }