public List <SalesData> addSale(List <Sale> a)
{
List <SalesData> data = new List <SalesData>();
foreach (Sale i in a)
{
var x = e.Sales.Add(i);
var old = e.Stocks.Find(i.Stock_ID);
var New = old;
New.Available = New.Available - i.Quantity;
e.Entry(old).CurrentValues.SetValues(New);
e.SaveChanges();
SalesData d = new SalesData();
d.Id = x.Id;
d.Stock_ID = x.Stock_ID;
Stock s = e.Stocks.Find(d.Stock_ID);
d.Name = s.Name;
d.Bill_ID = x.Bill_ID;
d.Quantity = x.Quantity;
d.Total = x.Total;
data.Add(d);
}
return(data);
}
public List <SalesData> getSale(int i)
{
var a = e.Sales.Where(m => m.Bill_ID == i);
List <SalesData> l = new List <SalesData>();
foreach (Sale x in a)
{
SalesData d = new SalesData();
d.Id = x.Id;
d.Stock_ID = x.Stock_ID;
d.Name = x.Stock.Name;
d.Bill_ID = x.Bill_ID;
d.Quantity = x.Quantity;
d.Total = x.Total;
l.Add(d);
}
return(l);
}
public SalesData updateSale(Sale a)
{
Branch old = e.Branches.Where(
x => x.Id == a.Id).SingleOrDefault();
if (old != null)
{
e.Entry(old).CurrentValues.SetValues(a);
e.SaveChanges();
SalesData d = new SalesData();
d.Id = a.Id;
d.Stock_ID = a.Stock_ID;
d.Bill_ID = a.Bill_ID;
d.Name = a.Stock.Name;
d.Quantity = a.Quantity;
d.Total = a.Total;
}
return(null);
}
public List <SalesData> selectSaleperBranch(int id)
{
var a = e.Sales.Where(m => m.Bill.Branch_ID == id).ToList();
List <SalesData> l = new List <SalesData>();
foreach (Sale i in a)
{
SalesData d = new SalesData();
d.Id = i.Id;
d.Stock_ID = i.Stock_ID;
d.Name = i.Stock.Name;
d.Bill_ID = i.Bill_ID;
d.Quantity = i.Quantity;
d.Total = i.Total;
l.Add(d);
}
return(l);
}
public List <SalesData> selectSale()
{
var a = e.Sales.ToList();
List <SalesData> l = new List <SalesData>();
foreach (Sale i in a)
{
SalesData d = new SalesData();
d.Id = i.Id;
d.Stock_ID = i.Stock_ID;
d.Name = i.Stock.Name;
d.Bill_ID = i.Bill_ID;
d.Quantity = i.Quantity;
d.Total = i.Total;
l.Add(d);
}
return(l);
}
