private void button1_Click(object sender, RoutedEventArgs e)
{
if (textBox1.Text.Equals("") || textBox2.Password.Equals(""))
{
MessageBox.Show("Please Enter Username or Password");
}
else
{
string executable = System.Reflection.Assembly.GetExecutingAssembly().Location;
string path = (System.IO.Path.GetDirectoryName(executable));
//AppDomain.CurrentDomain.SetData("DataDirectory", path);
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=" + path + "\\Inv.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
SqlDataAdapter sda = new SqlDataAdapter("Select * From Login where User_id = '" + textBox1.Text + "' and Password = '******'", con);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count == 1)
{
if (dt.Rows[0][2].ToString().Equals("1"))
{
u_id = textBox1.Text;
Sale_home sh = new Sale_home();
this.Hide();
sh.Show();
SqlConnection con1 = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Inv.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da1 = new SqlDataAdapter();
dt1 = DateTime.Now.ToString("dd/MM/yy");
lit = DateTime.Now.ToString("hh:mm:ss");
//DateTime cdt = Convert.ToDateTime(dt1);
//DateTime c**t = Convert.ToDateTime(lit);
cmd.CommandText = "INSERT INTO Cashier_details VALUES('" + textBox1.Text + "','" + dt1 + "','" + lit + "','','0','0')";
cmd.CommandType = CommandType.Text;
cmd.Connection = con1;
da1.InsertCommand = cmd;
con1.Open();
da1.InsertCommand.ExecuteNonQuery();
con1.Close();
int fl = 0;
SqlDataAdapter sda4 = new SqlDataAdapter("Select * From Report_sale where User_id = '" + textBox1.Text + "' and Login_date = '" + dt1 + "'", con);
DataTable dt4 = new DataTable();
sda4.Fill(dt4);
if (dt4.Rows.Count == 0)
{
fl = 1;
}
if (fl == 1)
{
SqlCommand cmd3 = new SqlCommand();
SqlDataAdapter sda3 = new SqlDataAdapter();
cmd3.CommandText = "insert into Report_sale values('" + textBox1.Text + "','0','0','" + dt1 + "')";
cmd3.CommandType = CommandType.Text;
cmd3.Connection = con1;
sda3.UpdateCommand = cmd3;
con1.Open();
sda3.UpdateCommand.ExecuteNonQuery();
con1.Close();
}
}
else if (dt.Rows[0][2].ToString().Equals("2"))
{
u_id = textBox1.Text;
Sale_manager_home smh = new Sale_manager_home();
this.Hide();
smh.Show();
dt1 = DateTime.Now.ToString("dd/MM/yy");
lit = DateTime.Now.ToString("hh:mm:ss");
}
else if (dt.Rows[0][2].ToString().Equals("3"))
{
u_id = textBox1.Text;
Inventory_manager_home imh = new Inventory_manager_home();
this.Hide();
imh.Show();
dt1 = DateTime.Now.ToString("dd/MM/yy");
lit = DateTime.Now.ToString("hh:mm:ss");
}
else if (dt.Rows[0][2].ToString().Equals("4"))
{
u_id = textBox1.Text;
Admin_home ah = new Admin_home();
this.Hide();
ah.Show();
dt1 = DateTime.Now.ToString("dd/MM/yy");
lit = DateTime.Now.ToString("hh:mm:ss");
}
}
else
{
MessageBox.Show("Please Check Username or Password");
}
}
}