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); }