private void button10_Click(object sender, EventArgs e)
{
this.Hide();
Signup signup = new Signup();
signup.Show();
}
private void CreateLink1_Click(object sender, EventArgs e)
{
this.Hide();
Signup s = new Signup();
s.Show();
}
private void button2_Click(object sender, EventArgs e)
{
var signup = new Signup();
signup.Show();
this.Hide();
}
public void gotoSignup()
{
Signup form = new Signup();
form.Show();
iLogin.currentForm.Hide();
}
private void button2_Click(object sender, EventArgs e)
{
var flag = "no";
SqlConnection con = new SqlConnection(@"Data Source=parmar\mysqlexpress;Initial Catalog=icrecreamparlor;Integrated Security=True");
con.Open();
if (checkBox1.Checked)
{
flag = "yes";
}
else
{
flag = "no";
}
SqlCommand cmd = new SqlCommand("select * from users where mobileNo='" + textBox1.Text + "' and password='******' and isManagar='" + flag + "';", con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
Form3 parlor = new Form3(flag);
parlor.Show();
}
else
{
MessageBox.Show("No Such Employee Found. Please Signup First");
Signup.Show();
Signup.Enabled = true;
}
con.Close();
}
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
this.Hide();
Signup signup = new Signup();
signup.Show();
}
private void sign_up_Click(object sender, RoutedEventArgs e)
{
var Sig = new Signup();
Sig.Show();
this.Close();
}
private void BtnLogout(object sender, RoutedEventArgs e)
{
Signup signup = new Signup();
signup.Show();
Close();
}
private void mtlAddUser_Click(object sender, EventArgs e)
{
Signup s = new Signup();
s.Show();
Hide();
}
public MainWindow(int user_id)
{
InitializeComponent();
SqlConnection con = new SqlConnection("Data Source=SUJIT_PC;Initial Catalog=tres_comma;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM users WHERE user_id='" + user_id + "'", con)
{
CommandType = CommandType.Text
};
SqlDataAdapter adapter = new SqlDataAdapter
{
SelectCommand = cmd
};
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
if (dataSet.Tables[0].Rows.Count > 0)
{
string name = dataSet.Tables[0].Rows[0]["f_name"].ToString() + " " + dataSet.Tables[0].Rows[0]["l_name"].ToString();
string username = dataSet.Tables[0].Rows[0]["username"].ToString();
Users.userId = user_id;
Users.name = name;
Users.username = username;
Users.fname = dataSet.Tables[0].Rows[0]["f_name"].ToString();
Users.lname = dataSet.Tables[0].Rows[0]["l_name"].ToString();
string welcome = @"Welcome " + Users.name + " to your personal Expense Tracker";
txtWelcome.Text = welcome;
}
else
{
Signup signup = new Signup();
signup.Show();
Close();
}
}
private void GetaLink1_Click(object sender, EventArgs e)
{
info f1 = info.read();
if (f1 != null)
{
if (PassTextBox1.Text == f1.pass && UserTextBox1.Text == f1.name)
{
this.Hide();
Done d = new Done();
d.Show();
}
else
{
MessageBox.Show(this, "Wrong Username Or Password", "Alert", MessageBoxButtons.OK);
UserTextBox1.Text = "";
PassTextBox1.Text = "";
}
}
else
{
if (MessageBox.Show(this, "FIle has been Deleted!! \nCreate New Account", "Error", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
this.Hide();
Properties.Settings.Default.First = 0;
Signup fw = new Signup();
fw.Show();
}
else
{
this.UserTextBox1.Text = "";
this.PassTextBox1.Text = "";
}
}
}
private void button1_Click(object sender, EventArgs e)
{
Signup.Enabled = true;
Signup.Show();
}