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