public ActionResult Dynamic()
{
ViewBag.LookupCodesSPBU = RepoLookup.FindAll().Where(d => d.LookupCodeCategories.Category == "tms_SPBU").ToList();
ViewBag.LookupCodesKapal = RepoLookup.FindAll().Where(d => d.LookupCodeCategories.Category == "tms_penyebrangan").ToList();
ViewBag.Pool = RepoMasterPool.FindAll();
return(View("Dynamic"));
}
public string UploadLookUpCode(IEnumerable <HttpPostedFileBase> filesLookUp)
{
ResponeModel response = new ResponeModel();
//algoritma
if (filesLookUp != null)
{
foreach (var file in filesLookUp)
{
try
{
using (var package = new ExcelPackage(file.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
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)
{
string namaKategori = workSheet.Cells[rowIterator, 1].Value.ToString();
int? idKategori = RepoKategori.FindAll().Where(k => k.Category == namaKategori).Select(k => k.Id).FirstOrDefault();
string namaLookUp = RepoLookup.FindAll().Where(l => l.Nama == workSheet.Cells[rowIterator, 2].Value.ToString()).Select(l => l.Nama).FirstOrDefault();
Context.LookupCode dbitem = new Context.LookupCode();
if (idKategori.HasValue && namaLookUp == null && idKategori > 0)
{
dbitem.IdKategori = idKategori.Value;
dbitem.Nama = workSheet.Cells[rowIterator, 2].Value.ToString();
dbitem.Order = int.Parse(workSheet.Cells[rowIterator, 3].Value.ToString());
dbitem.Deskripsi = workSheet.Cells[rowIterator, 4].Value.ToString();
RepoLookup.save(dbitem);
}
}
}
}
response.Success = true;
}
catch (Exception e)
{
response.Success = false;
response.Message = e.Message.ToString();
}
}
}
return(new JavaScriptSerializer().Serialize(new { Response = response }));
}
public string Binding()
{
GridRequestParameters param = GridRequestParameters.Current;
List <Context.LookupCode> items = RepoLookup.FindAll(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters);
List <LookupCode> ListModel = new List <LookupCode>();
foreach (Context.LookupCode item in items)
{
ListModel.Add(new LookupCode(item));
}
int total = RepoLookup.Count(param.Filters);
return(new JavaScriptSerializer().Serialize(new { total = total, data = ListModel }));
}
public string BindingKonsolidasi()
{
GridRequestParameters param = GridRequestParameters.Current;
List <Context.LookupCode> items = RepoLookup.FindAll(param.Skip, 200, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters).Where(d => d.LookupCodeCategories.Category == "tms_customer_konsolidasi").ToList();
List <LookupCode> ListModel = new List <LookupCode>();
foreach (Context.LookupCode item in items)
{
LookupCode lc = new LookupCode(item);
ListModel.Add(lc);
}
int total = RepoLookup.Count(param.Filters);
return(new JavaScriptSerializer().Serialize(new { total = total, data = ListModel }));
}
