public void setDb(Context.MasterPool dbitem) { dbitem.Id = Id; dbitem.IsActive = IsActive; dbitem.NamePool = NamePool; dbitem.Capacity = Capacity; dbitem.Address = Address; dbitem.IdProvinsi = IdProvinsi; dbitem.IdKabKota = IdKabKota; dbitem.IdKec = IdKec; dbitem.IdKel = IdKel; dbitem.Latitude = Latitude; dbitem.Longitude = Longitude; dbitem.Radius = Radius; dbitem.KodeTelp = KodeTelp; dbitem.Telp = Telp != null?Telp.Replace('-', ' ').Replace('_', ' ') : Telp; dbitem.Pic = Pic; dbitem.Handphone = Handphone != null?Handphone.Replace('-', ' ').Replace('_', ' ') : Handphone; dbitem.IpAddress = IpAddress; dbitem.IdCreditCash = IdCreditCash; dbitem.ListZoneParkir.Clear(); ZoneParkir[] result = JsonConvert.DeserializeObject <ZoneParkir[]>(strPool); foreach (ZoneParkir item in result) { dbitem.ListZoneParkir.Add(new Context.ZoneParkir() { IdZone = item.IdZone, Pit = item.Pit }); } }
public void saveDynamic(int id, int ac_id, string type) { if (type == "SPBU") { Context.ERPDynamicConfig model = new Context.ERPDynamicConfig(); model.ac_id = ac_id; model.lookup_code_id = id; context.ERPDynamicConfig.Add(model); context.SaveChanges(); Context.LookupCode lc = context.LookupCode.Where(d => d.Id == id).FirstOrDefault(); lc.ac_id = ac_id; context.LookupCode.Attach(lc); var entry = context.Entry(lc); entry.State = EntityState.Modified; context.SaveChanges(); } else if (type == "Pool") { Context.ERPDynamicConfig model = new Context.ERPDynamicConfig(); model.ac_id = ac_id; model.pool_id = id; context.ERPDynamicConfig.Add(model); context.SaveChanges(); Context.MasterPool lc = context.MasterPool.Where(d => d.Id == id).FirstOrDefault(); lc.IdCreditCash = ac_id; context.MasterPool.Attach(lc); var entry = context.Entry(lc); entry.State = EntityState.Modified; context.SaveChanges(); } }
public MasterPool(Context.MasterPool dbitem) { Id = dbitem.Id; IsActive = dbitem.IsActive; NamePool = dbitem.NamePool; Capacity = dbitem.Capacity; Address = dbitem.Address; IdProvinsi = dbitem.IdProvinsi; IdKabKota = dbitem.IdKabKota; IdKec = dbitem.IdKec; IdKel = dbitem.IdKel; NameProv = dbitem.IdProvinsi != null ? dbitem.LocProvinsi.Nama : ""; NameKec = dbitem.IdKec != null ? dbitem.LocKecamatan.Nama : ""; NameKabKot = dbitem.IdKabKota != null ? dbitem.LocKabKota.Nama : ""; NameKel = dbitem.IdKel != null ? dbitem.LocKelurahan.Nama : ""; Latitude = dbitem.Latitude; Longitude = dbitem.Longitude; Radius = dbitem.Radius; KodeTelp = dbitem.KodeTelp; Telp = dbitem.Telp; Pic = dbitem.Pic; Handphone = dbitem.Handphone; IpAddress = dbitem.IpAddress; ListZoneParkir = new List <ZoneParkir>(); IdCreditCash = dbitem.IdCreditCash; foreach (Context.ZoneParkir item in dbitem.ListZoneParkir.ToList()) { ListZoneParkir.Add(new ZoneParkir(item)); } }
public JsonResult Delete(int id) { ResponeModel response = new ResponeModel(true); Context.MasterPool dbItem = RepoPool.FindByPK(id); RepoPool.delete(dbItem); return(Json(response)); }
public ActionResult Edit(int id) { Context.MasterPool dbitem = RepoPool.FindByPK(id); MasterPool model = new MasterPool(dbitem); ViewBag.name = model.NamePool; if (dbitem.IdCreditCash.HasValue) { ac_mstr bk_credit_cash = Repoac_mstr.FindByPk(dbitem.IdCreditCash); model.IdCreditCash = bk_credit_cash.id; model.CodeCreditCash = bk_credit_cash.ac_code; model.NamaCreditCash = bk_credit_cash.ac_name; } return(View("Form", model)); }
public ActionResult Add(MasterPool model) { if (ModelState.IsValid) { if (RepoPool.IsExist(model.NamePool)) { ModelState.AddModelError("NamePool", "Nama sudah dipakai."); return(View("Form", model)); } Context.MasterPool dbitem = new Context.MasterPool(); model.setDb(dbitem); RepoPool.save(dbitem, UserPrincipal.id); return(RedirectToAction("Index")); } ZoneParkir[] result = JsonConvert.DeserializeObject <ZoneParkir[]>(model.strPool); model.ListZoneParkir = result.ToList(); return(View("Form", model)); }
public string Upload(IEnumerable <HttpPostedFileBase> files) { ResponeModel response = new ResponeModel(); //algoritma if (files != null) { foreach (var file in files) { try { using (var package = new ExcelPackage(file.InputStream)) { var currentSheet = package.Workbook.Worksheets; var workSheet = currentSheet.First(); var noOfRow = workSheet.Dimension.End.Row; //sheet 1 for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++) { if (workSheet.Cells[rowIterator, 1].Value != null && workSheet.Cells[rowIterator, 2].Value != null && workSheet.Cells[rowIterator, 3].Value != null && workSheet.Cells[rowIterator, 4].Value != null && workSheet.Cells[rowIterator, 5].Value != null && workSheet.Cells[rowIterator, 6].Value != null && workSheet.Cells[rowIterator, 7].Value != null && workSheet.Cells[rowIterator, 8].Value != null && workSheet.Cells[rowIterator, 9].Value != null && workSheet.Cells[rowIterator, 10].Value != null && workSheet.Cells[rowIterator, 11].Value != null && workSheet.Cells[rowIterator, 12].Value != null && workSheet.Cells[rowIterator, 13].Value != null && workSheet.Cells[rowIterator, 14].Value != null && workSheet.Cells[rowIterator, 15].Value != null) { int id = 0; int resId; if (workSheet.Cells[rowIterator, 17].Value != null) { if (int.TryParse(workSheet.Cells[rowIterator, 17].Value.ToString(), out resId)) { id = resId; } } //cara gancang ngarah teu kudu aya pengecekan tiap field Context.MasterPool dbitem = new Context.MasterPool(); try { if (id != 0) { dbitem = RepoPool.FindByPK(id); if (RepoPool.IsExist(workSheet.Cells[rowIterator, 2].Value.ToString(), id)) { continue; } } if (RepoPool.IsExist(workSheet.Cells[rowIterator, 2].Value.ToString(), 2)) { continue; } dbitem.IsActive = bool.Parse(workSheet.Cells[rowIterator, 1].Value.ToString()); dbitem.NamePool = workSheet.Cells[rowIterator, 2].Value.ToString(); dbitem.Capacity = int.Parse(workSheet.Cells[rowIterator, 3].Value.ToString()); dbitem.Address = workSheet.Cells[rowIterator, 4].Value.ToString(); dbitem.IdProvinsi = RepoLoc.FindByNama(workSheet.Cells[rowIterator, 5].Value.ToString()).Id; dbitem.IdKabKota = RepoLoc.FindByNama(workSheet.Cells[rowIterator, 6].Value.ToString()).Id; dbitem.IdKec = RepoLoc.FindByNama(workSheet.Cells[rowIterator, 7].Value.ToString()).Id; dbitem.IdKel = RepoLoc.FindByNama(workSheet.Cells[rowIterator, 8].Value.ToString()).Id; dbitem.Longitude = workSheet.Cells[rowIterator, 9].Value.ToString(); dbitem.Latitude = workSheet.Cells[rowIterator, 10].Value.ToString(); dbitem.Radius = int.Parse(workSheet.Cells[rowIterator, 11].Value.ToString()); dbitem.KodeTelp = workSheet.Cells[rowIterator, 12].Value.ToString(); dbitem.Telp = workSheet.Cells[rowIterator, 13].Value.ToString(); dbitem.Pic = workSheet.Cells[rowIterator, 14].Value.ToString(); dbitem.Handphone = workSheet.Cells[rowIterator, 15].Value.ToString(); dbitem.ListZoneParkir.Clear(); int idx = 0; for (idx = rowIterator; idx <= noOfRow; idx++) { if (workSheet.Cells[idx, 1].Value == null || idx == rowIterator) { if (workSheet.Cells[idx, 16].Value != null && workSheet.Cells[idx, 17].Value != null) { try { Context.ZoneParkir dbparkir = new Context.ZoneParkir(); dbparkir.IdZone = RepoLookup.FindByName(workSheet.Cells[idx, 16].Value.ToString()).Id; dbparkir.Pit = int.Parse(workSheet.Cells[idx, 17].Value.ToString()); dbitem.ListZoneParkir.Add(dbparkir); } catch (Exception) { } } } else { break; } } rowIterator = idx - 1; RepoPool.save(dbitem, UserPrincipal.id); } catch (Exception) { } } } } response.Success = true; } catch (Exception e) { response.Success = false; response.Message = e.Message.ToString(); } } } return(new JavaScriptSerializer().Serialize(new { Response = response })); }