public ScheduleRepository(MIDASGBXEntities context) : base(context) { _dbSet = context.Set <Schedule>(); _dbSetScheduleDetail = context.Set <ScheduleDetail>(); context.Configuration.ProxyCreationEnabled = false; }
/// <summary> /// Returns the user based on authentication context /// </summary> /// <param name="userName"></param> /// <param name="password"></param> public Model.User GetUser(string userName, string password) { _context = new MIDASGBXEntities(); User user = _context.Users.Where(u => u.UserName == userName).FirstOrDefault(); if (user != null) { try { if (Common.PasswordHash.ValidatePassword(password, user.Password)) { Model.User midasuser = new Model.User(); midasuser.Subject = Convert.ToString(user.id); midasuser.Id = user.id; midasuser.Username = user.UserName; midasuser.FirstName = user.FirstName; midasuser.MiddleName = user.MiddleName; midasuser.LastName = user.LastName; midasuser.DisplayName = user.FirstName + ' ' + user.LastName; midasuser.TwoFactorEmailAuthEnabled = (user.C2FactAuthEmailEnabled == null || user.C2FactAuthEmailEnabled == false ? false : true); midasuser.TwoFactorSMSAuthEnabled = (user.C2FactAuthSMSEnabled == null || user.C2FactAuthSMSEnabled == false ? false : true); midasuser.Roles = GetUserRoles(user.id); return(midasuser); } } catch (Exception) { //Log exception } } return(null); }
public InvitationRepository(MIDASGBXEntities context) : base(context) { _dbInvitation = context.Set <Invitation>(); context.Configuration.ProxyCreationEnabled = false; }
public AttorneyMasterRepository(MIDASGBXEntities context) : base(context) { _dbAttorney = context.Set <Attorney>(); _dbAttorneyAddressInfo = context.Set <AddressInfo>(); _dbAttorneyContactInfo = context.Set <ContactInfo>(); context.Configuration.ProxyCreationEnabled = false; }
public DoctorRepository(MIDASGBXEntities context) : base(context) { _dbSetDocSpecility = context.Set <DoctorSpeciality>(); _dbSet = context.Set <Doctor>(); _dbSetDocRoomTestMapping = context.Set <DoctorRoomTestMapping>(); context.Configuration.ProxyCreationEnabled = false; }
public CompanyRepository(MIDASGBXEntities context) : base(context) { _dbSet = context.Set <Company>(); _dbuser = context.Set <User>(); _dbUserCompany = context.Set <UserCompany>(); _dbUserCompanyRole = context.Set <UserCompanyRole>(); _dbInvitation = context.Set <Invitation>(); context.Configuration.ProxyCreationEnabled = false; }
//private int UTCAdjustment_Minutes = 0; public CalendarEventRepository(MIDASGBXEntities context) : base(context) { _dbCalendarEvent = context.Set <CalendarEvent>(); context.Configuration.ProxyCreationEnabled = false; //if (ConfigurationManager.AppSettings["UTCAdjustment_Minutes"] != null) //{ // int.TryParse(ConfigurationManager.AppSettings["UTCAdjustment_Minutes"], out UTCAdjustment_Minutes); //} }
public MIDASGBXEntities GetGbDBContext() { MIDASGBXEntities context = null; string serverName = ConfigReader.GetSettingsValue <string>("GbDatabaseServer", "codearray.dlinkddns.com"); string databaseName = ConfigReader.GetSettingsValue <string>("GbDatabase", "GreenBillsDb"); string modelName = ConfigReader.GetSettingsValue <string>("ModelName", "GreenBillsDb"); string entityConnection = ConnectionStringProvider.GetEntityConnection(serverName, databaseName, modelName); context = new MIDASGBXEntities(); // ((IObjectContextAdapter)context).ObjectContext.CommandTimeout = ConfigReader.GetSettingsValue<int>("CommandTimeout", 300); return(context); }
public bool GenerateAndSendOTP(int userID) { _context = new MIDASGBXEntities(); Repository.User user = _context.Users.Where(u => u.id == userID).FirstOrDefault(); int defaultAdminUserID = Convert.ToInt32(Common.Utility.GetConfigValue("DefaultAdminUserID")); bool result = false; try { if (user != null) { var existingOTP = _context.OTPs.Where(p => p.UserID == userID).ToList(); existingOTP.ForEach(a => { a.IsDeleted = true; a.UpdateDate = DateTime.UtcNow; a.UpdateByUserID = defaultAdminUserID; }); } OTP otp = new OTP(); otp.OTPCode = Common.Utility.GenerateRandomNumber(6); otp.Pin = Common.Utility.GenerateRandomNo(); otp.UserID = user.id; otp.CreateDate = DateTime.UtcNow; otp.CreateByUserID = Convert.ToInt32(defaultAdminUserID); otp.IsDeleted = false; _context.OTPs.Add(otp); _context.SaveChanges(); string Message = "Dear " + user.FirstName + ",<br><br>As per your request, a One Time Password (OTP) has been generated and the same is <i><b>" + otp.OTPCode.ToString() + "</b></i><br><br>Please use this OTP to complete the Login. Reference number is " + otp.Pin.ToString() + " <br><br>*** This is an auto-generated email. Please do not reply to this email.*** <br><br>Thanks" + " <br><br>MIDAS Administrator"; Common.Email mail = new Common.Email(); mail.ToEmail = user.UserName; mail.Subject = "OTP Alert Message From GBX MIDAS"; mail.Body = Message; mail.SendMail(); result = true; } catch { result = false; } return(result); }
public bool VerifyOTP(int userId, int otpCode) { _context = new MIDASGBXEntities(); bool result = false; var otp = _context.OTPs .Where(u => u.UserID == userId && u.OTPCode == otpCode && u.IsDeleted == false).FirstOrDefault(); if (otp != null) { otp.IsDeleted = true; otp.UpdateByUserID = userId; otp.UpdateDate = DateTime.UtcNow; _context.SaveChanges(); result = true; } return(result); }
/// <summary> /// Returns user by user id /// </summary> /// <param name="userID"></param> public Model.User GetUserProfileData(int userID) { _context = new MIDASGBXEntities(); Model.User midasuser = new Model.User(); Repository.User user = _context.Users.Where(u => u.id == userID).FirstOrDefault(); if (user != null) { midasuser.Subject = Convert.ToString(user.id); midasuser.Id = user.id; midasuser.Username = user.UserName; midasuser.FirstName = user.FirstName; midasuser.MiddleName = user.MiddleName; midasuser.LastName = user.LastName; midasuser.DisplayName = user.FirstName + ' ' + user.LastName; midasuser.TwoFactorEmailAuthEnabled = (user.C2FactAuthEmailEnabled == null ? false : true); midasuser.TwoFactorSMSAuthEnabled = (user.C2FactAuthSMSEnabled == null ? false : true); midasuser.Roles = GetUserRoles(user.id); } return(user != null ? midasuser : null); }
public RefferingOfficeRepository(MIDASGBXEntities context) : base(context) { _dbSet = context.Set <RefferingOffice>(); context.Configuration.ProxyCreationEnabled = false; }
public SpecialityDetailsRepository(MIDASGBXEntities context) : base(context) { _dbSet = context.Set <SpecialtyDetail>(); context.Configuration.ProxyCreationEnabled = false; }
public PlaintiffVehicleRepository(MIDASGBXEntities context) : base(context) { _dbAccidentInfo = context.Set <PlaintiffVehicle>(); context.Configuration.ProxyCreationEnabled = false; }
public CompanyCaseConsentApprovalRepository(MIDASGBXEntities context) : base(context) { _dbCompanyCaseConsentApproval = context.Set <CompanyCaseConsentApproval>(); context.Configuration.ProxyCreationEnabled = false; }
public AttorneyVisitRepository(MIDASGBXEntities context) : base(context) { _dbpatientVisit = context.Set <AttorneyVisit>(); context.Configuration.ProxyCreationEnabled = false; }
public OTPCompanyMappingRepository(MIDASGBXEntities context) : base(context) { _dbSet = context.Set <OTPCompanyMapping>(); context.Configuration.ProxyCreationEnabled = false; }
public DocumentNodeObjectMappingRepository(MIDASGBXEntities context) : base(context) { _dbSet = context.Set <DocumentNodeObjectMapping>(); context.Configuration.ProxyCreationEnabled = false; }
public CaseInsuranceMappingRepository(MIDASGBXEntities context) : base(context) { _dbCaseInsuranceMapping = context.Set <CaseInsuranceMapping>(); context.Configuration.ProxyCreationEnabled = false; }
public SocialMediaRepository(MIDASGBXEntities context) : base(context) { _dbSet = context.Set <CaseStatu>(); context.Configuration.ProxyCreationEnabled = false; }
public PatientEmpInfoRepository(MIDASGBXEntities context) : base(context) { _dbEmpInfo = context.Set <PatientEmpInfo>(); context.Configuration.ProxyCreationEnabled = false; }
public ReportsRepository(MIDASGBXEntities context) : base(context) { }
public CityRepository(MIDASGBXEntities context) : base(context) { _dbCity = context.Set <City>(); }
public UserCompanyRepository(MIDASGBXEntities context) : base(context) { _dbSet = context.Set <UserCompany>(); context.Configuration.ProxyCreationEnabled = false; }
public AdjusterMasterRepository(MIDASGBXEntities context) : base(context) { _dbAdjusterMaster = context.Set <AdjusterMaster>(); context.Configuration.ProxyCreationEnabled = false; }
public DoctorLocationScheduleRepository(MIDASGBXEntities context) : base(context) { _dbSet = context.Set <DoctorLocationSchedule>(); context.Configuration.ProxyCreationEnabled = false; }
public InsuranceMasterRepository(MIDASGBXEntities context) : base(context) { _dbSet = context.Set <InsuranceMaster>(); context.Configuration.ProxyCreationEnabled = false; }
public PreferredAttorneyProviderRepository(MIDASGBXEntities context) : base(context) { _dbSet = context.Set <PreferredAttorneyProvider>(); }
public RoomTestRepository(MIDASGBXEntities context) : base(context) { _dbSet = context.Set <RoomTest>(); context.Configuration.ProxyCreationEnabled = false; }
public SchoolInformationRepository(MIDASGBXEntities context) : base(context) { _dbSchoolInformation = context.Set<SchoolInformation>(); context.Configuration.ProxyCreationEnabled = false; }