public ActionResult DeleteConfirmed(int id)
{
tcProductSale tcProductSale = db.tcProductSales.Find(id);
db.tcProductSales.Remove(tcProductSale);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,ProductId,Quantity,Price,BillId")] tcProductSale tcProductSale)
{
if (ModelState.IsValid)
{
db.Entry(tcProductSale).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BillId = new SelectList(db.tcBills, "Id", "ClientId", tcProductSale.BillId);
ViewBag.ProductId = new SelectList(db.tcProducts, "Id", "Name", tcProductSale.ProductId);
return(View(tcProductSale));
}
// GET: tcProductSales/Delete/5
public ActionResult Delete(int?id)
{
if (IsAllowed() == false)
{
return(RedirectToAction("Index", "Login"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tcProductSale tcProductSale = db.tcProductSales.Find(id);
if (tcProductSale == null)
{
return(HttpNotFound());
}
return(View(tcProductSale));
}
// GET: tcProductSales/Edit/5
public ActionResult Edit(int?id)
{
if (IsAllowed() == false)
{
return(RedirectToAction("Index", "Login"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tcProductSale tcProductSale = db.tcProductSales.Find(id);
if (tcProductSale == null)
{
return(HttpNotFound());
}
ViewBag.BillId = new SelectList(db.tcBills, "Id", "ClientId", tcProductSale.BillId);
ViewBag.ProductId = new SelectList(db.tcProducts, "Id", "Name", tcProductSale.ProductId);
return(View(tcProductSale));
}
public string PostSale(string sale)
{
var billId = NewBill();
var lines = sale.Split('!');
foreach (var item in lines)
{
var fields = item.Split(',');
var sl = new tcProductSale()
{
ProductId = int.Parse(fields[0]),
Quantity = int.Parse(fields[1]),
Price = Convert.ToDecimal(fields[2]),
BillId = billId
};
db.tcProductSales.Add(sl);
var product = db.tcProducts.Find(sl.ProductId);
product.Stock = product.Stock - sl.Quantity;
db.Entry(product).State = EntityState.Modified;
}
db.SaveChanges();
return(billId.ToString());
}
void DeleteProductSale(tcProductSale item)
{
db.tcProductSales.Remove(item);
}
public tcBill GetBillDetails(int id)
{
var bill = db.tcBills.Find(id);
var products = new List <tcProductSale>();
foreach (var item in bill.tcProductSales)
{
var p = new tcProductSale()
{
Id = item.Id, BillId = item.Id, Price = item.Price, ProductId = item.ProductId, Quantity = item.Quantity, tcProduct = new tcProduct()
{
Name = item.tcProduct.Name
}
};
products.Add(p);
}
var services = new List <tcServiceSale>();
foreach (var item in bill.tcServiceSales)
{
var s = new tcServiceSale()
{
Id = item.Id, BillId = item.BillId, Price = item.Price, Quantity = item.Quantity, ServiceId = item.ServiceId, tcService = new tcService()
{
Name = item.tcService.Name
}
};
services.Add(s);
}
var payments = new List <tcClientDetail>();
foreach (var item in bill.tcClientDetails)
{
var p = new tcClientDetail()
{
BillId = item.BillId,
ClientId = item.ClientId,
Id = item.Id,
Credit = item.Credit,
Payment = item.Payment,
PaymentMethod = item.PaymentMethod
};
payments.Add(p);
}
var result = new tcBill()
{
Id = bill.Id,
ClientId = bill.ClientId,
tcClient = new tcClient()
{
Id = bill.ClientId, Name = bill.tcClient.Name, Group = bill.tcClient.Group
},
IsCredit = bill.IsCredit,
PaymentMethod = bill.PaymentMethod,
User = bill.User,
tcProductSales = products,
tcServiceSales = services,
tcClientDetails = payments
};
return(result);
}
