public static DataSet usp_PrintAllFees(string schoolYear)
{
SchoolDs ds = new SchoolDs();
SqlDataAdapter da = new SqlDataAdapter("usp_PrintAllFees", DataAccessLayer.con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
SqlParameter parm = new SqlParameter("@SchoolYear", SqlDbType.NVarChar)
{
Value = schoolYear
};
da.SelectCommand.Parameters.Add(parm);
da.Fill(ds.Tables["Facture"]);
return(ds);
}
public static DataSet usp_getRecu(int id)
{
SchoolDs ds = new SchoolDs();
SqlDataAdapter da = new SqlDataAdapter("usp_getRecu", DataAccessLayer.con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
SqlParameter parm = new SqlParameter("@idfees", SqlDbType.BigInt)
{
Value = id
};
da.SelectCommand.Parameters.Add(parm);
da.Fill(ds.Tables["Facture"]);
return(ds);
}
public static DataSet ups_getMofStudent(string Num, string Year)
{
SchoolDs ds = new SchoolDs();
SqlDataAdapter da = new SqlDataAdapter("ups_getMofStudent", DataAccessLayer.con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
List <SqlParameter> parm = new List <SqlParameter>()
{
new SqlParameter("@NumInscription", SqlDbType.VarChar)
{
Value = Num
},
new SqlParameter("@schoolYear", SqlDbType.NVarChar)
{
Value = Year
}
};
da.SelectCommand.Parameters.AddRange(parm.ToArray());
da.Fill(ds.Tables["Student"]);
return(ds);
}
