public void setDb(Context.RuteTol dbitem)
{
dbitem.Id = Id;
dbitem.IdRute = IdRute;
dbitem.NamaRuteTol = NamaRuteTol;
dbitem.ListTolBerangkat.Clear();
dbitem.ListTolPulang.Clear();
TolPP[] resultBerangkat = JsonConvert.DeserializeObject <TolPP[]>(strBerangkat);
TolPP[] resultPulang = JsonConvert.DeserializeObject <TolPP[]>(strPulang);
foreach (TolPP item in resultBerangkat)
{
dbitem.ListTolBerangkat.Add(new Context.TolBerangkat()
{
IdTol = item.IdTol,
IdRuteTol = item.IdRuteTol
});
}
foreach (TolPP item in resultPulang)
{
dbitem.ListTolPulang.Add(new Context.TolPulang()
{
IdTol = item.IdTol,
IdRuteTol = item.IdRuteTol
});
}
}
public RuteTol(Context.RuteTol dbitem)
{
Id = dbitem.Id;
IdRute = dbitem.IdRute;
KodeRute = dbitem.Rute.Kode;
NamaRute = dbitem.Rute.Nama;
NamaRuteTol = dbitem.NamaRuteTol;
ListTolBerangkat = new List <TolPP>();
ListTolPulang = new List <TolPP>();
TolB = new List <string>();
TolP = new List <string>();
foreach (Context.TolBerangkat item in dbitem.ListTolBerangkat.ToList())
{
ListTolBerangkat.Add(new TolPP(item));
TolB.Add(item.JnsTol.NamaTol);
}
strBerangkat = string.Join("-", TolB);
foreach (Context.TolPulang item in dbitem.ListTolPulang.ToList())
{
ListTolPulang.Add(new TolPP(item));
TolP.Add(item.JnsTol.NamaTol);
}
strPulang = string.Join("-", TolP);
}
public ActionResult Edit(int id)
{
Context.RuteTol dbitem = RepoRuteTol.FindByPK(id);
RuteTol model = new RuteTol(dbitem);
ViewBag.name = model.NamaRute;
return(View("Form", model));
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
Context.RuteTol dbItem = RepoRuteTol.FindByPK(id);
RepoRuteTol.delete(dbItem);
return(Json(response));
}
public ActionResult Edit(RuteTol model)
{
if (ModelState.IsValid)
{
Context.RuteTol dbitem = RepoRuteTol.FindByPK(model.Id);
model.setDb(dbitem);
RepoRuteTol.save(dbitem, UserPrincipal.id);
return(RedirectToAction("Index"));
}
TolPP[] resultBerangkat = JsonConvert.DeserializeObject <TolPP[]>(model.strBerangkat);
TolPP[] resultPulang = JsonConvert.DeserializeObject <TolPP[]>(model.strPulang);
model.ListTolBerangkat = resultBerangkat.ToList();
model.ListTolPulang = resultPulang.ToList();
return(View("Form", model));
}
public string UploadRuteTol(IEnumerable <HttpPostedFileBase> filesRuteTol)
{
ResponeModel response = new ResponeModel();
if (filesRuteTol != null)
{
foreach (var file in filesRuteTol)
{
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)
{
int id = 0;
Context.RuteTol dbitem = new Context.RuteTol();
if (workSheet.Cells[rowIterator, 5].Value != null)
{
int resId;
if (int.TryParse(workSheet.Cells[rowIterator, 5].Value.ToString(), out resId))
{
id = resId;
}
}
if (id != 0)
{
dbitem = RepoRuteTol.FindByPK(id);
dbitem.ListTolBerangkat.Clear();
dbitem.ListTolPulang.Clear();
}
try
{
//parent
dbitem.IdRute = RepoRute.FindByKode(workSheet.Cells[rowIterator, 1].Value.ToString()).Id;
dbitem.NamaRuteTol = workSheet.Cells[rowIterator, 2].Value.ToString();
//child 1
int idx = 0;
for (idx = rowIterator; idx <= noOfRow; idx++)
{
if (workSheet.Cells[idx, 1].Value == null || idx == rowIterator)
{
if (workSheet.Cells[idx, 3].Value != null)
{
Context.TolBerangkat item = new Context.TolBerangkat();
item.IdTol = RepoJnsTol.FindByNamaTol(workSheet.Cells[idx, 3].Value.ToString()).Id;
dbitem.ListTolBerangkat.Add(item);
}
}
else
{
break;
}
}
//child 1
idx = 0;
for (idx = rowIterator; idx <= noOfRow; idx++)
{
if (workSheet.Cells[idx, 1].Value == null || idx == rowIterator)
{
if (workSheet.Cells[idx, 4].Value != null)
{
Context.TolPulang item = new Context.TolPulang();
item.IdTol = RepoJnsTol.FindByNamaTol(workSheet.Cells[idx, 4].Value.ToString()).Id;
dbitem.ListTolPulang.Add(item);
}
}
else
{
break;
}
}
if (idx != 0)
{
rowIterator = idx - 1;
}
RepoRuteTol.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 }));
}
