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);
}
}
static public void Otkaz_vklada(int id, Operacii operacii, Bank bank)
{
operacii.SotrudnicID = id;
operacii.StatusID = bank.Status.Where(i => i.Name == "Отказано в выполнении").FirstOrDefault().ID;
operacii.Schet.Status = true;
bank.SaveChanges();
}
public Rassmotreniy_kreditVM(int id, Operacii operacii, Bank bank, SotrudnicWindowVM windowVM)
{
this.operacii = operacii;
this.bank = bank;
this.windowVM = windowVM;
ID = id;
}
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 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 Otkaz_vn_perevod(int id, Operacii operacii, Bank bank)
{
operacii.SotrudnicID = id;
operacii.StatusID = bank.Status.Where(i => i.Name == "Отказано в выполнении").FirstOrDefault().ID;
operacii.Schet1.Sum += operacii.Sum_Out;
bank.Client.Find(2).Schet.Where(i => i.ValuteID == operacii.Schet1.ValuteID).FirstOrDefault().Sum -= operacii.Sum_In;
bank.SaveChanges();
}
static public void Potv_vklada(int id, Operacii operacii, Bank bank)
{
operacii.SotrudnicID = id;
operacii.StatusID = bank.Status.Where(i => i.Name == "Выполнена").FirstOrDefault().ID;
perevod(operacii.Schet1, operacii.Schet, (decimal)operacii.Sum_Out, bank, operacii);
operacii.Schet1.ProgID = null;
bank.SaveChanges();
}
static public void Potv_kredita(int id, Operacii operacii, Bank bank, double proc)
{
operacii.SotrudnicID = id;
operacii.StatusID = bank.Status.Where(i => i.Name == "Выполнена").FirstOrDefault().ID;
operacii.Schet1.Prog.Procent = proc;
operacii.Schet1.Status = true;
perevod(operacii.Schet1, operacii.Schet, (decimal)operacii.Sum_Out, bank, operacii);
bank.SaveChanges();
}
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 OperaciiBLL(Operacii operacii)
{
ID = operacii.ID;
Sum_In = operacii.Sum_In;
Sum_Out = operacii.Sum_Out;
Out_FK = operacii.Out_FK;
In_FK = operacii.In_FK;
Vneshcniy_Nscheta = operacii.Vneshcniy_Nscheta;
Tip_operazii_FK = operacii.Tip_operazii_FK;
Date = operacii.Date;
Sotrudnic_FK = operacii.Sotrudnic_FK;
Status_FK = operacii.Status_FK;
}
public void UPD(Operacii operacii)
{
Operacii o = db.Operacii.Find(operacii.ID);
o.Date = operacii.Date;
o.InID = operacii.InID;
o.OutID = operacii.OutID;
o.SotrudnicID = operacii.SotrudnicID;
o.StatusID = operacii.StatusID;
o.Sum_In = operacii.Sum_In;
o.Sum_Out = operacii.Sum_Out;
o.Tip_operaziiID = operacii.Tip_operaziiID;
o.Vneshcniy_Nscheta = operacii.Vneshcniy_Nscheta;
}
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);
}
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_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();
}
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();
}
public Rassmotreniy_kreditV(int id, Operacii operacii, Bank bank, SotrudnicWindowVM window)
{
InitializeComponent();
DataContext = new Rassmotreniy_kreditVM(id, operacii, bank, window);
}
public void ADD(Operacii operacii)
{
db.Operacii.Add(operacii);
}
static public void Potv_vn_perevod(int id, Operacii operacii, Bank bank)
{
operacii.StatusID = bank.Status.Where(i => i.Name == "Выполнена").FirstOrDefault().ID;
operacii.SotrudnicID = id;
bank.SaveChanges();
}
