public ActionResult EditCategory(Guid? categoryID)
{
List<SelectListItem> listLevelCategory = new List<SelectListItem>();
listLevelCategory.Add(new SelectListItem { Text = "Mức 1", Value = "1" });
listLevelCategory.Add(new SelectListItem { Text = "Mức 2", Value = "2" });
//listLevelCategory.Add(new SelectListItem { Text = "Mức 3", Value = "3" });
ViewData["ListLevelCategory"] = listLevelCategory;
if (categoryID.HasValue && !categoryID.Value.Equals(Guid.Empty))
{
tblCategory tblCategory = new tblCategory();
tblCategory = Service.GetCategoryByID((Guid)categoryID);
return View("Admin/EditCategory", tblCategory);
}
else
{
tblCategory tblCategory = new tblCategory();
return View("Admin/EditCategory", tblCategory);
}
}
public void InsertCategory(tblCategory tblnew)
{
_da.InsertCategory(tblnew);
}
public void UpdateCategory(tblCategory tblnew)
{
_da.UpdateCategory(tblnew);
}
public void InsertCategory(tblCategory tblnew)
{
if (tblnew != null && tblnew.ID != null && !tblnew.ID.Equals(Guid.Empty))
{
tblnew.CreatedDate = DateTime.Now;
//todo: auto increment catagoryNo
tblnew.CategoryNo = "1";
_dataContext.tblCategories.InsertOnSubmit(tblnew);
_dataContext.SubmitChanges();
}
}
public void UpdateCategory(tblCategory tblcategory)
{
if (tblcategory != null && tblcategory.ID != null && !tblcategory.ID.Equals(Guid.Empty))
{
var query = _dataContext.tblCategories.Where("ID.ToString()=@0", tblcategory.ID.ToString());
if (query != null && query.ToList().Count > 0)
{
query.First().CategoryName = tblcategory.CategoryName;
query.First().CategoryName = tblcategory.CategoryName;
query.First().Description = tblcategory.Description;
query.First().Description = tblcategory.Description;
query.First().UpdatedDate = DateTime.Now;
_dataContext.SubmitChanges();
}
}
}
private void detach_tblCategories(tblCategory entity)
{
this.SendPropertyChanging();
entity.tblCategory1 = null;
}
private void attach_tblCategories(tblCategory entity)
{
this.SendPropertyChanging();
entity.tblCategory1 = this;
}
partial void DeletetblCategory(tblCategory instance);
partial void UpdatetblCategory(tblCategory instance);
partial void InserttblCategory(tblCategory instance);
