public IHttpActionResult PutPODETAIL(string pono, string itcode, PODETAIL pODETAIL)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (pono != pODETAIL.PONO && itcode != pODETAIL.ITCODE)
{
return(BadRequest());
}
db.MarkAsModified(pODETAIL);
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!PODETAILExists(pono, itcode))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Create(PODETAIL collection)
{
try
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://localhost:31766/api/");
//HTTP POST
var postTask = client.PostAsJsonAsync <PODETAIL>("PODetailAPI", collection);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
return(RedirectToAction("Index"));
}
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
// DELETE api/<controller>/5
public void Delete(string id)
{
PODETAIL poDetailOld = dbContext.PODETAILs.Where(a => a.PONO == id).FirstOrDefault();
dbContext.Entry(poDetailOld).State = System.Data.Entity.EntityState.Deleted;
dbContext.SaveChanges();
}
public async Task <ActionResult> CreatePoDetail(PODETAIL i)
{
try
{
PODETAIL Value = new PODETAIL();
if (ModelState.IsValid)
{
TryUpdateModel(Value);
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(Baseurl);
client.DefaultRequestHeaders.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
var myContent = JsonConvert.SerializeObject(Value);
var buffer = System.Text.Encoding.UTF8.GetBytes(myContent);
ByteArrayContent byteContent = new ByteArrayContent(buffer);
HttpResponseMessage Res = await client.PostAsJsonAsync <PODETAIL>("api/PODETAILS/", Value);
PODETAIL PoDetail = new PODETAIL();
if (Res.IsSuccessStatusCode)
{
var PoDetailResponse = Res.Content.ReadAsStringAsync().Result;
PoDetail = JsonConvert.DeserializeObject <PODETAIL>(PoDetailResponse);
return(RedirectToAction("Index"));
}
}
}
}
catch (Exception e)
{
throw e;
}
return(View());
}
public void DeletePoDetail(string PoNo, string iTCode)
{
PODETAIL poDetailEntity = _context.PODETAILs.Find(PoNo, iTCode);
_context.PODETAILs.Remove(poDetailEntity);
_context.SaveChanges();
}
private void ConvertToPurchaseOrderEntity(PODETAIL item, Entity.PurchaseProcessDetail ppDetail)
{
ppDetail.Item = new Entity.Item()
{
ItemCode = item.ITEM.ITCODE,
ItemDescription = item.ITEM.ITDESC,
ItemRate = item.ITEM.ITRATE
};
ppDetail.PurchaseOrderDetail = new Entity.PODetail()
{
Quantity = item.QTY
};
ppDetail.PurchaseOrderMaster = new Entity.POMaster()
{
PurchaseOrderDate = item.POMASTER.PODATE,
PurchaseOrderNo = item.PONO
};
ppDetail.Supplier = new Entity.Supplier()
{
SupplierAddress = item.POMASTER.SUPPLIER.SUPLADDR,
SupplierName = item.POMASTER.SUPPLIER.SUPLNAME,
SupplierNo = item.POMASTER.SUPPLIER.SUPLNO
};
}
public IHttpActionResult PutPODETAIL(string id, PODETAIL pODETAIL)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != pODETAIL.PONO.Trim())
{
return(BadRequest());
}
db.Entry(pODETAIL).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!PODETAILExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PostPODETAIL(PODETAIL pODETAIL)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.PODETAILs.Add(pODETAIL);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (PODETAILExists(pODETAIL.PONO, pODETAIL.ITCODE))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = pODETAIL.PONO }, pODETAIL));
}
public void Post([FromBody] PODETAIL item)
{
using (PODbEntities db = new PODbEntities())
{
db.PODETAILs.Add(item);
db.SaveChanges();
}
}
public void Put([FromBody] PODETAIL item)
{
using (PODbEntities db = new PODbEntities())
{
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
// PUT api/<controller>/5
public void Put(string id, [FromBody] PODETAIL poDetail)
{
PODETAIL poDetailOld = dbContext.PODETAILs.Where(a => a.PONO == id).FirstOrDefault();
poDetailOld.ITCODE = poDetail.ITCODE;
poDetailOld.QTY = poDetail.QTY;
dbContext.Entry(poDetailOld).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
}
public IHttpActionResult GetPODETAIL(string id)
{
PODETAIL pODETAIL = db.PODETAILs.Where(x => x.PONO == id).FirstOrDefault();
if (pODETAIL == null)
{
return(NotFound());
}
return(Ok(pODETAIL));
}
public IHttpActionResult GetPODETAIL(string pono, string itcode)
{
PODETAIL pODETAIL = db.PODETAILs.Find(pono, itcode);
if (pODETAIL == null)
{
return(NotFound());
}
return(Ok(pODETAIL));
}
private static PODETAIL GetPoDetailEntity(PoDetailModel poDetail)
{
PODETAIL poDetailEntity = new PODETAIL();
if (poDetail != null)
{
poDetailEntity.PONO = poDetail.PONO;
poDetailEntity.ITCODE = poDetail.ITCODE;
poDetailEntity.QTY = poDetail.QTY;
}
return(poDetailEntity);
}
public string UpdatePoDetail(PoDetailModel poDetail)
{
string result = string.Empty;
PODETAIL poDetailEntity = GetPoDetailEntity(poDetail);
if (poDetailEntity != null)
{
_context.Entry(poDetailEntity).State = EntityState.Modified;
_context.SaveChanges();
result = poDetailEntity.PONO;
}
return(result);
}
public IHttpActionResult DeletePODETAIL(string pono, string itcode)
{
PODETAIL pODETAIL = db.PODETAILs.Find(pono, itcode);
if (pODETAIL == null)
{
return(NotFound());
}
db.PODETAILs.Remove(pODETAIL);
db.SaveChanges();
return(Ok(pODETAIL));
}
public string AddPoDetail(PoDetailModel poDetail)
{
string result = string.Empty;
PODETAIL poDetailEntity = GetPoDetailEntity(poDetail);
if (poDetailEntity != null)
{
_context.PODETAILs.Add(poDetailEntity);
_context.SaveChanges();
result = poDetailEntity.PONO;
}
return(result);
}
public async Task <ActionResult> DeletePoDetail(string Id, string itcode)
{
PODETAIL PoDetail = new PODETAIL();
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(Baseurl);
client.DefaultRequestHeaders.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage Res = await client.DeleteAsync("api/PODETAILs/" + Id + "/" + itcode);
return(RedirectToAction("Index"));
}
}
public IHttpActionResult DeletePODETAIL(string id)
{
PODETAIL pODETAIL = db.PODETAILs.Where(x => x.PONO == id).FirstOrDefault();
if (pODETAIL == null)
{
return(NotFound());
}
db.PODETAILs.Remove(pODETAIL);
db.SaveChanges();
return(Ok(pODETAIL));
}
public void Podetails_GetPodetail_ShouldReturnPodetailById()
{
//Arrange
//Initialize();
//Act
OkNegotiatedContentResult <PODETAIL> response = podetailController.GetPODETAIL("1", "1") as OkNegotiatedContentResult <PODETAIL>;
PODETAIL podetail = response.Content;
//Assert
Assert.IsNotNull(podetail);
Assert.AreEqual("1", podetail.PONO);
Assert.AreEqual("1", podetail.ITCODE);
Assert.AreEqual(2, podetail.QTY);
}
public bool createPurchaseOrder(PurchaseProcessDetail purchaseProcessDetail)
{
SUPPLIER supplier = new SUPPLIER
{
SUPLNO = purchaseProcessDetail.Supplier.SupplierNo,
SUPLNAME = purchaseProcessDetail.Supplier.SupplierName,
SUPLADDR = purchaseProcessDetail.Supplier.SupplierAddress
};
PODETAIL poDetail = new PODETAIL
{
PONO = purchaseProcessDetail.PurchaseOrderDetail.PurchaseOrderNo,
ITCODE = purchaseProcessDetail.PurchaseOrderDetail.ItemCode,
QTY = purchaseProcessDetail.PurchaseOrderDetail.Quantity
};
POMASTER POMaster = new POMASTER
{
PODATE = purchaseProcessDetail.PurchaseOrderMaster.PurchaseOrderDate,
PONO = purchaseProcessDetail.PurchaseOrderMaster.PurchaseOrderNo,
SUPLNO = purchaseProcessDetail.PurchaseOrderMaster.SupplierNo
};
ITEM item = new ITEM
{
ITCODE = purchaseProcessDetail.Item.ItemCode,
ITDESC = purchaseProcessDetail.Item.ItemDescription,
ITRATE = purchaseProcessDetail.Item.ItemRate
};
using (var POContext = new Entities())
{
POContext.SUPPLIER.Add(supplier);
POContext.ITEM.Add(item);
POContext.PODETAIL.Add(poDetail);
POContext.POMASTER.Add(POMaster);
rowAffected = POContext.SaveChanges();
}
if (rowAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
private static PoDetailModel GetPoDetailModel(PODETAIL poDetailEntity)
{
PoDetailModel objPoDetail = new PoDetailModel();
if (poDetailEntity != null)
{
objPoDetail.PONO = poDetailEntity.PONO;
objPoDetail.ITCODE = poDetailEntity.ITCODE;
objPoDetail.QTY = poDetailEntity.QTY;
objPoDetail.ITDESC = poDetailEntity.ITEM.ITDESC;
objPoDetail.PODATE = poDetailEntity.POMASTER.PODATE;
objPoDetail.SUPLNAME = poDetailEntity.POMASTER.SUPPLIER.SUPLNAME;
objPoDetail.SUPLNO = poDetailEntity.POMASTER.SUPPLIER.SUPLNO;
}
return(objPoDetail);
}
public void Podetails_PutPodetail_ShouldReturnStatusCode()
{
//Arrange
//Initialize();
PODETAIL pODETAIL = new PODETAIL {
PONO = "1", ITCODE = "1", QTY = 100
};
//Act
StatusCodeResult result = podetailController.PutPODETAIL("1", "1", pODETAIL) as StatusCodeResult;
//Assert
Assert.IsNotNull(result);
Assert.IsInstanceOf <StatusCodeResult>(result);
Assert.AreEqual(HttpStatusCode.NoContent, result.StatusCode);
}
public void Add()
{
PurchaseOrderController controller = new PurchaseOrderController();
PODETAIL podetail = new PODETAIL()
{
PONO = "PO01", ITCODE = "IT01", QTY = 5
};
controller.PostPOMASTER(new POMASTER()
{
PODATE = DateTime.Now, PONO = "PO01", SUPLNO = "SU01", PODETAILs = new List <PODETAIL>()
{
podetail
}
});
Assert.IsTrue(podetail.PONO == "PO01");
}
public void Podetails_PostPodetail_ShouldReturnSamePodetail()
{
//Arrange
//Initialize();
PODETAIL pODETAIL = new PODETAIL {
PONO = "6", ITCODE = "2", QTY = 543
};
//Act
CreatedAtRouteNegotiatedContentResult <PODETAIL> result = podetailController.PostPODETAIL(pODETAIL) as CreatedAtRouteNegotiatedContentResult <PODETAIL>;
//Assert
Assert.IsNotNull(result);
Assert.AreEqual(result.RouteName, "DefaultApi");
Assert.AreEqual(result.RouteValues["id"], result.Content.PONO);
Assert.AreEqual(result.Content.ITCODE, pODETAIL.ITCODE);
}
public void Update()
{
PurchaseOrderController controller = new PurchaseOrderController();
PODETAIL podetail = new PODETAIL()
{
PONO = "PO01", ITCODE = "IT01", QTY = 10
};
controller.PutPOMASTER("PO01", new POMASTER()
{
PODATE = DateTime.Now, PONO = "PO01", SUPLNO = "SU01", PODETAILs = new List <PODETAIL>()
{
podetail
}
});
Assert.IsTrue(podetail.QTY == 10);
}
private void MapforUpdateItems(PODETAIL item, Entity.PurchaseProcessDetail purchaseProcessDetail)
{
if (purchaseProcessDetail.Item != null)
{
//if (!string.IsNullOrWhiteSpace(purchaseProcessDetail.Item.ItemCode))
//{
// item.ITEM.ITCODE = purchaseProcessDetail.Item.ItemCode;
//}
if (!string.IsNullOrWhiteSpace(purchaseProcessDetail.Item.ItemDescription))
{
item.ITEM.ITDESC = purchaseProcessDetail.Item.ItemDescription;
}
if (purchaseProcessDetail.Item.ItemRate != null)
{
item.ITEM.ITRATE = purchaseProcessDetail.Item.ItemRate;
}
}
if (purchaseProcessDetail.PurchaseOrderDetail != null)
{
if (purchaseProcessDetail.PurchaseOrderDetail.Quantity != null)
{
item.QTY = purchaseProcessDetail.PurchaseOrderDetail.Quantity;
}
}
if (purchaseProcessDetail.PurchaseOrderMaster != null)
{
if (purchaseProcessDetail.PurchaseOrderMaster.PurchaseOrderDate != null)
{
item.POMASTER.PODATE = purchaseProcessDetail.PurchaseOrderMaster.PurchaseOrderDate;
}
}
if (purchaseProcessDetail.Supplier != null)
{
if (!string.IsNullOrWhiteSpace(purchaseProcessDetail.Supplier.SupplierName))
{
item.POMASTER.SUPPLIER.SUPLNAME = purchaseProcessDetail.Supplier.SupplierName;
}
if (!string.IsNullOrWhiteSpace(purchaseProcessDetail.Supplier.SupplierAddress))
{
item.POMASTER.SUPPLIER.SUPLADDR = purchaseProcessDetail.Supplier.SupplierAddress;
}
}
}
public async Task <ActionResult> DetailsPoDetail(string Id)
{
PODETAIL PoDetail = new PODETAIL();
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(Baseurl);
client.DefaultRequestHeaders.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage Res = await client.GetAsync("api/PODETAILs/" + Id);
if (Res.IsSuccessStatusCode)
{
var PoDetailResponse = Res.Content.ReadAsStringAsync().Result;
PoDetail = JsonConvert.DeserializeObject <PODETAIL>(PoDetailResponse);
}
return(View(PoDetail));
}
}
public ActionResult Edit(int id)
{
PODETAIL model = new PODETAIL();
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://localhost:31766/api/");
//HTTP GET
var getTask = client.GetAsync("PODetailAPI/" + id);
getTask.Wait();
var result = getTask.Result;
if (result.IsSuccessStatusCode)
{
model = result.Content.ReadAsAsync <PODETAIL>().Result;
}
}
return(View(model));
}
public void Delete()
{
PurchaseOrderController controller = new PurchaseOrderController();
PODETAIL podetail = new PODETAIL()
{
PONO = "PO02", ITCODE = "IT01", QTY = 5
};
controller.PostPOMASTER(new POMASTER()
{
PODATE = DateTime.Now, PONO = "PO02", SUPLNO = "SU01", PODETAILs = new List <PODETAIL>()
{
podetail
}
});
IHttpActionResult poMasters = controller.DeletePOMASTER("PO02");
var content = poMasters as OkNegotiatedContentResult <POMASTER>;
Assert.IsNotNull(content);
}
