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)
{
}
