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