public List <ViewOrderWithDate> GetOrderWithDate(DateTime fromDate, DateTime toDate, string columnName)
{
List <ViewOrderWithDate> orderWithDateList = new List <ViewOrderWithDate>();
string query = String.Format("SELECT * FROM ViewOrderWithDate WHERE EntryDate BETWEEN '{0}' AND '{1}' ORDER BY '{2}'",
fromDate, toDate, columnName);
command = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
ViewOrderWithDate orderWithDate = new ViewOrderWithDate();
orderWithDate.TestId = Convert.ToInt32(reader["TestId"]);
orderWithDate.TestName = reader["TestName"].ToString();
orderWithDate.Fee = Convert.ToSingle(reader["Fee"]);
orderWithDate.TestTypeId = Convert.ToInt32(reader["TestTypeId"]);
orderWithDate.TestTypeName = reader["TestTypeName"].ToString();
orderWithDate.EntryDate = Convert.ToDateTime(reader["EntryDate"]);
orderWithDateList.Add(orderWithDate);
}
}
reader.Close();
conn.Close();
return(orderWithDateList);
}
private List <ViewOrderWithDate> GetModifiedGridView()
{
ViewOrderWithDate lastObj = new ViewOrderWithDate();
lastObj.TestName = "";
orderWithDateList.Add(lastObj);
List <ViewOrderWithDate> testWithCountList = new List <ViewOrderWithDate>();
for (int i = 0; i < orderWithDateList.Count - 1; i++)
{
int c = 1;
for (int j = i + 1; j < orderWithDateList.Count; j++)
{
if (orderWithDateList[i].TestName != orderWithDateList[j].TestName)
{
ViewOrderWithDate uniqueItem = new ViewOrderWithDate();
uniqueItem.Count = c;
uniqueItem.TestName = orderWithDateList[i].TestName;
uniqueItem.TotalFee = orderWithDateList[i].Fee * c;
testWithCountList.Add(uniqueItem);
i = j - 1;
break;
}
else
{
c++;
}
}
}
return(testWithCountList);
}
