static public void Create_Vklad(Client client, Valute valute, Prog prog, decimal Sum, Schet Out, Bank bank)
{
Schet In = new Schet();
In.Nschet = 1;
In.Data_sozd = DateTime.Now;
In.Prog = prog;
In.Sum = 0;
In.ValuteID = valute.ID;
In.ClientID = client.ID;
In.Status = true;
bank.Schet.Add(In);
bank.SaveChanges();
Operacii operacii = new Operacii();
operacii.ID = 1;
operacii.Date = DateTime.Now;
operacii.StatusID = bank.Status.Where(i => i.Name == "Выполнена").FirstOrDefault().ID;
operacii.OutID = Out.Nschet;
operacii.InID = In.Nschet;
operacii.Tip_operaziiID = bank.Tip_operacii.Where(i => i.Name == "Создание вклада").FirstOrDefault().ID;
if (In.ValuteID == Out.ValuteID)
{
operacii.Sum_In = operacii.Sum_Out = Sum;
Out.Sum -= Sum;
In.Sum += Sum;
}
else
{
perevod(Out, In, Sum, bank, operacii);
}
bank.Operacii.Add(operacii);
bank.SaveChanges();
}
static public void Create_Kredit(Schet schet, Prog prog, decimal Sum, Bank bank, Valute valute, int client)
{
bank.Prog.Add(prog);
bank.SaveChanges();
Schet schet1 = new Schet();
schet1.ClientID = client;
schet1.Nschet = 1;
schet1.Data_sozd = DateTime.Now;
schet1.ProgID = prog.ID;
schet1.Sum = 0;
schet1.Status = false;
schet1.ValuteID = valute.ID;
bank.Schet.Add(schet1);
bank.SaveChanges();
Operacii operacii = new Operacii();
operacii.ID = 1;
operacii.Date = DateTime.Now;
operacii.StatusID = bank.Status.Where(i => i.Name == "Ожидает выполнения").FirstOrDefault().ID;
operacii.OutID = schet1.Nschet;
operacii.InID = schet.Nschet;
operacii.Tip_operaziiID = bank.Tip_operacii.Where(i => i.Name == "Создание кредита").FirstOrDefault().ID;
operacii.Sum_In = operacii.Sum_Out = Sum;
bank.Operacii.Add(operacii);
bank.SaveChanges();
}
static public int Perevod_vneshniy_Schet(Schet Out, int In_n, decimal Sum, Bank bank)
{
Schet In = bank.Schet.Find(In_n);
if (In != null)
{
Operacii operacii = new Operacii();
operacii.ID = 1;
operacii.Date = DateTime.Now;
operacii.StatusID = bank.Status.Where(i => i.Name == "Выполнена").FirstOrDefault().ID;
operacii.OutID = Out.Nschet;
operacii.InID = In.Nschet;
operacii.Tip_operaziiID = bank.Tip_operacii.Where(i => i.Name == "Перевод").FirstOrDefault().ID;
if (In.ValuteID == Out.ValuteID)
{
operacii.Sum_In = operacii.Sum_Out = Sum;
Out.Sum -= Sum;
In.Sum += Sum;
}
else
{
perevod(Out, In, Sum, bank, operacii);
}
bank.Operacii.Add(operacii);
return(bank.SaveChanges());
}
else
{
return(0);
}
}
public SchetBLL(Schet schet)
{
Nschet = schet.Nschet;
Data_sozd = schet.Data_sozd;
Sum = schet.Sum;
Valute_FK = schet.Valute_FK;
Client_FK = schet.Client_FK;
}
public SchetBLL(Schet schet, List <ValuteBLL> valutes)
{
Nschet = schet.Nschet;
Data_sozd = schet.Data_sozd;
Sum = schet.Sum;
Valute_FK = schet.Valute_FK;
Client_FK = schet.Client_FK;
Valute = valutes.Where(i => i.ID == Valute_FK).FirstOrDefault().Name;
}
public VkladBLL(Schet schet)
{
Nschet = schet.Nschet;
Data_sozd = schet.Data_sozd;
Sum = schet.Sum;
Prog_FK = schet.Prog_FK;
Valute_FK = schet.Valute_FK;
Client_FK = schet.Client_FK;
}
static int perevod(Schet Out, Schet In, decimal Sum, Bank bank, Operacii operacii)
{
operacii.Sum_Out = Sum * (decimal)In.Valute.Otnoshenie_k_rub_pok / (decimal)Out.Valute.Otnoshenie_k_rub_prod;
operacii.Sum_In = Sum;
Out.Sum -= operacii.Sum_Out;
bank.Client.Find(2).Schet.Where(i => i.ValuteID == Out.ValuteID).FirstOrDefault().Sum += operacii.Sum_Out;
In.Sum += operacii.Sum_In;
bank.Client.Find(2).Schet.Where(i => i.ValuteID == In.ValuteID).FirstOrDefault().Sum -= operacii.Sum_In;
return(1);
}
public void UPD(Schet schet)
{
Schet s = db.Schet.Find(schet.Nschet);
s.ClientID = schet.ClientID;
s.Data_sozd = schet.Data_sozd;
s.Sum = schet.Sum;
s.ValuteID = schet.ValuteID;
s.ProgID = schet.ProgID;
}
public VkladBLL(Schet schet, List <ValuteBLL> valutes, List <ProgramBLL> programs)
{
Nschet = schet.Nschet;
Data_sozd = schet.Data_sozd;
Prog_FK = schet.Prog_FK;
Sum = schet.Sum;
Valute_FK = schet.Valute_FK;
Client_FK = schet.Client_FK;
Valute = valutes.Where(i => i.ID == Valute_FK).FirstOrDefault().Name;
Program = programs.Where(i => i.ID == Prog_FK).FirstOrDefault().Name;
}
static public void Perevod_vneshniy_Bank(Schet Out, int In, decimal Sum, Bank bank)
{
Operacii operacii = new Operacii();
operacii.ID = 1;
operacii.Date = DateTime.Now;
operacii.StatusID = bank.Status.Where(i => i.Name == "Ожидает выполнения").FirstOrDefault().ID;
operacii.OutID = Out.Nschet;
operacii.Vneshcniy_Nscheta = In;
operacii.Tip_operaziiID = bank.Tip_operacii.Where(i => i.Name == "Перевод").FirstOrDefault().ID;
operacii.Sum_In = operacii.Sum_Out = Sum;
Out.Sum -= Sum;
bank.Client.Find(2).Schet.Where(i => i.ValuteID == Out.ValuteID).FirstOrDefault().Sum += operacii.Sum_Out;
bank.Operacii.Add(operacii);
bank.SaveChanges();
}
static public int Delete_Schet(Schet del, Bank bank)
{
if (del.Client.Schet.Where(i => (i.ProgID == null) && (i.Status == true)).Count() > 1)
{
Operacii operacii = new Operacii();
operacii.ID = 1;
operacii.Date = DateTime.Now;
operacii.StatusID = bank.Status.Where(i => i.Name == "Выполнена").FirstOrDefault().ID;
operacii.OutID = del.Nschet;
operacii.Tip_operaziiID = bank.Tip_operacii.Where(i => i.Name == "Закрытие счёта").FirstOrDefault().ID;
bank.Operacii.Add(operacii);
del.Status = false;
return(bank.SaveChanges());
}
return(0);
}
/*
* public RelayCommand Cansel
* {
* get
* {
* return new RelayCommand(obj =>
* {
* try
* {
* window.Page.Content = new SchetV(ID, window);
* }
* catch (Exception ex)
* {
* MessageBox.Show(ex.Message);
* }
* });
* }
* }*/
public void UPD()
{
schets_in.Clear();
schets_out.Clear();
foreach (Schet schet in user.Schet.Where(i => (i.Status == true) && ((i.Prog == null) || (i.Prog.Tip.Name == "Вклад"))))
{
schets_out.Add(schet);
}
foreach (Schet schet in user.Schet.Where(i => (i.Status == true) && ((i.Prog == null) || (i.Prog.Tip.Name == "Кредит"))))
{
schets_in.Add(schet);
}
SumIn = 0;
SumOut = 0;
selectedIn = null;
selectedOut = null;
Schet_vibr = null;
Select_vnbank = false;
Select_vnschet = false;
}
static public int Delete_Vklad(Schet del, Schet In, Bank bank)
{
del.Status = false;
Operacii operacii = new Operacii();
operacii.ID = 1;
operacii.Date = DateTime.Now;
operacii.StatusID = bank.Status.Where(i => i.Name == "Ожидает выполнения").FirstOrDefault().ID;
operacii.OutID = del.Nschet;
operacii.InID = In.Nschet;
operacii.Tip_operaziiID = bank.Tip_operacii.Where(i => i.Name == "Закрытие вклада").FirstOrDefault().ID;
if (In.ValuteID == del.ValuteID)
{
operacii.Sum_In = operacii.Sum_Out = del.Sum;
}
else
{
operacii.Sum_Out = del.Sum;
operacii.Sum_In = del.Sum * (decimal)del.Valute.Otnoshenie_k_rub_prod / (decimal)In.Valute.Otnoshenie_k_rub_pok;
}
bank.Operacii.Add(operacii);
return(bank.SaveChanges());
}
static public int Delete_Kredit(Schet Out, Schet del, Bank bank)
{
del.Status = false;
Operacii operacii = new Operacii();
operacii.ID = 1;
operacii.Date = DateTime.Now;
operacii.StatusID = bank.Status.Where(i => i.Name == "Выполнена").FirstOrDefault().ID;
operacii.OutID = Out.Nschet;
operacii.InID = del.Nschet;
operacii.Tip_operaziiID = bank.Tip_operacii.Where(i => i.Name == "Закрытие кредита").FirstOrDefault().ID;
if (Out.ValuteID == del.ValuteID)
{
operacii.Sum_In = operacii.Sum_Out = (-1) * del.Sum;
}
else
{
operacii.Sum_Out = del.Sum * (decimal)del.Valute.Otnoshenie_k_rub_pok / (decimal)Out.Valute.Otnoshenie_k_rub_prod;
operacii.Sum_In = del.Sum;
}
bank.Operacii.Add(operacii);
return(bank.SaveChanges());
}
static public void Create_Client(Client client, int id, Bank bank)
{
bank.Client.Add(client);
Schet schet = new Schet();
schet.Nschet = 1;
schet.Data_sozd = DateTime.Now;
schet.ProgID = null;
schet.Sum = 0;
schet.ValuteID = bank.Valute.Where(i => i.Name == "Рубль").FirstOrDefault().ID;
schet.ClientID = client.ID;
schet.Status = true;
bank.Schet.Add(schet);
bank.SaveChanges();
Operacii operacii = new Operacii();
operacii.ID = 1;
operacii.Date = DateTime.Now;
operacii.StatusID = bank.Status.Where(i => i.Name == "Выполнена").FirstOrDefault().ID;
operacii.OutID = schet.Nschet;
operacii.Tip_operaziiID = bank.Tip_operacii.Where(i => i.Name == "Добавление клиента").FirstOrDefault().ID;
bank.Operacii.Add(operacii);
bank.SaveChanges();
}
static public void Create_Schet(Client client, Valute valute, Bank bank)
{
Schet schet = new Schet();
schet.Nschet = 1;
schet.Data_sozd = DateTime.Now;
schet.ProgID = null;
schet.Sum = 0;
schet.ValuteID = valute.ID;
schet.ClientID = client.ID;
schet.Status = true;
bank.Schet.Add(schet);
bank.SaveChanges();
Operacii operacii = new Operacii();
bank.SaveChanges();
operacii.ID = 1;
operacii.Date = DateTime.Now;
operacii.StatusID = bank.Status.Where(i => i.Name == "Выполнена").FirstOrDefault().ID;
operacii.OutID = schet.Nschet;
operacii.Tip_operaziiID = bank.Tip_operacii.Where(i => i.Name == "Создание счёта").FirstOrDefault().ID;
bank.Operacii.Add(operacii);
bank.SaveChanges();
}
static public void Perevod_vnutri(Schet Out, Schet In, decimal Sum, Bank bank)
{
Operacii operacii = new Operacii();
operacii.ID = 1;
operacii.Date = DateTime.Now;
operacii.StatusID = bank.Status.Where(i => i.Name == "Выполнена").FirstOrDefault().ID;
operacii.OutID = Out.Nschet;
operacii.InID = In.Nschet;
operacii.Tip_operaziiID = bank.Tip_operacii.Where(i => i.Name == "Перевод").FirstOrDefault().ID;
if (In.ValuteID == Out.ValuteID)
{
operacii.Sum_In = operacii.Sum_Out = Sum;
Out.Sum -= Sum;
In.Sum += Sum;
}
else
{
perevod(Out, In, Sum, bank, operacii);
}
bank.Operacii.Add(operacii);
bank.SaveChanges();
}
public void ADD(Schet schet)
{
db.Schet.Add(schet);
}
