private void Login_Button_Click(object sender, EventArgs e)
{
MainClass mc = new MainClass();
mc.OpenConnection();
mc.AppLogin(UserNameTBox.Text, PasswordTBox.Text);
try
{
if (MainClass.Flag == 1)
{
new SignIn().Show();
mc.CloseConnection();
MainClass.Flag = 0;
this.Hide();
}
else if (MainClass.Flag == 2)
{
new LoginChange().Show();
mc.CloseConnection();
MainClass.Flag = 0;
this.Hide();
}
else if (MainClass.Flag == 0)
{
mc.CloseConnection();
MessageBox.Show("Please Check Your Login Details !", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
mc.CloseConnection();
MessageBox.Show(ex.Message);
}
}
private void SaveButton_Click(object sender, EventArgs e)
{
MainClass mc = new MainClass();
mc.OpenConnection();
try
{
if (UserNameCheckBox.Checked && PasswordCheckBox.Checked)
{
MainClass.Flag = 1;
mc.UpdateLoginDetails(UserNameBox.Text, PasswordBox.Text);
}
else if (UserNameCheckBox.Checked)
{
MainClass.Flag = 2;
mc.UpdateLoginDetails(UserNameBox.Text, PasswordBox.Text = null);
}
else if (PasswordCheckBox.Checked)
{
MainClass.Flag = 3;
mc.UpdateLoginDetails(UserNameBox.Text = null, PasswordBox.Text);
}
if (MainClass.Flag == 4)
{
MessageBox.Show("UserName And Password Updated Successfully!", "Updated", MessageBoxButtons.OK, MessageBoxIcon.Information);
mc.CloseConnection();
new LoginForm().Show();
MainClass.Flag = 0;
this.Hide();
}
else if (MainClass.Flag == 5)
{
MessageBox.Show("UserName Updated Successfully!", "Updated", MessageBoxButtons.OK, MessageBoxIcon.Information);
mc.CloseConnection();
new LoginForm().Show();
MainClass.Flag = 0;
this.Hide();
}
else if (MainClass.Flag == 6)
{
MessageBox.Show("Password Updated Successfully!", "Updated", MessageBoxButtons.OK, MessageBoxIcon.Information);
mc.CloseConnection();
new LoginForm().Show();
MainClass.Flag = 0;
this.Hide();
}
}
catch (Exception ex)
{
mc.CloseConnection();
MessageBox.Show(ex.Message);
}
}
//Search Button
private void SearchButton_Click(object sender, EventArgs e)
{
{
MainClass mc = new MainClass();
mc.OpenConnection();
try
{
if (JewelleryTypeList.SelectedItem != null && MaterialList.SelectedItem != null && ItemBox.Text != "")
{
MessageBox.Show("Please Select Only Two Fields At Once!");
}
else if (JewelleryTypeList.SelectedItem != null && MaterialList.SelectedItem != null && ItemBox.Text == "")
{
mc.SqlQuery("Select * From Product." + JewelleryTypeList.SelectedItem + " where Material = '" + MaterialList.SelectedItem + "'");
SqlDataReader sdr = mc.DbCommand.ExecuteReader();
while (sdr.Read())
{
MainClass.item.Add(Convert.ToInt32(sdr[0].ToString()));
MainClass.quantity.Add(Convert.ToInt32(sdr[1].ToString()));
MainClass.type.Add(sdr[2].ToString());
MainClass.material.Add(sdr[3].ToString());
MainClass.weight.Add(Convert.ToDecimal(sdr[4].ToString()));
MainClass.colour.Add(sdr[5].ToString());
MainClass.size.Add(Convert.ToDecimal(sdr[6].ToString()));
MainClass.price.Add(Convert.ToDecimal(sdr[8].ToString()));
MainClass.Img = (byte[])(sdr[7]);
MainClass.Images.Add(MainClass.Img);
++MainClass.Flag;
}
MainClass.checkForPOS = 1;
this.Hide();
mc.CloseConnection();
sdr.Close();
}
else if (JewelleryTypeList.SelectedItem != null && ItemBox.Text != null)
{
try
{
mc.SqlQuery("Select * From Product." + JewelleryTypeList.SelectedItem + " where Item# = " + ItemBox.Text + "");
SqlDataReader sr = mc.DbCommand.ExecuteReader();
sr.Read();
if (sr.HasRows)
{
MainClass.Item = Convert.ToInt32(sr[0].ToString());
MainClass.Quantity = Convert.ToInt32(sr[1].ToString());
MainClass.Type = sr[2].ToString();
MainClass.Material = sr[3].ToString();
MainClass.Weight = Convert.ToDecimal(sr[4].ToString());
MainClass.Colour = sr[5].ToString();
MainClass.Size = Convert.ToDecimal(sr[6].ToString());
MainClass.Img = (byte[])(sr[7]);
MainClass.Price = Convert.ToDecimal(sr[8].ToString());
MainClass.Flag = 1;
mc.CloseConnection();
sr.Close();
this.Close();
}
else
{
mc.CloseConnection();
MessageBox.Show("This item does not exit", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
else
{
MessageBox.Show("Please insert data to search!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
mc.CloseConnection();
}
}
catch (Exception exp)
{
mc.CloseConnection();
MessageBox.Show(exp.Message);
}
}
}