public Settings GetSettings(long userID) { using (SandeepDBEntities db = new SandeepDBEntities()) { Settings set = new Settings(); tblSetting setting = db.tblSetting.First(x => x.tblUserID == userID); set.isAlertsEnabled = setting.IsAlertsEnabled; set.isallSettingsEnabled = setting.IsAllSettingsEnabled; set.isPushNotificationsEnabled = setting.IsPushNotificationsEnabled; return(set); } }
public string UserValidation(Validation validate) { using (SandeepDBEntities db = new SandeepDBEntities()) { string reqPassword = db.tblUser.First(x => x.Name == validate.userName).Password; if (reqPassword == validate.password) { return("Valid User"); } return("Not a Valid User"); } }
public IEnumerable <Loans> GetLoans() { using (SandeepDBEntities db = new SandeepDBEntities()) { List <Loans> loans = new List <Loans>(); var k = db.tblLoan.Select(x => new Loans() { ActualLoandId = x.ActualLoanID, primaryBorrower = db.tblUser.First(y => y.tblUserID == x.PrimaryBorrowerID).Name, Address = db.tblUser.First(y => y.tblUserID == x.PrimaryBorrowerID).Address }).ToList(); return(k); } }
static void Main(string[] args) { using (SandeepDBEntities db = new SandeepDBEntities()) { Courses cou = new Courses(); cou.CourseId = 5200; Employee emp = new Employee(); emp.EmployeeId = 545; emp.Name = "sandeep"; db.Courses.Add(cou); cou.Employee.Add(emp); db.SaveChanges(); } }
public IEnumerable <UserAlerts> GetAlert(long userID) { using (SandeepDBEntities db = new SandeepDBEntities()) { List <UserAlerts> alerts = new List <UserAlerts>(); UserAlerts userAlert = new UserAlerts(); var v = db.tblUserAlert.Where(x => x.tblUserID == userID).Select(y => new UserAlerts() { Description = y.tblAlerts.Description, createdAt = y.tblAlerts.CreatedAt, Subject = y.tblAlerts.Subject }).ToList(); return(v); } }
public ActionResult GoogleLoginCallback() { var claimsPrincipal = HttpContext.User.Identity as ClaimsIdentity; var loginInfo = GoogleLoginViewModel.GetLoginInfo(claimsPrincipal); if (loginInfo == null) { return(View("SignIn")); } SandeepDBEntities db = new SandeepDBEntities(); var user = db.UserAccount.FirstOrDefault(x => x.Email == loginInfo.emailaddress); if (user == null) { user = new UserAccount { Email = loginInfo.emailaddress, GivenName = loginInfo.givenname, Identifier = loginInfo.nameidentifier, Name = loginInfo.name, SurName = loginInfo.surname, IsActive = true }; var roleInsert = new Models.Roles { Id = user.Id, RoleName = "user" }; db.UserAccount.Add(user); db.Roles.Add(roleInsert); db.SaveChanges(); } Response.Cookies["Cookie"]["RoleName"] = db.Roles.FirstOrDefault(x => x.Id == user.Id).RoleName; string str = Response.Cookies["Cookie"]["RoleName"]; return(Redirect("signin")); }
public LoanDetails GetLoanDetails(long loanId) { using (SandeepDBEntities db = new SandeepDBEntities()) { User user = new User(); LoanDetails details = new LoanDetails(); List <User> list = new List <User>(); tblLoan loan = db.tblLoan.First(x => x.tblLoanID == loanId); long primaryId = loan.PrimaryBorrowerID; int statusId = loan.tblLoanStatusID; tblLoanStatus status = db.tblLoanStatus.First(x => x.tblLoanStatusID == statusId); details.LoanStatusLabel = status.Label; details.LoanStatusDesc = status.Description; details.primaryBorrower = db.tblUser.First(x => x.tblUserID == primaryId).Name; foreach (var v in db.tblUserLoan) { if (loanId == v.tblLoanID) { tblUser userAccount = db.tblUser.First(x => x.tblUserID == v.tblUserID); if ("Agent" == db.tblRole.First(x => x.tblRoleID == v.tblRoleID).Name) { details.Agent = userAccount; } else { user.Email = userAccount.Email; user.Name = userAccount.Name; user.Phone = userAccount.Mobile; list.Add(user); } } } details.borrowers = list; return(details); } }
public ValuesController() { _db = new SandeepDBEntities(); }