public bool Put(a_PurchaseOrderViewModel a_PurchaseOrder)
{
try
{
service.Updatea_PurchaseOrder(a_PurchaseOrder);
return(true);
}
catch (Exception e)
{
return(false);
}
}
public bool Post(a_PurchaseOrderViewModel a_PurchaseOrder)
{
try
{
service.CreateNewa_PurchaseOrder(a_PurchaseOrder);
return(true);
}
catch (Exception e)
{
return(false);
}
}
public List <a_PurchaseOrderViewModel> Geta_PurchaseOrderList(string id)
{
var a_PurchaseOrders = service.Geta_PurchaseOrderList();
var Lista_PurchaseOrder = new List <a_PurchaseOrderViewModel>();
foreach (var a_PurchaseOrder in a_PurchaseOrders)
{
var result = new a_PurchaseOrderViewModel();
result.ID = a_PurchaseOrder.ID;
Lista_PurchaseOrder.Add(result);
}
return(Lista_PurchaseOrder);
}
// UPDATE
public void Updatea_PurchaseOrder(a_PurchaseOrderViewModel a_PurchaseOrder)
{
using (ShopDBEntities db = new ShopDBEntities())
{
a_PurchaseOrder Model = new a_PurchaseOrder();
Model.ID = a_PurchaseOrder.ID;
Model.Code = a_PurchaseOrder.Code;
Model.PurchaseDate = a_PurchaseOrder.PurchaseDate;
Model.SupplierID = a_PurchaseOrder.SupplierID;
Model.Remarks = a_PurchaseOrder.Remarks;
db.Entry(Model).State = EntityState.Modified;
db.SaveChanges();
}
}
// INSERT INTO
public void CreateNewa_PurchaseOrder(a_PurchaseOrderViewModel a_PurchaseOrder)
{
using (ShopDBEntities db = new ShopDBEntities())
{
a_PurchaseOrder Model = new a_PurchaseOrder();
Model.ID = a_PurchaseOrder.ID;
Model.Code = a_PurchaseOrder.Code;
Model.PurchaseDate = a_PurchaseOrder.PurchaseDate;
Model.SupplierID = a_PurchaseOrder.SupplierID;
Model.Remarks = a_PurchaseOrder.Remarks;
db.a_PurchaseOrder.Add(Model);
db.SaveChanges();
}
}
// SELECT *
public a_PurchaseOrderViewModel Geta_PurchaseOrderById(int id)
{
using (ShopDBEntities db = new ShopDBEntities())
{
a_PurchaseOrder a_PurchaseOrder = db.a_PurchaseOrder.Find(id);
a_PurchaseOrderViewModel Model = new a_PurchaseOrderViewModel();
Model.ID = a_PurchaseOrder.ID;
Model.Code = a_PurchaseOrder.Code;
//Model.PurchaseDate = a_PurchaseOrder.PurchaseDate;
Model.SupplierID = a_PurchaseOrder.SupplierID;
Model.Remarks = a_PurchaseOrder.Remarks;
return(Model);
}
}
// GET: a_PurchaseOrders/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
string API_END_POINT = API_URL + "api/a_PurchaseOrderAPI/Get/" + (id ?? 0);
HttpClient client = new HttpClient();
HttpResponseMessage response = client.GetAsync(API_END_POINT).Result;
string result = response.Content.ReadAsStringAsync().Result.ToString();
a_PurchaseOrderViewModel Model = JsonConvert.DeserializeObject <a_PurchaseOrderViewModel>(result);
if (Model == null)
{
return(HttpNotFound());
}
return(View(Model));
}
// SELECT *
public List <a_PurchaseOrderViewModel> GetAlla_PurchaseOrder()
{
using (ShopDBEntities db = new ShopDBEntities())
{
var a_PurchaseOrders = db.a_PurchaseOrder.Include(p => p.a_Supplier).ToList();
List <a_PurchaseOrderViewModel> ListView = new List <a_PurchaseOrderViewModel>();
foreach (var a_PurchaseOrder in a_PurchaseOrders)
{
a_PurchaseOrderViewModel Model = new a_PurchaseOrderViewModel();
Model.ID = a_PurchaseOrder.ID;
Model.Code = a_PurchaseOrder.Code;
//Model.PurchaseDate = a_PurchaseOrder.PurchaseDate;
Model.SupplierID = a_PurchaseOrder.SupplierID;
Model.Remarks = a_PurchaseOrder.Remarks;
ListView.Add(Model);
}
return(ListView);
}
}
// GET: a_PurchaseOrders/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
string API_END_POINT = API_URL + "api/a_PurchaseOrderAPI/Get/" + (id ?? 0);
HttpClient client = new HttpClient();
HttpResponseMessage response = client.GetAsync(API_END_POINT).Result;
string result = response.Content.ReadAsStringAsync().Result.ToString();
a_PurchaseOrderViewModel Model = JsonConvert.DeserializeObject <a_PurchaseOrderViewModel>(result);
if (Model == null)
{
return(HttpNotFound());
}
ViewBag.SupplierID = new SelectList(service.Geta_SupplierList(), "Id", "Name", Model.SupplierID);
return(View(Model));
}
public ActionResult Create(a_PurchaseOrderViewModel a_PurchaseOrder)
{
string API_END_POINT, result;
HttpClient client = new HttpClient();
HttpResponseMessage response;
if (ModelState.IsValid)
{
string a_PurchaseOrderJSON = JsonConvert.SerializeObject(a_PurchaseOrder);
var buffer = Encoding.UTF8.GetBytes(a_PurchaseOrderJSON);
var byteContent = new ByteArrayContent(buffer);
byteContent.Headers.ContentType = new MediaTypeHeaderValue("application/json");
API_END_POINT = API_URL + "api/a_PurchaseOrderAPI/";
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_PurchaseOrder));
}
}
API_END_POINT = API_URL + "api/a_PurchaseOrderAPI/Geta_SupplierList/" + ("get");
response = client.GetAsync(API_END_POINT).Result;
result = response.Content.ReadAsStringAsync().Result.ToString();
var Lista_Supplier = JsonConvert.DeserializeObject <List <a_SupplierViewModel> >(result);
ViewBag.SupplierID = new SelectList(Lista_Supplier, "Id", "Name", a_PurchaseOrder.SupplierID);
return(View(a_PurchaseOrder));
}
