public ActionResult AddItem(int BID, float Price)
{
if (string.IsNullOrEmpty(Convert.ToString(Session["CompanyID"])))
{
return(RedirectToAction("Login", "Home"));
}
var find = db.PurchaseDetailTables.Where(i => i.BookID == BID).FirstOrDefault();
if (find == null)
{
if (BID > 0 && Price > 0)
{
var newitem = new PurchaseDetailTable()
{
BookID = BID,
Qty = Qty,
UnitPrice = Price
};
db.PurchaseDetailTables.Add(newitem);
db.SaveChanges();
ViewBag.Message = "Book Add Successfuly";
}
}
else
{
ViewBag.Message = "Alredy Exist plz Check";
}
return(RedirectToAction("NewPurchase"));
}
public ActionResult DeleteConfirmed(int id)
{
PurchaseDetailTable purchaseDetailTable = db.PurchaseDetailTables.Find(id);
db.PurchaseDetailTables.Remove(purchaseDetailTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "PurchaseDetailID,BookID,PurchaseID,Qty,UnitPrice")] PurchaseDetailTable purchaseDetailTable)
{
if (ModelState.IsValid)
{
db.Entry(purchaseDetailTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BookID = new SelectList(db.BookTables, "BookID", "BookTitle", purchaseDetailTable.BookID);
ViewBag.PurchaseID = new SelectList(db.PurchaseTables, "PurchaseID", "PurchaseID", purchaseDetailTable.PurchaseID);
return(View(purchaseDetailTable));
}
// GET: PurchaseDetailTables/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PurchaseDetailTable purchaseDetailTable = db.PurchaseDetailTables.Find(id);
if (purchaseDetailTable == null)
{
return(HttpNotFound());
}
return(View(purchaseDetailTable));
}
// GET: PurchaseDetailTables/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PurchaseDetailTable purchaseDetailTable = db.PurchaseDetailTables.Find(id);
if (purchaseDetailTable == null)
{
return(HttpNotFound());
}
ViewBag.BookID = new SelectList(db.BookTables, "BookID", "BookTitle", purchaseDetailTable.BookID);
ViewBag.PurchaseID = new SelectList(db.PurchaseTables, "PurchaseID", "PurchaseID", purchaseDetailTable.PurchaseID);
return(View(purchaseDetailTable));
}
public ActionResult PurchaseConfirm(FormCollection collection)
{
if (string.IsNullOrEmpty(Convert.ToString(Session["UserID"])))
{
return(RedirectToAction("Login", "Home"));
}
int userid = Convert.ToInt32(Convert.ToString(Session["UserID"]));
int supplierid = 0;
string[] keys = collection.AllKeys;
foreach (var name in keys)
{
if (name.Contains("name"))
{
string idname = name;
string[] valueids = idname.Split(' ');
supplierid = Convert.ToInt32(valueids[1]);
}
}
var purchasedetails = db.PurTemDetailsTables.ToList();
double totalamount = 0;
foreach (var item in purchasedetails)
{
totalamount = totalamount + (item.Qty * item.UnitPrice);
}
if (totalamount == 0)
{
ViewBag.Message = "Zamówienie jest puste";
return(View("NewPurchase"));
}
var purchaseheader = new PurchaseTable();
purchaseheader.SupplierID = supplierid;
purchaseheader.PurchaseDate = DateTime.Now;
purchaseheader.PurchaseAmount = totalamount;
purchaseheader.UserID = userid;
db.PurchaseTables.Add(purchaseheader);
db.SaveChanges();
foreach (var item in purchasedetails)
{
var purdetails = new PurchaseDetailTable()
{
BookID = item.BookID,
PurchaseID = purchaseheader.PurchaseID,
Qty = item.Qty,
UnitPrice = item.UnitPrice
};
db.PurchaseDetailTables.Add(purdetails);
db.SaveChanges();
var updatebookstock = db.BookTables.Find(item.BookID);
updatebookstock.TotalCopies = updatebookstock.TotalCopies + item.Qty;
updatebookstock.Price = item.UnitPrice;
db.Entry(updatebookstock).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
ViewBag.Message = "Zamówiono pomyślnie";
return(RedirectToAction("AllPurchase"));
}
