protected void Page_Load(object sender, EventArgs e)
{
classtaking = Session["CLASS"].ToString();
// SELECT [SUBJECT CODE] AS SUBJECT_CODE, [DAY], [CLASS BEGINS] AS CLASS_BEGINS,
// [CLASS ENDS] AS CLASS_ENDS, [EXAM BEGINS] AS EXAM_BEGINS, [EXAM ENDS]
// AS EXAM_ENDS FROM [TIMETABLE] WHERE ([CLASS ID] = @CLASS_ID)
if (!IsPostBack)
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["SMS"].ConnectionString))
{
Timetable timetable = new Timetable();
List <string> list = new List <string>();
List <Timetable> genericTimeTable = new List <Timetable>();
string sql;
string cachekey;
int expiry;
connection.Open();
using (SqlCommand command = new SqlCommand("SELECT Distinct(isExam) FROM TIMETABLE WHERE [CLASS ID] = @CLASS_ID "))
{
command.Connection = connection;
command.Parameters.Add(new SqlParameter("@CLASS_ID", classtaking));
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
list.Add(reader[0].ToString());
}
}
}
if (list.Contains("true"))
{
sql = @"SELECT [SUBJECT CODE] AS SUBJECT_CODE, [DAY], [EXAM BEGINS] AS EXAM_BEGINS,[EXAM ENDS] AS EXAM_ENDS FROM TIMETABLE WHERE [CLASS ID] = @CLASS_ID AND isExam = 'true' ";
cachekey = "isExam" + classtaking;
}
else
{
sql = @"SELECT [SUBJECT CODE] AS SUBJECT_CODE, [DAY], [CLASS BEGINS] AS CLASS_BEGINS,[CLASS ENDS] AS CLASS_ENDS FROM TIMETABLE WHERE [CLASS ID] = @CLASS_ID AND isExam = 'false' ORDER BY DayIndex,[CLASS BEGINS]";
cachekey = "class" + classtaking;
DateTime.UtcNow.AddDays(1).ToString("yyyy-MM-dd").Replace("-", "");
}
using (SqlCommand command = new SqlCommand(sql))
{
command.Connection = connection;
command.Parameters.Add(new SqlParameter("@CLASS_ID", classtaking));
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
timetable.Subject = reader[0].ToString();
timetable.Day = reader[1].ToString();
timetable.Start = reader[2];
timetable.End = reader[3];
genericTimeTable.Add(timetable);
}
}
}
var resultant = genericTimeTable;
}
}
SqliteCache cache = new SqliteCache();
var obj = cache.GetCache("my second key");
}