protected void PresentTeachrBtn_Click(object sender, EventArgs e)
{
substituteDA mysub2;
{
try
{
DataTable dt2 = new DataTable();
string dayofweek = System.DateTime.Now.DayOfWeek.ToString();
if (dayofweek == "Monday")
{
mysub2 = new substituteDA();
dt2 = mysub2.presentTeachersMon();
RadGrid2.DataSource = dt2;
RadGrid2.DataBind();
}
if (dayofweek == "Tuesday")
{
mysub2 = new substituteDA();
dt2 = mysub2.presentTeachersTues();
RadGrid2.DataSource = dt2;
RadGrid2.DataBind();
}
if (dayofweek == "Wednesday")
{
mysub2 = new substituteDA();
dt2 = mysub2.presentTeachersWed();
RadGrid2.DataSource = dt2;
RadGrid2.DataBind();
}
if (dayofweek == "Thursday")
{
mysub2 = new substituteDA();
dt2 = mysub2.presentTeachersThus();
RadGrid2.DataSource = dt2;
RadGrid2.DataBind();
}
if (dayofweek == "Friday")//select present teachers from db and they are set to display in the radgrid
{
mysub2 = new substituteDA();
dt2 = mysub2.presentTeachersFri();
substituteCLZ obj1 = new substituteCLZ();
RadGrid2.DataSource = dt2;
RadGrid2.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
}
}
protected void AbsentTeachrBtn_Click(object sender, EventArgs e)//when button clicks ,selects absent teachers from db and loads the data to radgrid table
{
substituteDA mysub;
try
{
DataTable dt1 = new DataTable();
string dayofweek = System.DateTime.Now.DayOfWeek.ToString();
if (dayofweek == "Monday")
{
mysub = new substituteDA();
dt1 = mysub.absentTeachersMon();
RadGrid1.DataSource = dt1;
RadGrid1.DataBind();
}
if (dayofweek == "Tuesday")
{
mysub = new substituteDA();
dt1 = mysub.absentTeachersTues();
RadGrid1.DataSource = dt1;
RadGrid1.DataBind();
}
if (dayofweek == "Wednesday")
{
mysub = new substituteDA();
dt1 = mysub.absentTeachersWed();
RadGrid1.DataSource = dt1;
RadGrid1.DataBind();
}
if (dayofweek == "Thursday")
{
mysub = new substituteDA();
dt1 = mysub.absentTeachersThus();
RadGrid1.DataSource = dt1;
RadGrid1.DataBind();
}
if (dayofweek == "Friday")//select present teachers from db and they are set to display in the radgrid
{
mysub = new substituteDA();
dt1 = mysub.absentTeachersFri();
RadGrid1.DataSource = dt1;
RadGrid1.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void FreeslotsofselectedTchrsBtn_Click(object sender, EventArgs e)
{
string dayofweek = System.DateTime.Now.DayOfWeek.ToString();
DataTable dt2 = new DataTable();
int[] myArray = new int[7];
int key = 0;
string presnt_teacher = Present_teher_Dp_dwn.SelectedValue;
string[] pt = presnt_teacher.Split(':');
string pst_T = pt[0];
substituteCLZ obj = new substituteCLZ(pst_T);
substituteDA mysub3 = new substituteDA();
if (dayofweek == "Monday")
{
dt2 = mysub3.findTechrTTMon(obj);
for (int j = 0; j < dt2.Rows.Count; j++)
{
int no = Convert.ToInt32(dt2.Rows[j][1]);
myArray[key] = no;
key++;
}
int upperlimit = 9;
int[] b = new int[upperlimit];
for (int i = 0; i < myArray.Length; i++)
{
b[myArray[i]] = 1;
}
for (int k = 1; k < upperlimit; k++)
{
if (b[k] == 0)
{
ListBox1.Items.Add(k.ToString());
}
}
}
if (dayofweek == "Tuesday")
{
dt2 = mysub3.findTechrTTTues(obj);
for (int j = 0; j < dt2.Rows.Count; j++)
{
int no = Convert.ToInt32(dt2.Rows[j][1]);
myArray[key] = no;
key++;
}
int upperlimit = 17;
int[] b = new int[upperlimit];
for (int i = 0; i < myArray.Length; i++)
{
b[myArray[i]] = 1;
}
for (int k = 9; k < upperlimit; k++)
{
if (b[k] == 0)
{
ListBox1.Items.Add(k.ToString());
}
}
}
if (dayofweek == "Wednesday")
{
dt2 = mysub3.findTechrTTWedn(obj);
for (int j = 0; j < dt2.Rows.Count; j++)
{
int no = Convert.ToInt32(dt2.Rows[j][1]);
myArray[key] = no;
key++;
}
int upperlimit = 25;
int[] b = new int[upperlimit];
for (int i = 0; i < myArray.Length; i++)
{
b[myArray[i]] = 1;
}
for (int k = 17; k < upperlimit; k++)
{
if (b[k] == 0)
{
ListBox1.Items.Add(k.ToString());
}
}
}
if (dayofweek == "Thursday")
{
dt2 = mysub3.findTechrTTThurs(obj);
for (int j = 0; j < dt2.Rows.Count; j++)
{
int no = Convert.ToInt32(dt2.Rows[j][1]);
myArray[key] = no;
key++;
}
int upperlimit = 33;
int[] b = new int[upperlimit];
for (int i = 0; i < myArray.Length; i++)
{
b[myArray[i]] = 1;
}
for (int k = 25; k < upperlimit; k++)
{
if (b[k] == 0)
{
ListBox1.Items.Add(k.ToString());
}
}
}
if (dayofweek == "Friday")
{
dt2 = mysub3.findTechrTTFri(obj);
//store all the slots of present teachers' in the myArray[] (today slots)
for (int j = 0; j < dt2.Rows.Count; j++)
{
int no = Convert.ToInt32(dt2.Rows[j][1]);
myArray[key] = no;
key++;
}
int upperlimit = 41;
int[] b = new int[upperlimit];
for (int i = 0; i < myArray.Length; i++)
{
b[myArray[i]] = 1;
}
for (int k = 33; k < upperlimit; k++)
{
if (b[k] == 0)
{
ListBox1.Items.Add(k.ToString());
}
}
}
}
protected void SelectPrstTchrsBtn_Click(object sender, EventArgs e)//when the button clicks,load the present teachers which are filtered from db to the drop down list
{
substituteDA mysub2;
{
try
{
DataTable dt2 = new DataTable();
string dayofweek = System.DateTime.Now.DayOfWeek.ToString();
if (dayofweek == "Monday")
{
mysub2 = new substituteDA();
dt2 = mysub2.distinctPresntMon();
for (int i = 0; i < dt2.Rows.Count; i++)
{
string prstTchrs = dt2.Rows[i][0].ToString();
Present_teher_Dp_dwn.Items.Insert(i, prstTchrs.ToString());
}
}
if (dayofweek == "Tuesday")
{
mysub2 = new substituteDA();
dt2 = mysub2.distinctPresntTues();
for (int i = 0; i < dt2.Rows.Count; i++)
{
string prstTchrs = dt2.Rows[i][0].ToString();
Present_teher_Dp_dwn.Items.Insert(i, prstTchrs.ToString());
}
}
if (dayofweek == "Wednesday")
{
mysub2 = new substituteDA();
dt2 = mysub2.distinctPresntWed();
for (int i = 0; i < dt2.Rows.Count; i++)
{
string prstTchrs = dt2.Rows[i][0].ToString();
Present_teher_Dp_dwn.Items.Insert(i, prstTchrs.ToString());
}
}
if (dayofweek == "Thursday")
{
mysub2 = new substituteDA();
dt2 = mysub2.distinctPresntThus();
for (int i = 0; i < dt2.Rows.Count; i++)
{
string prstTchrs = dt2.Rows[i][0].ToString();
Present_teher_Dp_dwn.Items.Insert(i, prstTchrs.ToString());
}
}
if (dayofweek == "Friday")//load the present teachers which are filtered from db to the drop down list
{
mysub2 = new substituteDA();
dt2 = mysub2.distinctPresntFri();
for (int i = 0; i < dt2.Rows.Count; i++)
{
string prstTchrs = dt2.Rows[i][0].ToString();
Present_teher_Dp_dwn.Items.Insert(i, prstTchrs.ToString());
}
}
}
catch (Exception e1) {
throw e1;
}
}
}