public int Create(RPT_User data)
{
using (ReportEntities db = new ReportEntities())
{
db.RPT_User.Add(data);
return(db.SaveChanges());
}
}
public int Delete(int id)
{
using (ReportEntities db = new ReportEntities())
{
var item = db.RPT_User.FirstOrDefault(p => p.ID == id);
if (item != null)
{
db.RPT_User.Remove(item);
}
return(db.SaveChanges());
}
}
public int Delete(int id)
{
using (ReportEntities db = new ReportEntities())
{
var exsit = db.RPT_Menu.FirstOrDefault(p => p.ID == id);
if (exsit != null)
{
db.RPT_Menu.Remove(exsit);
}
return(db.SaveChanges());
}
}
public int Update(RPT_Menu data)
{
using (ReportEntities db = new ReportEntities())
{
var exsit = db.RPT_Menu.FirstOrDefault(p => p.MenuID == data.MenuID);
if (exsit != null)
{
int id = exsit.ID;
exsit.CopyFrom(data);
exsit.ID = id;
}
return(db.SaveChanges());
}
}
public int Update(RPT_User data)
{
using (ReportEntities db = new ReportEntities())
{
var item = db.RPT_User.FirstOrDefault(p => p.UserAccount == data.UserAccount);
//item.UserName = data.UserName;
//return db.SaveChanges();
if (item != null)
{
item.UserName = data.UserName;
item.IsActive = data.IsActive;
item.Password = data.Password;
}
return(db.SaveChanges());
}
}
