public DataTable GetInfo(MadarekReportDTO dto)
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
cmd.CommandText = "[Request].[SP_GetMadarekBysearch]";
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@riz", dto.rizNomarat);
cmd.Parameters.AddWithValue("@govahi", dto.GovahiMovaghat);
cmd.Parameters.AddWithValue("@danesh", dto.DaneshName);
cmd.Parameters.AddWithValue("@sDate", dto.sDate);
cmd.Parameters.AddWithValue("@eDate", dto.eDate);
try
{
conn.Open();
SqlDataReader rdr;
rdr = cmd.ExecuteReader();
dt.Load(rdr);
conn.Close();
}
catch
{
throw;
}
return(dt);
}
public DataTable GetInfo(MadarekReportDTO dto)
{
return(mrDAO.GetInfo(dto));
}
