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