public static CategoryViewModel DeleteCategory(int id)
{
CategoryViewModel model = new CategoryViewModel();
try
{
using (SampleCodeEntities db = new SampleCodeEntities())
{
Category CT = db.Categories.Where(x => x.Id == id).FirstOrDefault();
db.Categories.Remove(CT);
if (db.SaveChanges() > 0)
{
model.ErrorCode = "success";
model.ErrorMessage = "Category deleted successfully.";
}
else
{
model.ErrorCode = "Error";
model.ErrorMessage = "Error";
}
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
return(model);
}
public static CategoryViewModel AddCategory(CategoryViewModel model)
{
try
{
using (SampleCodeEntities db = new SampleCodeEntities())
{
if (!IsCheckExistsCategory(model.objModel.Name, model.objModel.Type))
{
Category C = new Category
{
Name = model.objModel.Name,
TypeId = model.objModel.TypeId
};
db.Categories.Add(C);
if (db.SaveChanges() > 0)
{
model.ErrorCode = "Success";
model.ErrorMessage = "Category created successfully.";
}
else
{
model.ErrorCode = "Error";
model.ErrorMessage = "Name and Type already Exists!";
}
}
}
}
catch (Exception ex)
{
ex.Message.ToString();
model.ErrorCode = "Error";
model.ErrorMessage = ex.Message;
}
return(model);
}
public ActionResult Update(CustomerViewModel model)
{
// CustomerViewModel model = new CustomerViewModel();
using (SampleCodeEntities db = new SampleCodeEntities())
{
var custinfo = db.Customers.Where(x => x.Id == model.objModel.CustomerId).FirstOrDefault();
custinfo.FirstName = model.objModel.FirstName;
custinfo.LastName = model.objModel.LastName;
custinfo.Emailaddress = model.objModel.Emailaddress;
custinfo.CompanyName = model.objModel.CompanyName;
custinfo.Country = model.objModel.Country;
custinfo.ContactNo = model.objModel.ContactNo;
custinfo.URL = model.objModel.URL;
custinfo.ContactPerson = model.objModel.ContactPerson;
custinfo.Designation = model.objModel.Designation;
if (db.SaveChanges() > 0)
{
return(RedirectToAction("CustomerList"));
}
}
return(View(model));
}