public ActionResult Edit(int id)
{
Context.Atm dbitem = RepoAtm.FindByPK(id);
Atm model = new Atm(dbitem);
ViewBag.name = model.NamaBank;
return(View("Form", model));
}
public void setDb(Context.Atm dbitem)
{
dbitem.Id = Id;
dbitem.NoKartu = NoKartu;
dbitem.IdBank = IdBank;
dbitem.NoRekening = NoRekening;
dbitem.AtasNama = AtasNama;
dbitem.IdDriver = IdDriver;
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
Context.Atm dbItem = RepoAtm.FindByPK(id);
RepoAtm.delete(dbItem, UserPrincipal.id);
return(Json(response));
}
public ActionResult Edit(Atm model)
{
if (ModelState.IsValid)
{
Context.Atm dbitem = RepoAtm.FindByPK(model.Id);
model.setDb(dbitem);
RepoAtm.save(dbitem, UserPrincipal.id);
return(RedirectToAction("Index"));
}
return(View("Form", model));
}
public string FindByDriver(int id)
{
Context.Atm items = RepoAtm.FindByDriver(id);
Atm model = new Atm();
if (items != null)
{
model = new Atm(items);
}
return(new JavaScriptSerializer().Serialize(model));
}
public Atm(Context.Atm dbitem)
{
Id = dbitem.Id;
NoKartu = dbitem.NoKartu;
IdBank = dbitem.IdBank;
NamaBank = dbitem.LookupCodeBank.Nama;
NoRekening = dbitem.NoRekening;
AtasNama = dbitem.AtasNama;
IdDriver = dbitem.IdDriver;
KodeDriver = dbitem.Driver.KodeDriver;
NamaDriver = dbitem.Driver.NamaDriver;
Panggilan = dbitem.Driver.NamaPangilan;
}
public AdminUangJalanUangTf(Context.AdminUangJalanUangTf dbitem, List <Context.Atm> listAtm)
{
Id = dbitem.Id;
Nama = dbitem.Keterangan;
Value = dbitem.Value;
Tanggal = dbitem.Tanggal;
JumlahTransfer = dbitem.JumlahTransfer.HasValue ? dbitem.JumlahTransfer : 0;
idRekening = dbitem.idRekenings;
if (dbitem.idRekenings.HasValue)
{
NoRekening = dbitem.Atm.NoRekening;
AtasNama = dbitem.Atm.Driver.NamaDriver;
NamaBank = dbitem.Atm.LookupCodeBank.Nama;
}
else
{
Context.Atm dbattm = listAtm.Where(d => d.IdDriver == dbitem.AdminUangJalan.IdDriver1).FirstOrDefault();
if (dbattm != null)
{
idRekening = dbattm.Id;
NoRekening = dbattm.NoRekening;
public AdminUangJalanUangTf(Context.AdminUangJalanUangTf dbitem, List <Context.Atm> listAtm)
{
Id = dbitem.Id;
Nama = dbitem.Keterangan;
Value = dbitem.Value;
Tanggal = dbitem.Tanggal;
Code = dbitem.Code;
JumlahTransfer = dbitem.JumlahTransfer.HasValue ? dbitem.JumlahTransfer : 0;
idRekening = dbitem.idRekenings;
if (dbitem.idRekenings.HasValue)
{
NoRekening = dbitem.Atm.NoRekening;
AtasNama = dbitem.Atm.AtasNama;
NamaBank = dbitem.Atm.LookupCodeBank.Nama;
}
else
{
Context.Atm dbattm = listAtm.Where(d => d.IdDriver == dbitem.AdminUangJalan.IdDriver1).FirstOrDefault();
if (dbattm != null)
{
idRekening = dbattm.Id;
NoRekening = dbattm.NoRekening;
AtasNama = dbattm.AtasNama;
NamaBank = dbattm.LookupCodeBank.Nama;
}
}
TanggalAktual = dbitem.TanggalAktual.HasValue ? dbitem.TanggalAktual : DateTime.Now;
JamAktual = dbitem.JamAktual;
KeteranganTf = dbitem.KeteranganTf;
KeteranganAdmin = dbitem.AdminUangJalan.KeteranganAdmin;
if (dbitem.IdDriverPenerima.HasValue)
{
IdDriverPenerima = dbitem.IdDriverPenerima;
DriverPenerima = dbitem.Driver.NamaDriver;
}
isTf = dbitem.isTf;
}
public string UploadATM(IEnumerable <HttpPostedFileBase> filesAtm)
{
ResponeModel response = new ResponeModel();
//algoritma
if (filesAtm != null)
{
foreach (var file in filesAtm)
{
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 &&
workSheet.Cells[rowIterator, 5].Value != null)
{
int id = 0;
int resId;
if (workSheet.Cells[rowIterator, 6].Value != null)
{
if (int.TryParse(workSheet.Cells[rowIterator, 6].Value.ToString(), out resId))
{
id = resId;
}
}
//cara gancang ngarah teu kudu aya pengecekan tiap field
Context.Atm dbitem = new Context.Atm();
try
{
if (id != 0)
{
dbitem = RepoAtm.FindByPK(id);
}
dbitem.NoKartu = workSheet.Cells[rowIterator, 1].Value.ToString();
dbitem.IdBank = RepoLookup.FindByName(workSheet.Cells[rowIterator, 2].Value.ToString()).Id;
dbitem.NoRekening = workSheet.Cells[rowIterator, 3].Value.ToString();
dbitem.AtasNama = workSheet.Cells[rowIterator, 4].Value.ToString();
dbitem.IdDriver = RepoDriver.FindByCode(workSheet.Cells[rowIterator, 5].Value.ToString()).Id;
RepoAtm.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 }));
}
public ActionResult Edit(int id)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByPK(id);
List <Context.Atm> ListAtm = RepoAtm.FindAll();
if (dbitem.SalesOrderOncallId.HasValue)
{
SalesOrderOncall model = new SalesOrderOncall(dbitem);
//ambil rekening default
if (!model.AtmId.HasValue)
{
Context.Atm dummAtm = ListAtm.Where(d => d.IdDriver == model.Driver1Id).FirstOrDefault();
if (dummAtm != null)
{
model.AtmId = dummAtm.Id;
model.StrRekening = dummAtm.NoRekening;
model.AtasNamaRek = dummAtm.AtasNama;
model.Bank = dummAtm.LookupCodeBank.Nama;
}
}
ViewBag.kondisi = "konfirmasi";
ViewBag.name = model.SONumber;
ViewBag.Title = "konfirmasi Sales Order Oncall " + model.SONumber;
ViewBag.PostData = "EditOncall";
return(View("SalesOrderOncall/FormReadOnly", model));
}
else if (dbitem.SalesOrderProsesKonsolidasiId.HasValue)
{
SalesOrderProsesKonsolidasi model = new SalesOrderProsesKonsolidasi(dbitem);
//ambil rekening default
if (!model.AtmId.HasValue)
{
Context.Atm dummAtm = ListAtm.Where(d => d.IdDriver == model.Driver1Id).FirstOrDefault();
if (dummAtm != null)
{
model.AtmId = dummAtm.Id;
model.StrRekening = dummAtm.NoRekening;
model.AtasNamaRek = dummAtm.AtasNama;
model.Bank = dummAtm.LookupCodeBank.Nama;
}
}
ViewBag.kondisi = "konfirmasi";
ViewBag.name = model.SONumber;
ViewBag.Title = "konfirmasi Sales Proses Konsolidasi " + model.SONumber;
ViewBag.PostData = "EditKonsolidasi";
return(View("SalesOrderProsesKonsolidasi/FormReadOnly", model));
}
else if (dbitem.SalesOrderPickupId.HasValue)
{
SalesOrderPickup model = new SalesOrderPickup(dbitem);
//ambil rekening default
if (!model.AtmId.HasValue)
{
Context.Atm dummAtm = ListAtm.Where(d => d.IdDriver == model.Driver1Id).FirstOrDefault();
if (dummAtm != null)
{
model.AtmId = dummAtm.Id;
model.StrRekening = dummAtm.NoRekening;
model.AtasNamaRek = dummAtm.AtasNama;
model.Bank = dummAtm.LookupCodeBank.Nama;
}
}
ViewBag.kondisi = "konfirmasi";
ViewBag.name = model.SONumber;
ViewBag.Title = "konfirmasi Sales Order Pickup " + model.SONumber;
ViewBag.PostData = "EditPickup";
return(View("SalesOrderPickup/FormReadOnly", model));
}
else
{
return(View(""));
}
}
