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 void setDb(Context.LookupCode dbitem)
{
dbitem.IdKategori = IdKategori.Value;
dbitem.Nama = Nama;
dbitem.Order = Order.Value;
dbitem.Deskripsi = Deskripsi;
dbitem.VendorId = VendorId;
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
Context.LookupCode dbItem = RepoLookup.FindByPK(id);
RepoLookup.delete(dbItem);
return(Json(response));
}
public LookupCode(Context.LookupCode dbitem)
{
Id = dbitem.Id;
IdKategori = dbitem.IdKategori;
Kategori = dbitem.LookupCodeCategories.Category;
Nama = dbitem.Nama;
Order = dbitem.Order;
Deskripsi = dbitem.Deskripsi;
VendorId = dbitem.VendorId;
}
public ActionResult Add(LookupCode model)
{
if (ModelState.IsValid)
{
Context.LookupCode dbitem = new Context.LookupCode();
model.setDb(dbitem);
RepoLookup.save(dbitem);
return(RedirectToAction("Index"));
}
return(View("Form", model));
}
public ActionResult Edit(LookupCode model)
{
if (ModelState.IsValid)
{
Context.LookupCode dbitem = RepoLookup.FindByPK(model.Id);
model.setDb(dbitem);
RepoLookup.save(dbitem);
return(RedirectToAction("Index"));
}
return(View("Form", model));
}
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 GetLookUpByName(string nama)
{
Context.LookupCode db = RepoLookup.FindByName(nama);
return(new JavaScriptSerializer().Serialize(db));
}
public LantaiModel(Context.LookupCode dbitem)
{
IdLantai = dbitem.Id;
StrLantai = dbitem.Nama;
}
public DindingModel(Context.LookupCode dbitem)
{
IdDinding = dbitem.Id;
StrDinding = dbitem.Nama;
}
