public ForgetPasswordModel UpdateChangePasswordFailedCount(ForgetPasswordModel model) { APSEntities dbContext = new APSEntities(); var selectedEntity = dbContext.APS_USERS.FirstOrDefault(p => p.USER_NAME == model.UserName); selectedEntity.USER_NAME = model.UserName; selectedEntity.PWD_CHANGE_FAIL_ATTMPT = model.PasswordChangeFailAttempt; selectedEntity.LAST_UPDATED_BY = model.LastUpdatedBy; selectedEntity.LAST_UPDATED_TIME = DateTime.Now; dbContext.Entry(selectedEntity).State = EntityState.Modified; dbContext.SaveChanges(); return(model); }
public UserModel UpdateLoginFailedCount(UserModel model) { APSEntities dbContext = new APSEntities(); var selectedEntity = dbContext.APS_USERS.FirstOrDefault(p => p.USER_NAME == model.UserName); selectedEntity.USER_NAME = model.UserName; selectedEntity.LOGIN_FAIL_ATTEMPT = model.LoginFailAttemptCount; selectedEntity.LAST_UPDATED_BY = model.LastUpdatedBy; selectedEntity.LAST_UPDATED_TIME = DateTime.Now; dbContext.Entry(selectedEntity).State = EntityState.Modified; dbContext.SaveChanges(); return(selectedEntity.ToUserModel()); }
public UserModel ChangeUserPassword(ChangePasswordModel model) { APSEntities dbContext = new APSEntities(); var selectedEntity = dbContext.APS_USERS.FirstOrDefault(p => p.USER_NAME == model.UserName); selectedEntity.USER_NAME = model.UserName; selectedEntity.USER_PASSWORD = model.UserPassword; selectedEntity.PWD_QUES_ID = model.PasswordQuestionID; selectedEntity.PWD_QUES_ANSWER = model.PasswordQuesAnswer; selectedEntity.LAST_UPDATED_BY = model.LastUpdatedBy; selectedEntity.LAST_UPDATED_TIME = DateTime.Now; dbContext.Entry(selectedEntity).State = EntityState.Modified; dbContext.SaveChanges(); UserModel userModel = ToUserModelFromChangePassword(model); return(userModel); }
public APS.BusinessEntity.Models.Appointment.AppointmentModel BookOrChangeAppointment(APS.BusinessEntity.Models.Appointment.AppointmentModel appModel) { try { UserInfoModel userInfo = new UserInfoModel(); userInfo.UserName = appModel.App_UserName; using (AuthenticationRepository authRepo = new AuthenticationRepository()) { userInfo = authRepo.GetUserInfoDetails(userInfo); } APS.BusinessEntity.Models.Appointment.AppointmentModel appointModel = new APS.BusinessEntity.Models.Appointment.AppointmentModel(); APSEntities dbContext = new APSEntities(); DateTime appDt; DateTime.TryParse(appModel.App_Date, out appDt); if (!appModel.IsAppointmentAvailable) { var objApp = new APS_APPOINTMENT { APP_DATE = appDt, APP_TIMESLOT_ID = appModel.App_TimeSlot_ID, APP_USERNAME = appModel.App_UserName, CREATED_BY = appModel.App_UserName, CREATED_ON = DateTime.Now, LAST_UPDATED_BY = appModel.App_UserName, LAST_UPDATED_ON = DateTime.Now, APP_STATUS = BusinessConstants.AppointmetStatus.Active, APP_CHANGE_CNT = 0 }; dbContext.APS_APPOINTMENT.Add(objApp); dbContext.SaveChanges(); appModel.App_ID = objApp.APP_ID; } else { var selectedEntity = dbContext.APS_APPOINTMENT.FirstOrDefault(p => p.APP_ID == appModel.App_ID); if (appModel.App_Change_Count <= 3) { selectedEntity.APP_CHANGE_CNT = appModel.App_Change_Count; selectedEntity.APP_TIMESLOT_ID = appModel.App_TimeSlot_ID; selectedEntity.LAST_UPDATED_BY = appModel.App_UserName; selectedEntity.LAST_UPDATED_ON = DateTime.Now; } else if (appModel.App_Change_Count > 3) { selectedEntity.APP_CHANGE_CNT = appModel.App_Change_Count; selectedEntity.LAST_UPDATED_BY = appModel.App_UserName; selectedEntity.LAST_UPDATED_ON = DateTime.Now; } dbContext.Entry(selectedEntity).State = EntityState.Modified; dbContext.SaveChanges(); } var appointments = dbContext.V_APPOINTMENT_DETAILS.Where(i => i.APP_USERNAME == appModel.App_UserName).FirstOrDefault(); if (appointments != null) { appointModel = appointments.ToAppointmentModel(); } appointModel.UserInfoDetails = userInfo; return(appointModel); } catch (Exception ex) { throw ex; } }