public List <SelectListItem> GetUsers(int id)
{
using (MyApp_BitSolveEntities db = new MyApp_BitSolveEntities())
{
var _userList = db.tblEmployees.Where(x => x.IsActive == true && x.IsDeleted == false &&
x.UserName != null).Select(x => new { x.EmpId, x.UserName }).ToList();
List <SelectListItem> UserList = new List <SelectListItem>();
if (id == 0)
{
var _userRoleList = db.UserRoleMasters.Select(x => x.UserId).ToList();
var result = (from u in _userList where !_userRoleList.Contains(u.EmpId) select u).ToList();
foreach (var u in result)
{
UserList.Add(new SelectListItem
{
Value = u.EmpId.ToString(),
Text = u.UserName
});
}
}
else
{
foreach (var u in _userList)
{
UserList.Add(new SelectListItem
{
Value = u.EmpId.ToString(),
Text = u.UserName
});
}
}
return(UserList);
}
}
public List <SelectListItem> GetMainMenus()
{
using (MyApp_BitSolveEntities db = new MyApp_BitSolveEntities())
{
var menu = db.tblMainMenus.Where(x => x.isActive == true).Select(x => new { x.MenuId, x.MenuName }).ToList();
List <SelectListItem> menulist = new List <SelectListItem>();
foreach (var t in menu)
{
menulist.Add(new SelectListItem
{
Value = t.MenuId.ToString(),
Text = t.MenuName,
});
}
return(menulist);
}
}
public List <SelectListItem> GetRFQNOs()
{
using (MyApp_BitSolveEntities db = new MyApp_BitSolveEntities())
{
var RFQNOs = db.tblRFQs.Where(x => x.isDeleted == false).Select(x => new { x.RfqId, x.RfqNo }).ToList();
List <SelectListItem> RFQNOsList = new List <SelectListItem>();
foreach (var u in RFQNOs)
{
RFQNOsList.Add(new SelectListItem
{
Value = u.RfqId.ToString(),
Text = u.RfqNo
});
}
return(RFQNOsList);
}
}
public List <SelectListItem> GetRoles()
{
using (MyApp_BitSolveEntities db = new MyApp_BitSolveEntities())
{
var roles = db.tblRoleMasters.Select(x => new { x.RoleId, x.RoleName }).ToList();
List <SelectListItem> roleList = new List <SelectListItem>();
foreach (var u in roles)
{
roleList.Add(new SelectListItem
{
Value = u.RoleId.ToString(),
Text = u.RoleName
});
}
return(roleList);
}
}
public List <SelectListItem> GetDesignation()
{
using (MyApp_BitSolveEntities db = new MyApp_BitSolveEntities())
{
var designation = db.tblDesignations.Select(x => new { x.DesignationId, x.Name }).ToList();
List <SelectListItem> designationLits = new List <SelectListItem>();
foreach (var u in designation)
{
designationLits.Add(new SelectListItem
{
Value = u.DesignationId.ToString(),
Text = u.Name
});
}
return(designationLits);
}
}
public List <System.Web.Mvc.SelectListItem> CountryList()
{
using (MyApp_BitSolveEntities db = new MyApp_BitSolveEntities())
{
List <SelectListItem> ddlCountry = new List <SelectListItem>();
var countryList = db.tblCountries.ToList();
foreach (var c in countryList)
{
ddlCountry.Add(new SelectListItem()
{
Value = c.CountryId.ToString(),
Text = c.CountryName
});
}
return(ddlCountry);
}
}
public List <SelectListItem> GetTypes()
{
using (MyApp_BitSolveEntities db = new MyApp_BitSolveEntities())
{
var type = db.tblTypeMasters.Where(x => x.IsDeleted == false).Select(
x => new { x.TypeId, x.Type }).ToList();
List <SelectListItem> TypeList = new List <SelectListItem>();
foreach (var t in type)
{
TypeList.Add(new SelectListItem
{
Value = t.TypeId.ToString(),
Text = t.Type
});
}
return(TypeList);
}
}
public List <SelectListItem> GetTax()
{
using (MyApp_BitSolveEntities db = new MyApp_BitSolveEntities())
{
var Tax = db.tblTaxMasters.Where(x => x.IsDeleted == false && x.IsActive == true)
.Select(x => new { x.TaxId, x.TaxName }).ToList();
List <SelectListItem> TaxList = new List <SelectListItem>();
foreach (var t in Tax)
{
TaxList.Add(new SelectListItem
{
Value = t.TaxId.ToString(),
Text = t.TaxName,
});
}
return(TaxList);
}
}
public List <SelectListItem> GetItems()
{
using (MyApp_BitSolveEntities db = new MyApp_BitSolveEntities())
{
var Items = db.tblItemMasters.Where(x => x.IsDeleted == false && x.IsActive == true)
.Select(x => new { x.ItemId, x.ItemName }).ToList();
List <SelectListItem> ItemsList = new List <SelectListItem>();
foreach (var t in Items)
{
ItemsList.Add(new SelectListItem
{
Value = t.ItemId.ToString(),
Text = t.ItemName,
});
}
return(ItemsList);
}
}
public List <SelectListItem> GetSuppliers(string supp)
{
using (MyApp_BitSolveEntities db = new MyApp_BitSolveEntities())
{
var Suppliers = db.tblSuppliers.Where(x => x.IsDeleted == false && x.IsActive == true &&
x.SupplierName.Contains(supp)).Select(x => new { x.SupplierId, x.SupplierName }).ToList();
List <SelectListItem> SuppliersList = new List <SelectListItem>();
foreach (var u in Suppliers)
{
SuppliersList.Add(new SelectListItem
{
Value = u.SupplierId.ToString(),
Text = u.SupplierName
});
}
return(SuppliersList);
}
}
public List <SelectListItem> GetUnits()
{
using (MyApp_BitSolveEntities db = new MyApp_BitSolveEntities())
{
var units = db.tblUnitMasters.Where(x => x.IsDeleted == false).Select(
x => new { x.UnitId, x.abbreviation }).ToList();
List <SelectListItem> unitsList = new List <SelectListItem>();
foreach (var u in units)
{
unitsList.Add(new SelectListItem
{
Value = u.UnitId.ToString(),
Text = u.abbreviation
});
}
return(unitsList);
}
}
public List <UserRoleMasterVM> GetAllUserRole()
{
using (MyApp_BitSolveEntities db = new MyApp_BitSolveEntities())
{
var userRoleList = (from ur in _UserRoleRepository.GetAll()
join u in _empRepository.GetAll(x => x.IsActive == true && x.IsDeleted == false)
on ur.UserId equals u.EmpId
select new
UserRoleMasterVM
{
RoleId = ur.RoleId,
UserId = ur.UserId,
UserRoleId = ur.UserRoleId,
UserName = u.UserName,
RoleName = db.tblRoleMasters.Where(x => x.RoleId == ur.RoleId).Select(x => x.RoleName).FirstOrDefault()
}).ToList();
return(userRoleList);
}
}
public LoginVM Login(LoginVM _login)
{
using (MyApp_BitSolveEntities db = new MyApp_BitSolveEntities())
{
var user = (from role in db.UserRoleMasters
join emp in
db.tblEmployees on role.UserId equals emp.EmpId
where role.RoleId == 1 && emp.UserName == _login.UserName &&
emp.EmpPassword == _login.Password
select new { emp.UserName, emp.ImageName, emp.EmpId }).FirstOrDefault();
if (user != null)
{
_login.UserName = user.UserName;
_login.ImageName = user.ImageName;
_login.RoleId = (int)user.EmpId;
return(_login);
}
else
{
return(_login = null);
}
}
}
public UnitOfWork(MyApp_BitSolveEntities dbContext)
{
_DbContext = dbContext;
}
