public bool Create(MstSupplierViewModel vmodelSupplier)
{
bool result = true;
MstSupplier modelSupplier = new MstSupplier();
modelSupplier.SupplierCode = vmodelSupplier.SupplierCode;
modelSupplier.ItemId = vmodelSupplier.ItemId;
modelSupplier.Price = vmodelSupplier.Price;
modelSupplier.Name = vmodelSupplier.Name;
modelSupplier.Address = vmodelSupplier.Address;
modelSupplier.Email = vmodelSupplier.Email;
modelSupplier.Phone = vmodelSupplier.Phone;
modelSupplier.Actived = vmodelSupplier.Actived;
modelSupplier.CreatedOn = vmodelSupplier.CreatedOn;
modelSupplier.CreatedBy = vmodelSupplier.CreatedBy;
modelSupplier.ModifiedOn = vmodelSupplier.ModifiedOn;
modelSupplier.ModifiedBy = vmodelSupplier.ModifiedBy;
dataContext.mstSupplier.Add(modelSupplier);
try
{
dataContext.SaveChanges();
return(result);
}
catch (Exception)
{
result = false;
return(result);
throw;
}
}
public bool Update(MstSupplierViewModel vmodelSupplier)
{
bool result = true;
MstSupplier modelSupplier = dataContext.mstSupplier.Where(mdl => mdl.SupplierCode == vmodelSupplier.SupplierCode).FirstOrDefault();
modelSupplier.SupplierCode = vmodelSupplier.SupplierCode;
modelSupplier.ItemId = vmodelSupplier.ItemId;
modelSupplier.Price = vmodelSupplier.Price;
modelSupplier.Name = vmodelSupplier.Name;
modelSupplier.Address = vmodelSupplier.Address;
modelSupplier.Email = vmodelSupplier.Email;
modelSupplier.Phone = vmodelSupplier.Phone;
modelSupplier.Actived = vmodelSupplier.Actived;
modelSupplier.ModifiedOn = vmodelSupplier.ModifiedOn;
modelSupplier.ModifiedBy = vmodelSupplier.ModifiedBy;
dataContext.Entry(modelSupplier).State = EntityState.Modified;
try
{
dataContext.SaveChanges();
return(result);
}
catch (Exception)
{
result = false;
return(result);
throw;
}
}
public MstSupplierViewModel GetPriceBySupplierCode(string cd)
{
MstSupplierViewModel result = new MstSupplierViewModel();
result = (from supplier in dataContext.mstSupplier
where supplier.SupplierCode == cd
select new MstSupplierViewModel {
SupplierCode = supplier.SupplierCode,
Price = supplier.Price
}).FirstOrDefault();
return(result);
}
public ActionResult Update(MstSupplierViewModel model)
{
if (ModelState.IsValid)
{
model.ModifiedOn = today;
model.ModifiedBy = (string)Session["EmployeeName"];
if (serviceSupplier.Update(model))
{
return(Json(new { pesan = "sukses" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { pesan = "gagal" }, JsonRequestBehavior.AllowGet));
}
}
return(View());
}
public MstSupplierViewModel GetById(string cd)
{
MstSupplierViewModel result = new MstSupplierViewModel();
result = (from supplier in dataContext.mstSupplier
where supplier.SupplierCode == cd
select new MstSupplierViewModel {
SupplierCode = supplier.SupplierCode,
ItemId = supplier.ItemId,
Price = supplier.Price,
Name = supplier.Name,
Address = supplier.Address,
Email = supplier.Email,
Phone = supplier.Phone,
Actived = supplier.Actived,
CreatedOn = supplier.CreatedOn,
CreatedBy = supplier.CreatedBy,
ModifiedOn = supplier.ModifiedOn,
ModifiedBy = supplier.ModifiedBy
}).FirstOrDefault();
return(result);
}
