public DataTable GetInfoSTU(MilitaryReportDTO msd)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "[Request].[SP_Get_StudentInfoBySearch]";
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
DataTable dt = new DataTable();
cmd.Parameters.AddWithValue("@reshte", msd.reshte);
cmd.Parameters.AddWithValue("@salVorood", msd.salVorood);
cmd.Parameters.AddWithValue("@vaziat", msd.vaziat);
cmd.Parameters.AddWithValue("@maghta", msd.maghta);
cmd.Parameters.AddWithValue("@mojavez", msd.mojavez);
try
{
conn.Open();
SqlDataReader rdr;
rdr = cmd.ExecuteReader();
dt.Load(rdr);
conn.Close();
}
catch
{
throw;
}
return(dt);
}
public DataTable GetInfoSTUD(MilitaryReportDTO msd)
{
return(RES.GetInfoSTU(msd));
}
