public ActionResult Index(string username, string password)
{
Login login = db.Logins.Where(u => u.U_Name.Equals(username) && u.Password.ToString() == password).FirstOrDefault();
if (login != null)
{
Session["U_Name"] = login.U_Name.ToString();
Session["Password"] = login.Password.ToString();
Session["Role"] = login.Role.ToString();
if (login.Role.ToString().Equals("SalesPerson"))
{
Salespersondetail sp = db.Salespersondetails.Where(x => x.Salesperson.ToLower().Equals(login.U_Name.ToLower())).FirstOrDefault();
if (sp != null)
{
Session["Totalsale"] = sp.Totalsale.ToString();
Session["Loginammount"] = sp.Loginammount.ToString();
Session["Logoutammount"] = sp.Logoutammount.ToString();
}
}
return(RedirectToAction("Index", "Home"));
}
ViewBag.Error = "Invalid login credentials.";
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 ActionResult SalePersonSearch(string itemNo)
{
Salespersondetail item = db.Salespersondetails.FirstOrDefault(i => i.Salesperson == itemNo);
if (item != null)
{
return(View("SalePersonDetails", item));
}
ViewBag.SearchError = "Sale Person '" + itemNo + "' not found.";
return(View("SalePersonDetails"));
}
public ActionResult SalePersonDetails(Salespersondetail newItem)
{
try
{
Salespersondetail item = db.Salespersondetails.Find(newItem.Salesperson);
}
catch (Exception ex)
{
ViewBag.salepersonfound = "sale person found.";
}
return(View());
}
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 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));
}
}
