public static tblUser CurrentUser()
{
tblUser userInfo = null;
using (ticketmanagmentEntities db = new ticketmanagmentEntities())
{
var userid = Convert.ToInt32(HttpContext.Current.User.Identity.Name);
userInfo = db.tblUsers.Where(x =>
x.userId == userid
).FirstOrDefault();
}
return userInfo;
}
public tblUser AuthenticateUser(LoginModel objLoginModel)
{
tblUser objLogin = null;
using (ticketmanagmentEntities dbobj = new ticketmanagmentEntities())
{
objLogin= dbobj.tblUsers.Where(x =>
x.userName == objLoginModel.UserName &&
x.Password == objLoginModel.Password &&
x.RoleId == objLoginModel.UserRole && x.IsActive == true
).FirstOrDefault();
}
return objLogin;
}
public List<CategoryModel> GetAllCategoryList()
{
List<CategoryModel> CategoryList = null;
using (ticketmanagmentEntities db = new ticketmanagmentEntities())
{
CategoryList = db.tblCategories.Where(x => x.IsActive == true).Select(x => new CategoryModel
{
CategoryId = x.CategoryId,
CatgoryName = x.CatgoryName,
}).ToList();
}
return CategoryList;
}
