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 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);
}
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);
}
// 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);
}