public HttpResponseMessage GetLoanDetails() { using (GVOneEntities1 db = new GVOneEntities1()) { int loanID = User.Identity.LoanID(); LoanDetailsModel loanDetails = (from l in db.tblLoans where l.tblLoanID == loanID select new LoanDetailsModel { Name = l.tblUser.Name, ActualLoanID = l.ActualLoanID, Address = l.tblUser.Address, Description = l.tblLoanStatu.Description, Lable = l.tblLoanStatu.Lable, Borrowers = l.tblUserLoans.Where(m => m.tblRole.Name == "User").SelectMany(z => l.tblUserLoans.Select(v => new UsersModel() { UserId = z.tblUserID, Name = z.tblUser.Name, Email = z.tblUser.Email, Mobile = z.tblUser.Mobile })).ToList().Distinct(), Agent = l.tblUserLoans.Where(m => m.tblRole.Name == "Agent").Select(n => new UsersModel() { UserId = n.tblUserID, Name = n.tblUser.Name, Email = n.tblUser.Email, Mobile = n.tblUser.Mobile }).FirstOrDefault(), }).First(); return(Request.CreateResponse(HttpStatusCode.OK, loanDetails)); } }
public HttpResponseMessage DisablePushNotification() { using (GVOneEntities1 db = new GVOneEntities1()) { int userID = User.Identity.UserID(); (from s in db.tblSettings where s.tblUserID == userID select s).ToList().ForEach(x => x.IsPushNotificationEnable = false); return(Request.CreateResponse(HttpStatusCode.OK, "Disabled Push Notification")); } }
public IEnumerable <LoanListModel> GetLoans(int pagenumber, int size) { using (GVOneEntities1 db = new GVOneEntities1()) { List <LoanListModel> loanList = (from l in db.tblLoans where l.PrimaryBorrowerID == l.tblUser.tblUserID orderby l.tblLoanID select new LoanListModel { LoanId = l.tblLoanID, Name = l.tblUser.Name, ActualLoanId = l.ActualLoanID, Address = l.tblUser.Address }).Skip(pagenumber * size).Take(size).ToList(); return(loanList); } }
public IEnumerable <AlertsModel> GetAlerts(int pagenumber, int size) { using (GVOneEntities1 db = new GVOneEntities1()) { int userID = User.Identity.UserID(); List <AlertsModel> alertList = new List <AlertsModel>(); alertList = (from ua in db.tblUserAlerts where (ua.tblUserID == userID && ua.IsDeleted == false) orderby ua.tblAlertID descending select new AlertsModel { tblAlertID = ua.tblAlert.tblAlertID, Subject = ua.tblAlert.Subject, Description = ua.tblAlert.Description, Createdat = ua.tblAlert.CreatedAt }).Skip(pagenumber * size).Take(size).ToList(); return(alertList); } }
public HttpResponseMessage GetSettings() { using (GVOneEntities1 db = new GVOneEntities1()) { int userID = User.Identity.UserID(); SettingsModel settings = (from s in db.tblSettings where s.tblUserID == userID select new SettingsModel { IsAlertNotificationEnable = s.IsAlertNotificationEnable, IsAllSettingEnable = s.IsAllSettingEnable, IsPushNotificationEnable = s.IsPushNotificationEnable }).FirstOrDefault(); db.tblSettings.FirstOrDefault(x => x.tblUserID == userID); if (settings == null) { return(Request.CreateResponse(HttpStatusCode.NotFound, "NotThere")); } return(Request.CreateResponse(HttpStatusCode.OK, settings)); } }