void deletebyId(string txtId) { BALEquipe balJoueur = new BALEquipe(); try { int returnValue = balJoueur.deleteEquipe(txtId); if (returnValue == 0) { Page.RegisterClientScriptBlock("message", "<script>alert('Incorrect Joueur Id')</script>"); } else if (returnValue == -2) { Page.RegisterClientScriptBlock("message", "<script>alert('Joueur ID could not found.')</script>"); } else if (returnValue == 1) { Page.RegisterClientScriptBlock("message", "<script>alert('Joueur is deleted successfully.')</script>"); binding(null); //txtDeleteID.Text = string.Empty; } else { Page.RegisterClientScriptBlock("message", "<script>alert('Unspecified error.')</script>"); } } catch (Exception ex) { clsLogging logError = new clsLogging(); logError.WriteLog(ex); } }
protected void gvJoueurList_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { //con.Open(); DropDownList DropDownList1 = (e.Row.FindControl("ddequipeRow") as DropDownList); //SqlCommand cmd = new SqlCommand("select * from tbl_qualification", con); //SqlDataAdapter sda = new SqlDataAdapter(cmd); //DataTable dt = new DataTable(); //sda.Fill(dt); //con.Close(); //DropDownList1.DataSource = dt; //var d= e.Row.Cells[5].Text; BALEquipe balEquipe = new BALEquipe(); DropDownList1.DataSource = balEquipe.getEquipe(null); DropDownList1.DataValueField = "id"; DropDownList1.DataTextField = "nom"; DropDownList1.SelectedValue = e.Row.Cells[6].Text; //"8"; //DropDownList1.SelectedValue = DropDownList1.DataBind(); //DropDownList1.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Selectionnée l'equipe", "-1")); } }
protected void btnCreate_Click(object sender, EventArgs e) { BALEquipe balJoueur = new BALEquipe(); try { int returnValue = balJoueur.CreateEquipe(txtEquipeName.Text); if (returnValue > 0) { gvJoueurList.DataBind(); Page.RegisterClientScriptBlock("message", "<script>alert('Joueur is created successfully')</script>"); txtEquipeName.Text = string.Empty; binding(null); } else { Page.RegisterClientScriptBlock("message", "<script>alert('Incorrect User Inputs.')</script>"); } } catch (Exception ex) { clsLogging logError = new clsLogging(); logError.WriteLog(ex); } }
protected void btnEditCountryName_Click(object sender, EventArgs e) { try { PROP.PROPEquipe equipe = new PROP.PROPEquipe(); //equipe.Id = Convert.ToInt16(ddlCountry.SelectedValue); //equipe.Nom = txtEditCountryName.Text; BALEquipe dalequipe = new BALEquipe(); //DALEquipe balCountry = new BALCountry(); bool result = dalequipe.updateEquipe(equipe); if (!result) { Page.RegisterClientScriptBlock("message", "<script>alert('Invalid Inputs for update.')</script>"); } else { Page.RegisterClientScriptBlock("message", "<script>alert('Country is updated successfully.')</script>"); binding(null); //ddlCountry.SelectedIndex = 0; //txtEditCountryName.Text = string.Empty; } } catch (Exception ex) { clsLogging logError = new clsLogging(); logError.WriteLog(ex); } }
private void binding(string searchJoueur) { try { BALEquipe balEquipe = new BALEquipe(); LsEquipe = balEquipe.getEquipe(null); BALJoueur balJoueure = new BALJoueur(); LsJoueur = balJoueure.getJoueur(null); foreach (var eq in LsEquipe) { var TwoJoueurs = LsJoueur.Where(x => x.EquipeId == eq.Id).Take(2); if (TwoJoueurs.Count() > 0) { eq.Joueur1 = TwoJoueurs.FirstOrDefault(); } if (TwoJoueurs.Count() == 2) { eq.Joueur2 = TwoJoueurs.LastOrDefault(); } } } catch (Exception ex) { clsLogging logError = new clsLogging(); logError.WriteLog(ex); } }
protected void btnDelete_Click(object sender, EventArgs e) { BALEquipe dalequipe = new BALEquipe(); try { int returnValue = 0; //int returnValue = dalequipe.deleteEquipe(txtDeleteID.Text); if (returnValue == 0) { Page.RegisterClientScriptBlock("message", "<script>alert('Incorrect Country Id')</script>"); } else if (returnValue == -2) { Page.RegisterClientScriptBlock("message", "<script>alert('Country ID could not found.')</script>"); } else if (returnValue == 1) { Page.RegisterClientScriptBlock("message", "<script>alert('Country is deleted successfully.')</script>"); binding(null); //txtDeleteID.Text = string.Empty; } else { Page.RegisterClientScriptBlock("message", "<script>alert('Unspecified error.')</script>"); } } catch (Exception ex) { clsLogging logError = new clsLogging(); logError.WriteLog(ex); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { enVisibleEditButton(); string idString = Request.QueryString["id"]; var balEquipe = new BALEquipe(); try { EquipeObj = balEquipe.getEquipeByID(idString); if (EquipeObj == null) { Page.RegisterClientScriptBlock("message", "<script>alert('Country Id is not found.')</script>"); Response.Redirect(btnLink.PostBackUrl); } else { lblName.Text = EquipeObj.Nom; BALJoueur balJoueure = new BALJoueur(); var LsJoueur = balJoueure.getJoueur(null); var TwoJoueurs = LsJoueur.Where(x => x.EquipeId == EquipeObj.Id).Take(2); if (TwoJoueurs.Count() > 0) { EquipeObj.Joueur1 = TwoJoueurs.FirstOrDefault(); } if (TwoJoueurs.Count() == 2) { EquipeObj.Joueur2 = TwoJoueurs.LastOrDefault(); } Label1.Text = EquipeObj.Joueur1.Nom; Label2.Text = EquipeObj.Joueur2.Prenom; } } catch (Exception ex) { clsLogging logError = new clsLogging(); logError.WriteLog(ex); Response.Redirect(btnLink.PostBackUrl); } } }
private void binding(string searchJoueur) { try { BALJoueur balJoueur = new BALJoueur(); gvJoueurList.DataSource = balJoueur.getCoutry(searchJoueur); gvJoueurList.DataBind(); BALEquipe balEquipe = new BALEquipe(); ddlEquipe.DataSource = balEquipe.getEquipe(null); ddlEquipe.DataValueField = "id"; ddlEquipe.DataTextField = "nom"; ddlEquipe.DataBind(); ddlEquipe.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Selectionnée l'equipe", "-1")); } catch (Exception ex) { clsLogging logError = new clsLogging(); logError.WriteLog(ex); } }
private void binding(string searchCountry) { try { var balCountry = new BALEquipe(); //gvCountryList.DataSource = balCountry.getEquipe(searchCountry); //gvCountryList.DataBind(); //ddlCountry.DataSource = balCountry.getEquipe(null); //ddlCountry.DataValueField = "CountryID"; //ddlCountry.DataTextField = "CountryName"; //ddlCountry.DataBind(); //ddlCountry.Items.Insert(0,new System.Web.UI.WebControls.ListItem("Select Country to Edit", "-1")); } catch (Exception ex) { clsLogging logError = new clsLogging(); logError.WriteLog(ex); } }
protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e) { var balEquipe = new BALEquipe(); try { var countryName = balEquipe.getEquipeByID(ddlCountry.SelectedValue); if (countryName == null) { Page.RegisterClientScriptBlock("message", "<script>alert('Country Id is not found.')</script>"); } else { txtEditCountryName.Text = countryName.Nom; } } catch (Exception ex) { clsLogging logError = new clsLogging(); logError.WriteLog(ex); } }
protected void btnCreate_Click(object sender, EventArgs e) { BALEquipe dalequipe = new BALEquipe(); try { int returnValue = dalequipe.CreateEquipe(""); if (returnValue > 0) { Page.RegisterClientScriptBlock("message", "<script>alert('Country is created successfully')</script>"); //txtCountryName.Text = string.Empty; } else { Page.RegisterClientScriptBlock("message", "<script>alert('Incorrect User Inputs.')</script>"); } } catch (Exception ex) { clsLogging logError = new clsLogging(); logError.WriteLog(ex); } }
public string CreateEquipe(string contryName) { BALEquipe equipe = new BALEquipe(); try { int returnValue = equipe.CreateEquipe(contryName); if (returnValue > 0) { return("Country is created successfully "); } else { return("Incorrect User Inputs."); } } catch (Exception ex) { clsLogging logError = new clsLogging(); logError.WriteLog(ex); } return("hello"); }