public bool HardDeleteSupport(int SupportId, string userId = null) { using (var _context = new AdminPortalEntities()) { if (userId != null) { var support = _context.SupportMasters.SingleOrDefault(s => s.SupportId == SupportId && s.UserId == userId); if (support != null) { _context.SupportMasters.Remove(support); _context.SaveChanges(); return(true); } return(false); } else { var support = _context.SupportMasters.SingleOrDefault(s => s.SupportId == SupportId); if (support != null) { _context.SupportMasters.Remove(support); _context.SaveChanges(); return(true); } return(false); } } }
public bool DeleteClientDocumentById(string UserId, int FileId, int ClientId) { using (var _context = new AdminPortalEntities()) { ////RecruitmentClientDocument recruitmentClientDoc = _context.RecruitmentClientDocuments.Where(x => x.Id == FileId).FirstOrDefault(); ////_context.RecruitmentClientDocuments.Remove(recruitmentClientDoc); RecruitmentClient recruitmentClientDoc = _context.RecruitmentClients.Where(x => x.Id == ClientId).FirstOrDefault(); recruitmentClientDoc.ModifiedUserId = UserId; recruitmentClientDoc.ModifiedDate = System.DateTime.Now; switch (FileId) { case 1: recruitmentClientDoc.ClientDocument1 = null; recruitmentClientDoc.DocumentName1 = null; break; case 2: recruitmentClientDoc.ClientDocument2 = null; recruitmentClientDoc.DocumentName2 = null; break; } _context.Entry(recruitmentClientDoc).State = EntityState.Modified; _context.SaveChanges(); return(true); } }
public int GetSupportOpenTicketsCount(string id) { using (var _context = new AdminPortalEntities()) { var openTicketCount = _context.SupportMasters.Where(x => x.UserId == id && x.LookupCodeMaster.LookupCodeName == "Open").Count(); return(openTicketCount); } }
public LOA GetJustLOA(int id) { using (var _context = new AdminPortalEntities()) { var loa = _context.LOAs.Where(x => x.LoaId == id).FirstOrDefault(); return(loa); } }
public int GetUserCount() { using (var _context = new AdminPortalEntities()) { var user = _context.AspNetUsers.Count(); return(user); } }
public List <AspNetUser> GetListOfUserStartsWith(string term) { using (var _context = new AdminPortalEntities()) { var model = _context.AspNetUsers.Where(a => (a.Firstname.Contains(term)) && (a.IsActive == true) && (a.IsDeleted == false)).ToList() /*.Select(a => new { label = a.UserName })*/; return(model); } }
public LOA GetMyLOA(int id, string userId) { using (var _context = new AdminPortalEntities()) { var loa = _context.LOAs.Where(x => (x.LoaId == id) && (x.UserId == userId) && (x.IsDeleted == false)).Include(x => x.AspNetUser).Include(x => x.AspNetUser.AspNetUser1).Include(x => x.LookupCodeMaster).Include(x => x.LookupCodeMaster1).Include(x => x.LookupCodeMaster2).FirstOrDefault(); return(loa); } }
//public List<LookupCodeMaster> GetCategoryList() //{ // using (var _context = new AdminPortalEntities()) // { // var categories = _context.LookupCodeMasters.Where(l => l.LookupTypeMaster.LookupTypeName == "Category").ToList(); // return categories; // } //} public List <LookupCodeMaster> GetProductDropDownList(string lookupTypeName) { using (var _context = new AdminPortalEntities()) { var list = _context.LookupCodeMasters.Where(l => l.LookupTypeMaster.LookupTypeName == lookupTypeName && l.IsActive == true).ToList(); return(list); } }
public List <Product> GetProductList() { using (var _context = new AdminPortalEntities()) { var products = _context.Products.Include("Category").Include("ProductType").Include(x => x.Status).Include("AssignedUser").ToList(); return(products); } }
public List <TimeSheetsMaster> GetReportingManagerPendingTimeSheets(string RMuserId) { using (var _context = new AdminPortalEntities()) { var timesheetList = _context.TimeSheetsMasters.Where(x => x.AspNetUser.ReportingManager == RMuserId && x.LookupCodeMaster7.LookupCodeName == "Pending").Include(x => x.AspNetUser).Include("AspNetUser.AspNetUser1").Include(x => x.LookupCodeMaster7).ToList(); return(timesheetList); } }
public LOA GetLOABetweenDates(DateTime fromDate, DateTime toDate, string userId) { using (var _context = new AdminPortalEntities()) { var lastTS = _context.LOAs.FirstOrDefault(x => (((x.StartDate >= fromDate && x.EndDate <= toDate) || (x.StartDate <= fromDate && x.EndDate >= fromDate) || (x.StartDate <= toDate && x.EndDate >= toDate)) && (x.UserId == userId) && (x.IsDeleted == false))); return(lastTS); } }
public List <TimeSheetsMaster> GetTimeSheetsBetweenDatesAndUserId(DateTime FromDate, DateTime Todate, string userId) { using (var _context = new AdminPortalEntities()) { var timesheetList = _context.TimeSheetsMasters.Where(x => (x.UserID == userId)).Where(x => (x.StartDate >= FromDate && x.EndDate <= Todate) || (x.StartDate <= FromDate && x.EndDate >= FromDate) || (x.StartDate <= Todate && x.EndDate >= Todate)).Include(x => x.AspNetUser).Include(x => x.LookupCodeMaster7).ToList(); return(timesheetList); } }
public List <TimeSheetsMaster> GetEmployeePendingTimeSheets() { using (var _context = new AdminPortalEntities()) { var timesheetList = _context.TimeSheetsMasters.Where(x => x.LookupCodeMaster7.LookupCodeName == "Pending").Include(x => x.AspNetUser).Include("AspNetUser.AspNetUser1").Include(x => x.LookupCodeMaster7).ToList(); return(timesheetList); } }
public List <TimeSheetsMaster> GetTimeSheetsBetweenDates(DateTime FromDate, DateTime Todate) { using (var _context = new AdminPortalEntities()) { var timesheetList = _context.TimeSheetsMasters.Where(x => (x.StartDate >= FromDate && x.EndDate <= Todate) || (x.StartDate <= FromDate && x.EndDate >= FromDate) || (x.StartDate <= Todate && x.EndDate >= Todate)).ToList(); return(timesheetList); } }
public List <TimeSheetsMaster> GetTimeSheetListWithUserId(string userId) { using (var _context = new AdminPortalEntities()) { var timesheetList = _context.TimeSheetsMasters.Where(x => x.UserID == userId).ToList(); return(timesheetList); } }
public UserInfo GetUserInfo(string userId) { using (var _context = new AdminPortalEntities()) { var userInfo = _context.UserInfoes.SingleOrDefault(s => s.UserId == userId); return(userInfo); } }
public int GetMyPendingRequestsCount(string userId = null) // with user id search for reporting manager { using (var _context = new AdminPortalEntities()) { var no = _context.SupportMasters.Where(x => x.UserId == userId && (x.LookupCodeMaster1.LookupCodeName == "Open" || x.LookupCodeMaster1.LookupCodeName == "Assigned" || x.LookupCodeMaster1.LookupCodeName == "InProgress")).ToList().Count(); return(no); } }
public List <LOA> GetLOABetweenDatesRepoMan(DateTime fromDate, DateTime toDate, string userId) { using (var _context = new AdminPortalEntities()) { var loas = _context.LOAs.Where(x => (((x.StartDate >= fromDate && x.EndDate <= toDate) || (x.StartDate <= fromDate && x.EndDate >= fromDate) || (x.StartDate <= toDate && x.EndDate >= toDate)) && (x.UserId == userId) && (x.IsDeleted == false) && (x.LookupCodeMaster2.LookupCodeName != "Saved"))).Include(x => x.AspNetUser).Include(x => x.LookupCodeMaster2).ToList(); return(loas); } }
public int GetMyClosedRequestsCount(string userId = null) // with user id search for reporting manager { using (var _context = new AdminPortalEntities()) { var no = _context.SupportMasters.Where(x => x.UserId == userId && x.LookupCodeMaster1.LookupCodeName == "Closed").ToList().Count(); return(no); } }
//public List<SupportMaster> GetMySupportListByUserId(string UserId) //{ // using (var _context = new AdminPortalEntities()) // { // var supportList = _context.SupportMasters.Where(x => x.UserId == UserId).SingleOrDefault(); // return GetMySupportListByUserId(UserId); // } //} #region Get all my support list and my support list by userid public List <SupportMaster> GetSupportListForUserId(string userId) { using (var _context = new AdminPortalEntities()) { var list = _context.SupportMasters.Where(x => x.UserId.Equals(userId) && x.IsDeleted == false).Include(x => x.AspNetUser).Include(x => x.AspNetUser1).Include(x => x.LookupCodeMaster).Include(x => x.LookupCodeMaster1).Include(x => x.LookupCodeMaster2).ToList(); return(list); } }
public string GetLookupNameFromId(int id) { using (var _context = new AdminPortalEntities()) { var lookupCode = _context.LookupCodeMasters.SingleOrDefault(p => p.LookupCodeId == id).LookupCodeName; return(lookupCode); } }
public List <SupportMaster> GetAllSupportForEngineer(string userId) { using (var _context = new AdminPortalEntities()) { var support = _context.SupportMasters.Where(s => s.AssignTo == userId && s.IsDeleted == false).Include(x => x.AspNetUser).Include(x => x.AspNetUser1).Include(x => x.LookupCodeMaster).Include(x => x.LookupCodeMaster1).Include(x => x.LookupCodeMaster2).ToList(); return(support); } }
public int GetProductCount() { using (var _context = new AdminPortalEntities()) { var products = _context.Products.Count(); return(products); } }
public List <SupportMaster> GetAllSupportList() { using (var _context = new AdminPortalEntities()) { var list = _context.SupportMasters.Where(x => x.IsDeleted == false && x.LookupCodeMaster1.LookupCodeName != "Saved").Include(x => x.AspNetUser).Include(x => x.AspNetUser1).Include(x => x.LookupCodeMaster).Include(x => x.LookupCodeMaster1).Include(x => x.LookupCodeMaster2).ToList(); return(list); } }
//public bool DeleteProduct(int id) //{ // using (var _context = new AdminPortalEntities()) // { // var product = _context.Products.SingleOrDefault(p => p.ProductId == id); // product.IsActive = false; // product.IsDeleted = true; // _context.Products.Attach(product); // _context.Entry(product).State = EntityState.Modified; // _context.SaveChanges(); // return true; // } //} public Product GetProductWithId(int?id) { using (var _context = new AdminPortalEntities()) { var product = _context.Products.SingleOrDefault(p => p.ProductId == id && p.IsDeleted == false); return(product); } }
public List <AspNetUser> GetUsersWithRolesList() { using (var _context = new AdminPortalEntities()) { var userlist = _context.AspNetUsers.Where(x => x.IsDeleted == false).Include(x => x.AspNetRoles).ToList(); return(userlist); } }
public LOA GetJustMyLOA(int id, string userId) { using (var _context = new AdminPortalEntities()) { var loa = _context.LOAs.Where(x => (x.LoaId == id) && (x.UserId == userId)).FirstOrDefault(); return(loa); } }
public List <SupportAttachment> GetSupportAttachments(int id) { using (var _context = new AdminPortalEntities()) { var attachments = _context.SupportAttachments.Where(s => s.SupportId == id && s.IsDeleted == false).ToList(); return(attachments); } }
public List <LOA> GetLoaListWithUserId(string userId) { using (var _context = new AdminPortalEntities()) { var loaList = _context.LOAs.Where(x => x.UserId == userId && x.IsDeleted == false).Include(x => x.AspNetUser).Include(x => x.LookupCodeMaster2).ToList(); return(loaList); } }
public AspNetUser GetUserWithId(string userId) { using (var _context = new AdminPortalEntities()) { var user = _context.AspNetUsers.Where(u => u.Id == userId).Include(u => u.AspNetUser1).FirstOrDefault(); return(user); } }