public Object GetUser(int page, int pagesize, int userId) { try { User user = _CacheManager.GetOrSetUserSession(Request.Query["key"], null); var resp = _context.User.Include(r => r.lstUserCorporate) .Include(x => x.lstUserLocation) .Include(x => x.Supervisor) .Where(x => x.UserType != "Admin" && x.UserType != "Supervisor" && x.IsActive && user.lstUserLocation.Any(M => x.lstUserCorporate.Any(y => y.CorporateMaster.fk_LocationId == M.FK_LocationId)) ) .Select(x => new { x.Id, x.UserType, x.IsActive, x.Name, x.EmpCode, Supervisor = x.Supervisor.Name, }).GetPaged(page, pagesize); var TotalRecords = resp.RowCount; return(StatusCode(200, new { TotalRecords, resp })); } catch (Exception ex) { _ErrLogService.Log(ex, HttpContext); return(StatusCode(500, new { status = true, Msg = ex.Message })); } }
public Object GetUser(int page, int pagesize, int userid) { try { // var resp = _context.Corporate.Where(x => x.OstSubmittedBy == userid) //.Select(x => new //{ // x.Id, // OstSubmittedOn = (x.OstSubmittedOn != null) ? ((DateTime)x.OstSubmittedOn).ToString("dd MMM yyyy hh:mm") : null, // x.Name, // x.No_, // //toDate = (x.toDate != null) ? ((DateTime)x.toDate).ToString("dd MMM yyyy") : null, // //fromDate = (x.fromDate != null) ? ((DateTime)x.fromDate).ToString("dd MMM yyyy") : null, // //x.Amount, //}).GetPaged(page, pagesize); // var TotalRecords = _context.User.Include(x => x.Supervisor).Where(x => x.UserType != "Admin").Count(); // return StatusCode(200, new { TotalRecords, resp }); return(null); } catch (Exception ex) { _ErrLogService.Log(ex, HttpContext); return(StatusCode(500, new { status = true, Msg = ex.Message })); } }
public object GetStatusByUser(int userid, int IsPromise) { try { int start = 0; int end = 1; if (IsPromise == 0) { start = 1; end = 7; } var resp1 = _context.UserCorporateAction.Include(x => x.SubmitedCorporate).ThenInclude(x => x.CorporateMaster) .Include(x => x.CorporateStatusMaster).Include(x => x.UserUpdatedBy).Where(x => x.UpdatedBy == userid && x.FK_CorporateStatusMasterId > start && x.FK_CorporateStatusMasterId <= end) .Select(x => new { x.Id, x.PromiseAmount, x.PromiseDate, x.UpdatedOn, x.CallNote, Corporate = x.SubmitedCorporate.CorporateMaster.Name, UserUpdatedBy = x.UserUpdatedBy.Name, Status = x.CorporateStatusMaster.Name }); return(StatusCode(200, new { resp1 })); } catch (Exception ex) { _ErrLogService.Log(ex, HttpContext); return(StatusCode(500, new { status = true, Msg = ex.Message })); } }
public Object GetCorporate(int page, int pagesize, int userId) { try { var userLocations = _context.UserLocation.Where(x => x.FK_UserId == userId).Select(x => x.FK_LocationId); var resp1 = _context.CorporateMaster.Where(x => userLocations.Contains(x.fk_LocationId)) .Select(x => new { x.Id, x.Name, x.Phone, x.Location, x.No_, x.Email }).GetPaged(page, pagesize); int TotalRecord = resp1.RowCount; return(StatusCode(200, new { Results = resp1.Results.OrderBy(x => x.Name), TotalRecord })); } catch (Exception ex) { _ErrLogService.Log(ex, HttpContext); return(StatusCode(500, new { status = true, Msg = ex.Message })); } }
public Object Get() { try { var statusList = _context.StatusMaster.Where(x => x.Id != (int)CorporateStatus.Submition).ToList(); return(Ok(new { status = true, statusList, Msg = "Done!" })); } catch (Exception ex) { _ErrLogService.Log(ex, HttpContext, JsonConvert.SerializeObject(ex)); return(StatusCode(500, new { status = false, Msg = "Internal Server Error!", MsgDetails = ex.Message })); } }
public Object GetUser(int page, int pagesize) { try { var resp = _context.User.Include(x => x.Supervisor).Where(x => x.UserType != "Admin") .Select(x => new { x.Id, x.UserType, x.IsActive, x.Email, x.Name, x.EmpCode, x.Password, Supervisor = x.Supervisor.Name }).GetPaged(page, pagesize); var TotalRecords = resp.RowCount; resp.Results = resp.Results.OrderBy(x => x.Name).ToList(); return(StatusCode(200, new { TotalRecords, resp })); } catch (Exception ex) { _ErrLogService.Log(ex, HttpContext); return(StatusCode(500, new { status = true, Msg = ex.Message })); } }
public object GetFollowupFlag() { try { int userId = _cache.GetOrSetUserSession(Request.Query["key"], null).Id; var cnt = _context.UserCorporateAction.Include(x => x.SubmitedCorporate) .Include(x => x.CorporateStatusMaster) .Include(x => x.UserUpdatedBy) .Where(x => x.UpdatedBy == userId && x.CurrentStatus == true && Convert.ToDateTime(x.PromiseDate).Date == DateTime.Now.Date && x.FK_CorporateStatusMasterId == (int)CorporateStatus.Promise).Count(); return(StatusCode(200, new { status = (cnt > 0) ? true : false })); } catch (Exception ex) { _ErrLogService.Log(ex, HttpContext); return(StatusCode(500, new { status = false, Msg = ex.Message })); } }
public IActionResult AuthenticateUser([FromQuery] string empCode, [FromQuery] string password) { try { var ss = _context.User.ToList(); var resp = _context.User.Include(x => x.lstUserLocation).SingleOrDefault(x => x.EmpCode == empCode && x.Password == password && x.IsActive == true); if (resp != null) { Guid obj = Guid.NewGuid(); string key = obj.ToString(); if (resp.Password != "reset@123") { _CacheManager.GetOrSetUserSession(key, resp); SetCookie("UserData", JsonConvert.SerializeObject(new { resp.Id, resp.UserType, resp.Name }), null); return(Ok(new { CPwdF = false, Status = true, Token = key, resp.UserType, id = resp.Id, resp.Name })); } else { return(StatusCode(200, new { Status = true, id = resp.Id, CPwdF = true, Msg = "Pass" })); // RedirectToAction("ChangePassword"); // HttpContext.Response.Redirect("Home/ChangePassword"); } } else { return(StatusCode(200, new { Status = true, Msg = "Invalid UserName or Password" })); } } catch (Exception ex) { _ErrLogService.Log(ex, HttpContext); return(StatusCode(500, new { Status = false, MsgDetails = ex.Message, Msg = "Internal Server Error" })); } return(NoContent()); //return View("Index"); }
public Object GetLocationMaster() { try { return(_context.LocationMaster.Select(x => new { x.Id, x.BranchLocation, x.Branch })); } catch (Exception ex) { _ErrLogService.Log(ex, HttpContext); return(StatusCode(500, new { status = true, Msg = ex.Message })); } }
public object GetStatusByAllUser(int supervisorId) { try { var corpLocation = _context.CorporateMaster.Include(x => x.LocationMaster).Select(x => new { x.Id, x.Name, x.No_, Location = x.LocationMaster.BranchLocation, LocationId = x.LocationMaster.Id }); var resp1 = _context.User .Include(x => x.lstUserCorporateAction) .ThenInclude(x => x.CorporateStatusMaster).Where(x => x.fk_SupervisorId == supervisorId). Select(x => new { x.Id, x.Name, x.EmpCode, x.Email, lstUserCorporateAction = x.lstUserCorporateAction.Select(m => new { m.Id, m.PromiseAmount, m.PromiseDate, m.UpdatedOn, m.CallNote, LocationName = corpLocation.SingleOrDefault(h => h.Id == m.FK_SubmitedCorporateId).Location, corporateName = corpLocation.SingleOrDefault(h => h.Id == m.FK_SubmitedCorporateId).Name, Status = m.CorporateStatusMaster.Name }) }); return(StatusCode(200, new { resp1 })); } catch (Exception ex) { _ErrLogService.Log(ex, HttpContext); return(StatusCode(500, new { status = true, Msg = ex.Message })); } }
public Object GetEmpData(string empCode) { try { var resp = context_Intra.Emp_Data.FirstOrDefault(x => x.emp_status == "N" && x.emp_code == empCode); if (resp != null) { return(Ok(resp)); } else { return(NoContent()); } } catch (Exception ex) { _ErrLogService.Log(ex, HttpContext); return(StatusCode(500, new { status = true, Msg = ex.Message })); } }
public async Task <IActionResult> ChangePassword([FromQuery] int id, [FromBody] User user) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { // _context.Attach(user); User exist = await _context.Set <User>().FindAsync(id); exist.Password = user.Password; await _context.SaveChangesAsync(); return(Ok(new { status = true, Msg = "Password Changed Successfully!" })); } catch (Exception ex) { _ErrLogService.Log(ex, HttpContext); return(StatusCode(500, new { status = true, Msg = ex.Message })); } }
public object SetPriority([FromQuery] int priority, [FromQuery] int CorporateId) { try { CorporateMaster Corporate = new CorporateMaster(); Corporate.Id = CorporateId; CorporateMaster CorpMaster = _context.CorporateMaster.SingleOrDefault(x => x.Id == CorporateId); CorpMaster.Priority = (CorpMaster.Priority == 1) ? 0 : 1; CorpMaster.PriorityUpdatedBy = _cache.GetOrSetUserSession(Request.Query["key"], null).Id; CorpMaster.PrioriyUpdatedOn = DateTime.Now; _context.SaveChanges(); return(StatusCode(200, new { status = true, CorpMaster.Priority, Msg = "Priority Set Successfully!" })); } catch (Exception ex) { _ErrLogService.Log(ex, HttpContext); return(StatusCode(500, new { status = true, Msg = "Internal Server Error", MsgDeatail = ex.Message })); } }
public async Task <IActionResult> UpdateUserCorporates([FromQuery] int id, [FromBody] List <UserCorporate> userCorporate) { // Update User Corporate if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { for (int i = 0; i < userCorporate.Count; i++) { userCorporate[i].ModifiedBy = id; userCorporate[i].ModifiedOn = DateTime.Now; } var user = _context.User.Include(x => x.lstUserCorporate).SingleOrDefault(x => x.Id == id); user.lstUserCorporate = userCorporate; User existUser = await _context.Set <User>().FindAsync(id); if (existUser != null) { _context.Entry(existUser).CurrentValues.SetValues(user); await _context.SaveChangesAsync(); return(StatusCode(200, new { status = true, Msg = "Record Updated!" })); } else { return(StatusCode(200, new { status = false, Msg = "User Not Found!" })); } } catch (Exception ex) { _ErrLogService.Log(ex, HttpContext); return(StatusCode(500, new { status = true, Msg = "Internal Server Error.", MsgDetails = ex.Message })); } }
public object GetUserCorporate([FromBody] UserReportSearchPara Para) { try { if (Para == null) { return(StatusCode(400, new { status = false, Msg = "Bad Request" })); } var UserLogin = _cache.GetOrSetUserSession(Request.Query["key"], null); if (UserLogin.UserType.Trim().ToLower() == "supervisor") { var userLocation = _context.UserLocation.Include(x => x.Location).Where(x => x.FK_UserId == UserLogin.Id); var Resp = _context.UserCorporateAction .Include(x => x.SubmitedCorporate).ThenInclude(y => y.CorporateMaster) .Include(x => x.CorporateStatusMaster) .Where(x => x.CurrentStatus == true && (Para.userId == 0 || x.UpdatedBy == Para.userId) && (x.UpdatedOn.Value.Date >= Para.dtFromDate.Date && x.UpdatedOn.Value.Date <= Para.dtToDate.Date) && (Para.ICUST == null || x.SubmitedCorporate.CorporateMaster.No_ == Para.ICUST) && (Para.statusId == 0 || x.FK_CorporateStatusMasterId == Para.statusId) && userLocation.Any(p => p.Location.Branch == x.SubmitedCorporate.CorporateMaster.Location) ) .Select(x => new { x.FK_SubmitedCorporateId, x.SubmitedCorporate.CorporateMaster.Name, x.SubmitedCorporate.CorporateMaster.No_, x.SubmitedCorporate.CorporateMaster.Phone, //x.SbmtAmount, //x.PromiseAmount, Amount = ((x.FK_CorporateStatusMasterId) == (int)CorporateStatus.Submition) ? x.SbmtAmount : x.PromiseAmount, Status = x.CorporateStatusMaster.Name, x.SubmitedCorporate.CorporateMaster.Location, x.UpdatedOn }).GetPaged(Para.Page, Para.PageSize); Resp.Results = Resp.Results.OrderByDescending(x => x.UpdatedOn).ToList(); return(StatusCode(200, new { status = true, Resp })); } else if (UserLogin.UserType.Trim().ToLower() == "calling") { var Resp = _context.UserCorporateAction .Include(x => x.SubmitedCorporate).ThenInclude(y => y.CorporateMaster) .Include(x => x.CorporateStatusMaster) .Where(x => x.CurrentStatus == true && x.UpdatedBy == UserLogin.Id && (x.UpdatedOn.Value.Date >= Para.dtFromDate.Date && x.UpdatedOn.Value.Date <= Para.dtToDate.Date) && (Para.ICUST == null || x.SubmitedCorporate.CorporateMaster.No_ == Para.ICUST) && (Para.statusId == 0 || x.FK_CorporateStatusMasterId == Para.statusId) ) .Select(x => new { x.FK_SubmitedCorporateId, x.SubmitedCorporate.CorporateMaster.Name, x.SubmitedCorporate.CorporateMaster.No_, x.SubmitedCorporate.CorporateMaster.Phone, //x.SbmtAmount, //x.PromiseAmount, Amount = ((x.FK_CorporateStatusMasterId) == (int)CorporateStatus.Submition) ? x.SbmtAmount : x.PromiseAmount, Status = x.CorporateStatusMaster.Name, x.SubmitedCorporate.CorporateMaster.Location, x.UpdatedOn }).GetPaged(Para.Page, Para.PageSize); Resp.Results = Resp.Results.OrderByDescending(x => x.UpdatedOn).ToList(); return(StatusCode(200, new { status = true, Resp })); } else if (UserLogin.UserType.Trim().ToLower() == "backoffice") { var Resp = _context.UserCorporateAction .Include(x => x.SubmitedCorporate).ThenInclude(y => y.CorporateMaster) .Include(x => x.CorporateStatusMaster) .Where(x => x.UpdatedBy == UserLogin.Id && (x.FK_CorporateStatusMasterId == (int)(CorporateStatus.Submition)) && (x.UpdatedOn.Value.Date >= Para.dtFromDate.Date && x.UpdatedOn.Value.Date <= Para.dtToDate.Date) && (Para.ICUST == null || x.SubmitedCorporate.CorporateMaster.No_ == Para.ICUST) ) .Select(x => new { x.FK_SubmitedCorporateId, x.SubmitedCorporate.CorporateMaster.Name, x.SubmitedCorporate.CorporateMaster.No_, x.SubmitedCorporate.CorporateMaster.Phone, //x.SbmtAmount, //x.PromiseAmount, Amount = ((x.FK_CorporateStatusMasterId) == (int)CorporateStatus.Submition) ? x.SbmtAmount : x.PromiseAmount, Status = x.CorporateStatusMaster.Name, x.SubmitedCorporate.CorporateMaster.Location, x.UpdatedOn }).GetPaged(Para.Page, Para.PageSize); Resp.Results = Resp.Results.OrderByDescending(x => x.UpdatedOn).ToList(); return(StatusCode(200, new { status = true, Resp })); } return(StatusCode(500, new { status = false, Msg = "Invalid User Type" })); } catch (Exception ex) { _ErrLogService.Log(ex, HttpContext); return(StatusCode(500, new { status = false, Msg = "Internat Server Error!", MsgDetails = ex.Message })); } }
public Object GetPromisedCorporate(int page, int pagesize, bool IsPromise) { //int dop = (int)CorporateStatus.Promise; try { int userId = _cache.GetOrSetUserSession(Request.Query["key"], null).Id; int TotalRecords = 0; if (IsPromise) { var statusList = _context.UserCorporateAction.Include(x => x.SubmitedCorporate).ThenInclude(x => x.CorporateMaster) .Include(x => x.CorporateStatusMaster) .Include(x => x.UserUpdatedBy) .Where(x => x.UpdatedBy == userId && x.CurrentStatus == true && x.FK_CorporateStatusMasterId == (int)CorporateStatus.Promise) .Select(x => new { x.Id, x.PromiseAmount, PromiseDate = (x.PromiseDate != null) ? ((DateTime)x.PromiseDate).ToString("dd MMM yyyy") : null, UpdatedOn = (x.UpdatedOn != null) ? ((DateTime)x.UpdatedOn).ToString("dd MMM yyyy hh:mm:ss") : null, x.CallNote, x.SubmitedCorporate.Balance, x.FK_SubmitedCorporateId, CorporateName = x.SubmitedCorporate.CorporateMaster.Name, CorporateLocation = x.SubmitedCorporate.CorporateMaster.Location, CorporateIcust = x.SubmitedCorporate.CorporateMaster.No_, CorporatePhone = x.SubmitedCorporate.CorporateMaster.Phone, CorporateEmail = x.SubmitedCorporate.CorporateMaster.Email, UserUpdatedBy = x.UserUpdatedBy.Name, Status = x.CorporateStatusMaster.Name, }).GetPaged(page, pagesize); TotalRecords = statusList.RowCount; statusList.Results = statusList.Results.OrderByDescending(x => x.UpdatedOn).ToList(); return(StatusCode(200, new { statusList.Results, TotalRecords })); } else { var statusList = _context.UserCorporateAction.Include(x => x.SubmitedCorporate).ThenInclude(x => x.CorporateMaster) .Include(x => x.CorporateStatusMaster) .Include(x => x.UserUpdatedBy) .Where(x => x.UpdatedBy == userId && x.CurrentStatus == true && x.FK_CorporateStatusMasterId != (int)CorporateStatus.Promise) .Select(x => new { x.Id, // x.PromiseAmount, // PromiseDate = (x.PromiseDate != null) ? ((DateTime)x.PromiseDate).ToString("dd MMM yyyy") : null, UpdatedOn = (x.UpdatedOn != null) ? ((DateTime)x.UpdatedOn).ToString("dd MMM yyyy hh:mm:ss") : null, //x.CallNote, //x.Corporate.Balance, x.FK_SubmitedCorporateId, CorporateName = x.SubmitedCorporate.CorporateMaster.Name, CorporateLocation = x.SubmitedCorporate.CorporateMaster.Location, CorporateIcust = x.SubmitedCorporate.CorporateMaster.No_, //CorporatePhone = x.Corporate.Phone, CorporateEmail = x.SubmitedCorporate.CorporateMaster.Email, // UserUpdatedBy = x.UserUpdatedBy.Name, Status = x.CorporateStatusMaster.Name }).GetPaged(page, pagesize); TotalRecords = statusList.RowCount; statusList.Results = statusList.Results.OrderByDescending(x => x.UpdatedOn).ToList(); return(StatusCode(200, new { statusList.Results, TotalRecords })); } } catch (Exception ex) { _ErrLogService.Log(ex, HttpContext); return(StatusCode(500, new { status = false, Msg = ex.Message })); } }