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");
}
