private void LogInNow()
{
//String str = "Data Source=localhost\\sqlexpress;Initial Catalog=master; Integrated Security=True";
//String str = "Data Source=d:\\1.sdf; Persist Security Info=False";
//SqlCeConnection con = new SqlCeConnection(str);
SqlCeConnection con = new SqlCeConnection("Data Source=" + Application.StartupPath + "\\1.sdf; Persist Security Info=False");
//SqlCommand cmd = new SqlCommand("select * from UserProfile where LogInUser=@LogInUser and LogInPass =@LogInPass", con);
SqlCeCommand cmd = new SqlCeCommand("select * from UserProfile where LogInUser=@LogInUser and LogInPass =@LogInPass", con);
cmd.Parameters.AddWithValue("@LogInUser", textBox1.Text);
cmd.Parameters.AddWithValue("@LogInPass", textBox2.Text);
SqlCeDataAdapter sda = new SqlCeDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
//Connection open here
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
if (dt.Rows.Count > 0 & portalSelect.Text != "")
{
switch (portalSelect.Text)
{
case "MainWindowOpener":
this.Hide();
Main f2 = new Main();
f2.Show();
break;
case "EntryReportOpener":
this.Hide();
EntryReport f3 = new EntryReport();
f3.Show();
break;
}
}
else if (dt.Rows.Count > 0 & portalSelect.Text == "")
{
MessageBox.Show("لطفا زیر پورتال مورد نظر را انتخاب کنید.");
}
else
{
//MessageBox.Show("نام کاربری یا رمز عبور صحیح نمی باشد.");
MsgBox frm = new MsgBox("نام کاربری یا رمز عبور صحیح نمی باشد.", "قبول");
frm.ShowDialog();
}
}
private void button3_Click(object sender, EventArgs e)
{
EntryReport report = new EntryReport();
report.ShowDialog();
}
