public async Task <ActionResult> CreatePoMaster(POMASTER i)
{
try
{
POMASTER Value = new POMASTER();
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 <POMASTER>("api/POMASTERs/", Value);
POMASTER PoMasterInfo = new POMASTER();
if (Res.IsSuccessStatusCode)
{
var PoMasterResponse = Res.Content.ReadAsStringAsync().Result;
PoMasterInfo = JsonConvert.DeserializeObject <POMASTER>(PoMasterResponse);
return(RedirectToAction("Index"));
}
}
}
}
catch (Exception e)
{
throw e;
}
return(View());
}
public void DeletePoMaster(string PoNo)
{
POMASTER poMasterEntity = _context.POMASTERs.Find(PoNo);
_context.POMASTERs.Remove(poMasterEntity);
_context.SaveChanges();
}
public async Task <IHttpActionResult> PutPOMASTER(string id, POMASTER pOMASTER)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != pOMASTER.PONO)
{
return(BadRequest());
}
db.Entry(pOMASTER).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!POMASTERExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutPOMASTER(POMASTER pOMASTER)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Entry(pOMASTER).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!POMASTERExists(pOMASTER.PONO))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <IHttpActionResult> PostPOMASTER(POMASTER pOMASTER)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.POMASTERs.Add(pOMASTER);
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (POMASTERExists(pOMASTER.PONO))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = pOMASTER.PONO }, pOMASTER));
}
public ActionResult Create(POMASTER collection)
{
try
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://localhost:31766/api/");
//HTTP POST
var postTask = client.PostAsJsonAsync <POMASTER>("POMasterAPI", collection);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
return(RedirectToAction("Index"));
}
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public IHttpActionResult PostSUPPLIER(SUPPLIER sUPPLIER)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
var d = db.SUPPLIERs.Include(X => X.POMASTERs).First();
var e = new POMASTER {
PONO = "PO" + sUPPLIER.SUPLNO.Substring(2, 2), PODATE = DateTime.Now
};
d.POMASTERs.Add(e);
db.Entry(sUPPLIER).State = EntityState.Modified;
db.SUPPLIERs.Add(sUPPLIER);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (SUPPLIERExists(sUPPLIER.SUPLNO))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = sUPPLIER.SUPLNO }, sUPPLIER));
}
public IHttpActionResult PutPOMASTER(string id, POMASTER pOMASTER)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != pOMASTER.PONO)
{
return(BadRequest());
}
db.MarkAsModified(pOMASTER);
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!POMASTERExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
// DELETE api/<controller>/5
public void Delete(string id)
{
POMASTER poMasterOld = dbContext.POMASTERs.Where(a => a.PONO == id).FirstOrDefault();
dbContext.Entry(poMasterOld).State = System.Data.Entity.EntityState.Deleted;
dbContext.SaveChanges();
}
public void Post([FromBody] POMASTER item)
{
using (PODbEntities db = new PODbEntities())
{
db.POMASTERs.Add(item);
db.SaveChanges();
}
}
public void Put([FromBody] POMASTER 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] POMASTER pomaster)
{
POMASTER pomasterOld = dbContext.POMASTERs.Where(a => a.PONO == id).FirstOrDefault();
pomasterOld.PODATE = pomaster.PODATE;
pomasterOld.SUPLNO = pomaster.SUPLNO;
dbContext.Entry(pomasterOld).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
}
public IHttpActionResult GetPOMASTER(string id)
{
POMASTER pOMASTER = db.POMASTERs.Find(id);
if (pOMASTER == null)
{
return(NotFound());
}
return(Ok(pOMASTER));
}
public async Task <IHttpActionResult> GetPOMASTER(string id)
{
POMASTER pOMASTER = await db.POMASTERs.FindAsync(id);
if (pOMASTER == null)
{
return(NotFound());
}
return(Ok(pOMASTER));
}
private static POMASTER GetPoMasterEntity(PoMasterModel poMaster)
{
POMASTER poMasterEntity = new POMASTER();
if (poMaster != null)
{
poMasterEntity.PONO = poMaster.PONO;
poMasterEntity.PODATE = poMaster.PODATE;
poMasterEntity.SUPLNO = poMaster.SUPLNO;
}
return(poMasterEntity);
}
public string UpdatePoMaster(PoMasterModel poMaster)
{
string result = string.Empty;
POMASTER poMasterEntity = GetPoMasterEntity(poMaster);
if (poMasterEntity != null)
{
_context.Entry(poMasterEntity).State = EntityState.Modified;
_context.SaveChanges();
result = poMasterEntity.PONO;
}
return(result);
}
private static PoMasterModel GetPoMasterModel(POMASTER poMasterEntity)
{
PoMasterModel objPoMaster = new PoMasterModel();
if (poMasterEntity != null)
{
objPoMaster.PODATE = poMasterEntity.PODATE;
objPoMaster.PONO = poMasterEntity.PONO;
objPoMaster.SUPLNO = poMasterEntity.SUPLNO;
objPoMaster.SUPLNAME = poMasterEntity.SUPPLIER?.SUPLNAME;
}
return(objPoMaster);
}
public string AddPoMaster(PoMasterModel poMaster)
{
string result = string.Empty;
POMASTER poMasterEntity = GetPoMasterEntity(poMaster);
if (poMasterEntity != null)
{
_context.POMASTERs.Add(poMasterEntity);
_context.SaveChanges();
result = poMasterEntity.PONO;
}
return(result);
}
public IHttpActionResult DeletePOMASTER(string id)
{
POMASTER pOMASTER = db.POMASTERs.Find(id);
if (pOMASTER == null)
{
return(NotFound());
}
db.POMASTERs.Remove(pOMASTER);
db.SaveChanges();
return(Ok(pOMASTER));
}
public async Task <ActionResult> DeletePoMaster(string Id)
{
POMASTER PoMasterInfo = new POMASTER();
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/POMASTERs/" + Id);
return(RedirectToAction("Index"));
}
}
public async Task <IHttpActionResult> DeletePOMASTER(string id)
{
POMASTER pOMASTER = await db.POMASTERs.FindAsync(id);
if (pOMASTER == null)
{
return(NotFound());
}
db.POMASTERs.Remove(pOMASTER);
await db.SaveChangesAsync();
return(Ok(pOMASTER));
}
public void Pomasters_GetPomaster_ShouldReturnPomasterById()
{
//Arrange
//Initialize();
//Act
OkNegotiatedContentResult <POMASTER> response = pomasterController.GetPOMASTER("1") as OkNegotiatedContentResult <POMASTER>;
POMASTER pomaster = response.Content;
//Assert
Assert.IsNotNull(pomaster);
Assert.AreEqual("1", pomaster.PONO);
Assert.AreEqual(DateTime.Now.Date, pomaster.PODATE.Value.Date);
Assert.AreEqual("1", pomaster.SUPLNO);
}
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);
}
}
public void Pomasters_PutPomaster_ShouldReturnStatusCode()
{
//Arrange
//Initialize();
POMASTER pOMASTER = new POMASTER {
PONO = "1", PODATE = DateTime.Now, SUPLNO = "4"
};
//Act
StatusCodeResult result = pomasterController.PutPOMASTER("1", pOMASTER) as StatusCodeResult;
//Assert
Assert.IsNotNull(result);
Assert.IsInstanceOf <StatusCodeResult>(result);
Assert.AreEqual(HttpStatusCode.NoContent, result.StatusCode);
}
public void Pomasters_PostPomaster_ShouldReturnSamePomaster()
{
//Arrange
//Initialize();
POMASTER pOMASTER = new POMASTER {
PONO = "6", PODATE = DateTime.Now, SUPLNO = "4"
};
//Act
CreatedAtRouteNegotiatedContentResult <POMASTER> result = pomasterController.PostPOMASTER(pOMASTER) as CreatedAtRouteNegotiatedContentResult <POMASTER>;
//Assert
Assert.IsNotNull(result);
Assert.AreEqual(result.RouteName, "DefaultApi");
Assert.AreEqual(result.RouteValues["id"], result.Content.PONO);
Assert.AreEqual(result.Content.SUPLNO, pOMASTER.SUPLNO);
}
public async Task <ActionResult> DetailsPoMaster(string Id)
{
POMASTER PoMasterInfo = new POMASTER();
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/POMASTERs/" + Id);
if (Res.IsSuccessStatusCode)
{
var PoMasterResponse = Res.Content.ReadAsStringAsync().Result;
PoMasterInfo = JsonConvert.DeserializeObject <POMASTER>(PoMasterResponse);
}
return(View(PoMasterInfo));
}
}
public IHttpActionResult DeletePOMASTER(string id)
{
POMASTER pOMASTER = db.POMASTERs.Find(id);
if (pOMASTER == null)
{
return(NotFound());
}
var lst = pOMASTER.PODETAILs.ToList();
foreach (var podDetail in lst)
{
db.PODETAILs.Remove(podDetail);
}
db.POMASTERs.Remove(pOMASTER);
db.SaveChanges();
return(Ok(pOMASTER));
}
public ActionResult Edit(int id)
{
POMASTER model = new POMASTER();
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://localhost:31766/api/");
//HTTP GET
var getTask = client.GetAsync("POMasterAPI/" + id);
getTask.Wait();
var result = getTask.Result;
if (result.IsSuccessStatusCode)
{
model = result.Content.ReadAsAsync <POMASTER>().Result;
}
}
return(View(model));
}
// POST api/<controller>
public void Post([FromBody] POMASTER pomaster)
{
dbContext.POMASTERs.Add(pomaster);
dbContext.SaveChanges();
}
