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;
}
}
