private void BindGrid()
{
AstreeDonnees a = new AstreeDonnees();
gv_Profil.DataSource = a.GetProfil().Where(w => w.code != 0);
gv_Profil.DataBind();
}
protected void BtnAjoutProfil_Click(object sender, EventArgs e)
{
// MsgCode.Text = "";
MsgProfil.Text = "";
bool validCode = false;
bool validLibelle = false;
if (String.IsNullOrEmpty((txtcode.Text)))
{
MsgCode.Text = "veuillez remplir votre code";
}
else if (String.IsNullOrEmpty(txtlibelle.Text))
{
MsgCode.Text = "";
MsgProfil.Text = "veuillez remplir votre libelle";
}
else
{
lblMessage1.Visible = false;
AstreeDonnees a = new AstreeDonnees();
List <profilDB> lstprofil = a.GetProfil();
try
{
if (lstprofil.Where(w => w.code == Convert.ToInt16(txtcode.Text.ToString())).Count() > 0)
{
lblMessage1.Visible = true;
lblMessage1.Text = "code existant!";
}
else
{
MsgCode.Text = "";
MsgProfil.Text = "";
lblMessage1.Visible = false;
validCode = true;
}
if (lstprofil.Where(w => w.libelle == txtlibelle.Text).Count() > 0)
{
lblMessage1.Visible = true;
lblMessage1.Text = "Libelle existant";
}
else
{
if (validCode)
{
lblMessage1.Visible = false;
validLibelle = true;
}
}
}
catch
{
MsgCode.Text = "Le code doit étre un entier!";
}
}
if ((validCode) && (validLibelle))
{
AstreeDonnees ad = new AstreeDonnees();
profilDB profl = new profilDB();
try
{
profl.code = Convert.ToInt16(txtcode.Text.ToString());
profl.libelle = txtlibelle.Text;
ad.InsertProfil(profl);
lblMessage1.Visible = true;
lblMessage1.Text = "Ajout fait avec succés!";
// PnlAffecter.Visible = true;
}
catch
{
MsgCode.Text = "Le code doit étre un entier!!";
}
// insert affec
DataBind();
BindGrid();
}
}