public static int Insert(string Title, int ParentID) { using (var dbe = new inventorymanagementEntities()) { tbl_PostCategory ui = new tbl_PostCategory(); ui.Title = Title; ui.ParentID = ParentID; dbe.tbl_PostCategory.Add(ui); int kq = dbe.SaveChanges(); return ui.ID; } }
public static tbl_PostCategory GetByID(int ID) { using (var dbe = new inventorymanagementEntities()) { tbl_PostCategory ai = dbe.tbl_PostCategory.Where(a => a.ID == ID).SingleOrDefault(); if (ai != null) { return ai; } else return null; } }
public static tbl_PostCategory GetByName(string name) { using (var dbe = new inventorymanagementEntities()) { tbl_PostCategory ai = dbe.tbl_PostCategory.Where(a => a.Title == name).SingleOrDefault(); if (ai != null) { return(ai); } else { return(null); } } }
public static string Update(int ID, string Title, int ParentID) { using (var dbe = new inventorymanagementEntities()) { tbl_PostCategory ui = dbe.tbl_PostCategory.Where(a => a.ID == ID).SingleOrDefault(); if (ui != null) { ui.Title = Title; ui.ParentID = ParentID; int kq = dbe.SaveChanges(); return kq.ToString(); } else return null; } }