public static T_Connexion GetCoById(int id)
{
DepenseBDDataContext bd = new DepenseBDDataContext();
T_Connexion co = bd.T_Connexion.Single(f => f.idCo == id);
bd.Dispose();
return(co);
}
protected void btn_connexion_Click(object sender, EventArgs e)
{
T_Connexion co = CoBD.GetConnexionByUserName(tbx_username.Text, tbx_password.Text);
if (co != null)
{
ajouterSession(co);
Response.Redirect("Acceuil.aspx");
}
}
public static T_Connexion GetConnexionByUserName(string p_username, string password)
{
DepenseBDDataContext bd = new DepenseBDDataContext();
try
{
T_Connexion co = bd.T_Connexion.Single(f => f.username == p_username && f.pwd == password);
bd.Dispose();
return(co);
}
catch (System.InvalidOperationException ex)
{
bd.Dispose();
return(null);
}
}
private void ajouterSession(T_Connexion co)
{
Session["idCo"] = co.idCo;
}
partial void DeleteT_Connexion(T_Connexion instance);
partial void UpdateT_Connexion(T_Connexion instance);
partial void InsertT_Connexion(T_Connexion instance);