public DataTable absentTeachersWed()
{
string query = "";
try
{
srv = new smss_web_service_app();
XMLReader = new readXML();
query = XMLReader.readXMLtxt("absentTeachers", "~/DATA/XML/substituteXML.xml");
query = query.Replace("@from", "17");
query = query.Replace("@to", "24");
query = query.Replace("@a", "21");
query = query.Replace("@b", "24");
query = query.Replace("@c", "17");
query = query.Replace("@d", "20");
dt = srv.Search(query);
}
catch (Exception e)
{
throw e;
}
return(dt);
}
public DataTable findTechrTTMon(substituteCLZ obj)
{
string query = "";
try
{
srv = new smss_web_service_app();
XMLReader = new readXML();
query = XMLReader.readXMLtxt("presentTchsTT", "~/DATA/XML/substituteXML.xml");
query = query.Replace("@from", "1");
query = query.Replace("@to", "8");
query = query.Replace("@a", "1");
query = query.Replace("@b", "4");
query = query.Replace("@c", "5");
query = query.Replace("@d", "8");
query = query.Replace("@e", obj.present_teacher);
dt = srv.Search(query);//return the techer_id,class_id,slot_id,subject_type_name,subject_code and leave_category_id
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public DataTable findTechrTTFri(substituteCLZ obj)
{
string query = "";
try
{
srv = new smss_web_service_app();
XMLReader = new readXML();
//query = readXML("presentTchsTT");
query = XMLReader.readXMLtxt("presentTchsTT", "~/DATA/XML/substituteXML.xml");
query = query.Replace("@from", "33");
query = query.Replace("@to", "40");
query = query.Replace("@a", "33");
query = query.Replace("@b", "36");
query = query.Replace("@c", "37");
query = query.Replace("@d", "40");
query = query.Replace("@e", obj.present_teacher);
dt = srv.Search(query);
}
catch (Exception exc)
{
throw exc;
}
return(dt);
}
public DataTable distinctPresntMon()
{
string query = "";
try
{
srv = new smss_web_service_app();
XMLReader = new readXML();
query = XMLReader.readXMLtxt("distictpresentTchrs", "~/DATA/XML/substituteXML.xml");
query = query.Replace("@from", "1");
query = query.Replace("@to", "8");
query = query.Replace("@a", "1");
query = query.Replace("@b", "4");
query = query.Replace("@c", "5");
query = query.Replace("@d", "8");
dt = srv.Search(query);//return the teacher_id of present teachers
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public DataTable distinctPresntFri()
{
string query = "";
try
{
srv = new smss_web_service_app();
XMLReader = new readXML();
query = XMLReader.readXMLtxt("distictpresentTchrs", "~/DATA/XML/substituteXML.xml");
query = query.Replace("@from", "33");
query = query.Replace("@to", "40");
query = query.Replace("@a", "33");
query = query.Replace("@b", "36");
query = query.Replace("@c", "37");
query = query.Replace("@d", "40");
dt = srv.Search(query);
}
catch (Exception exc)
{
throw exc;
}
return(dt);
}
// ..........................................VIEW TEACHER TIMETABLE.............................................
public void viewTeacherTimetable(string teacher_id)
{
// xmlReader = new readXML();
// srv = new smss_web_service_app();
string query = "";
string query1 = "";
try
{
query1 = XMLreader.readXMLtxt("createTemporyTable", "~/DATA/XML/timetableXML.xml");
srv.Modify(query1);
int mon = 1;
int tue = 9;
int wed = 17;
int thu = 25;
int fri = 33;
for (int i = 0; i <= 7; i++)
{
srv = new smss_web_service_app();
query = XMLreader.readXMLtxt("insert_tempory", "~/DATA/XML/timetableXML.xml");
query = query.Replace("@teacher_id", teacher_id);
query = query.Replace("@mon", mon.ToString());
query = query.Replace("@tue", tue.ToString());
query = query.Replace("@wed", wed.ToString());
query = query.Replace("@thu", thu.ToString());
query = query.Replace("@fri", fri.ToString());
srv.Modify(query);
mon = mon + 1;
tue = tue + 1;
wed = wed + 1;
thu = thu + 1;
fri = fri + 1;
}
}
catch (Exception ex)
{
throw ex;
}
}
// should be in leave app list
public DataTable loadLeavesToVPrincipal()
{
srv = new smss_web_service_app();
XMLreader = new readXML();
DataTable dt;
string query;
try
{
query = XMLreader.readXMLtxt("loadRequestedLeavesToVPrincipal", "~/DATA/XML/LeaveXML.xml");
dt = srv.Search(query);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
// should be in leave app list
public DataTable loadTeacherLeaves(string teacherId)
{
srv = new smss_web_service_app();
XMLreader = new readXML();
DataTable dt;
string query;
try
{
query = XMLreader.readXMLtxt("loadTeacherRequestedLeaves", "~/DATA/XML/LeaveXML.xml");
query = query.Replace("@teacherID", teacherId);
dt = srv.Search(query);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
//handle dataflow between database for sending mails
public DataTable loadReceiverMailAndPassword(userCLZ objUser)
{
string query = "";
try
{
srv = new smss_web_service_app();
XMLreader = new readXML();
query = XMLreader.readXMLtxt("getReceiverMailAndPassword", "~/DATA/XML/homeXML.xml");
query = query.Replace("@username", objUser.user_name);
dt = srv.Search(query);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
// should be in leave app list
public double maxLeaves(string leave_type)
{
DataTable dataTable = new DataTable();
try
{
string query = XMLreader.readXMLtxt(leave_type, "~/DATA/XML/LeaveXML.xml");
srv = new smss_web_service_app();
dataTable = srv.Search(query);
if (dataTable.Rows[0]["MAX_DAYS"].ToString() == "null" || dataTable.Rows.Count == 0 || dataTable.Rows[0]["MAX_DAYS"].ToString() == "")
{
return(0);
}
else
{
return(double.Parse(dataTable.Rows[0]["MAX_DAYS"].ToString()));
}
}
catch (Exception ex)
{
throw ex;
}
}
