public IEnumerable <RPT_Role> GetList(List <RPT_UserRole> RoleCode)
{
using (ReportEntities db = new ReportEntities())
{
int count = RoleCode.Count();
if (count == 0)
{
var Role = db.RPT_Role.ToList();
return(Role);
}
else
{
List <RPT_Role> Role = db.RPT_Role.ToList();
List <RPT_Role> Roledate = db.RPT_Role.ToList();
foreach (RPT_UserRole i in RoleCode)
{
foreach (RPT_Role j in Role)
{
if (i.RoleCode.Equals(j.RoleCode))
{
Roledate.Remove(j);
}
}
}
return(Roledate);
}
}
}
public RPT_Company GetData(int id)
{
using (ReportEntities db = new ReportEntities())
{
return(db.RPT_Company.FirstOrDefault(p => p.ID == id));
}
}
public RPT_Company GetData(string systemId)
{
using (ReportEntities db = new ReportEntities())
{
return(db.RPT_Company.FirstOrDefault(p => p.SystemID == systemId));
}
}
public List <RPT_Company> GetList()
{
using (ReportEntities db = new ReportEntities())
{
return(db.RPT_Company.ToList());
}
}
public int Update(string Account, string RoList, string CreateUser = "")
{
if (Account.Equals(""))
{
return(0);
}
using (ReportEntities db = new ReportEntities())
{
var items = db.RPT_UserRole.Where(p => p.UserAccount == Account);
if (items == null)
{
return(0);
}
foreach (var v in items)
{
db.RPT_UserRole.Remove(v);
}
string UserName = "";
if (CreateUser != "")
{
UserName = db.RPT_User.Where(p => p.UserAccount == Account).FirstOrDefault().UserName;
}
if (RoList.Equals(""))
{
return(0);
}
string[] sArray = RoList.Split(';');
RptRoleOP op = new RptRoleOP();
List <RPT_Role> RoleLst = op.GetList().ToList();
Hashtable data = new Hashtable();
foreach (string i in sArray)
{
foreach (RPT_Role j in RoleLst)
{
if (i.Equals(j.RoleCode))
{
data[i] = j.RoleName;
}
}
}
foreach (string i in sArray)
{
if (!i.Equals(""))
{
RPT_UserRole UserRole = new RPT_UserRole()
{
UserAccount = Account,
UserName = UserName,
RoleName = data[i].ToString(),
RoleCode = i,
CreateUser = CreateUser,
CreateTime = DateTime.Now
};
db.RPT_UserRole.Add(UserRole);
}
}
return(db.SaveChanges());
}
}
public RPT_Role GetDataByCode(string RoleCode)
{
using (ReportEntities db = new ReportEntities())
{
var item = db.RPT_Role.FirstOrDefault(p => p.RoleCode == RoleCode);
return(item);
}
}
public RPT_Role GetData(int id)
{
using (ReportEntities db = new ReportEntities())
{
var item = db.RPT_Role.FirstOrDefault(p => p.ID == id);
return(item);
}
}
public List <RPT_Menu> GetAllMenu()
{
using (ReportEntities db = new ReportEntities())
{
var item = db.RPT_Menu.OrderBy(p => p.ID);
return(item.ToList());
}
}
public IEnumerable <RPT_Role> GetList(string txtSearch = "")
{
using (ReportEntities db = new ReportEntities())
{
var item = db.RPT_Role.Where(p => txtSearch == "" || p.RoleName.Contains(txtSearch) || p.RoleDesc.Contains(txtSearch)).ToList();
return(item);
}
}
public bool Exists(string RoleCode)
{
using (ReportEntities db = new ReportEntities())
{
var item = db.RPT_Role.FirstOrDefault(p => p.RoleCode == RoleCode);
return(item != null);
}
}
public IEnumerable <RPT_Menu> GetList()
{
using (ReportEntities db = new ReportEntities())
{
var data = db.RPT_Menu.ToList();
return(data);
}
}
public int Create(RPT_Company data)
{
using (ReportEntities db = new ReportEntities())
{
db.RPT_Company.Add(data);
return(db.SaveChanges());
}
}
public IEnumerable <RPT_UserRole> GetListByUser(string UserAccount)
{
using (ReportEntities db = new ReportEntities())
{
var item = db.RPT_UserRole.Where(p => p.UserAccount == UserAccount).ToList();
return(item);
}
}
public IEnumerable <RPT_Role> GetList(string txtSearch, int PageNumber, int PageSize, out int total)
{
using (ReportEntities db = new ReportEntities())
{
var item = db.RPT_Role.Where(p => txtSearch == "" || p.RoleName.Contains(txtSearch) || p.RoleDesc.Contains(txtSearch));
total = item.Count();
var data = item.OrderBy(p => p.RoleCode).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 exsit = db.RPT_Company.FirstOrDefault(p => p.ID == id);
if (exsit != null)
{
db.RPT_Company.Remove(exsit);
}
return(db.SaveChanges());
}
}
public int Create(RPT_Role data, List <RPT_UserRolePriv> list)
{
using (ReportEntities db = new ReportEntities())
{
db.RPT_Role.Add(data);
foreach (RPT_UserRolePriv userRole in list)
{
db.RPT_UserRolePriv.Add(userRole);
}
return(db.SaveChanges());
}
}
public int Update(RPT_Company data)
{
using (ReportEntities db = new ReportEntities())
{
var exsit = db.RPT_Company.FirstOrDefault(p => p.CompanyCode == data.SystemID);
if (exsit != null)
{
int id = exsit.ID;
exsit.CopyFrom(data);
exsit.ID = id;
}
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 List <SelectListItem> GetExistsMenu(string RoleCode)
{
using (ReportEntities db = new ReportEntities())
{
var item = from menu in db.RPT_Menu
join role in db.RPT_UserRolePriv on menu.MenuID equals role.MenuID
where role.UserRoleCode == RoleCode
select new SelectListItem
{
Value = menu.MenuID,
Text = menu.MenuName
};
return(item.ToList());
}
}
public int Delete(int id)
{
using (ReportEntities db = new ReportEntities())
{
var item = db.RPT_Role.FirstOrDefault(p => p.ID == id);
db.RPT_UserRolePriv.Where(p => p.UserRoleCode == item.RoleCode).ToList().ForEach(k =>
{
db.RPT_UserRolePriv.Remove(k);
});
if (item != null)
{
db.RPT_Role.Remove(item);
}
return(db.SaveChanges());
}
}
public int Update(RPT_Role data, List <RPT_UserRolePriv> list)
{
using (ReportEntities db = new ReportEntities())
{
var item = db.RPT_Role.FirstOrDefault(p => p.RoleCode == data.RoleCode);
if (item != null)
{
item.RoleName = data.RoleName;
item.IsActive = data.IsActive;
item.RoleDesc = data.RoleDesc;
}
var items = db.RPT_UserRolePriv.Where(p => p.UserRoleCode == data.RoleCode);
foreach (var v in items)
{
db.RPT_UserRolePriv.Remove(v);
}
foreach (RPT_UserRolePriv userRole in list)
{
db.RPT_UserRolePriv.Add(userRole);
}
return(db.SaveChanges());
}
}
