public static List <OtData> GetAllOT(string sortColumn)
{
List <OtData> lst = new List <OtData>();
string cs = ConfigurationManager.ConnectionStrings["connexionInfo"].ConnectionString;
SqlConnection con = new SqlConnection(cs);
string sqlQuery = "select ordre, date_saisie, designation_ot from ot";
if (!string.IsNullOrEmpty(sortColumn))
{
sqlQuery += " order by " + sortColumn;
}
SqlCommand cmd = new SqlCommand(sqlQuery, con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
OtData otdata = new OtData();
otdata.ordre = Convert.ToInt32(rdr["ordre"]);
otdata.date_saisie = Convert.ToDateTime(rdr["date_saisie"]);
otdata.designation_ot = rdr["designation_ot"].ToString();
lst.Add(otdata);
}
return(lst);
}
public static List <OtData> GetAllOT(int pageIndex, int pageSize, string sortExpression, string sortDirection, out int totalRows)
{
List <OtData> lst = new List <OtData>();
string cs = ConfigurationManager.ConnectionStrings["connexionInfo"].ConnectionString;
SqlConnection con = new SqlConnection(cs);
SqlCommand cmd = new SqlCommand("spGetOt_by_PageIndex_and_PageSize", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter paramStartIndex = new SqlParameter();
paramStartIndex.ParameterName = "@PageIndex";
paramStartIndex.Value = pageIndex;
cmd.Parameters.Add(paramStartIndex);
SqlParameter paramMaximumRows = new SqlParameter();
paramMaximumRows.ParameterName = "@PageSize";
paramMaximumRows.Value = pageSize;
cmd.Parameters.Add(paramMaximumRows);
SqlParameter paramSortExpression = new SqlParameter();
paramSortExpression.ParameterName = "@SortExpression";
paramSortExpression.Value = sortExpression;
cmd.Parameters.Add(paramSortExpression);
SqlParameter paramSortDirection = new SqlParameter();
paramSortDirection.ParameterName = "@SortDirection";
paramSortDirection.Value = sortDirection;
cmd.Parameters.Add(paramSortDirection);
SqlParameter paramOutputTotalRows = new SqlParameter();
paramOutputTotalRows.ParameterName = "@TotalRows";
paramOutputTotalRows.Direction = ParameterDirection.Output;
paramOutputTotalRows.SqlDbType = SqlDbType.Int;
cmd.Parameters.Add(paramOutputTotalRows);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
OtData otdata = new OtData();
otdata.ordre = Convert.ToInt32(rdr["ordre"]);
otdata.date_saisie = Convert.ToDateTime(rdr["date_saisie"]);
otdata.designation_ot = rdr["designation_ot"].ToString();
lst.Add(otdata);
}
rdr.Close();
totalRows = (int)cmd.Parameters["@TotalRows"].Value;
return(lst);
}