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