public HttpResponseMessage ModifyItem(Item item)
{
try
{
var origional = db.Items.Find(item.Item_No);
db.Entry(origional).CurrentValues.SetValues(item);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Item is Modified"));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public HttpResponseMessage UpdateDrawer(Drawer drawer)
{
try
{
var x = db.Drawers.FirstOrDefault(xn => xn.Counter_name == drawer.Counter_name);
x.Drawer_amount = drawer.Drawer_amount;
db.Entry(x).State = EntityState.Modified;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, x));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public ActionResult AddStock(Item newItem)
{
try
{
Item item = db.Items.Find(newItem.Item_No);
if (item == null)
{
ViewBag.Error = "This item does not exist.";
}
else
{
db.Items.Attach(item);
item.Quantity += newItem.Quantity;
db.Entry(item).Property(i => i.Quantity).IsModified = true;
db.SaveChanges();
db.Stock_Detail.Add(new Stock_Detail
{
Date = DateTime.Now,
Time = DateTime.Now.ToString(),
Itemno = item.Item_No,
Quantity = item.Quantity,
});
db.SaveChanges();
ViewBag.Success = "Updated successfully.";
}
}
catch (Exception ex)
{
ViewBag.Error = "Failed to Update Stock.";
}
return(View());
}
public HttpResponseMessage Sale(Sales_Detail sale)
{
try
{
var dt = sale.Sale_Date;
db.Sales_Detail.Add(sale);
var x = db.Items.FirstOrDefault(xn => xn.Item_No == sale.Item_No);
x.Quantity = x.Quantity - sale.Item_Quantity;
db.Entry(x).State = EntityState.Modified;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, sale));
}catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public HttpResponseMessage MakeSale(List <Sales_Detail> saleDetail)
{
try {
var lastSale = db.Sales_Detail.OrderByDescending(s => s.id).FirstOrDefault();
int id = 1;
Salespersondetail spd = db.Salespersondetails.Where(x => x.Salesperson == lastSale.Saleperson).FirstOrDefault();
spd.Totalsale = spd.Totalsale += 1;
saleDetail.ForEach(x => {
spd.Loginammount = spd.Loginammount + (x.Price * x.Item_Quantity);
});
db.SaveChanges();
if (lastSale != null)
{
id = lastSale.id + 1;
}
saleDetail.ForEach(s => {
s.Sale_Id = id;
Item i = db.Items.Where(x => x.Item_No == s.Item_No).FirstOrDefault();
db.Items.Attach(i);
i.Quantity = i.Quantity - s.Item_Quantity;
db.Entry(i).Property(x => x.Quantity).IsModified = true;
db.Sales_Detail.Add(s);
db.SaveChanges();
});
return(Request.CreateResponse(HttpStatusCode.OK, "Sale done."));
} catch (Exception ex) {
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public HttpResponseMessage AddStock(Stock_Detail stockdetail)
{
try
{
var x = db.Items.Find(stockdetail.Itemno);
if (x == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
else
{
x.Quantity = x.Quantity + stockdetail.Quantity;
db.Entry(x).State = EntityState.Modified;
var abc = stockdetail;
db.Stock_Detail.Add(stockdetail);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, x));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
