protected void GetTop5UnreadMail()
{
DataSet ds = new DataSet();
dalCommon objCommon = new dalCommon();
dalLibMail objLibMail = new dalLibMail();
try
{
objCommon.UID = Session["UID"].ToString();
ds = objLibMail.GetTop5UnreadMail(objCommon, "UR");
if (ds.Tables[0].Rows.Count > 0)
{
URMsgCount = ds.Tables[0].Rows.Count;
ltrlMessages.Text = "";
int dsRowcount = 0;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ltrlMessages.Text += "<li><a href=\"../SchoolOnline/messages.aspx\"><span class=\"icon-envelope\"></span>New message from <strong>" + ds.Tables[0].Rows[i]["Sender"] + "</strong><small class='muted'>- " + ds.Tables[0].Rows[i]["Date"] + "</small></a></li>";
if (dsRowcount == 5)
{
break;
}
else
{
dsRowcount = dsRowcount + 1;
}
}
}
}
catch (Exception)
{
throw;
}
}
protected void GetStudentProfile()
{
dalCommon objCommon = new dalCommon();
dalDashboard objDashboard = new dalDashboard();
try
{
objCommon.AcaStart = Session["AcaStart"].ToString();
objCommon.StudEmp = Session["StudentID"].ToString();
SqlDataReader rdr1 = objDashboard.GetStudentProfile(objCommon);
if (rdr1.Read())
{
Name = rdr1.GetValue(1).ToString();
ClassSection = rdr1.GetValue(2).ToString();
ltrlProfileDetail.Text = "";
ltrlProfileDetail.Text += "<li><a href=''>";
if (File.Exists(Server.MapPath("../FatherPhoto") + "/F" + Session["ParentID"] + ".jpg") == true)
{
ltrlProfileDetail.Text += "<img src='../FatherPhoto/F" + Session["ParentID"] + ".jpg' height='32px' alt='' class='userthumb' />";
}
else
{
ltrlProfileDetail.Text += "<img src='images/photos/thumb1.png' alt='' class='userthumb' />";
}
ltrlProfileDetail.Text += "<strong>Mr. " + Convert.ToString(rdr1["FatherName"]) + "</strong>Father Name<small></small> </a></li>";
ltrlProfileDetail.Text += "<li><a href=''>";
if (File.Exists(Server.MapPath("../MotherPhoto") + "/M" + Session["ParentID"] + ".jpg") == true)
{
ltrlProfileDetail.Text += "<img src='../MotherPhoto/M" + Session["ParentID"] + ".jpg' height='32px' alt='' class='userthumb' />";
}
else
{
ltrlProfileDetail.Text += "<img src='images/photos/thumb1.png' alt='' class='userthumb' />";
}
ltrlProfileDetail.Text += "<strong>Mrs. " + Convert.ToString(rdr1["MotherName"]) + "</strong> <small>Mother Name</small> </a></li>";
ltrlProfileDetail.Text += "<li class='viewmore'><a href='../SchoolOnline/PLStudentInformation.aspx'>View Full Details</a></li>";
}
rdr1.Close();
rdr1.Dispose();
ClassID = objDashboard.GetClassID(objCommon);
SectionID = objDashboard.GetSectionID(objCommon);
if (File.Exists(Server.MapPath("~/StudentPhoto") + "/S" + Session["StudentID"].ToString() + ".jpg") == true)
{
imgStudent.ImageUrl = "~/StudentPhoto/S" + Session["StudentID"].ToString() + ".jpg?" + System.DateTime.Now.ToFileTimeUtc();
}
}
catch (Exception)
{
throw;
}
finally
{
objDashboard = null;
}
}
public byte[] GetBackupHistory(byte[] loginTicket, int topList)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable data = new dalCommon(null).GetBackupHistory(topList);
return(ZipTools.CompressionDataSet(ServerLibrary.TableToDataSet(data)));
}
public byte[] SearchOutstanding(byte[] loginTicket, string invoiceNo, string customer, DateTime dateFrom, DateTime dateTo, DateTime dateEnd, string outstandingType)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable data = new dalCommon(loginer).SearchOutstanding(invoiceNo, customer, dateFrom, dateTo, dateEnd, outstandingType);
return(ZipTools.CompressionDataSet(ServerLibrary.TableToDataSet(data)));
}
protected void GetNewsEventList()
{
objCommon = new dalCommon();
objDashboard = new dalDashboard();
objCommon.AcaStart = Session["AcaStart"].ToString();
objCommon.SchoolId = Session["SchoolID"].ToString();
objCommon.StudEmp = Session["StudentID"].ToString();
objCommon.strDate = DateTime.Now.Date.ToString("yyyy/MM/dd");
DataTable dt = new DataTable();
try
{
//dt.Load(objDashboard.GetNewsAndEventList(objCommon));
//if (dt.Rows.Count > 0)
//{
rptrNewsEventList.DataSource = objDashboard.GetNewsAndEventList(objCommon);
rptrNewsEventList.DataBind();
//}
}
catch (Exception)
{
throw;
}
finally
{
objCommon = null;
objDashboard = null;
}
}
public byte[] getDataTableSQL(byte[] loginTicket, string sql)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable data = new dalCommon(loginer).getDataTableSQL(sql);
return(ZipTools.CompressionDataSet(DataConverter.TableToDataSet(data)));
}
public byte[] SearchLog(byte[] loginTicket, string sFilter)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable data = new dalCommon(loginer).SearchLog(sFilter); //dalLog.GetLog(loginer, sFilter);
return(ZipTools.CompressionDataSet(DataConverter.TableToDataSet(data)));
}
public byte[] GetTableFieldsDef(byte[] loginTicket, string tableName, bool onlyDisplayField)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable data = new dalCommon(loginer).GetTableFieldsDef(tableName, onlyDisplayField);
return(ZipTools.CompressionDataSet(ServerLibrary.TableToDataSet(data)));
}
public byte[] GetModules(byte[] loginTicket)
{
Loginer loginer = WebServiceSecurity.ValidateLoginer(loginTicket);
DataTable data = new dalCommon(loginer).GetModules();
return(ZipTools.CompressionDataSet(ServerLibrary.TableToDataSet(data)));
}
protected void lnkSignout_Click(object sender, EventArgs e)
{
dalCommon objCommon = new dalCommon();
dalDashboard objDashboard = new dalDashboard();
if (Session["Cache"] != null)
{
Cache.Remove(Session["Cache"].ToString());
}
Session.Clear();
Response.Redirect("~/Logon.aspx");
}
protected void GetParentsProfile()
{
dalCommon objCommon = new dalCommon();
dalDashboard objDashboard = new dalDashboard();
try
{
}
catch (Exception)
{
throw;
}
}
public DataTable GetDiaryDetails(dalCommon objCommon, int flagid, string sFromDate, string sToDate)
{
try
{
DataTable dt = new DataTable();
dt = objCCWeb.BindDataTable("Exec Sp_PLPersonalDairy " + objCommon.SchoolId + "," + flagid + ",'" + sFromDate + "','" + sToDate + "'");
return(dt);
}
catch (Exception)
{
throw;
}
}
public byte[] GetSystemDataSet(byte[] validationTicket)
{
bool pass = WebServiceSecurity.ValidateLoginIdentity(validationTicket);
//检查校验码成功,有效的登录请求.
if (pass)
{
DataTable data = new dalCommon(null).GetSystemDataSet();
return(ZipTools.CompressionDataSet(ServerLibrary.TableToDataSet(data)));
}
else
{
return(null);
}
}
public byte[] GetSystemDataSetByOrg(byte[] validationTicket, string sOrgID)
{
bool pass = WebServiceSecurity.ValidateLoginIdentity(validationTicket);
//检查校验码成功,有效的登录请求.
if (pass)
{
DataTable data = new dalCommon(null).GetSystemDataSetByOrg(sOrgID);
return(ZipTools.CompressionDataSet(DataConverter.TableToDataSet(data)));
}
else
{
return(null);
}
}
protected void NewsEventBind()
{
objDashboard = new dalDashboard();
objCommon = new dalCommon();
objCommon.AcaStart = Session["AcaStart"].ToString();
objCommon.SchoolId = Session["SchoolID"].ToString();
objCommon.StudEmp = Session["StudentID"].ToString();
try
{
rptrEventList.DataSource = objDashboard.GetEventList(objCommon);
rptrEventList.DataBind();
}
catch (Exception)
{
throw;
}
}
protected void GeRecentAssignmentList()
{
DataTable dt = new DataTable();
dalCommon objCommon = new dalCommon();
objCommon.AcaStart = Session["AcaStart"].ToString();
objCommon.SchoolId = Session["SchoolID"].ToString();
objCommon.StudEmp = Session["StudentID"].ToString();
dt = objDashboard.GetRecentAssignmentList(objCommon, 5);
if (dt.Rows.Count > 0)
{
ltrlRecentAssignment.Text = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
ltrlRecentAssignment.Text += "<li>";
ltrlRecentAssignment.Text += "";
ltrlRecentAssignment.Text += "<div class='slide_wrap'>";
ltrlRecentAssignment.Text += " <div class='slide_date'>";
ltrlRecentAssignment.Text += "<span class='date-dash'>" + Convert.ToDateTime(dt.Rows[i]["Date"], cinfo).ToString("dd") + " </span><span class='month'> " + dt.Rows[i]["Month"] + " </span>";
ltrlRecentAssignment.Text += "</div>";
ltrlRecentAssignment.Text += " <div class='slide_content'>";
ltrlRecentAssignment.Text += " <h4>";
ltrlRecentAssignment.Text += "" + dt.Rows[i]["AssigntmentTitle"] + "</h4>";
ltrlRecentAssignment.Text += " <p>";
ltrlRecentAssignment.Text += "" + dt.Rows[i]["Assignment"] + "</p>";
ltrlRecentAssignment.Text += "<p>";
ltrlRecentAssignment.Text += "<a class='btn btn-primary' href='assignment.aspx?AssignmentID=" + dt.Rows[i]["AssignmentID"] + "'>";
ltrlRecentAssignment.Text += " View More</a>";
ltrlRecentAssignment.Text += "</p>";
ltrlRecentAssignment.Text += "</div>";
ltrlRecentAssignment.Text += "</div>";
ltrlRecentAssignment.Text += "<div class='assignment-border'>";
ltrlRecentAssignment.Text += "</div>";
if (i + 1 == dt.Rows.Count)
{
break;
}
else
{
i = i + 1;
}
ltrlRecentAssignment.Text += "<div class='slide_wrap'>";
ltrlRecentAssignment.Text += " <div class='slide_date'>";
ltrlRecentAssignment.Text += "<span class='date-dash'>" + Convert.ToDateTime(dt.Rows[i]["Date"], cinfo).ToString("dd") + " </span><span class='month'> " + dt.Rows[i]["Month"] + " </span>";
ltrlRecentAssignment.Text += " </div>";
ltrlRecentAssignment.Text += " <div class='slide_content'>";
ltrlRecentAssignment.Text += "<h4>";
ltrlRecentAssignment.Text += " " + dt.Rows[i]["AssigntmentTitle"] + "</h4>";
ltrlRecentAssignment.Text += " <p>";
if (dt.Rows[i]["Assignment"].ToString().Length > 30)
{
ltrlRecentAssignment.Text += " " + dt.Rows[i]["Assignment"].ToString().Substring(1, 30) + "...</p>";
}
else
{
ltrlRecentAssignment.Text += " " + dt.Rows[i]["Assignment"].ToString() + "...</p>";
}
ltrlRecentAssignment.Text += " <p>";
ltrlRecentAssignment.Text += " <a class='btn btn-primary' href='assignment.aspx?AssignmentID=" + dt.Rows[i]["AssignmentID"] + "'>";
ltrlRecentAssignment.Text += " View More</a>";
ltrlRecentAssignment.Text += " </p>";
ltrlRecentAssignment.Text += " </div>";
ltrlRecentAssignment.Text += " </div>";
ltrlRecentAssignment.Text += " </li>";
}
}
//rptrRecentAssignments.DataSource =
//rptrRecentAssignments.DataBind();
}
protected void GetFeeDetails()
{
DataTable dt = new DataTable();
objCommon = new dalCommon();
objDashboard = new dalDashboard();
objCommon.AcaStart = Session["AcaStart"].ToString();
objCommon.SchoolId = Session["SchoolID"].ToString();
objCommon.StudEmp = Session["StudentID"].ToString();
try
{
dt.Load(objDashboard.GetFeeDetails(objCommon));
if (dt.Rows.Count > 0)
{
ltrlFeedetail.Text = "";
ltrlFeedetail.Text += "<div class='heading'>" +
"<div class='col'>Installment</div>" +
"<div class='col'>Amount</div>" +
"<div class='col'>Paid</div>" +
"<div class='col'>Fine/Excess</div>" +
"<div class='col'>Balance</div>" +
"</div>";
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i + 1 != dt.Rows.Count)
{
ltrlFeedetail.Text += "<div class='table-row'>";
ltrlFeedetail.Text += "<div class='col'>";
ltrlFeedetail.Text += "" + dt.Rows[i]["Installment"] + "</div>";
ltrlFeedetail.Text += "<div class='col'>";
ltrlFeedetail.Text += "" + dt.Rows[i]["Amount"] + "</div>";
ltrlFeedetail.Text += "<div class='col'>";
ltrlFeedetail.Text += "" + dt.Rows[i]["Paid"] + "</div>";
ltrlFeedetail.Text += "<div class='col'>";
ltrlFeedetail.Text += "" + dt.Rows[i]["Fine/Excess"] + "</div>";
ltrlFeedetail.Text += "<div class='col'>";
ltrlFeedetail.Text += "" + dt.Rows[i]["Balance"] + "</div>";
ltrlFeedetail.Text += "</div>";
}
else
{
ltrlFeedetail.Text += " <div class='total'>";
ltrlFeedetail.Text += "<div class='col'>";
ltrlFeedetail.Text += "" + dt.Rows[i]["Installment"] + "</div>";
ltrlFeedetail.Text += "<div class=\"col\">" + dt.Rows[i]["Amount"] + "</div>";
ltrlFeedetail.Text += "<div class=\"col\">" + dt.Rows[i]["Paid"] + "</div>";
ltrlFeedetail.Text += "<div class=\"col\">" + dt.Rows[i]["Fine/Excess"] + "</div>";
ltrlFeedetail.Text += "<div class=\"col\">" + dt.Rows[i]["Balance"] + "</div>";
ltrlFeedetail.Text += "</div>";
}
}
}
// rptrFeeDetails.DataSource = objDashboard.GetFeeDetails(objCommon);
// rptrFeeDetails.DataBind();
}
catch (Exception)
{
throw;
}
finally
{
objCommon = null;
objDashboard = null;
}
}