public void chargementAvecLesParametreDate(string req, string connexion, string tb, string[] n, DateTime[] d)
{
string[] pn = { "@a", "@b", "@c", "@d", "@e", "@f", "@g", "@h", "@i", "@j", "@k", "@l", "@m", "@n", "@o", "@p", "@q", "@r", "@s", "@t" };
string[] pd = { "@da", "@db", "@dc", "@dd", "@de", "@df", "@dg" };
try
{
con = new SqlConnection();
con.ConnectionString = connexion;
con.Open();
cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandTimeout = 0;
// Cr�ation de la commande
int i;
cmd.CommandText = req;
for (i = 0; (i
<= (n.Length - 1)); i++)
{
cmd.Parameters.AddWithValue(pn[i], n[i]);
//cmd.Parameters.Add("",SqlDbType.VarChar, 50, "").Value = n[i];
}
for (i = 0; (i <= (d.Length - 1)); i++)
{
cmd.Parameters.AddWithValue(pd[i], d[i]);
//cmd.Parameters.Add(pd[i], SqlDbType.Date, 50, "").Value = d[i];
}
ds = new DataSet();
da = new SqlDataAdapter("gestc", con);
da.SelectCommand = cmd;
da.Fill(ds, tb);
dt = new DataTable();
dt = ds.Tables[tb];
cmd.Dispose();
da.Dispose();
con.Close();
}
catch (Exception EXC)
{
message = EXC.ToString();
// MessageBox.Show(EXC.Message)
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
try
{
using (db.CON)
{
SqlCommand cmd = new SqlCommand("sp_role_login", db.CON);
cmd.CommandType = CommandType.StoredProcedure;
db.CON.Open();
cmd.Parameters.AddWithValue("@uname", UserNametxt.Text);
cmd.Parameters.AddWithValue("@upass", PasswordTxt.Password);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (rdr[4].ToString() == "Admin")
{
MainWindow obj = new MainWindow();
obj.Show();
this.Hide();
}
else if (rdr[4].ToString() == "User")
{
MainWindowUser objUsr = new MainWindowUser();
objUsr.Show();
this.Hide();
}
}
else
{
Window6 obj = new Window6();
obj.Show();
this.Hide();
}
}
}
catch (Exception EXC)
{
MessageBox.Show(EXC.ToString());
}
}
