public void addLeaveToDB(LeaveApplicationDA leaveObj)
{
string query = "";
try
{
query = XMLreader.readXMLtxt("addLeave", "~/DATA/XML/LeaveXML.xml");
leaveObj.leaveID = getLeaveId(teacherID).ToString();
query = query.Replace("@TEACHER_ID", leaveObj.teacherID);
query = query.Replace("@LEAVE_ID", leaveObj.leaveID.ToString());
query = query.Replace("@START_DATE", leaveObj.startDate.ToString("yyyy/M/d"));
query = query.Replace("@END_DATE", leaveObj.endDate.ToString("yyyy/M/d"));
query = query.Replace("@DURATION", leaveObj.duration.ToString());
query = query.Replace("@REASON", leaveObj.reason);
query = query.Replace("@STATUS", leaveObj.status.ToString());
query = query.Replace("@LEAVE_TYPE_ID", leaveObj.leaveTypeId);
query = query.Replace("@LEAVE_CATEGORY_ID", leaveObj.leaveCategoryId);
query = query.Replace("@ABSENT_TIME_PERIOD", leaveObj.absentTimePeriod);
srv.Modify(query);
}
catch (Exception ex)
{
throw ex;
}
}
// should be in leave app list
public string countAvailableAndPendingLeaves(string teacherID)
{
string numOfLeaves = "";
DataTable dataTable = new DataTable();
try
{
query = XMLreader.readXMLtxt("countAvailablePendingLeaves", "~/DATA/XML/LeaveXML.xml");
query = query.Replace("@TEACHERID", teacherID);
dataTable = srv.Search(query);
for (int i = 0; i < 6; i++)
{
if (dataTable.Rows[0][i].ToString() == "null" || dataTable.Rows[0][i].ToString() == "")
{
if (i == 0)
{
numOfLeaves = maxLeaves("maxCas").ToString();
}
else if (i == 1)
{
numOfLeaves = numOfLeaves + "," + maxLeaves("maxMedi").ToString();
}
else
{
numOfLeaves = numOfLeaves + "," + "0";
}
}
else
{
if (i == 0)
{
numOfLeaves = (maxLeaves("maxCas") - Double.Parse(dataTable.Rows[0][i].ToString())).ToString();
}
else if (i == 1)
{
numOfLeaves = numOfLeaves + "," + (maxLeaves("maxMedi") - Double.Parse(dataTable.Rows[0][i].ToString())).ToString();
}
else
{
numOfLeaves = numOfLeaves + "," + dataTable.Rows[0][i].ToString();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(numOfLeaves);
}
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 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 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 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);
}
public bool validateLeaveRequestedEarlier(DateTime requestingDate, string teacherId)
{
try
{
query = XMLreader.readXMLtxt("checkHalfShortLeaveRequestedEarlier", "~/DATA/XML/LeaveXML.xml");
query = query.Replace("@TEACHER_ID", teacherId);
query = query.Replace("@REQUESTING_DATE", requestingDate.Date.ToString("yyyy/M/d"));
leaveTable = srv.Search(query);
if (leaveTable.Rows.Count == 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}