private void deleteToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
if (readable)
{
List <dynamic> lparam = new List <dynamic>();
for (int i = 0; i < dataGrid.CurrentRow.Cells.Count; i++)
{
lparam.Add(dataGrid.CurrentRow.Cells[i].Value);
}
MDI_DB.Participe oParticipe = new MDI_DB.Participe();
oParticipe.Participe_Delete(lparam[1], lparam[0], lparam[2]);
getParticipatesReadable();
}
else
{
ModeleParticipe oModele = (ModeleParticipe)dataGrid.CurrentRow.DataBoundItem;
MDI_DB.Participe oParticipe = new MDI_DB.Participe();
oParticipe.Participe_Delete2(oModele.Stu_Id, oModele.Clas_Id);
getParticipates();
}
}
catch (BusinessError be)
{
MessageBox.Show(be.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public List <dynamic> MyExecuteSelect(string pStoredName, string pTab)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = _Connection;
SqlDataReader oReader;
List <dynamic> lModele = new List <dynamic>();
try
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "secretariat." + pStoredName;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
oReader = cmd.ExecuteReader();
while (oReader.Read())
{
List <dynamic> lParam = new List <dynamic>();
for (int i = 0; i < oReader.FieldCount; i++)
{
lParam.Add(oReader.GetValue(i));
}
if (pTab == "Classe")
{
ModeleClasse oModele = new ModeleClasse();
lModele.Add(oModele.Init(lParam));
}
else if (pTab == "Students")
{
ModeleEtudiant oModele = new ModeleEtudiant();
lModele.Add(oModele.Init(lParam));
}
else
{
ModeleParticipe oModele = new ModeleParticipe();
lModele.Add(oModele.Init(lParam));
}
}
con.Close();
}
catch (SqlException exsql)
{
BusinessError oErreur = new BusinessError(exsql);
throw oErreur;
}
catch (Exception ex)
{
throw ex;
}
return(lModele);
}
