/BaliEnterpriseSystems/BaliEnterpriseSystems/BestStudentSchedule.aspx.cs
C# | 133 lines | 118 code | 12 blank | 3 comment | 16 complexity | e399a6b603cbc765486072c6e20340c2 MD5 | raw file
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Web;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using BaliEnterpriseSystems.BestObjects;
- using System.Text;
- using System.Data;
- using System.Data.OleDb;
- namespace BaliEnterpriseSystems
- {
- public partial class BestStudentSchedule : System.Web.UI.Page
- {
- protected void Page_Load(object sender, EventArgs e)
- {
- }
- protected void Page_LoadComplete(object sender, EventArgs e)
- {
- if (HttpContext.Current.Session["CurrentUser"] == null)
- {
- Response.Redirect("Logout.aspx");
- }
- ltrSubMenu.Text = UtilMenu.StudentMenu("studentschedule");
- if (!Utils.User.UserRoleByName("Student - Schedule").allowView)
- {
- ltrValidateMsg.Text = "You do not have rights to view.";
- return;
- }
- string ms = Request.QueryString["ms"];
- this.ltrMScript.Text = Utils.MenuSelectScript(ms);
- BestStudents bstd = new BestStudents();
- bstd.LoadRows("CenterId=?", Utils.User.CIdParam,"firstname");
- string selstudent = Request.Form["selStudent"];
- StringBuilder sb = new StringBuilder();
- sb.Append("");
- string selName = "";
- string emailaddress = "";
- for (int i = 0; i < bstd.TableRows.Count; i++)
- {
- string sname = bstd.TableRows[i].Fields["firstname"].fieldValue + " " + bstd.TableRows[i].Fields["lastname"].fieldValue;
- string sguid = bstd.TableRows[i].Fields["guidfield"].fieldValue;
- sb.Append("<option value=\"" + HttpUtility.HtmlEncode(sguid) + "\"");
- if (string.IsNullOrEmpty(selstudent))
- {
- selstudent = sguid;
- }
- if (sguid.Equals(selstudent))
- {
- selName = sname;
- emailaddress = bstd.TableRows[i].Fields["emailId"].fieldValue;
- sb.Append(" selected ");
- }
- sb.Append(">" + HttpUtility.HtmlEncode(sname) + "</option>");
- }
- ltrStudentOpts.Text = sb.ToString();
- string fromdate = Request.Form["fromdate"] ?? "";
- string todate = Request.Form["todate"] ?? "";
- DateTime today = DateTime.Today;
- int curweek = ((int)today.DayOfWeek) * -1;
- if (string.IsNullOrEmpty(fromdate))
- {
- fromdate = today.AddDays(curweek).ToString("MM/dd/yyyy");
- }
- if (string.IsNullOrEmpty(todate))
- {
- todate = today.AddDays(curweek).AddDays(7).ToString("MM/dd/yyyy");
- }
- ltrLoadScript.Text = "<script type=\"text/javascript\">$(document).ready(function(){$('#fromdate').val('" + fromdate + "'); $('#todate').val('" + todate + @"');
- }); </script>";
- if (!string.IsNullOrEmpty(selstudent))
- {
- string tsql = "select Date, [Sunday], [Monday], [Tuesday], [Wednesday], [Thursday], [Friday], [Saturday] from VBestSchedules where ";
- tsql += "(stuGuid1='" + selstudent + "' or stuGuid2='" + selstudent + "' or stuGuid3='" + selstudent + "' or stuGuid4='" + selstudent + "' or stuGuid5='" + selstudent + "') and convert(datetime,date) between '" + fromdate + @"' and '" + todate + @"' order by convert(datetime, date), convert(numeric, schfrom)";
- StringBuilder sbSchd = new StringBuilder();
- BestDatabase db = new BestDatabase();
- OleDbCommand myCmd = db.dbCmd;
- myCmd.CommandText = tsql;
- OleDbDataReader tblReader = myCmd.ExecuteReader(CommandBehavior.KeyInfo);
- //Retrieve column schema into a DataTable.
- DataTable schemaTable = tblReader.GetSchemaTable();
- sbSchd.Append("<table cellpadding=\"0\" style=\"padding:1px;font-family:Tahoma;font-size:12px;border:1px solid #999;background-color:#A11117\"><tr>");
- //For each field in the table...
- int fieldCnt = 0;
- foreach (DataRow myField in schemaTable.Rows)
- {
- fieldCnt++; if (fieldCnt > 8) break;
- sbSchd.Append("<th style=\"color:#000;background-color:#E9BA15;padding:2px;\">" + myField[0] + "</th>");
- }
- sbSchd.Append("</tr>");
- int cnt = 0;
- while (tblReader.Read())
- {
- string trclass = (cnt % 2 == 0) ? "" : "trordd";
- sbSchd.Append("<tr style=\"font-family:Tahoma;color:#FFF;font-size:12px;\"><td>" + (tblReader[0].ToString()) + "</td>");
- sbSchd.Append("<td>" + Utils.ToTimeFormat(tblReader[1].ToString()) + "</td>");
- sbSchd.Append("<td>" + Utils.ToTimeFormat(tblReader[2].ToString()) + "</td>");
- sbSchd.Append("<td>" + Utils.ToTimeFormat(tblReader[3].ToString()) + "</td>");
- sbSchd.Append("<td>" + Utils.ToTimeFormat(tblReader[4].ToString()) + "</td>");
- sbSchd.Append("<td>" + Utils.ToTimeFormat(tblReader[5].ToString()) + "</td>");
- sbSchd.Append("<td>" + Utils.ToTimeFormat(tblReader[6].ToString()) + "</td>");
- sbSchd.Append("<td>" + Utils.ToTimeFormat(tblReader[7].ToString()) + "</td></tr>");
- cnt++;
- }
- tblReader.Close();
- sbSchd.Append("</table>");
- ltrSchdules.Text = sbSchd.ToString();
- /* Sending EMail */
- string sendEClick = Request.Form["sendEMailClick"] ?? "";
- if (!string.IsNullOrEmpty(sendEClick) && sendEClick.Equals("1") && emailaddress.Length > 0)
- {
- string emailbody = "Dear " + selName + "<br />Following is your Schedule from " + fromdate + " to " + todate + ":<br />" + sbSchd.ToString() + "<br />Thank you<br />Bali Learning";
- if (Utils.User.emailUtil.Send(emailaddress, "Schedule Info", emailbody, selName))
- {
- ltrEMessage.Text = "EMail Sent To: " + Server.HtmlEncode(emailaddress);
- }
- }
- }
- }
- }
- }