public IActionResult AddToBill(CustomModelBag modelBag)
{
var query = from u in billdetails where u.ProductId == modelBag.BillDetails.ProductId select u;
if (query.Count() != 0)
{
return(RedirectToAction("Index"));
}
var products = db.Product.ToList();
ViewBag.Products = products;
foreach (var p in products)
{
if (p.ProductId == modelBag.BillDetails.ProductId)
{
modelBag.BillDetails.Amount = Convert.ToInt32(modelBag.BillDetails.Quantity) * Convert.ToInt32(p.Rate);
modelBag.TotalAmount += modelBag.BillDetails.Amount;
TotalAmount += modelBag.TotalAmount;
}
}
billdetails.Add(modelBag.BillDetails);
ViewBag.BillDetails = billdetails.ToList();
ViewBag.Total = modelBag.TotalAmount;
return(RedirectToAction("Index"));
}
public IActionResult SaveBill(CustomModelBag modelBag)
{
int outletId = int.Parse(User.Claims.FirstOrDefault(x => x.Type == ClaimTypes.Actor)?.Value);
int staffid = int.Parse(User.Claims.FirstOrDefault(x => x.Type == ClaimTypes.PrimarySid)?.Value);
Bill newbill = new Bill();
newbill.BillId = (int)DateTime.Now.GetHashCode();
newbill.Date = DateTime.Now;
newbill.TotalPayable = TotalAmount;
newbill.PaymentMethod = "Sold";
newbill.StaffId = staffid;
newbill.BuyerId = BuyerId;
db.Bill.Add(newbill);
db.SaveChanges();
BillDetails billDetails = new BillDetails();
foreach (var item in billdetails)
{
billDetails.Id = DateTime.Now.GetHashCode() + staffid.GetHashCode();
billDetails.BillId = newbill.BillId;
billDetails.ProductId = item.ProductId;
billDetails.Quantity = item.Quantity;
billDetails.Amount = item.Amount;
db.BillDetails.Add(billDetails);
db.SaveChanges();
}
billdetails.Clear();
TotalAmount = 0;
return(RedirectToAction("Index"));
}
public IActionResult EditProduct(int Id)
{
CustomModelBag modelBag = new CustomModelBag();
modelBag.NewProduct = db.Product.Where(s => s.ProductId == Id).FirstOrDefault();
modelBag.NewProduct.Spec = db.Spec.Where(sp => sp.ProdId == Id).ToList();
ViewBag.Categories = db.Category.ToList();
return(View("EditProduct", modelBag));
}
public IActionResult AddProductSubmit(CustomModelBag modelBag)
{
modelBag.NewProduct.Cat_Id = db.Category.Where(w => w.Name == modelBag.NewProduct.ProductCat.Name).FirstOrDefault().Cat_Id;
db.Product.Add(modelBag.NewProduct);
foreach (var spec in modelBag.NewProduct.Spec)
{
spec.ProdId = modelBag.NewProduct.ProductId;
db.Spec.Add(spec);
}
db.SaveChanges();
return(RedirectToAction("ViewProduct"));
}
//public async Task<IActionResult> ViewStaff(int? id)
//{
// if (id == null)
// {
// return NotFound();
// }
// var staf = await _context.Staff
// .Include(e => e.Role)
// .Include(e => e.Name)
// .Include(e => e.PhoneNumber)
// .FirstOrDefaultAsync(m => m.Id == id);
// if (staf == null)
// {
// return NotFound();
// }
// return View(staf);
//}
public IActionResult AddProduct()
{
CustomModelBag modelBag = new CustomModelBag();
Product product = new Product();
Spec spec = new Spec();
product.Spec = new List <Spec>();
product.Spec.Add(spec);
modelBag.NewProduct = product;
ViewBag.Categories = db.Category.ToList();
return(View("AddProduct", modelBag));
}
public IActionResult ViewProduct()
{
List <Product> products = db.Product.ToList();
for (int i = 0; i < products.Count(); i++)
{
products[i].ProductCat = db.Category.Where(s => s.Cat_Id == products[i].Cat_Id).FirstOrDefault();
products[i].Spec = db.Spec.Where(sp => sp.ProdId == products[i].ProductId).ToList();
}
CustomModelBag modelBag = new CustomModelBag();
modelBag.Product = products;
return(View("ViewProduct", modelBag));
}
public IActionResult UpdateProductSpec(CustomModelBag modelBag)
{
Spec spec = new Spec();
modelBag.NewProduct.Spec.Add(spec);
ViewBag.Categories = db.Category.ToList();
if (modelBag.NewProduct.Cat_Id <= 0)
{
return(View("AddProduct", modelBag));
}
else
{
return(View("ViewProduct", modelBag));
}
}
public IActionResult CustomerDetails()
{
ViewBag.BillDetails = billdetails.ToList();
var products1 = db.Product.ToList();
ViewBag.Products = products1;
CustomModelBag modelBag = new CustomModelBag();
ViewBag.BillProducts = db.Product.ToList();
int outletId = int.Parse(User.Claims.FirstOrDefault(x => x.Type == ClaimTypes.Actor)?.Value);
var products = db.LocalInventory.Where(s => s.OutletId == outletId);
ViewData["ProductId"] = new SelectList(db.LocalInventory.Where(s => s.OutletId == outletId), "ProductId", "ProductId", products);
return(View());
}
public IActionResult BillProcess(CustomModelBag modelBag)
{
ViewBag.BillDetails = billdetails.ToList();
var products1 = db.Product.ToList();
ViewBag.Products = products1;
modelBag.BillProducts = db.Product.ToList();
int userId = int.Parse(User.Claims.FirstOrDefault(x => x.Type == ClaimTypes.PrimarySid)?.Value);
modelBag.Buyer = FindCustomerByPhone(modelBag.Buyer.BuyerPhone);
BuyerId = modelBag.Buyer.BuyerId;
ViewBag.Customer = modelBag.Buyer;
int outletId = int.Parse(User.Claims.FirstOrDefault(x => x.Type == ClaimTypes.Actor)?.Value);
var products = db.LocalInventory.Where(s => s.OutletId == outletId);
ViewData["ProductId"] = new SelectList(db.LocalInventory.Where(s => s.OutletId == outletId), "ProductId", "ProductId", products);
return(View("CustomerDetails", modelBag));
}
//public IActionResult ManageProducts()
//{
// CentralModel obj = new CentralModel
// {
// loopproducts = db.Product.ToList()
// };
// return View(obj);
//}
//[HttpPost]
//public IActionResult AddProductsFunction(CentralModel model)
//{
// db.Product.Add(model.productsdb);
// db.SaveChanges();
// return RedirectToAction("ManageProducts");
//}
//public IActionResult Outlet()
//{
// CentralModel obj = new CentralModel
// {
// loopoutelts = db.Outlet.ToList()
// };
// return View(obj);
//}
//private IActionResult GenerateNumbers()
//{
// List<SelectListItem> items = new List<SelectListItem>();
// var numbers = (from p in db.Outlet
// select p.Location,p.Id);
//}
public IActionResult UpdateProduct(CustomModelBag modelBag)
{
//Getting category id from category name
modelBag.NewProduct.Cat_Id = db.Category.Where(s => s.Name == modelBag.NewProduct.ProductCat.Name).FirstOrDefault().Cat_Id;
//creating temp product variable
Product temp = modelBag.NewProduct;
//Updating existing data;
Product product = db.Product.Find(modelBag.NewProduct.ProductId);
product.ProductName = temp.ProductName;
product.Company = temp.Company;
product.Cat_Id = temp.Cat_Id;
product.Rate = temp.Rate;
db.Product.Update(product);
foreach (var spec in temp.Spec)
{
Spec prodSpec = db.Spec.Find(spec.Id);
spec.ProdId = product.ProductId;
if (prodSpec == null)
{
db.Spec.Add(spec);
}
else
{
prodSpec.ProdId = spec.ProdId;
prodSpec.SpecName = spec.SpecName;
prodSpec.SpecValue = spec.SpecValue;
db.Spec.Update(prodSpec);
}
}
db.SaveChanges();
return(RedirectToAction("ViewProduct"));
}
