public int AddStrataOwnerMyRequest(StrataOwnerMyRequestModel strataOwnerMyRequestModel) { int result = 0; try { tblUserRequest tblUserRequestDb = new tblUserRequest(); tblUserRequestDb.UserClientId = ClientSessionData.UserClientId; tblUserRequestDb.RequestTitle = strataOwnerMyRequestModel.RequestTitle; tblUserRequestDb.FromDate = !string.IsNullOrEmpty(strataOwnerMyRequestModel.FromDate) ? Convert.ToDateTime(strataOwnerMyRequestModel.FromDate) : !string.IsNullOrEmpty(strataOwnerMyRequestModel.ToDate) ? Convert.ToDateTime(strataOwnerMyRequestModel.ToDate) : (DateTime?)null; tblUserRequestDb.ToDate = !string.IsNullOrEmpty(strataOwnerMyRequestModel.ToDate) ? Convert.ToDateTime(strataOwnerMyRequestModel.ToDate) : !string.IsNullOrEmpty(strataOwnerMyRequestModel.FromDate) ? Convert.ToDateTime(strataOwnerMyRequestModel.FromDate) : (DateTime?)null; tblUserRequestDb.Details = strataOwnerMyRequestModel.Details; tblUserRequestDb.Status = 0; tblUserRequestDb.CreatedOn = DateTime.UtcNow; tblUserRequestDb.ModifiedOn = DateTime.UtcNow; tblUserRequestDb.StratasBoardId = ClientSessionData.ClientStrataBoardId; var UserRequests = _context.tblUserRequests.Where(x => x.UserClientId == ClientSessionData.UserClientId && x.RequestTitle == strataOwnerMyRequestModel.RequestTitle && x.Status != 2).OrderByDescending(x => x.CreatedOn).FirstOrDefault(); if (UserRequests != null) { if (UserRequests.FromDate != null && UserRequests.ToDate != null) { if (UserRequests.FromDate > Convert.ToDateTime(strataOwnerMyRequestModel.ToDate) || UserRequests.ToDate < Convert.ToDateTime(strataOwnerMyRequestModel.FromDate)) { _context.tblUserRequests.Add(tblUserRequestDb); result = _context.SaveChanges(); } else { result = -1; } } else { if (!string.IsNullOrEmpty(strataOwnerMyRequestModel.FromDate) && !string.IsNullOrEmpty(strataOwnerMyRequestModel.ToDate)) { _context.tblUserRequests.Add(tblUserRequestDb); result = _context.SaveChanges(); } else { result = -1; } } } else { _context.tblUserRequests.Add(tblUserRequestDb); result = _context.SaveChanges(); } if (result == 1) { EmailSender.FncSend_StratasBoard_OwnerRequestMail_ToStrataAdmin(ClientSessionData.UserClientId, ClientSessionData.ClientStrataBoardId); } } catch { } return(result); }
public int UpdateMyRequestStatusToReject(StrataOwnerMyRequestModel model) { int result = 0; try { var UserRequests = _context.tblUserRequests.AsNoTracking().Where(x => x.RequestId == model.RequestId && x.Status == 0).FirstOrDefault(); if (UserRequests != null) { tblUserRequest tblUserRequestDb = new tblUserRequest(); tblUserRequestDb.UserClientId = UserRequests.UserClientId; tblUserRequestDb.Status = 2; ///// For Rejected tblUserRequestDb.RequestTitle = UserRequests.RequestTitle; tblUserRequestDb.Details = UserRequests.Details; tblUserRequestDb.FromDate = UserRequests.FromDate; tblUserRequestDb.ToDate = UserRequests.ToDate; tblUserRequestDb.CreatedOn = UserRequests.CreatedOn; tblUserRequestDb.StatusRemark = model.StatusRemark; tblUserRequestDb.StatusUpdateBy = ClientSessionData.UserClientId; tblUserRequestDb.StatusUpdateOn = DateTime.UtcNow; tblUserRequestDb.ModifiedOn = DateTime.UtcNow; tblUserRequestDb.StratasBoardId = ClientSessionData.ClientStrataBoardId; if (model.RequestId > 0) { tblUserRequestDb.RequestId = model.RequestId; _context.Entry(tblUserRequestDb).State = EntityState.Modified; _context.Entry(tblUserRequestDb).Property(x => x.RequestTitle).IsModified = true; _context.Entry(tblUserRequestDb).Property(x => x.UserClientId).IsModified = true; _context.Entry(tblUserRequestDb).Property(x => x.Details).IsModified = true; _context.Entry(tblUserRequestDb).Property(x => x.Status).IsModified = true; _context.Entry(tblUserRequestDb).Property(x => x.StatusRemark).IsModified = true; _context.Entry(tblUserRequestDb).Property(x => x.StatusUpdateBy).IsModified = true; _context.Entry(tblUserRequestDb).Property(x => x.StatusUpdateOn).IsModified = true; _context.Entry(tblUserRequestDb).Property(x => x.ModifiedOn).IsModified = true; result = _context.SaveChanges(); } } } catch { } return(result); }