private void LoadOffers()
{
ctx = new BanksDBV2Entities();
ctx.OfferType.Load();
offersBindingSource.DataSource = ctx.Offers.Local.ToBindingList();
ctx.Conditions.Load();
ctx.Banks.Load();
banksBindingSource.DataSource = ctx.Banks.Local.ToBindingList();
int CreditCount = (from con in ctx.Contracts
join off in ctx.Offers on con.con_o_ID equals off.o_ID
join ot in ctx.OfferType on off.o_ot_ID equals ot.ot_ID
where (con.con_cl_ID == cl_id && ot.ot_name == "Credit")
select con).Count();
int DepositCount = (from con in ctx.Contracts
join off in ctx.Offers on con.con_o_ID equals off.o_ID
join ot in ctx.OfferType on off.o_ot_ID equals ot.ot_ID
where (con.con_cl_ID == cl_id && ot.ot_name == "Deposit")
select con).Count();
var querry = (from off in ctx.Offers
join con in ctx.Conditions on off.o_c_ID equals con.c_ID
join ot in ctx.OfferType on off.o_ot_ID equals ot.ot_ID
where (con.c_sum_max >= numericUpDownSum.Value &&
con.c_sum_min <= numericUpDownSum.Value &&
con.c_credit_count_max >= CreditCount &&
con.c_deposit_count_min <= DepositCount &&
ot.ot_type_int == comboBoxOfferType.SelectedIndex
)
select off);
querry.Load();
}
public FormAddNewOffer(int b_idtempo)
{
InitializeComponent();
ctx = new ClassLib.BanksDBV2Entities();
b_id = b_idtempo;
comboBoxOfferType.SelectedIndex = 0;
ctx.Offers.Load();
ctx.Conditions.Load();
this.conditionsBindingSource.DataSource = ctx.Conditions.Local.ToBindingList();
}
private void LoadContracts()
{
ctx = new BanksDBV2Entities();
var query = (from c in ctx.Contracts
join off in ctx.Offers on c.con_o_ID equals off.o_ID
where (c.con_cl_ID == cl_id && off.o_ot_ID == (comboBoxContractType.SelectedIndex + 1))
select c);
query.Load();
this.contractsBindingSource.DataSource = ctx.Contracts.Local.ToBindingList();
ctx.Offers.Load();
this.offersBindingSource.DataSource = ctx.Offers.Local.ToBindingList();
}
public FormAddNewContract(int cl_idtempo)
{
InitializeComponent();
cl_id = cl_idtempo;
ctx = new BanksDBV2Entities();
ctx.OfferType.Load();
ctx.Conditions.Load();
offersBindingSource.DataSource = ctx.Offers.Local.ToBindingList();
ctx.Banks.Load();
banksBindingSource.DataSource = ctx.Banks.Local.ToBindingList();
dateTimePickerFinish.MinDate = DateTime.Now;
dateTimePickerFinish.Value = DateTime.Now;
comboBoxOfferType.SelectedIndex = 0;
LoadOffers();
}
public FormMain(ClassLib.RegisteredUsers temp)
{
logedInUser = temp;
InitializeComponent();
if (logedInUser.access_lvl > 0)
{
}
else
{
SetSettingForUser();
}
ctx = new BanksDBV2Entities();
ctx.Banks.Load();
this.banksBindingSource.DataSource = ctx.Banks.Local.ToBindingList();
ctx.Clients.Load();
this.clientsBindingSource.DataSource = ctx.Clients.Local.ToBindingList();
ctx.ClientType.Load();
this.clientTypeBindingSource.DataSource = ctx.ClientType.Local.ToBindingList();
}
