public UnitOfWork(IDbConnection connection) { _connection = connection; AccountDao = new AccountDao(connection); BusCoordinateDao = new BusCoordinateDao(connection); BusDao = new BusDao(connection); BusDriverDao = new BusDriverDao(connection); CityDao = new CityDao(connection); CountryDao = new CountryDao(connection); DistanceDao = new DistanceDao(connection); DistrictDao = new DistrictDao(connection); DriverDao = new DriverDao(connection); DriverContactDao = new DriverContactDao(connection); LocationDao = new LocationDao(connection); LookupsDao = new LookupsDao(connection); LookupValuesDao = new LookupValuesDao(connection); RepairSpecialistDao = new RepairSpecialistDao(connection); RoleDao = new RoleDao(connection); RouteDao = new RouteDao(connection); RouteLocationDao = new RouteLocationDao(connection); TripDao = new TripDao(connection); TripBusDao = new TripBusDao(connection); TripBusDriverDao = new TripBusDriverDao(connection); UserDao = new UserDao(connection); VehicleDao = new VehicleDao(connection); ScheduleDao = new ScheduleDao(connection); ScheduleLocationDao = new ScheduleLocationDao(connection); StoredProcedureDao = new StoredProcedureDao(connection); }
public JsonResult ChangeDistrict(string cityid) { var dao = new DistrictDao(); var list = dao.FindByID(cityid); JsonResult result = new JsonResult(); result.Data = list; result.JsonRequestBehavior = JsonRequestBehavior.AllowGet; return(result); }
public void SetViewBagDistrict(string selectedId = null, string cityid = null) { var dao = new DistrictDao(); if (cityid != null) { ViewBag.DistrictID = new SelectList(dao.FindByID(cityid), "DistrictCode", "Name", selectedId); } else { ViewBag.DistrictID = new SelectList(dao.ToList(), "DistrictCode", "Name", selectedId); } }
// GET: Supplier/Details/5 public ActionResult Details(long id) { SupplierDao bdDao = new SupplierDao(); var sl = bdDao.FindByID(id); if (sl.Status == true) { ViewBag.Status = "Kích hoạt"; } else { ViewBag.Status = "Khóa"; } var dao = new CityDao(); var ct = dao.FindByID(sl.CityID); ViewBag.CityName = ct[0].Name; var disDao = new DistrictDao(); var dist = disDao.FindByID(sl.CityID, sl.DistrictID); ViewBag.DistName = dist.Name; return(View(sl)); }
/// <summary> /// Lấy danh sách quận nạp vào Select2 /// </summary> /// <returns></returns> public JsonResult DistrictDropdown(int proid, string term, string q, string _type = "query") { var symptoms = new DistrictDao().Search(proid, term).Select(x => new { id = x.Id, text = x.Type + " " + x.Name, disabled = x.IsDeleted == true ? true : false }); return(Json(new { results = symptoms }, JsonRequestBehavior.AllowGet)); }
public DistrictBusiness(MardisContext mardisContext) { _districtDao = new DistrictDao(mardisContext); }
public void InitProcess() { var numberLine = 0; var fileContent = new StreamReader(new MemoryStream(BufferFile)); using (var mardisContext = MardisContext) { _bulkLoadBusiness = new BulkLoadBusiness(mardisContext, null); _branchDao = new BranchDao(mardisContext); _provinceDao = new ProvinceDao(mardisContext); _districtDao = new DistrictDao(mardisContext); _parishDao = new ParishDao(mardisContext); _personaDao = new PersonDao(mardisContext); _sectorDao = new SectorDao(mardisContext); _bulkLoadStatusDao = new BulkLoadStatusDao(mardisContext); var oneProcess = _bulkLoadBusiness.GetOne(IdProcess); var separatorChar = Convert.ToChar(oneProcess.BulkLoadCatalog.Separator); string line; while ((line = fileContent.ReadLine()) != null) { if (0 == numberLine) { //primera fila es cabecera numberLine++; continue; } //comienza transacción oneProcess.BulkLoadStatus = _bulkLoadStatusDao.GetOneByCode(CBulkLoad.StateBulk.EnProceso); oneProcess.IdBulkLoadStatus = oneProcess.BulkLoadStatus.Id; mardisContext.SaveChanges(); var addCurrent = 0; var updateCurrent = 0; var deleteCurrent = 0; var lineResult = line; var errorLine = string.Empty; using (var transaction = mardisContext.Database.BeginTransaction()) { try { var valuesLine = line.Split(separatorChar); var branchViewModel = ConvertViewModel(line, separatorChar); var branchTemp = _branchDao.GetBranchByExternalCode(branchViewModel.ExternalCode, IdAccount); var updateFields = false; if (null == branchTemp) { //significa que es nuevo updateFields = true; branchTemp = new Branch { Code = branchViewModel.ExternalCode, ExternalCode = branchViewModel.ExternalCode, IdAccount = IdAccount }; addCurrent++; } else { if (CBulkLoad.CharacteristicBulk.ConsevarYAdicionar.Equals(CharacteristicBulk)) { lineResult += separatorChar + "Local conservado por configuración"; _lstItemsSuccess.Add(lineResult); } else if (CBulkLoad.CharacteristicBulk.ActualizarYAdicionar.Equals(CharacteristicBulk)) { updateFields = true; } updateCurrent++; } if (updateFields) { branchTemp.Name = branchViewModel.Name; branchTemp.Label = branchViewModel.Label; var oneCountry = new Country();// _countryDao.GetCountryByCode(branchViewModel.Contry); var oneProvince = _provinceDao.GetProvinceByCode(branchViewModel.Province); var oneDistrinct = _districtDao.GetDistrinctByCode(branchViewModel.District); var oneParish = _parishDao.GetParishByCode(branchViewModel.Parish); var onePersonOwner = _personaDao.GetPersonByCode(branchViewModel.PersonOwnerCode); var oneSector = _sectorDao.GetByCode(branchViewModel.Sector); if (null != oneCountry) { branchTemp.Country = oneCountry; branchTemp.IdCountry = oneCountry.Id; } else { errorLine += "Ciudad:" + branchViewModel.Contry + " no existe,"; } if (null != oneProvince) { branchTemp.Province = oneProvince; branchTemp.IdProvince = oneProvince.Id; } else { errorLine += "Provincia:" + branchViewModel.Province + " no existe,"; } if (null != oneDistrinct) { branchTemp.District = oneDistrinct; branchTemp.IdDistrict = oneDistrinct.Id; } else { errorLine += "Distrito:" + branchViewModel.District + " no existe,"; } if (null != oneSector) { branchTemp.Sector = oneSector; branchTemp.IdSector = oneSector.Id; } else { errorLine += "Sector:" + branchViewModel.Sector + " no existe,"; } if (null != oneParish) { branchTemp.Parish = oneParish; branchTemp.IdParish = oneParish.Id; } else { errorLine += "Parroquia:" + branchViewModel.Parish + " no existe,"; } branchTemp.Zone = branchViewModel.Zone; branchTemp.Neighborhood = branchViewModel.Neighborhood; branchTemp.MainStreet = branchViewModel.MainStreet; branchTemp.SecundaryStreet = branchViewModel.SecundaryStreet; branchTemp.NumberBranch = branchViewModel.NumberBranch; branchTemp.LatitudeBranch = branchViewModel.Latitude; branchTemp.LenghtBranch = branchViewModel.Lenght; branchTemp.Reference = branchViewModel.Reference; if (null == onePersonOwner) { onePersonOwner = new Person { IdAccount = IdAccount }; } onePersonOwner.Code = branchViewModel.PersonOwnerCode; onePersonOwner.Name = branchViewModel.PersonOwnerName; onePersonOwner.SurName = branchViewModel.PersonOwnerSurname; onePersonOwner.TypeDocument = branchViewModel.PersonOwnerType; onePersonOwner.Document = branchViewModel.PersonOwnerDocument; onePersonOwner.Phone = branchViewModel.PersonOwnerPhone; onePersonOwner.Mobile = branchViewModel.PersonOwnerMobile; if (onePersonOwner.Id == Guid.Empty) { mardisContext.Persons.Add(onePersonOwner); } mardisContext.SaveChanges(); branchTemp.PersonOwner = onePersonOwner; branchTemp.IdPersonOwner = onePersonOwner.Id; branchTemp.IsAdministratorOwner = branchViewModel.IsPersonAdministrator.ToUpper(); if (CBranch.Yes.Equals(branchViewModel.IsPersonAdministrator.ToUpper())) { branchTemp.IdPersonAdministrator = null; branchTemp.PersonAdministration = null; } else if (CBranch.No.Equals(branchViewModel.IsPersonAdministrator.ToUpper())) { var onePersonAdmin = _personaDao.GetPersonByCode(branchViewModel.PersonAdminCode); if (null == onePersonAdmin) { onePersonAdmin = new Person(); mardisContext.Persons.Add(onePersonAdmin); } onePersonAdmin.Code = branchViewModel.PersonAdminCode; onePersonAdmin.Name = branchViewModel.PersonAdminName; onePersonAdmin.SurName = branchViewModel.PersonAdminSurname; onePersonAdmin.TypeDocument = branchViewModel.PersonAdminType; onePersonAdmin.Document = branchViewModel.PersonAdminDocument; onePersonAdmin.Phone = branchViewModel.PersonAdminPhone; onePersonAdmin.Mobile = branchViewModel.PersonAdminMobile; onePersonAdmin.IdAccount = IdAccount; if (onePersonAdmin.Id == Guid.Empty) { mardisContext.Persons.Add(onePersonAdmin); } mardisContext.SaveChanges(); branchTemp.IdPersonAdministrator = onePersonAdmin.Id; branchTemp.PersonAdministration = onePersonAdmin; } else { errorLine += "No se entiende si es o no Adminitrador use SI o NO,"; } } if (!string.IsNullOrEmpty(errorLine)) { throw new Exception(errorLine); } if (branchTemp.Id == Guid.Empty) { mardisContext.Branches.Add(branchTemp); } mardisContext.SaveChanges(); transaction.Commit(); _lstItemsSuccess.Add(lineResult); } catch (Exception ex) { addCurrent = 0; updateCurrent = 0; deleteCurrent = 1; transaction.Rollback(); lineResult += separatorChar + "Error linea " + numberLine + " , mensaje: " + ex.Message; _lstItemsError.Add(lineResult); } numberLine++; } oneProcess.CurrentFile = numberLine; oneProcess.TotalAdded += addCurrent; oneProcess.TotalUpdated += updateCurrent; oneProcess.TotalFailed += deleteCurrent; mardisContext.SaveChanges(); } oneProcess.BulkLoadStatus = _bulkLoadStatusDao.GetOneByCode(CBulkLoad.StateBulk.Aceptado); oneProcess.IdBulkLoadStatus = oneProcess.BulkLoadStatus.Id; mardisContext.SaveChanges(); } }
public JsonResult GetDistrictByProvinceId(string id) { List <district> data = new DistrictDao().GetListByProvinceId(id); return(Json(data, JsonRequestBehavior.AllowGet)); }