public BestStudentNotes()
{
this.TableName = "BestStudentNotes";
this.SecurityPage = "Student - Notes";
TableFields.Add(new BestField() { fieldName = "guidfield", fieldHeader = "guid", displayField = false, fieldSize = 40, IsRequired = true, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid });
TableFields.Add(new BestField() { fieldName = "lastChange", fieldHeader = "Last Change", displayField = false, fieldSize = 20, IsRequired = true, fieldType = "System.DateTime", paramOledbType = System.Data.OleDb.OleDbType.DBTimeStamp });
TableFields.Add(new BestField() { fieldName = "lastChangeUser", fieldHeader = "Last Change User", displayField = false, fieldSize = 128, IsRequired = true, fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar });
TableFields.Add(new BestField() { fieldName = "studentGuid", fieldHeader = "Student Name", displayField = true, fieldSize = 40, IsRequired = false, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, displayFormatFunc = new Func<BestRow,object>( (obj) =>
{
BestRow bstd = (BestRow)obj;
List<BestField> bparams = new List<BestField>();
BestField guid = new BestField() { fieldName = "studentGuid", fieldSize = 40, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, displayField = false };
guid.fieldValue = bstd.Fields["studentGuid"].fieldValue;
bparams.Add(guid);
BestStudents bpstd = new BestStudents();
bpstd.LoadRows("guidfield=?", bparams);
return bpstd.firstName + " " + bpstd.lastName;
})});
TableFields.Add(new BestField() { fieldName = "noteDate", fieldHeader = "Note Date", displayField = true, fieldSize = 20, IsRequired = true, fieldType = "System.DateTime", paramOledbType = System.Data.OleDb.OleDbType.DBDate });
TableFields.Add(new BestField() { fieldName = "notes", fieldHeader = "Notes", displayField = true, fieldSize = 9000, IsRequired = true, fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar});
TableFields.Add(new BestField() { fieldName = "CenterId", displayField = true, fieldHeader = "Center Id", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 50 });
TableFields.Add(new BestField() { fieldName = "StudentId", displayField = true, fieldHeader = "Student Id", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 50 });
}
public PaymentDetails()
{
this.TableName = "BestPaymentDetails";
this.SecurityPage = "Payment - Details";
TableFields.Add(new BestField() { fieldName = "paymentTypeGuid", fieldHeader = "Program Type", displayField = true, fieldSize = 128, IsRequired = true, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid,
displayFormatFunc = new Func<BestRow, object>((obj) =>
{
BestRow pd = (BestRow)obj;
List<BestField> bparams = new List<BestField>();
BestField guid = new BestField() { fieldName = "paymentTypeGuid", fieldSize = 40, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, displayField = false };
guid.fieldValue = pd.Fields["paymentTypeGuid"].fieldValue;
bparams.Add(guid);
PaymentTypes bptype = new PaymentTypes();
bptype.LoadRows("guidfield=?", bparams);
return bptype.paymentType;
})
});
TableFields.Add(new BestField() { fieldName = "studentGuid", fieldHeader = "Student", displayField = true, fieldSize = 128, IsRequired = true, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid,
displayFormatFunc = new Func<BestRow,object>((obj)=>
{
BestRow pd = (BestRow)obj;
List<BestField> bparams = new List<BestField>();
BestField guid = new BestField() { fieldName = "studentGuid", fieldSize = 40, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, displayField = false };
guid.fieldValue = pd.Fields["studentGuid"].fieldValue;
bparams.Add(guid);
BestStudents bpstd = new BestStudents();
bpstd.LoadRows("guidfield=?", bparams);
return bpstd.firstName + " " + bpstd.lastName;
})
});
TableFields.Add(new BestField() { fieldName = "amount", fieldHeader = "Amount", displayField = true, fieldSize = 18, IsRequired = false, fieldType = "System.Decimal", paramOledbType = System.Data.OleDb.OleDbType.Decimal });
TableFields.Add(new BestField() { fieldName = "paymentDate", fieldHeader = "Payment Date", displayField = true, fieldSize = 10, IsRequired = false, fieldType = "System.DateTime", paramOledbType = System.Data.OleDb.OleDbType.DBTimeStamp,
displayFormatFunc = new Func<BestRow,object>((obj)=>
{
BestRow br = (BestRow) obj;
DateTime dt = Convert.ToDateTime(br.Fields["paymentDate"].fieldValue);
return dt.ToString("MM/dd/yyyy");
})
});
TableFields.Add(new BestField() { fieldName = "guidfield", fieldHeader = "guid", displayField = false, fieldSize = 40, IsRequired = false, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid });
TableFields.Add(new BestField() { fieldName = "lastChange", fieldHeader = "Last Change", displayField = false, fieldSize = 20, IsRequired = false, fieldType = "System.DateTime", paramOledbType = System.Data.OleDb.OleDbType.DBTimeStamp });
TableFields.Add(new BestField() { fieldName = "lastChangeUser", fieldHeader = "Last Change User", displayField = false, fieldSize = 128, IsRequired = false, fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar });
TableFields.Add(new BestField() { fieldName = "hours", fieldHeader = "Hours", displayField = true, fieldSize = 18, IsRequired = false, fieldType = "System.Decimal", paramOledbType = System.Data.OleDb.OleDbType.Decimal, Precision = 18, scale = 2 });
TableFields.Add(new BestField() { fieldName = "CenterId", displayField = true, fieldHeader = "Center Id", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 50 });
}
public BestStudentPicture()
{
this.TableName = "BestStudentPicture";
this.SecurityPage = "Student - Information";
TableFields.Add(new BestField() { fieldName = "guidfield", displayField = false, fieldHeader = "Guid", fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, fieldSize = 40 });
TableFields.Add(new BestField() { fieldName = "lastChange", displayField = false, fieldHeader = "Last Change", fieldType = "System.DateTime", paramOledbType = System.Data.OleDb.OleDbType.DBTime, fieldSize = 20 });
TableFields.Add(new BestField() { fieldName = "lastChangeUser", displayField = false, fieldHeader = "Last Change User", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 128 });
TableFields.Add(new BestField() { fieldName = "CenterId", displayField = true, fieldHeader = "Center Id", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 50 });
TableFields.Add(new BestField() { fieldName = "StudentId", displayField = true, fieldHeader = "Student Id", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 50 });
TableFields.Add(new BestField()
{
fieldName = "studentGuid",
fieldHeader = "Student Name",
displayField = true,
fieldSize = 128,
IsRequired = true,
fieldType = "System.Guid",
paramOledbType = System.Data.OleDb.OleDbType.Guid,
displayFormatFunc = new Func<BestRow, object>((obj) =>
{
BestRow pd = (BestRow)obj;
List<BestField> bparams = new List<BestField>();
BestField guid = new BestField() { fieldName = "studentGuid", fieldSize = 40, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, displayField = false };
guid.fieldValue = pd.Fields["studentGuid"].fieldValue;
bparams.Add(guid);
BestStudents bpstd = new BestStudents();
bpstd.LoadRows("guidfield=?", bparams);
return bpstd.firstName + " " + bpstd.lastName;
})
});
TableFields.Add(new BestField() { fieldName = "picture", displayField = false, fieldHeader = "Photo", fieldType = "System.byte[]", paramOledbType = System.Data.OleDb.OleDbType.LongVarBinary, fieldSize = -1 });
TableFields.Add(new BestField() { fieldName = "photoSize", displayField = false, fieldHeader = "Photo Size", fieldType = "System.Decimal", paramOledbType = System.Data.OleDb.OleDbType.Decimal, fieldSize = 18 });
TableFields.Add(new BestField() { fieldName = "photoName", displayField = true, fieldHeader = "Photo Name", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 200 });
//hobbies,personality,goals,learningstyle,tutorpreference,
TableFields.Add(new BestField() { fieldName = "hobbies", displayField = false, fieldHeader = "Hobbies", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 500 });
TableFields.Add(new BestField() { fieldName = "personality", displayField = false, fieldHeader = "Personality", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 500 });
TableFields.Add(new BestField() { fieldName = "goals", displayField = false, fieldHeader = "Goals", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 500 });
TableFields.Add(new BestField() { fieldName = "learningstyle", displayField = false, fieldHeader = "Learning Style", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 500 });
TableFields.Add(new BestField() { fieldName = "tutorpreference", displayField = false, fieldHeader = "Tutor Preference", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 50 });
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
if (HttpContext.Current.Session["CurrentUser"] == null)
{
Response.Redirect("Logout.aspx");
}
ltrSubMenu.Text = UtilMenu.PaymentMenu("paymentdetails");
if (!Utils.User.UserRoleByName("Payment - Details").allowView)
{
ltrGrid.Text = "You do not have rights to view.";
return;
}
string ms = Request.QueryString["ms"];
ltrMScript.Text = Utils.MenuSelectScript(ms);
string saveClicked = Request.Form["SaveClicked"] ?? "";
if (IsPostBack && saveClicked.Equals("1"))
{
PaymentDetails bs = new PaymentDetails();
string isnew = Request.Form["isnew"];
bool cansave = true;
if (string.IsNullOrEmpty(isnew))
{
List<BestField> bparams = new List<BestField>();
BestField guid = new BestField() { fieldName = "guidfield", fieldSize = 40, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, displayField = false };
guid.fieldValue = Request.Form["guidfield"];
bparams.Add(guid);
if (!string.IsNullOrEmpty(guid.fieldValue))
{
bs.LoadRows("guidfield=?", bparams);
}
else
{
string delguid = Request.Form["deleteguid"];
if (!string.IsNullOrEmpty(delguid))
{
bparams[0].fieldValue = delguid;
bs.LoadRows("guidfield=?", bparams);
bs.CurrentRow.IsDelete = true;
bs.CurrentRow.Save();
}
cansave = false;
}
}
if (cansave)
{
string stdguid = Request.Form["g_studentGuid"];
string payguid = Request.Form["g_paymentTypeGuid"];
string amt = Request.Form["g_amount"];
string paydate = Request.Form["g_paymentDate"];
string hours = Request.Form["g_hours"];
if (string.IsNullOrEmpty(payguid))
{
ltrValidateMsg.Text = Utils.WarningMessage("Payment Type is Required.");
cansave = false;
}
if (string.IsNullOrEmpty(stdguid))
{
ltrValidateMsg.Text = Utils.WarningMessage("Student is Required.");
cansave = false;
}
if (string.IsNullOrEmpty(paydate))
{
ltrValidateMsg.Text = Utils.WarningMessage("Payment Date is Required.");
cansave = false;
}
if (cansave)
{
bs.studentGuid = new Guid(stdguid);
bs.paymentTypeGuid = new Guid(payguid);
bs.amount = amt;
Decimal dhours;
Decimal.TryParse(hours, out dhours);
bs.hours = dhours;
bs.paymentDate = Convert.ToDateTime(paydate);
bs.CenterId = Utils.User.CenterId;
if (!bs.CurrentRow.Save())
{
ltrValidateMsg.Text = Utils.WarningMessage(bs.CurrentRow.lastError);
}
}
}
}
PaymentTypes bpayTypes = new PaymentTypes();
bpayTypes.LoadRows();
StringBuilder sbc = new StringBuilder();
sbc.Append("<option value=\"\"></option>");
for (int rnum = 0; rnum < bpayTypes.TableRows.Count; rnum++)
{
string paytype = bpayTypes.TableRows[rnum].Fields["paymentType"].fieldValue;
string guid = bpayTypes.TableRows[rnum].Fields["guidfield"].fieldValue;
sbc.Append("<option value=\"" + HttpUtility.HtmlEncode(guid) + "\">" + HttpUtility.HtmlEncode(paytype) + "</option>");
}
ltrPayTypes.Text = sbc.ToString();
/* Auto Student */
string autoSample = "{value:\"[paramValue]\", label:[paramLabel]}";
StringBuilder sb = new StringBuilder();
sb.AppendLine("autoStudents = [");
BestStudents bstd = new BestStudents();
bstd.LoadRows("CenterId=?", Utils.User.CIdParam);
for (int s = 0; s < bstd.TableRows.Count; s++)
{
string result = autoSample;
result = result.Replace("[paramValue]", bstd.TableRows[s].Fields["guidfield"].fieldValue);
result = result.Replace("[paramLabel]", Utils.EnquoteJS((bstd.TableRows[s].Fields["firstName"].fieldValue ?? "") + " " +
(bstd.TableRows[s].Fields["lastName"].fieldValue ?? "")));
sb.Append(result);
if (s < bstd.TableRows.Count - 1) sb.AppendLine(",");
}
sb.AppendLine("];");
ltrScript.Text = @"<script type=""text/javascript"">
$(document).ready(function(){ " + sb.ToString() + @"
$('#studentTag1').autocomplete( { source:autoStudents, delay: 0, select : function( event, ui){
$('#studentGuid').val( ui.item.value );
$( this ).val( ui.item.label );
return false;
} } ); }); </script>";
BestGrid bsGrid = new BestGrid();
bsGrid.PageRequest = Page.Request;
bsGrid.Title = "Payment Details";
bsGrid.GridTable = new PaymentDetails();
bsGrid.securityPage = "Payment - Details";
ltrGrid.Text = bsGrid.ToHTML();
}
private string StudentOptions()
{
StringBuilder sb = new StringBuilder();
string stuguid = Request.Form["StudentGuid"] ?? "";
sb.Append("<option value=\"\"></option>");
BestStudents bs = new BestStudents();
bs.LoadRows("CenterId=?", "centerid", Utils.User.CenterId, "firstname");
sb.Append(string.Join("", bs.TableRows.Rows.Select(x => "<option value=\"" + Server.HtmlEncode(x.Fields["guidfield"].fieldValue) + "\" " + (stuguid.Equals(x.Fields["guidfield"].fieldValue)?"selected":"") + " >" + Server.HtmlEncode(x.Fields["firstname"].fieldValue + " " + x.Fields["lastname"].fieldValue) + "</option>").ToArray()));
return sb.ToString();
}
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);
}
}
}
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
if (HttpContext.Current.Session["CurrentUser"] == null)
{
Response.Redirect("Logout.aspx");
}
ltrSubMenu.Text = UtilMenu.StudentMenu("studentinfo");
if (!Utils.User.UserRoleByName("Student - Information").allowView)
{
ltrGrid.Text = "You do not have rights to view.";
return;
}
string ms = Request.QueryString["ms"];
ltrMScript.Text = Utils.MenuSelectScript(ms);
BestCenters bcs = new BestCenters();
bcs.LoadRows();
StringBuilder sbc = new StringBuilder();
sbc.Append("<option value=\"\"></option>");
for (int rnum = 0; rnum < bcs.TableRows.Count; rnum++)
{
string cid = bcs.TableRows[rnum].Fields["CenterId"].fieldValue;
sbc.Append("<option value=\"" + HttpUtility.HtmlEncode(cid) + "\">" + HttpUtility.HtmlEncode(cid) + "</option>");
}
this.ltrCenters.Text = sbc.ToString();
StringBuilder jsbp = new StringBuilder();
jsbp.Append("jsProg=[");
StringBuilder sbp = new StringBuilder();
sbp.Append("<option value=\"\"></option>");
BestPrograms bps = new BestPrograms();
bps.LoadRows();
for (int rnum = 0; rnum < bps.TableRows.Count; rnum++)
{
string optext = bps.TableRows[rnum].Fields["programName"].fieldValue + ":" + bps.TableRows[rnum].Fields["programType"].fieldValue + ": Per " + bps.TableRows[rnum].Fields["amountType"].fieldValue;
string optval = bps.TableRows[rnum].Fields["guidfield"].fieldValue;
sbp.Append("<option value=\"" + HttpUtility.HtmlEncode(optval) + "\">" + HttpUtility.HtmlEncode(optext) + "</option>");
jsbp.Append("{\"guid\":\"" + optval + "\",\"amount\":\"" + bps.TableRows[rnum].Fields["amount"].fieldValue + "\",\"amountType\":\"" + bps.TableRows[rnum].Fields["amountType"].fieldValue + "\"}");
if (rnum < bps.TableRows.Count - 1) jsbp.Append(",");
}
jsbp.Append("]");
this.ltrProgScript.Text = "<script type=\"text/javascript\">" + jsbp.ToString() + "</script>";
this.ltrPrograms.Text = sbp.ToString();
this.ltrStateOpts.Text = Utils.StateOptions();
if (IsPostBack)
{
BestStudents bs = new BestStudents();
string isnew = Request.Form["isnew"];
bool cansave = true;
if (string.IsNullOrEmpty(isnew))
{
List<BestField> bparams = new List<BestField>();
BestField guid = new BestField() { fieldName = "guidfield", fieldSize = 40, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, displayField = false };
guid.fieldValue = Request.Form["guidfield"];
bparams.Add(guid);
if (!string.IsNullOrEmpty(guid.fieldValue))
{
bs.LoadRows("guidfield=?", bparams);
}
else
{
string delguid = Request.Form["deleteguid"];
if (!string.IsNullOrEmpty(delguid))
{
bparams[0].fieldValue = delguid;
bs.LoadRows("guidfield=?", bparams);
bs.CurrentRow.IsDelete = true;
bs.CurrentRow.Save();
}
cansave = false;
}
}
if (cansave)
{
bs.StudentId = Request.Form["g_StudentId"];
bs.CenterId = Request.Form["g_CenterId"];
bs.firstName = Request.Form["g_firstName"];
bs.lastName = Request.Form["g_lastName"];
if (string.IsNullOrEmpty(bs.StudentId))
{
ltrValidateMsg.Text = Utils.WarningMessage("Student Id is Required.");
cansave = false;
}
if (string.IsNullOrEmpty(bs.CenterId))
{
ltrValidateMsg.Text = Utils.WarningMessage("Center Id is Required.");
cansave = false;
}
if (string.IsNullOrEmpty(bs.firstName) && string.IsNullOrEmpty(bs.lastName))
{
ltrValidateMsg.Text = Utils.WarningMessage("First Name or Last Name is required");
cansave = false;
}
if (cansave)
{
bs.middleName = Request.Form["g_middleName"];
bs.parentName = Request.Form["g_parentName"];
if(!string.IsNullOrEmpty(Request.Form["g_programGuid"]))
bs.programGuid = new Guid(Request.Form["g_programGuid"]);
bs.address1 = Request.Form["g_address1"];
bs.address2 = Request.Form["g_address2"];
bs.city = Request.Form["g_city"];
bs.state = Request.Form["g_state"];
bs.zip = Request.Form["g_zip"];
bs.cellPhone = Request.Form["g_cellPhone"];
bs.workPhone = Request.Form["g_workPhone"];
bs.homePhone = Request.Form["g_homePhone"];
bs.emailId = Request.Form["g_emailId"];
bs.gender = Request.Form["g_gender"];
bs.Hours = Request.Form["g_Hours"];
bs.hourType = Request.Form["g_hourType"];
bs.amountType = Request.Form["g_amountType"];
bs.Amount = Request.Form["g_Amount"];
string joinDate = Request.Form["g_joinDate"];
if (!string.IsNullOrEmpty(joinDate))
{
bs.joinDate = Convert.ToDateTime(joinDate);
}
string birthDate = Request.Form["g_birthDate"];
if (!string.IsNullOrEmpty(birthDate))
{
bs.joinDate = Convert.ToDateTime(birthDate);
}
if (!bs.CurrentRow.Save())
{
ltrValidateMsg.Text = Utils.WarningMessage(bs.CurrentRow.lastError);
}
}
}
}
BestGrid bsGrid = new BestGrid();
bsGrid.PageRequest = Page.Request;
bsGrid.Title = "Students Information";
bsGrid.GridTable = new BestStudents();
bsGrid.securityPage = "Student - Information";
ltrGrid.Text = bsGrid.ToHTML();
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
if (HttpContext.Current.Session["CurrentUser"] == null)
{
Response.Redirect("Logout.aspx");
}
ltrSubMenu.Text = UtilMenu.StudentMenu("studentdocument");
if (!Utils.User.UserRoleByName("Student - Documents").allowView)
{
ltrGrid.Text = "You do not have rights to view.";
return;
}
string ms = Request.QueryString["ms"];
this.ltrMScript.Text = Utils.MenuSelectScript(ms);
string saveClicked = Request.Form["SaveClicked"] ?? "";
if (IsPostBack && saveClicked.Equals("1"))
{
BestDocuments bs = new BestDocuments();
string isnew = Request.Form["isnew"];
bool cansave = true;
if (string.IsNullOrEmpty(isnew))
{
List<BestField> bparams = new List<BestField>();
BestField guid = new BestField() { fieldName = "guidfield", fieldSize = 40, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, displayField = false };
guid.fieldValue = Request.Form["guidfield"];
bparams.Add(guid);
if (!string.IsNullOrEmpty(guid.fieldValue))
{
bs.LoadRows("guidfield=?", bparams);
}
else
{
string delguid = Request.Form["deleteguid"];
if (!string.IsNullOrEmpty(delguid))
{
bparams[0].fieldValue = delguid;
bs.LoadRows("guidfield=?", bparams);
bs.CurrentRow.IsDelete = true;
bs.CurrentRow.Save();
}
cansave = false;
}
}
if (cansave)
{
if (!string.IsNullOrEmpty(isnew))
{
string guid = Request.Form["g_studentGuid"];
if (string.IsNullOrEmpty(guid))
{
ltrValidateMsg.Text = Utils.WarningMessage("Student Name is Required.");
cansave = false;
}
bs.studentGuid = new Guid(guid);
}
if (cansave)
{
bool showToStudent = (Request.Form["g_showToStudent"] ?? "").ToLower().Equals("true");
bs.showToStudent = showToStudent;
string docdate = Request.Form["g_documentDate"];
if (!string.IsNullOrEmpty(docdate))
{
bs.documentDate = Convert.ToDateTime(docdate);
}
bs.documentTitle = Request.Form["g_documentTitle"];
string expdate = Request.Form["g_documentExpiry"];
if (!string.IsNullOrEmpty(expdate))
{
bs.documentExpiry = Convert.ToDateTime(expdate);
}
bs.CenterId = Utils.User.CenterId;
BestStudents bestStd = new BestStudents();
bestStd.LoadRows("guidfield=?", "studentguid", bs.studentGuid, "");
bs.StudentId = bestStd.StudentId;
if (!bs.CurrentRow.Save())
{
ltrValidateMsg.Text = Utils.WarningMessage(bs.CurrentRow.lastError);
}
}
}
}
/* Auto Student */
string autoSample = "{value:\"[paramValue]\", label:[paramLabel]}";
StringBuilder sb = new StringBuilder();
sb.AppendLine("autoStudents = [");
BestStudents bstd = new BestStudents();
bstd.LoadRows("CenterId=?", Utils.User.CIdParam);
for (int s = 0; s < bstd.TableRows.Count; s++)
{
string result = autoSample;
result = result.Replace("[paramValue]", bstd.TableRows[s].Fields["guidfield"].fieldValue);
result = result.Replace("[paramLabel]", Utils.EnquoteJS((bstd.TableRows[s].Fields["firstName"].fieldValue ?? "") + " " +
(bstd.TableRows[s].Fields["lastName"].fieldValue ?? "")));
sb.Append(result);
if (s < bstd.TableRows.Count - 1) sb.AppendLine(",");
}
sb.AppendLine("];");
ltrScript.Text = @"<script type=""text/javascript"">
$(document).ready(function(){ " + sb.ToString() + @"
$('#studentTag1').autocomplete( { source:autoStudents, delay: 0, select : function( event, ui){
$('#studentGuid').val( ui.item.value );
$( this ).val( ui.item.label );
return false;
} } ); }); </script>";
BestGrid bsGrid = new BestGrid();
bsGrid.PageRequest = Page.Request;
bsGrid.Title = "Student Documents";
bsGrid.securityPage = "Student - Documents";
bsGrid.GridTable = new BestDocuments();
bsGrid.extraRowHTML = "<span><a href=\"javascript:void(0);\" onclick=\"showUploadDocument('[paramCID]','[paramSID]','[paramGuid]', [paramRowNum]);\" title=\"Upload Document\" ><img src=\"images\\folder_page.png\" alt=\"upload\" /></a></span><span><a href=\"javascript:void(0);\" onclick=\"DownloadDocument('[paramGuid]','[paramCID]','[paramSID]');\" title=\"Download Document\"><img src=\"images\\page_white_put.png\" alt=\"upload\" /></a></span>";
bsGrid.whereClause = "";
ltrGrid.Text = bsGrid.ToHTML();
}
private string EMailTargetHTML(string studTutor, string filter, string filterval)
{
StringBuilder result = new StringBuilder();
result.Append("<table id=\"available\" class=\"bestgrid\" cellspacing=\"0\" cellpadding=\"0\" style=\"width:80%;\"><tr><th><input type=\"checkbox\" id=\"checkAll\" onclick=\"ToggleCheck();\" /></th><th>Id</th><th>First Name</th><th>Last Name</th><th>EMail Address</th></tr>");
int rowcount = 0;
if (studTutor.Equals("Student"))
{
BestStudents bs = new BestStudents();
if (!string.IsNullOrEmpty(filter) && !string.IsNullOrEmpty(filterval))
{
BestField bfld = new BestField() { fieldName = "filterparam", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 50, fieldType = "System.String" };
bfld.fieldValue = filterval;
List<BestField> bparam = new List<BestField>();
bparam.Add(bfld);
bparam.Add(Utils.User.CenterIdField);
if (filter.Equals("School"))
{
bs.LoadRows("school = ? and CenterId=?", bparam,"firstname,lastname");
}
else if (filter.Equals("Grade"))
{
bs.LoadRows("grade = ? and CenterId=?", bparam, "firstname,lastname");
}
}
else
{
bs.LoadRows("CenterId=?",Utils.User.CIdParam,"firstname, lastname");
}
rowcount = bs.TableRows.Count;
for (int row = 0; row < bs.TableRows.Count; row++)
{
bs.currentRowId = row;
string trclass = (row % 2 == 0) ? "" : " class=\"gridodd\" ";
result.Append("<tr" + trclass + ">");
if (!string.IsNullOrEmpty(bs.emailId))
{
result.Append("<td><input type=\"checkbox\" id=\"chk_" + row.ToString() + "\" name=\"chk_" + row.ToString() + "\" /><input type=\"hidden\" id=\"guid" + row.ToString() + "\" name=\"guid" + row.ToString() + "\" value=\"" + HttpUtility.HtmlEncode(bs.guidfield.ToString()) + "\" /></td>");
}
else
{
result.Append("<td> </td>");
}
result.Append("<td>" + HttpUtility.HtmlEncode(bs.StudentId) + "</td><td>" + HttpUtility.HtmlEncode(bs.firstName) + "</td><td>" + HttpUtility.HtmlEncode(bs.lastName) + "</td><td>" + HttpUtility.HtmlEncode(bs.emailId) + "</td></tr>");
}
}
else if (studTutor.Equals("Tutor"))
{
BestTutors bt = new BestTutors();
bt.LoadRows("CenterId=?", Utils.User.CIdParam, "firstname,lastname");
rowcount = bt.TableRows.Count;
for (int row = 0; row < bt.TableRows.Count; row++)
{
bt.currentRowId = row;
string trclass = (row % 2 == 0) ? "" : " class=\"gridodd\" ";
result.Append("<tr" + trclass + ">");
if (!string.IsNullOrEmpty(bt.emailId))
{
result.Append("<td><input type=\"checkbox\" id=\"chk_" + row.ToString() + "\" name=\"chk_" + row.ToString() + "\" /><input type=\"hidden\" id=\"guid" + row.ToString() + "\" name=\"guid" + row.ToString() + "\" value=\"" + HttpUtility.HtmlEncode(bt.guidfield.ToString()) + "\" /></td>");
}
else
{
result.Append("<td> </td>");
}
result.Append("<td>" + HttpUtility.HtmlEncode(bt.TutorId) + "</td><td>" + HttpUtility.HtmlEncode(bt.firstName) + "</td><td>" + HttpUtility.HtmlEncode(bt.lastName) + "</td><td>" + HttpUtility.HtmlEncode(bt.emailId) + "</td></tr>");
}
}
result.Append("<input type=\"hidden\" id=\"rowcount\" name=\"rowcount\" value=\"" + rowcount.ToString() + "\" />");
result.Append("</table>");
return result.ToString();
}
private void SendEMails()
{
/* Send EMails */
string strRows = Request.Form["rowcount"];
int rowCount;
int.TryParse(strRows, out rowCount);
List<BestField> bparams = new List<BestField>();
string paramQs = "";
for (int i = 0; i < rowCount; i++)
{
string chkStr = Request.Form["chk_" + i.ToString()]??"";
if (chkStr.Equals("on"))
{
BestField bsf = new BestField() { fieldName = "guidfield", paramOledbType = System.Data.OleDb.OleDbType.Guid, fieldType = "System.Guid" };
bsf.fieldValue = Request.Form["guid" + i.ToString()];
bparams.Add(bsf);
paramQs += "?,";
}
}
paramQs = (paramQs.Length > 0) ? paramQs.Substring(0, paramQs.Length - 1) : "";
string selWho = Request.Form["selWho"];
if (bparams.Count > 0)
{
Dictionary<string, BMails> nvc = new Dictionary<string, BMails>();
string emailBody = getEMailBody();
if (selWho.Equals("Student"))
{
BestStudents bs = new BestStudents();
bs.LoadRows("guidfield in (" + paramQs + ")", bparams);
for (int i = 0; i < bs.TableRows.Count; i++)
{
bs.currentRowId = i;
BMails bm = new BMails();
bm.emailbody = ReplaceParams(bs, emailBody);
bm.emailToName = bs.firstName + " " + bs.lastName;
nvc.Add(bs.emailId, bm);
}
}
else if (selWho.Equals("Tutor"))
{
BestTutors bt = new BestTutors();
bt.LoadRows("guidfield in (" + paramQs + ")", bparams);
for (int i = 0; i < bt.TableRows.Count; i++)
{
bt.currentRowId = i;
BMails bm = new BMails();
bm.emailbody = ReplaceParams(bt, emailBody);
bm.emailToName = bt.firstName + " " + bt.lastName;
nvc.Add(bt.emailId, bm);
}
}
string emailSubject = Request.Form["emailSubject"] ?? "";
string message = "Send EMail To:\n";
foreach (string key in nvc.Keys)
{
BMails bm = (BMails)nvc[key];
if (Utils.User.emailUtil.Send(key, emailSubject, bm.emailbody, bm.emailToName))
{
message += key + " " + bm.emailToName + "\n";
}
}
ltrValidateMsg.Text = Utils.InfoMessage(message);
}
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
if (HttpContext.Current.Session["CurrentUser"] == null)
{
Response.Redirect("Logout.aspx");
}
ltrSubMenu.Text = UtilMenu.StudentMenu("studentusers");
if (!Utils.User.UserRoleByName("Student - Users").allowView)
{
ltrGrid.Text = "You do not have rights to view.";
return;
}
string ms = Request.QueryString["ms"];
this.ltrMScript.Text = Utils.MenuSelectScript(ms);
string saveClicked = Request.Form["SaveClicked"] ?? "";
if (IsPostBack && saveClicked.Equals("1"))
{
BestField fld = new BestField() { fieldName = "guidfield", paramOledbType = System.Data.OleDb.OleDbType.Guid, fieldType = "System.Guid" };
List<BestField> bparam = new List<BestField>();
string delguid = Request.Form["deleteguid"];
if (!string.IsNullOrEmpty(delguid))
{
BestUser bsduser = new BestUser();
fld.fieldValue = delguid;
bparam.Add(fld);
bsduser.LoadRows("guidfield=?", bparam);
bsduser.CurrentRow.IsDelete = true;
if (!bsduser.CurrentRow.Save())
{
ltrValidateMsg.Text = Utils.WarningMessage(bsduser.CurrentRow.lastError);
}
}
else
{
string stdGud = Request.Form["studentTag10"];
if (!string.IsNullOrEmpty(stdGud))
{
fld.fieldValue = stdGud;
bparam.Add(fld);
BestStudents bstud = new BestStudents();
bstud.LoadRows("guidfield=?", bparam);
if (!bstud.CurrentRow.IsNew)
{
if (string.IsNullOrEmpty(bstud.emailId))
{
ltrValidateMsg.Text = Utils.WarningMessage("Student E-Mail Address is Required.");
}
else
{
BestUser bstuser = new BestUser();
bstuser.userName = bstud.emailId;
bstuser.firstName = bstud.firstName;
bstuser.lastName = bstud.lastName;
bstuser.address1 = bstud.address1;
bstuser.address2 = bstud.address2;
bstuser.city = bstud.city;
bstuser.state = bstud.state;
bstuser.zip = bstud.zip;
bstuser.cellPhone = bstud.cellPhone;
bstuser.workPhone = bstud.workPhone;
bstuser.homePhone = bstud.homePhone;
bstuser.studentGuid = bstud.guidfield;
bstuser.Centers = bstud.CenterId;
bstuser.emailId = bstud.emailId;
bstuser.userType = "Student";
string randPwd = RandomString(8);
bstuser.password = Utils.GetMD5Hash(randPwd);
bstuser.passwordExpiration = DateTime.Today.AddDays(3);
if (bstuser.CurrentRow.Save())
{
Utils.User.emailUtil.Send(bstuser.emailId, "BLC Login Information", @"<h2>Welcome to Bali Learning Center!</h2><br><h3>Your login information is enclosed.</h3>
<b>Accessing Your Account</b><br>
Step 1:<br>
Click the link below or enter the URL below into your web browser<br>
Address: <a href=""http://best.vasbal.com"">Bali Learning Center Login</a><br><br>
Step 2:<br>
Enter the following user name and temporary password.<br>
User Name: <b>" + bstuser.userName + @"</b><br>
Password: <b>" + randPwd + @"</b><br><br>
<h3>This temporary password expires in 24 hours.</h3><br><br>
You will be prompted to change your user name and password during your initial log in as well as answer a few security related questions. <br>
<br>
<br>
<br>
Thank you,<br>
Bali Learning Center", bstuser.firstName + " " + bstuser.lastName);
/* Create Studet - Personal Role */
List<BestField> bparams = new List<BestField>();
BestField paramUName = new BestField() { fieldName = "username", fieldSize = 80, fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, displayField = false };
paramUName.fieldValue = bstuser.userName;
BestField service = new BestField() { fieldName = "service", fieldSize = 80, fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, displayField = false };
bparams.Add(paramUName);
bparams.Add(service);
string[] aryRoles = { "2.Students", "Student - Personal", "Student - Planner" };
for (int i = 0; i < aryRoles.Length; i++)
{
UserRoles urole = new UserRoles();
bparams[1].fieldValue = aryRoles[i];
urole.LoadRows("username = ? and service=?", bparams);
if (urole.TableRows.Count == 0)
{
urole.Service = aryRoles[i];
urole.UserName = bstuser.userName;
urole.allowView = "1";
urole.CurrentRow.Save();
}
}
}
else
{
ltrValidateMsg.Text = Utils.WarningMessage( bstuser.CurrentRow.lastError);
}
}
}
}
}
}
BestGrid bsGrid = new BestGrid();
bsGrid.PageRequest = Page.Request;
bsGrid.Title = "Student Users";
bsGrid.securityPage = "Student - Users";
BestUser bsuser = new BestUser();
bsuser.overrideAdd = Utils.User.UserRoleByName("Student - Users").allowAdd;
bsuser.overrideDelete = Utils.User.UserRoleByName("Student - Users").allowDelete;
bsuser.overrideEdit = false;
bsuser.TableFields["address1"].displayField = false;
bsuser.TableFields["address2"].displayField = false;
bsuser.TableFields["city"].displayField = false;
bsuser.TableFields["zip"].displayField = false;
bsuser.TableFields["state"].displayField = false;
bsuser.TableFields["Centers"].displayField = false;
bsGrid.GridTable = bsuser;
bsGrid.whereClause = "usertype in ('Student')";
ltrGrid.Text = bsGrid.ToHTML();
/* Auto Student */
StringBuilder sb = new StringBuilder();
string autoSample = "{value:\"[paramValue]\", label:[paramLabel]}";
sb.AppendLine("<script type=\"text/javascript\">");
sb.AppendLine("autoStudents = [");
BestStudents bstd = new BestStudents();
bstd.LoadRows();
for (int s = 0; s < bstd.TableRows.Count; s++)
{
string result = autoSample;
result = result.Replace("[paramValue]", bstd.TableRows[s].Fields["guidfield"].fieldValue);
result = result.Replace("[paramLabel]", Utils.EnquoteJS((bstd.TableRows[s].Fields["firstName"].fieldValue ?? "") + " " +
(bstd.TableRows[s].Fields["lastName"].fieldValue ?? "")));
sb.Append(result);
if (s < bstd.TableRows.Count - 1) sb.AppendLine(",");
}
sb.AppendLine("];");
sb.AppendLine("</script>");
this.ltrScript.Text = sb.ToString();
}
private string StudentAndTutors()
{
StringBuilder jsSb = new StringBuilder();
string autoSample = "{value:\"[paramValue]\", label:[paramLabel]}";
jsSb.AppendLine("autoStudents = [");
BestStudents bstd = new BestStudents();
bstd.LoadRows("CenterId=?", Utils.User.CIdParam, "firstname");
for (int s = 0; s < bstd.TableRows.Count; s++)
{
string result = autoSample;
bstd.currentRowId = s;
result = result.Replace("[paramValue]", bstd.guidfield.ToString());
result = result.Replace("[paramLabel]", Utils.EnquoteJS((bstd.firstName ?? "") + " " +
(bstd.lastName ?? "")));
jsSb.Append(result);
if (s < bstd.TableRows.Count - 1) jsSb.AppendLine(",");
}
jsSb.AppendLine("];");
BestTutors bstut = new BestTutors();
bstut.LoadRows("CenterId=?", Utils.User.CIdParam,"firstname");
jsSb.AppendLine("autoTutors = [");
for (int s = 0; s < bstut.TableRows.Count; s++)
{
string result = autoSample;
bstut.currentRowId = s;
result = result.Replace("[paramValue]", bstut.guidfield.ToString());
result = result.Replace("[paramLabel]", Utils.EnquoteJS((bstut.firstName ?? "") + " " + (bstut.lastName ?? "").Substring(0, 1) + "-" + bstut.TutorId));
jsSb.Append(result);
if (s < bstut.TableRows.Count - 1) jsSb.AppendLine(",");
}
jsSb.AppendLine("];");
string studentSample = "{\"firstName\":[paramFirst], \"lastName\":[paramLast], \"guid\":\"[paramGuid]\"}";
jsSb.AppendLine("StudentInfo = [");
for (int s = 0; s < bstd.TableRows.Count; s++)
{
string result = studentSample;
bstd.currentRowId = s;
result = result.Replace("[paramGuid]", bstd.guidfield.ToString());
result = result.Replace("[paramFirst]", Utils.EnquoteJS(bstd.firstName?? ""));
result = result.Replace("[paramLast]", Utils.EnquoteJS(bstd.lastName?? ""));
jsSb.Append(result);
if (s < bstd.TableRows.Count - 1) jsSb.AppendLine(",");
}
jsSb.AppendLine("];");
string tutorSample = "{\"Name\":[paramName], \"Id\":\"[paramId]\",\"guid\":\"[paramGuid]\"}";
jsSb.AppendLine("TutorInfo = [");
for (int s = 0; s < bstut.TableRows.Count; s++)
{
string result = tutorSample;
bstut.currentRowId = s;
result = result.Replace("[paramGuid]", bstut.guidfield.ToString());
result = result.Replace("[paramName]", Utils.EnquoteJS((bstut.firstName?? "") + " " + (bstut.lastName?? "").Substring(0,1) + "-" + bstut.TutorId));
result = result.Replace("[paramId]", bstut.TutorId);
jsSb.Append(result);
if (s < bstut.TableRows.Count - 1) jsSb.AppendLine(",");
}
jsSb.AppendLine("];");
return jsSb.ToString();
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
if (HttpContext.Current.Session["CurrentUser"] == null)
{
Response.Redirect("Logout.aspx");
}
ltrSubMenu.Text = UtilMenu.StudentMenu("studentplanner");
if (!Utils.User.UserRoleByName("Student - Planner").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();
string studentLoginScript = "";
if (Utils.User.BestUser.userType.Equals("Student"))
{
List<BestField> bparam = new List<BestField>();
bparam.Add(new BestField() { fieldName = "studentGuid", fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, fieldSize = 40 });
bparam[0].fieldValue = Utils.User.BestUser.studentGuid.ToString();
bstd.LoadRows("guidfield=?", bparam);
studentLoginScript = "$('#tblStudentSel').css('display','none');";
}
else
{
bstd.LoadRows("CenterId=?", Utils.User.CIdParam);
}
string selstudent = Request.Form["selStudent"];
StringBuilder sb = new StringBuilder();
sb.Append("");
string selName = "";
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;
sb.Append(" selected ");
}
sb.Append(">" + HttpUtility.HtmlEncode(sname) + "</option>");
}
ltrStudentOpts.Text = sb.ToString();
StringBuilder sbInfo = new StringBuilder();
sbInfo.Append("[");
if (!string.IsNullOrEmpty(selstudent))
{
BestSTPlan bstPlan = new BestSTPlan();
BestField bfield = new BestField() { fieldName = "studentguid", paramOledbType = System.Data.OleDb.OleDbType.Guid, fieldType = "System.Guid" };
bfield.fieldValue = selstudent;
List<BestField> bparams = new List<BestField>();
bparams.Add(bfield);
bparams.Add(Utils.User.CenterIdField);
bstPlan.LoadRows("studentguid=? and isdeleted=0 and centerid=?", bparams);
string stplanInfo = "{guidfield:\"[paramguid]\",stuGuid:\"[paramstuGuid]\",schDay:\"[paramschDay]\",schFrom:\"[paramschFrom]\",schTo:\"[paramschTo]\"}";
for (int i = 0; i < bstPlan.TableRows.Count; i++)
{
string result = stplanInfo;
bstPlan.currentRowId = i;
result = result.Replace("[paramguid]", bstPlan.guidfield.ToString());
result = result.Replace("[paramstuGuid]", bstPlan.studentGuid.ToString());
result = result.Replace("[paramschDay]", bstPlan.schDay);
result = result.Replace("[paramschFrom]", bstPlan.schFrom);
result = result.Replace("paramschTo]", bstPlan.schTo);
sbInfo.Append(result);
if (i < bstPlan.TableRows.Count - 1)
sbInfo.Append(",");
}
}
sbInfo.Append("]");
ltrStdScript.Text = @"<script type=""text/javascript""> " + studentLoginScript + @"
g_nameOnScheduler = " + Utils.EnquoteJS(selName) + @";
g_curSTGuid = " + Utils.EnquoteJS(selstudent) + @";
g_IsStudent = true;
STPlanInfo = " + sbInfo.ToString() + @"
</script>";
}
public BestDocuments()
{
this.TableName = "BestDocuments";
this.SecurityPage = "Student - Documents";
TableFields.Add(new BestField() { fieldName = "guidfield", displayField = false, fieldHeader = "Guid", fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, fieldSize = 40 });
TableFields.Add(new BestField() { fieldName = "lastChange", displayField = false, fieldHeader = "Last Change", fieldType = "System.DateTime", paramOledbType = System.Data.OleDb.OleDbType.DBTime, fieldSize = 20 });
TableFields.Add(new BestField() { fieldName = "lastChangeUser", displayField = false, fieldHeader = "Last Change User", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 128 });
TableFields.Add(new BestField()
{
fieldName = "CenterId",
displayField = true,
fieldHeader = "Center Id",
fieldType = "System.String",
paramOledbType = System.Data.OleDb.OleDbType.VarChar,
fieldSize = 50
});
TableFields.Add(new BestField()
{
fieldName = "StudentId",
displayField = true,
fieldHeader = "Student Id",
fieldType = "System.String",
paramOledbType = System.Data.OleDb.OleDbType.VarChar,
fieldSize = 50
});
TableFields.Add(new BestField()
{
fieldName = "studentGuid",
displayField = true,
fieldHeader = "Student Name",
fieldType = "System.Guid",
paramOledbType = System.Data.OleDb.OleDbType.Guid,
fieldSize = 40,
displayFormatFunc = new Func<BestRow, object>((obj) =>
{
BestRow bstd = (BestRow)obj;
List<BestField> bparams = new List<BestField>();
BestField guid = new BestField() { fieldName = "studentGuid", fieldSize = 40, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, displayField = false };
guid.fieldValue = bstd.Fields["studentGuid"].fieldValue;
bparams.Add(guid);
BestStudents bpstd = new BestStudents();
bpstd.LoadRows("guidfield=?", bparams);
return bpstd.firstName + " " + bpstd.lastName;
})
});
TableFields.Add(new BestField()
{
fieldName = "documentFile",
displayField = false,
fieldHeader = "documentFile",
fieldType = "System.byte[]",
paramOledbType = System.Data.OleDb.OleDbType.LongVarBinary,
fieldSize = -1
});
TableFields.Add(new BestField()
{
fieldName = "documentFileSize",
displayField = false,
fieldHeader = "Document Size",
fieldType = "System.Decimal",
paramOledbType = System.Data.OleDb.OleDbType.Decimal,
fieldSize = 18, Precision=18, scale=0
});
TableFields.Add(new BestField()
{
fieldName = "documentTitle",
displayField = true,
fieldHeader = "Document Title",
fieldType = "System.String",
paramOledbType = System.Data.OleDb.OleDbType.VarChar,
fieldSize = 50
});
TableFields.Add(new BestField()
{
fieldName = "documentFileName",
displayField = true,
fieldHeader = "File Name",
fieldType = "System.String",
paramOledbType = System.Data.OleDb.OleDbType.VarChar,
fieldSize = 100
});
TableFields.Add(new BestField()
{
fieldName = "documentDate",
fieldHeader = "Doc Date",
displayField = true,
fieldType = "System.DateTime",
paramOledbType = System.Data.OleDb.OleDbType.DBDate,
fieldSize = 10,
displayFormatFunc = new Func<BestRow,object>( (obj) => { DateTime dd = Convert.ToDateTime(obj.Fields["documentDate"].fieldValue); return dd.ToString("MM/dd/yyyy"); })
});
TableFields.Add(new BestField()
{
fieldName = "documentExpiry",
fieldHeader = "Doc Expiry",
displayField = true,
fieldType = "System.DateTime",
paramOledbType = System.Data.OleDb.OleDbType.DBDate,
fieldSize = 10,
displayFormatFunc = new Func<BestRow, object>((obj) => { DateTime dd = Convert.ToDateTime(obj.Fields["documentExpiry"].fieldValue); return dd.ToString("MM/dd/yyyy"); })
});
TableFields.Add(new BestField()
{
fieldSize = 1,
fieldName = "showToStudent",
fieldType = "System.Boolean",
paramOledbType = System.Data.OleDb.OleDbType.Boolean,
fieldHeader = "Show To Student",
displayField = true
});
}
