public ActionResult CreateEdit(PemasokViewModel model)
{
try
{
if (ModelState.IsValid)
{
if (PemasokDataAccess.Update(model))
{
return(Json(new { success = true, message = "Succes" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = PemasokDataAccess.Message }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { success = false, message = "Pelase full fill required fields" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
{
}
}
}
public static bool Update(PemasokViewModel model)
{
bool result = true;
try
{
using (var db = new PerpusContext())
{
if (model.Id == 0)
{
Pemasok pms = new Pemasok();
pms.Id = model.Id;
pms.KodePenerbit = model.KodePenerbit;
pms.KodePemasok = model.KodePemasok;
pms.NamaPemasok = model.NamaPemasok;
pms.AlamatPemasok = model.AlamatPemasok;
pms.Telepon = model.Telepon;
pms.CreatedBy = "Admin";
pms.Created = DateTime.Now;
db.Pemasok.Add(pms);
db.SaveChanges();
}
else
{
Pemasok pms = db.Pemasok.Where(o => o.Id == model.Id).FirstOrDefault();
if (pms != null)
{
pms.KodePenerbit = model.KodePenerbit;
pms.KodePemasok = model.KodePemasok;
pms.NamaPemasok = model.NamaPemasok;
pms.AlamatPemasok = model.AlamatPemasok;
pms.Telepon = model.Telepon;
pms.ModifiedBy = "Admin";
pms.Modified = DateTime.Now;
db.SaveChanges();
}
}
}
}
catch (Exception ex)
{
Message = ex.Message;
result = false;
}
return(result);
}
public static bool Update(PemasokViewModel model)
{
bool result = true;
try
{
using (var db = new TokoKonteks())
{
if (model.Id == 0)
{
Mst_Pemasok Pmk = new Mst_Pemasok();
Pmk.Kode = model.Kode;
Pmk.NamaPemasok = model.NamaPemasok;
Pmk.Alamat = model.Alamat;
Pmk.NoHp = model.NoHp;
Pmk.Aktif = model.Aktif;
Pmk.DibuatOleh = "Test";
Pmk.Dibuat = DateTime.Now;
db.Mst_Pemasok.Add(Pmk);
db.SaveChanges();
}
else
{
Mst_Pemasok Pmk = db.Mst_Pemasok.Where(o => o.Id == model.Id).FirstOrDefault();
if (Pmk != null)
{
Pmk.Kode = model.Kode;
Pmk.NamaPemasok = model.NamaPemasok;
Pmk.Alamat = model.Alamat;
Pmk.NoHp = model.NoHp;
Pmk.Aktif = model.Aktif;
Pmk.DiubahOleh = "Test";
Pmk.Diubah = DateTime.Now;
db.SaveChanges();
}
}
}
}
catch (Exception ex)
{
Message = ex.Message;
result = false;
}
return(result);
}
public static PemasokViewModel GetById(int id)
{
PemasokViewModel result = new PemasokViewModel();
using (var db = new TokoKonteks())
{
result = (from Pmk in db.Mst_Pemasok
where Pmk.Id == id
select new PemasokViewModel
{
Id = Pmk.Id,
Kode = Pmk.Kode,
NamaPemasok = Pmk.NamaPemasok,
Alamat = Pmk.Alamat,
NoHp = Pmk.NoHp,
Aktif = Pmk.Aktif
}).FirstOrDefault();
}
return(result);
}
public static PemasokViewModel GetById(int id)
{
PemasokViewModel result = new PemasokViewModel();
using (var db = new PerpusContext())
{
result = (from pms in db.Pemasok
where pms.Id == id
select new PemasokViewModel
{
Id = pms.Id,
KodePenerbit = pms.KodePenerbit,
KodePemasok = pms.KodePemasok,
NamaPemasok = pms.NamaPemasok,
AlamatPemasok = pms.AlamatPemasok,
Telepon = pms.Telepon
}).FirstOrDefault();
}
return(result);
}
public ActionResult Edit(PemasokViewModel model)
{
return(CreateEdit(model));
}
