public async Task <int> UpdateProviderAsync(Provider provider, int providerNo) { var updateProvider = await(from a in CreditContext.Provider where a.ProviderNo == providerNo select a).SingleOrDefaultAsync(); if (updateProvider != null) { updateProvider.RegionNo = provider.RegionNo; updateProvider.ProviderNo = provider.ProviderNo; updateProvider.ProviderName = provider.ProviderName; updateProvider.Street = provider.Street; updateProvider.City = provider.City; updateProvider.StateProv = provider.StateProv; updateProvider.PhoneNo = provider.PhoneNo; updateProvider.MailCode = "33333"; updateProvider.IssueDt = DateTime.Now; updateProvider.Country = provider.Country; updateProvider.ProviderCode = provider.ProviderCode; CreditContext.Update(updateProvider); return(1); } else { return(-1); } }
public async Task <int> UpdateRegionAsync(Region region, int regionNo) { var updateRegion = await(from a in CreditContext.Region where a.RegionNo == regionNo select a).SingleOrDefaultAsync(); if (updateRegion != null) { updateRegion.RegionNo = region.RegionNo; updateRegion.RegionName = region.RegionName; updateRegion.Street = region.Street; updateRegion.City = region.City; updateRegion.StateProv = region.StateProv; updateRegion.PhoneNo = region.PhoneNo; updateRegion.MailCode = "33333"; updateRegion.Country = region.Country; CreditContext.Update(updateRegion); return(1); } else { return(-1); } }
public async Task <int> UpdateBasicMemberAsync(Member member, int memberNo) { var updateMember = await(from a in CreditContext.Member where a.MemberNo == memberNo select a).SingleOrDefaultAsync(); if (updateMember != null) { updateMember.MemberNo = member.MemberNo; updateMember.RegionNo = member.RegionNo; updateMember.LastName = member.LastName; updateMember.Middleinitial = member.Middleinitial; updateMember.FirstName = member.FirstName; updateMember.Street = member.Street; updateMember.City = member.City; updateMember.StateProv = member.StateProv; updateMember.PhoneNo = member.PhoneNo; updateMember.IssueDt = DateTime.Now; member.MailCode = "33333"; member.Country = "US"; updateMember.ExprDt = DateTime.Now.AddYears(3); CreditContext.Update(updateMember); return(1); } else { return(-1); } }
public async Task <int> UpdateCorporationAsync(Corporation corp, int corpNo) { var updateCorp = await(from a in CreditContext.Corporation where a.CorpNo == corpNo select a).SingleOrDefaultAsync(); if (updateCorp != null) { updateCorp.CorpNo = corp.CorpNo; updateCorp.CorpName = corp.CorpName; updateCorp.RegionNo = corp.RegionNo; updateCorp.Street = corp.Street; updateCorp.City = corp.City; updateCorp.StateProv = corp.StateProv; updateCorp.PhoneNo = corp.PhoneNo; updateCorp.MailCode = "33333"; updateCorp.Country = corp.Country; updateCorp.ExprDt = DateTime.Now.AddYears(5); CreditContext.Update(updateCorp); return(1); } else { return(-1); } }
public void AddToDb() { var root = HttpContext.Current.Server.MapPath( WebConfigurationManager.AppSettings["CreditsRootDirectory"]); using (var db = new CreditContext()) { db.Credits.Add(this); db.SaveChanges(); } }
public MyCreditsModel(string userName) { this.MyCredits = new List <Credit>(); using (var creditsContext = new CreditContext()) { foreach (var c in creditsContext.Credits.Where( c => c.UserName == userName)) { MyCredits.Add(c); } } }
public ActionResult Reject(int creditId) { using (var context = new CreditContext()) { Credit credit = context.Credits.Where( c => c.CreditId == creditId).First(); credit.Status = Status.Rejected; context.SaveChanges(); } return(View()); }
public async Task <int> DeleteProviderByIdAsync(int providerNo) { var providerCategory = await(from a in CreditContext.Provider where a.ProviderNo == providerNo select a).SingleOrDefaultAsync(); if (providerCategory != null) { var deleted = CreditContext.Remove(providerCategory); if (deleted != null) { return(1); } } return(-1); }
public async Task <int> DeleteBasicMemberByIdAsync(int memberNo) { var deleteMember = await(from a in CreditContext.Member where a.MemberNo == memberNo select a).SingleOrDefaultAsync(); if (deleteMember != null) { var deleted = CreditContext.Remove(deleteMember); if (deleted != null) { return(1); } } return(-1); }
public async Task <int> DeleteCategoryByIdAsync(int categoryNo) { var deleteCategory = await(from a in CreditContext.Category where a.CategoryNo == categoryNo select a).SingleOrDefaultAsync(); if (deleteCategory != null) { var deleted = CreditContext.Remove(deleteCategory); if (deleted != null) { return(1); } } return(-1); }
public ActionResult UploadDocs(HttpPostedFileBase passport, HttpPostedFileBase salaryCert) { string dirName = String.Empty; Credit credit; using (var context = new CreditContext()) { var credits = context.Credits; credit = credits.Where( c => c.UserName == System.Web.HttpContext.Current.User.Identity.Name).OrderByDescending(c => c.DocsFolder).First(); dirName = credit.DocsFolder; var directory = Directory.CreateDirectory( Path.Combine( Server.MapPath( WebConfigurationManager.AppSettings["CreditsRootDirectory"]), dirName)); var passportDirectory = Directory.CreateDirectory( Path.Combine(directory.FullName, "passport")); var salaryCertDirectory = Directory.CreateDirectory( Path.Combine(directory.FullName, "salary_cert")); passport.SaveAs(Path.Combine(passportDirectory.FullName, Path.GetFileName(passport.FileName))); salaryCert.SaveAs(Path.Combine(salaryCertDirectory.FullName, Path.GetFileName(salaryCert.FileName))); credit.PassportFile = Directory.GetFiles( Path.Combine(directory.FullName, "passport")).First(); credit.SalaryCertFile = Directory.GetFiles( Path.Combine(directory.FullName, "salary_cert")).First(); context.SaveChanges(); } return(RedirectToAction("DocsUploaded", "File")); }
public async Task <int> UpdateCategoryAsync(Category category, int categoryNo) { var updateCategory = await CreditContext.Category.SingleOrDefaultAsync(m => m.CategoryNo == categoryNo); if (updateCategory != null) { updateCategory.CategoryNo = category.CategoryNo; updateCategory.CategoryDesc = category.CategoryDesc; updateCategory.CategoryCode = category.CategoryCode; CreditContext.Update(updateCategory); return(1); } else { return(-1); } }
public UsersCreditsModel() { this.AllCredits = new Dictionary <string, List <Credit> >(); using (var usersContext = new ApplicationDbContext()) using (var creditsContext = new CreditContext()) { foreach (var u in usersContext.Users.Where( u => u.Roles.Any( r => r.RoleId == usersContext.Roles.Where( i => i.Name == "User").FirstOrDefault().Id))) { AllCredits.Add(u.Email, new List <Credit>()); foreach (var c in creditsContext.Credits.Where( c => c.UserName == u.Email)) { AllCredits[u.Email].Add(c); } } } }
public CorpMemberRepository(CreditContext context) : base(context) { }
public CategoryRepository(CreditContext context) : base(context) { }
public StatusRepository(CreditContext context) : base(context) { }
public PaymentRepository(CreditContext context) : base(context) { }
public RegionRepository(CreditContext context) : base(context) { }
public HomeController(ILogger <HomeController> logger, CreditContext creditContext) { _logger = logger; db = creditContext; //Подключение к БД }
public CorporationRepository(CreditContext context) : base(context) { }
public ChargeRepository(CreditContext context) : base(context) { }
public ProviderRepository(CreditContext context) : base(context) { }
public BasicMemberRepository(CreditContext context) : base(context) { }
private void Find_Click(object sender, EventArgs e) { Finansial = new Financialfunctions(); CultureInfo englishCulture = CultureInfo.CreateSpecificCulture("pl-PL"); string dateString = mc_uruchomienia.Text; string formatString = "MMMM"; DateTime extendedWay = DateTime.ParseExact( dateString, formatString, englishCulture.DateTimeFormat); var date = new DateTime(ToInt32(rok_uruchomienia.Text), extendedWay.Month, 1); var year = date.AddMonths(1).Year; var month = date.AddMonths(1).Month; List <LiborWibor> rows; using (var context = new CreditContext()) { rows = context.LiborWibor.Where(l => l.Year >= year && l.Month >= month).ToList(); //.Sum(x => x.RatePlnChf).ToList(); ///SUMAOWANIE wartosci!!!!!! } List <LiborWibor> rows0; var year0 = date.Year; var month0 = date.Month; using (var context0 = new CreditContext()) { rows0 = context0.LiborWibor.Where(z => z.Year == year0 && z.Month == month0).ToList(); } foreach (var row1 in rows0) { kurs_chf.Text = row1.RatePlnChf.ToString(".##"); } string dateString1 = mc_aktualny.Text; DateTime extendedWay1 = DateTime.ParseExact(dateString1, formatString, englishCulture.DateTimeFormat); var date1 = new DateTime(ToInt32(rok_aktualny.Text), extendedWay1.Month, 1); var year1 = date1.Year; var month1 = date1.Month; var t2 = rows.Where(z => z.Year == year1 && z.Month == month1).ToList(); foreach (var row in t2) { kurs_chf_aktualny.Text = row.RatePlnChf.ToString(".##"); saldo_kapitalu_chf_aktualny.Text = ""; saldo_kap_pln.Text = ""; } kwota_kredytu_chf.Text = (ToDecimal(kwota_kredytu_pln.Text) / (ToDecimal(kurs_chf.Text))).ToString(".##"); double a = 0.02; int i = 1; var result = rows.Where(l => l.Id <= ToInt32((okres_kredytowania.Text))).Select(l => new CreditForms { Nrraty = i++, Year = l.Year, Month = l.Month, Libor3Mchf = l.Libor3MChf.ToString(), Marza = 2, OdsetkiChf = Finansial.IPmt((l.Libor3MChf1 + a) / 12, 1, ToInt32(okres_kredytowania.Text) - i - 1, -(ToDouble(kwota_kredytu_chf.Text))).ToString(".##"), KapitalChf = (Finansial.Ppmt((l.Libor3MChf1 + a) / 12, 1, ToInt32(okres_kredytowania.Text) - i - 1, (ToDouble(kwota_kredytu_chf.Text)))).ToString(".##"), SaldokapitaluChf = (ToDecimal(kwota_kredytu_chf.Text) - (ToDecimal(Finansial.Ppmt((l.Libor3MChf1 + a) / 12, 1, ToInt32(okres_kredytowania.Text) - i - 1, (ToDouble(kwota_kredytu_chf.Text)))))).ToString(".##"), KursChf = l.RatePlnChf.ToString(".##"), Wibor3m = l.Wibor3M.ToString(".##"), Marza1 = 2, WplataPln = (ToDecimal(l.RatePlnChf) * (ToDecimal(Finansial.Pmt((l.Libor3MChf1 + a) / 12, ToInt32(okres_kredytowania.Text) - i - 1, -(ToDouble(kwota_kredytu_chf.Text)))))).ToString(".##"), OdsetkiPln = (ToDecimal(kwota_kredytu_pln.Text) * (ToDecimal(ToDouble(l.Wibor3M) + a) / 12)).ToString(".##"), KapitalPln = (l.RatePlnChf * (ToDecimal(Finansial.Pmt((l.Libor3MChf1 + a) / 12, ToInt32(okres_kredytowania.Text) - i - 1, -(ToDouble(kwota_kredytu_chf.Text))))) - (ToDecimal(kwota_kredytu_pln.Text) * ToDecimal((ToDouble(l.Wibor3M) + a) / 12))).ToString(".##"), SaldokapitaluPln = (ToDecimal(kwota_kredytu_pln.Text) - (l.RatePlnChf * (ToDecimal(Finansial.Pmt((l.Libor3MChf1 + a) / 12, ToInt32(okres_kredytowania.Text) - i - 1, -(ToDouble(kwota_kredytu_chf.Text)))))) - (ToDecimal(kwota_kredytu_pln.Text) * ToDecimal((ToDouble(l.Wibor3M) + a) / 12))).ToString(".##"), }).ToList(); dataGridView1.DataSource = result; var dataGridViewColumn = dataGridView1.Columns["Nrraty"]; if (dataGridViewColumn != null) { dataGridViewColumn.HeaderText = @"Nr raty"; } var gridViewColumn = dataGridView1.Columns["Month"]; if (gridViewColumn != null) { gridViewColumn.HeaderText = @"Miesiąc"; } var viewColumn = dataGridView1.Columns["Libor3MchdecimalF"]; if (viewColumn != null) { viewColumn.HeaderText = @"Libor 3 miecisęczny"; } var column = dataGridView1.Columns["Marza"]; if (column != null) { column.HeaderText = @"Marża"; } var dataGridViewColumn1 = dataGridView1.Columns["OdsetkiChf"]; if (dataGridViewColumn1 != null) { dataGridViewColumn1.HeaderText = "Odsetki CHF"; } var o = dataGridView1.Columns["KapitalChf"]; if (o != null) { o.HeaderText = "Kapitał CHF"; } var gridViewColumn1 = dataGridView1.Columns["SaldokapitaluChf"]; if (gridViewColumn1 != null) { gridViewColumn1.HeaderText = "Saldo kapitału CHF"; } var viewColumn1 = dataGridView1.Columns["KursChf"]; if (viewColumn1 != null) { viewColumn1.HeaderText = "Kurs CHF"; } var column1 = dataGridView1.Columns["Wibor3m"]; if (column1 != null) { column1.HeaderText = @"Wibor 3 miesięczny"; } var o1 = dataGridView1.Columns["Marza1"]; if (o1 != null) { o1.HeaderText = @"Marża"; } dataGridView1.Columns["WplataPln"].HeaderText = @"Wpłata PLN"; dataGridView1.Columns["OdsetkiPln"].HeaderText = @"Odsetki PLN"; dataGridView1.Columns["KapitalPln"].HeaderText = @"Kapitał PLN"; dataGridView1.Columns["SaldokapitaluPln"].HeaderText = @"Saldo kapitału PLN"; }
public StatementWideRepository(CreditContext context) : base(context) { }
public OverdueRepository(CreditContext context) : base(context) { }