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(); }