public List<DepositType> GetActiveDepositTypes() { using (var context = new FinanceEntities()) { return context.DepositType.Where(dt => dt.IsActive).ToList(); } }
public CreditType GetCreditTypeById(int creditTypeId) { using (var context = new FinanceEntities()) { return context.CreditType.FirstOrDefault(ct => ct.Id == creditTypeId); } }
public List<CreditType> GetCreditTypes() { using (var context = new FinanceEntities()) { return context.CreditType.ToList(); } }
public UserProfile GetUserByPassportNumber(String passportNumber) { using (var context = new FinanceEntities()) { return context.UserProfile.FirstOrDefault(user => user.PassportIdentificationNumber == passportNumber); } }
public List<CreditType> GetActiveCreditTypes() { using (var context = new FinanceEntities()) { return context.CreditType.Where(ct => ct.IsActive).ToList(); } }
public void AddOrUpdateUser(UserProfile user) { try { using (var context = new FinanceEntities()) { if (user.UserId == 0) { context.UserProfile.Add(user); } else { var dbuser = context.UserProfile.Include(u => u.webpages_Roles).Single(u => u.UserId == user.UserId); context.Entry(dbuser).CurrentValues.SetValues(user); dbuser.webpages_Roles = new List<webpages_Roles>(); foreach (var role in user.webpages_Roles) { dbuser.webpages_Roles.Add(context.webpages_Roles.Single(r => r.RoleId == role.RoleId)); } } context.SaveChanges(); } } catch (DbEntityValidationException e) { var message = e.Message; throw; } }
public UserProfile GetUserByLogin(String login) { using (var context = new FinanceEntities()) { return context.UserProfile.FirstOrDefault(item => item.Login == login); } }
public List<UserProfile> GetUsers() { using (var context = new FinanceEntities()) { return context.UserProfile.ToList(); } }
public void Percents() { using (var context = new FinanceEntities()) { context.Database.ExecuteSqlCommand("exec DepositOvercharge"); } }
private void SetDatumSource() { FinanceEntities datumDb = new FinanceEntities(); ObjectSet<Datum> datum = datumDb.Data; datumBindingSource.DataSource = datum; datumBindingSource.ResetBindings(false); }
public DepositType GetDepositTypeById(int depositTypeId) { using (var context = new FinanceEntities()) { return context.DepositType.FirstOrDefault(item => item.Id == depositTypeId); } }
public List<DepositPayment> GetPaymentsPerDeposit(int depositId) { using (var context = new FinanceEntities()) { return context.DepositPayment.Include(item => item.Deposit).Where(item => item.DepositId == depositId).ToList(); } }
public void CreateRequest(Request request) { using (var context = new FinanceEntities()) { context.Request.Add(request); context.SaveChanges(); } }
public void CreateDeposit(Deposit deposit) { using (var context = new FinanceEntities()) { context.Deposit.Add(deposit); context.SaveChanges(); } }
public List<CreditPayment> GetPaymentsPerCredit(int creditId) { using (var context = new FinanceEntities()) { return context.CreditPayment.Include(item => item.Credit).Where(item => item.CreditId == creditId).ToList(); } }
public void CreateComment(Comment comment) { using (var context = new FinanceEntities()) { context.Comment.Add(comment); context.SaveChanges(); } }
public List<DepositType> GetDepositRows() { using (var context = new FinanceEntities()) { return context.DepositType .ToList(); } }
public void CreatePayment(CreditPayment creditPayment) { using (var context = new FinanceEntities()) { context.CreditPayment.Add(creditPayment); context.SaveChanges(); } }
public void DeleteCreditType(int creditTypeId) { using (var context = new FinanceEntities()) { context.CreditType.Remove(context.CreditType.First(ct => ct.Id == creditTypeId)); } }
public void RemovePayment(int id) { using (var context = new FinanceEntities()) { var payment = context.CreditPayment.Find(id); context.CreditPayment.Remove(payment); context.SaveChanges(); } }
public UserProfile GetUserById(int userId) { using (var context = new FinanceEntities()) { return context.UserProfile .Include(user => user.webpages_Roles) .FirstOrDefault(user => user.UserId == userId); } }
public void UpdateCredit(Credit credit) { using (var context = new FinanceEntities()) { context.Credit.Attach(credit); context.Entry(credit).State = EntityState.Modified; context.SaveChanges(); } }
public void UpdateRequest(Request request) { using (var context = new FinanceEntities()) { context.Request.Attach(request); context.Entry(request).State = EntityState.Modified; context.SaveChanges(); } }
public List<Request> GetUnassignedAndPersonalRequests(int employeeId, int state) { using (var context = new FinanceEntities()) { var query = context.Request.Include(item => item.CreditType).Include(item => item.DepositType); query = SetEmployeeCriteria(query, employeeId, state); return query.ToList(); } }
public void UpdateDeposit(Deposit deposit) { using (var context = new FinanceEntities()) { context.Deposit.Attach(deposit); context.Entry(deposit).State = EntityState.Modified; context.SaveChanges(); } }
public List<UserProfile> GetUsers(int page, string sortColumnName) { using (var context = new FinanceEntities()) { return context.UserProfile .Include(u => u.webpages_Roles) .OrderBy(sortColumnName) .Skip((page - 1) * 20).Take(20).ToList(); } }
public Credit GetCreditById(int creditId) { using (var context = new FinanceEntities()) { return context.Credit.Include(item => item.CreditType) .Include(item => item.CreditPayment) .Include(item => item.UserProfile) .FirstOrDefault(item => item.Id == creditId); } }
public FinanceBrowser(FinanceEntities DB) { _browser = new WebBrowser(); _browser.DocumentCompleted += new WebBrowserDocumentCompletedEventHandler(browser_DocumentCompleted); _browser.Navigated += new WebBrowserNavigatedEventHandler(browser_Navigated); _db = DB; _downloadUrl = GetDownloadUrl(); _timer = new Timer {Interval = 5000}; _timer.Tick += new System.EventHandler(timer_Tick); }
public Deposit FindByRequestId(int requestId) { using (var context = new FinanceEntities()) { return context.Deposit.Include(item => item.DepositType) .Include(item => item.UserProfile) .Include(item => item.DepositPayment) .FirstOrDefault(item => item.RequestId == requestId); } }
public List<Credit> GetCredits() { using (var context = new FinanceEntities()) { return context.Credit.Include(item => item.CreditType) .Include(item => item.UserProfile) .Include(item => item.CreditPayment) .ToList(); } }
public IEnumerable <Company> Get() // public string Get() { using (FinanceEntities entities = new FinanceEntities()) { var templist = from a in entities.Companys // where a.IPOYear != null select a; //var json = JsonConvert.SerializeObject(templist.ToArray()); // return json; return(templist.ToList()); } }
public IEnumerable <Company> GetIndustry(string id) { using (FinanceEntities entities = new FinanceEntities()) { var templist = from a in entities.Companys //a.IPOYear != null && where a.Industry.StartsWith(id) select a; // templist.Where(x => x.IPOYear == null).Select(a => a.IPOYear. = 0).ToList(); return(templist.ToList()); } }
public void Post([FromBody] Cardadd cu) { FinanceEntities db = new FinanceEntities(); CardDetail c = new CardDetail(); int custid = (from u in db.Users where u.Username == cu.Username select u.CustomerID).FirstOrDefault(); var entry = (from cd in db.CardDetails where cd.CustomerID == custid select cd); foreach (var item in entry) { //item.RemainingCredit = item.TotalCredit - cu.RemainingCredit; item.EMIPendingStatus = true; } db.SaveChanges(); }
public void Post([FromBody] CardNew cu) { FinanceEntities db = new FinanceEntities(); CardDetail c = new CardDetail(); Random rd = new Random(); int rno = rd.Next(000000, 999999); c.CustomerID = (from a in db.Users where a.Username == cu.Username select a.CustomerID).FirstOrDefault(); c.CardID = "EMI" + rno; c.Validity = cu.Validity; c.CardType = cu.CardType; c.ActivationStatus = cu.ActivationStatus; c.TotalCredit = cu.TotalCredit; c.RemainingCredit = cu.RemainingCredit; c.EMIPendingStatus = cu.EmiPendingStatus; db.CardDetails.Add(c); db.SaveChanges(); }
public void Post([FromBody] Purchase pur) { FinanceEntities db = new FinanceEntities(); PurchaseDetail p = new PurchaseDetail(); p.PurchaseID = 1; p.ProductID = pur.id; p.CardID = "EMI093443"; p.PurchaseDate = DateTime.Now; p.CustomerID = 3; p.EmiScheme = pur.scheme; p.EmiPerMonth = pur.amount / pur.scheme; p.EmiPaid = 0; p.EmiLeft = pur.amount; db.PurchaseDetails.Add(p); db.SaveChanges(); }
public HttpResponseMessage CheckIfsc(string id) { try { using (FinanceEntities db = new FinanceEntities()) { var data = db.Banks.Find(id); if (data != null) { return(Request.CreateResponse(HttpStatusCode.OK, data)); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "IFSC Code Not Found")); } } } catch { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "IFSC Code Could Not Be Checked")); } }
public void Post([FromBody] Pay pay) { FinanceEntities db = new FinanceEntities(); var query = (from x in db.PurchaseDetails where x.PurchaseID == pay.pur_id select x).FirstOrDefault(); var query1 = (from a in db.CardDetails where a.CardID.Equals(query.CardID) select a).FirstOrDefault(); if (query.EmiLeft > 0) { query.EmiPaid += query.EmiPerMonth; query.EmiLeft -= query.EmiPerMonth; query.PaidForMonth = "YES"; query1.RemainingCredit += Convert.ToInt32(query.EmiPerMonth); } db.SaveChanges(); }
//实例化 public AccountModel() { fin = new FinanceEntities(); }