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