public JsonResponse Change(PurchaseRequestLineitem purchaseRequestLineitem)
{
purchaseRequestLineitem.Product = null;
if (purchaseRequestLineitem == null)
{
return new JsonResponse {
Code = -100, Message = $"purchaseRequestLineitem cannot be null"
}
}
;
if (!ModelState.IsValid)
{
return new JsonResponse {
Code = -200, Message = $"ModelState is invalid", Error = ModelState
}
}
;
db.PurchaseRequestLineitems.Attach(purchaseRequestLineitem);
db.Entry(purchaseRequestLineitem).State = System.Data.Entity.EntityState.Modified;
var recsAffected = db.SaveChanges();
RecalcLineItemTotal(purchaseRequestLineitem.PurchaseRequestId);
return(new JsonResponse {
Message = "PurchaseRequestLineitem change successful!", Data = purchaseRequestLineitem
});
}
// POST: PurchaseRequestLineitems/Change
public ActionResult Change([FromBody] PurchaseRequestLineitem purchaseRequestLineitem)
{
if (!ModelState.IsValid || purchaseRequestLineitem.Quantity == 0)
{
var errorMessages = ModelStateErrors.GetModelStateErrors(ModelState);
return(new JsonNetResult {
Data = new Msg {
Result = "Failed", Message = "ModelState invalid.", Data = errorMessages
}
});
}
var purchaseRequest2 = db.PurchaseRequestLineitems.Find(purchaseRequestLineitem.Id);
purchaseRequest2.Copy(purchaseRequestLineitem);
try {
db.SaveChanges();
CalculatePurchaseRequestTotal(purchaseRequestLineitem.PurchaseRequestId);
} catch (Exception ex) {
return(new JsonNetResult {
Data = new Msg {
Result = "Failed", Message = ex.Message
}
});
}
return(new JsonNetResult {
Data = new Msg {
Result = "Success", Message = "Changed."
}
});
}
public JsonResponse Create(PurchaseRequestLineitem purchaseRequestLineitem)
{
if (purchaseRequestLineitem == null)
{
return new JsonResponse {
Code = -100, Message = $"purchaseRequestLineitem cannot be null"
}
}
;
if (!ModelState.IsValid)
{
return new JsonResponse {
Code = -200, Message = $"ModelState is invalid", Error = ModelState
}
}
;
db.PurchaseRequestLineitems.Add(purchaseRequestLineitem);
var recsAffected = db.SaveChanges();
RecalcLineItemTotal(purchaseRequestLineitem.PurchaseRequestId);
return(new JsonResponse {
Message = "PurchaseRequestLineitem create successful!", Data = purchaseRequestLineitem
});
}
public ActionResult DeleteConfirmed(int id)
{
PurchaseRequestLineitem purchaseRequestLineitem = db.PurchaseRequestLineitems.Find(id);
db.PurchaseRequestLineitems.Remove(purchaseRequestLineitem);
db.SaveChanges();
return(RedirectToAction("Index"));
}
static void run()
{
//var pEchoDot = new Product {
// Name = "Echo Dot",
// PartNumber = "EDOT",
// Price = 39.99,
// Unit = "Each",
// PhotoPath = null,
// VendorId = 1,
// Vendor = null
//};
//db.Products.Add(pEchoDot);
//db.SaveChanges();
var products = db.Products.ToList();
var product = products[0];
var vendorName = product.Vendor.Name;
List <User> users = db.Users.ToList();
User user = db.Users.Find(1);
User nouser = db.Users.Find(111);
User adduser = new User {
Username = "******",
Password = "******",
Firstname = "Greg",
Lastname = "Doud",
Phone = "513-555-1212",
Email = "*****@*****.**",
Active = true,
IsAdmin = false,
IsReviewer = false
};
//User addedUser = db.Users.Add(adduser);
//db.SaveChanges();
//db = new PrsDbContext();
//var pr1 = new PurchaseRequest {
// Description = "First PR",
// Justification = "",
// DeliveryMode = "Pickup",
// UserId = db.Users.SingleOrDefault(u => u.Username == "gdoud").Id
//};
//db.PurchaseRequests.Add(pr1);
//db.SaveChanges();
var prli1 = new PurchaseRequestLineitem {
PurchaseRequestId = db.PurchaseRequests.SingleOrDefault(pr => pr.Description == "First PR").Id,
ProductId = db.Products.SingleOrDefault(p => p.PartNumber == "Echo").Id,
Quantity = 1
};
db.PurchaseRequestLineitems.Add(prli1);
db.SaveChanges();
}
public ActionResult Edit([Bind(Include = "Id,PurchaseRequestId,ProductId,Quantity")] PurchaseRequestLineitem purchaseRequestLineitem)
{
if (ModelState.IsValid)
{
db.Entry(purchaseRequestLineitem).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductId = new SelectList(db.Products, "Id", "PartNumber", purchaseRequestLineitem.ProductId);
ViewBag.PurchaseRequestId = new SelectList(db.PurchaseRequests, "Id", "Description", purchaseRequestLineitem.PurchaseRequestId);
return(View(purchaseRequestLineitem));
}
public ActionResult Create([Bind(Include = "Id,PurchaseRequestId,ProductId,Quantity")] PurchaseRequestLineitem purchaseRequestLineitem)
{
if (ModelState.IsValid)
{
purchaseRequestLineitem.PurchaseRequestId = (int)TempData["PurchaseRequestId"];
db.PurchaseRequestLineitems.Add(purchaseRequestLineitem);
db.SaveChanges();
return(RedirectToAction("Lines", new { prid = purchaseRequestLineitem.PurchaseRequestId }));
}
ViewBag.ProductId = new SelectList(db.Products, "Id", "PartNumber", purchaseRequestLineitem.ProductId);
ViewBag.PurchaseRequestId = new SelectList(db.PurchaseRequests, "Id", "Description", purchaseRequestLineitem.PurchaseRequestId);
return(View(purchaseRequestLineitem));
}
// GET: PurchaseRequestLineitems/Details/5
public ActionResult Details(int?prid, int?id)
{
if (id == null || prid == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PurchaseRequestLineitem purchaseRequestLineitem = db.PurchaseRequestLineitems.Find(id);
if (purchaseRequestLineitem == null)
{
return(HttpNotFound());
}
return(View(purchaseRequestLineitem));
}
// GET: PurchaseRequestLineitems/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PurchaseRequestLineitem purchaseRequestLineitem = db.PurchaseRequestLineitems.Find(id);
if (purchaseRequestLineitem == null)
{
return(HttpNotFound());
}
ViewBag.ProductId = new SelectList(db.Products, "Id", "PartNumber", purchaseRequestLineitem.ProductId);
ViewBag.PurchaseRequestId = new SelectList(db.PurchaseRequests, "Id", "Description", purchaseRequestLineitem.PurchaseRequestId);
return(View(purchaseRequestLineitem));
}
public JsonResponse Remove(PurchaseRequestLineitem purchaseRequestLineitem)
{
if (purchaseRequestLineitem == null)
{
return new JsonResponse {
Code = -100, Message = $"purchaseRequestLineitem cannot be null"
}
}
;
db.PurchaseRequestLineitems.Attach(purchaseRequestLineitem);
db.Entry(purchaseRequestLineitem).State = System.Data.Entity.EntityState.Deleted;
var recsAffected = db.SaveChanges();
RecalcLineItemTotal(purchaseRequestLineitem.PurchaseRequestId);
return(new JsonResponse {
Message = "PurchaseRequestLineitem remove successful!", Data = purchaseRequestLineitem
});
}
}