private void buttonSignIn_Click(object sender, EventArgs e)
{
if (!String.IsNullOrWhiteSpace(textBoxLogin.Text) && !String.IsNullOrWhiteSpace(textBoxPassword.Text))
{
var user = (from u in ctx.RegisteredUsers where (u.login == textBoxLogin.Text) select u).Any();
if (!user)
{
MessageBox.Show("User with this name is not exist");
}
else
{
user = (from u in ctx.RegisteredUsers where (u.login == textBoxLogin.Text && u.password == textBoxPassword.Text) select u).Any();
if (!user)
{
MessageBox.Show("Login or password is incorrect");
}
else
{
ClassLib.RegisteredUsers logedInUser = (from u in ctx.RegisteredUsers where (u.login == textBoxLogin.Text && u.password == textBoxPassword.Text) select u).First();
FormMain formMain = new FormMain(logedInUser);
this.Hide();
formMain.ShowDialog();
formMain.Dispose();
this.Show();
}
}
}
else
{
MessageBox.Show("You need to fill login and password fields");
}
}
public FormOffersOfBank(int b_idtempo, ClassLib.RegisteredUsers tempo)
{
user = tempo;
InitializeComponent();
ctx = new BanksDBV2Entities();
b_id = b_idtempo;
if (user.access_lvl > 0)
{
}
else
{
SetSettingsForUser();
}
comboBoxOfferType.SelectedIndex = 2;
var query = (from offer in ctx.Offers
join con in ctx.Conditions on offer.o_c_ID equals con.c_ID
where (offer.o_b_ID == b_id &&
con.c_credit_count_max >= (int)numericUpDownCredCount.Value &&
con.c_deposit_count_min <= (int)numericUpDownDepCount.Value &&
con.c_sum_max >= (int)numericUpDownSum.Value && con.c_sum_min <= (int)numericUpDownSum.Value)
select offer);
query = query.Where(c => c.o_b_ID == b_id);
if (!String.IsNullOrWhiteSpace(textBoxName.Text))
{
query = query.Where(c => c.o_name.Contains(textBoxName.Text));
}
if (comboBoxOfferType.SelectedIndex != 2)
{
query = query.Where(c => c.o_ot_ID == (comboBoxOfferType.SelectedIndex + 1));
}
if ((int)numericUpDownPercentage.Value != 0)
{
query = query.Where(c => c.o_percentage == (int)numericUpDownPercentage.Value);
}
query.Load();
offersBindingSource.DataSource = ctx.Offers.Local.ToBindingList();
ctx.Conditions.Load();
conditionsBindingSource.DataSource = ctx.Conditions.Local.ToBindingList();
ctx.OfferType.Load();
offerTypeBindingSource.DataSource = ctx.OfferType.Local.ToBindingList();
}
public FormContractsOfClient(int cl_idtemp, ClassLib.RegisteredUsers tempo)
{
user = tempo;
InitializeComponent();
cl_id = cl_idtemp;
if (user.access_lvl > 0)
{
}
else
{
SetSettingsForUser();
}
comboBoxContractType.SelectedIndex = 0;
LoadContracts();
}
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();
}
private void buttonSignUp_Click(object sender, EventArgs e)
{
if (IsPasswordValid() && IsLoginValid() && IsAdminCodeValid())
{
ClassLib.RegisteredUsers newuser = new ClassLib.RegisteredUsers();
System.Nullable <int> ID = (int)(from u in ctx.RegisteredUsers select u.ID).Max() + 1;
newuser.ID = (int)ID;
newuser.login = textBoxLogin.Text;
newuser.password = textBoxPassword.Text;
if (textBoxAdminCode.Text == "I am ADMIN")
{
newuser.access_lvl = 2;
}
else
{
newuser.access_lvl = 0;
}
ctx.RegisteredUsers.Add(newuser);
ctx.SaveChanges();
this.Dispose();
}
}
