public ActionResult AddNewItem(Item item)
{
try
{
db.Items.Add(item);
db.SaveChanges();
ViewBag.Success = "Item has been added.";
}
catch (Exception ex)
{
ViewBag.Error = "Failed to save item.";
}
return(View());
}
public ActionResult Logout()
{
if (Session["Role"].ToString().Equals("SalesPerson"))
{
var str = Session["U_Name"].ToString();
Salespersondetail sp = db.Salespersondetails.FirstOrDefault(x => x.Salesperson.ToLower() == str.ToLower());
sp.Logoutammount = sp.Loginammount;
db.SaveChanges();
}
Session.Abandon();
return(RedirectToAction("Index", "Login"));
}
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 Addsalespersondetail(Salespersondetail salespersondetail2)
{
try
{
db.Salespersondetails.Add(salespersondetail2);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, salespersondetail2));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public HttpResponseMessage AddItem(Item item)
{
try
{
var x = db.Items.Find(item.Item_No);
if (x == null)
{
db.Items.Add(item);
db.SaveChanges();
var Item = db.Items.FirstOrDefault(i => i.Item_No == item.Item_No);
return(Request.CreateResponse(HttpStatusCode.OK, Item));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Found, "Item already exist"));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
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 PutDraweramount(DrawerAmount draweramount)
{
try
{
var x = db.DrawerAmounts.Add(draweramount);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Data added successfully! " + x));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public ActionResult Index(int?amount, string user)
{
POS_InventoryEntities1 db = new POS_InventoryEntities1();
List <Salespersondetail> sps = db.Salespersondetails.ToList();
sps.ForEach(x =>
{
x.Loginammount = amount;
});
db.SaveChanges();
var users = db.Logins.ToList();
ViewBag.Users = users;
return(RedirectToAction("Index", "Home"));
}
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));
}
}
