public RPT_Menu GetData(int id)
{
using (ReportEntities db = new ReportEntities())
{
return(db.RPT_Menu.FirstOrDefault(p => p.ID == id));
}
}
public int Create(RPT_User data)
{
using (ReportEntities db = new ReportEntities())
{
db.RPT_User.Add(data);
return(db.SaveChanges());
}
}
public RPT_User GetUser(string userAccount)
{
using (ReportEntities db = new ReportEntities())
{
var item = db.RPT_User.FirstOrDefault(p => p.UserAccount == userAccount);
return(item);
}
}
public RPT_User GetData(int id)
{
using (ReportEntities db = new ReportEntities())
{
var item = db.RPT_User.FirstOrDefault(p => p.ID == id);
return(item);
}
}
public IEnumerable <RPT_User> GetList(string txtSearch = "")
{
using (ReportEntities db = new ReportEntities())
{
var item = db.RPT_User.Where(p => txtSearch == "" || p.UserAccount.Contains(txtSearch) || p.UserName.Contains(txtSearch)).ToList();
return(item);
}
}
public IEnumerable <RPT_Menu> GetList()
{
using (ReportEntities db = new ReportEntities())
{
var data = db.RPT_Menu.ToList();
return(data);
}
}
public IEnumerable <RPT_User> GetList(string txtSearch, int PageNumber, int PageSize, out int total)
{
using (ReportEntities db = new ReportEntities())
{
var item = db.RPT_User.Where(p => txtSearch == "" || p.UserAccount.Contains(txtSearch) || p.UserName.Contains(txtSearch));
total = item.Count();
var data = item.OrderBy(p => p.UserAccount).Skip((PageNumber - 1) * PageSize).Take(PageSize);
return(data.ToList());
}
}
public IEnumerable <RPT_Company> GetList(string txtSearch, int pageNumber, int pageSize, out int total)
{
using (ReportEntities db = new ReportEntities())
{
var data = db.RPT_Company.Where(p => txtSearch == "" || p.CompanyCode.Contains(txtSearch) || p.CompanyName.Contains(txtSearch) || p.CompanyAddress.Contains(txtSearch));
total = data.Count();
data = data.OrderBy(p => p.ID).Skip((pageNumber - 1) * pageSize).Take(pageSize);
return(data.ToList());
}
}
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());
}
}