public bool Put(a_PurchaseOrderDetailViewModel a_PurchaseOrderDetail)
{
try
{
service.Updatea_PurchaseOrderDetail(a_PurchaseOrderDetail);
return(true);
}
catch (Exception e)
{
return(false);
}
}
// UPDATE
public void Updatea_PurchaseOrderDetail(a_PurchaseOrderDetailViewModel a_PurchaseOrderDetail)
{
using (ShopDBEntities db = new ShopDBEntities())
{
a_PurchaseOrderDetail Model = new a_PurchaseOrderDetail();
Model.ID = a_PurchaseOrderDetail.ID;
Model.PurchaseOrderID = a_PurchaseOrderDetail.PurchaseOrderID;
Model.ProductID = a_PurchaseOrderDetail.ProductID;
Model.Quantity = a_PurchaseOrderDetail.Quantity;
Model.UnitPrice = a_PurchaseOrderDetail.UnitPrice;
db.Entry(Model).State = EntityState.Modified;
db.SaveChanges();
}
}
// INSERT INTO
public void CreateNewa_PurchaseOrderDetail(a_PurchaseOrderDetailViewModel a_PurchaseOrderDetail)
{
using (ShopDBEntities db = new ShopDBEntities())
{
a_PurchaseOrderDetail Model = new a_PurchaseOrderDetail();
Model.ID = a_PurchaseOrderDetail.ID;
Model.PurchaseOrderID = a_PurchaseOrderDetail.PurchaseOrderID;
Model.ProductID = a_PurchaseOrderDetail.ProductID;
Model.Quantity = a_PurchaseOrderDetail.Quantity;
Model.UnitPrice = a_PurchaseOrderDetail.UnitPrice;
db.a_PurchaseOrderDetail.Add(Model);
db.SaveChanges();
}
}
// SELECT *
public a_PurchaseOrderDetailViewModel Geta_PurchaseOrderDetailById(int id)
{
using (ShopDBEntities db = new ShopDBEntities())
{
a_PurchaseOrderDetail a_PurchaseOrderDetail = db.a_PurchaseOrderDetail.Find(id);
a_PurchaseOrderDetailViewModel Model = new a_PurchaseOrderDetailViewModel();
Model.ID = a_PurchaseOrderDetail.ID;
Model.PurchaseOrderID = a_PurchaseOrderDetail.PurchaseOrderID;
Model.ProductID = a_PurchaseOrderDetail.ProductID;
//Model.Quantity = a_PurchaseOrderDetail.Quantity;
//Model.UnitPrice = a_PurchaseOrderDetail.UnitPrice;
return(Model);
}
}
// GET: a_PurchaseOrderDetails/Delete/5
public ActionResult Delete(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
string API_END_POINT = API_URL + "api/a_PurchaseOrderDetailAPI/Get/" + (id ?? 0);
HttpClient client = new HttpClient();
HttpResponseMessage response = client.GetAsync(API_END_POINT).Result;
string result = response.Content.ReadAsStringAsync().Result.ToString();
a_PurchaseOrderDetailViewModel Model = JsonConvert.DeserializeObject<a_PurchaseOrderDetailViewModel>(result);
if (Model == null)
{
return HttpNotFound();
}
return View(Model);
}
// SELECT *
public List <a_PurchaseOrderDetailViewModel> GetAlla_PurchaseOrderDetail()
{
using (ShopDBEntities db = new ShopDBEntities())
{
var a_PurchaseOrderDetails = db.a_PurchaseOrderDetail.Include(p => p.a_Product).ToList();
List <a_PurchaseOrderDetailViewModel> ListView = new List <a_PurchaseOrderDetailViewModel>();
foreach (var a_PurchaseOrderDetail in a_PurchaseOrderDetails)
{
a_PurchaseOrderDetailViewModel Model = new a_PurchaseOrderDetailViewModel();
Model.ID = a_PurchaseOrderDetail.ID;
Model.PurchaseOrderID = a_PurchaseOrderDetail.PurchaseOrderID;
Model.ProductID = a_PurchaseOrderDetail.ProductID;
//Model.Quantity = a_PurchaseOrderDetail.Quantity;
//Model.UnitPrice = a_PurchaseOrderDetail.UnitPrice;
ListView.Add(Model);
}
return(ListView);
}
}
public ActionResult Create(a_PurchaseOrderDetailViewModel a_PurchaseOrderDetail)
{
string API_END_POINT, result;
HttpClient client = new HttpClient();
HttpResponseMessage response;
if (ModelState.IsValid)
{
string a_PurchaseOrderDetailJSON = JsonConvert.SerializeObject(a_PurchaseOrderDetail);
var buffer = Encoding.UTF8.GetBytes(a_PurchaseOrderDetailJSON);
var byteContent = new ByteArrayContent(buffer);
byteContent.Headers.ContentType = new MediaTypeHeaderValue("application/json");
API_END_POINT = API_URL + "api/a_PurchaseOrderDetailAPI/";
response = client.PostAsync(API_END_POINT, byteContent).Result;
result = response.Content.ReadAsStringAsync().Result.ToString();
bool success = bool.Parse(result);
if (success)
{
return RedirectToAction("Index");
}
else
{
ModelState.AddModelError(string.Empty, "Something was happened.");
return View(a_PurchaseOrderDetail);
}
}
API_END_POINT = API_URL + "api/a_PurchaseOrderDetailAPI/Geta_PurchaseOrderList/" + ("get");
response = client.GetAsync(API_END_POINT).Result;
result = response.Content.ReadAsStringAsync().Result.ToString();
var Lista_PurchaseOrder = JsonConvert.DeserializeObject<List<a_PurchaseOrderViewModel>>(result);
var Lista_Product = JsonConvert.DeserializeObject<List<a_ProductViewModel>>(result);
ViewBag.PurchaseOrderID = new SelectList(Lista_PurchaseOrder, "Id", "Remarks", a_PurchaseOrderDetail.PurchaseOrderID);
ViewBag.ProductID = new SelectList(Lista_Product, "Id", "Name", a_PurchaseOrderDetail.ProductID);
return View(a_PurchaseOrderDetail);
}
// GET: a_PurchaseOrderDetails/Edit/5
public ActionResult Edit(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
string API_END_POINT = API_URL + "api/a_PurchaseOrderDetailAPI/Get/" + (id ?? 0);
HttpClient client = new HttpClient();
HttpResponseMessage response = client.GetAsync(API_END_POINT).Result;
string result = response.Content.ReadAsStringAsync().Result.ToString();
a_PurchaseOrderDetailViewModel Model = JsonConvert.DeserializeObject<a_PurchaseOrderDetailViewModel>(result);
if (Model == null)
{
return HttpNotFound();
}
ViewBag.PurchaseOrderID = new SelectList(service.Geta_PurchaseOrderList(), "Id", "Remarks", Model.PurchaseOrderID);
ViewBag.ProductID = new SelectList(service.Geta_ProductList(), "Id", "Name", Model.ProductID);
return View(Model);
}
