public bool Add(User suser)
{
int isExecuted = 0;
db.Users.Add(suser);
isExecuted = db.SaveChanges();
if (isExecuted > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Add(Category sCategory)
{
int isExecuted = 0;
db.Categories.Add(sCategory);
isExecuted = db.SaveChanges();
if (isExecuted > 0)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult Register(User user)
{
if (ModelState.IsValid)
{
using (SBMS_DBContext db = new SBMS_DBContext())
{
var get_user = db.Users.FirstOrDefault(p => p.UserName == user.UserName);
if (get_user == null)
{
user.Password = user.Password;
db.Users.Add(user);
db.SaveChanges();
}
else
{
ViewBag.Message = "UserName already exists";
return(View());
}
}
ModelState.Clear();
ViewBag.Message = "Successfully Registered Mr. " +
user.FullName;
}
return(RedirectToAction("Login"));
}
public ActionResult AddOrEdit(Product product)
{
using (SBMS_DBContext db = new SBMS_DBContext())
{
if (product.Id == 0)
{
db.Products.Add(product);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult AddOrEdit(Customer customer)
{
using (SBMS_DBContext db = new SBMS_DBContext())
{
if (customer.ClietId == 0)
{
db.Customers.Add(customer);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult Delete(int id)
{
using (SBMS_DBContext db = new SBMS_DBContext())
{
Customer customer = db.Customers.Where(x => x.ClietId == id).FirstOrDefault <Customer>();
db.Customers.Remove(customer);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
