protected void Page_LoadComplete(object sender, EventArgs e)
{
if (HttpContext.Current.Session["CurrentUser"] == null)
{
Response.Redirect("Logout.aspx");
}
ltrSubMenu.Text = UtilMenu.StudentMenu("studentpicture");
if (!Utils.User.UserRoleByName("Student - Pictures").allowView)
{
ltrGrid.Text = "You do not have rights to view.";
return;
}
string ms = Request.QueryString["ms"];
this.ltrMScript.Text = Utils.MenuSelectScript(ms);
BestGrid bsGrid = new BestGrid();
bsGrid.PageRequest = Page.Request;
bsGrid.Title = "Student Pictures";
bsGrid.securityPage = "Student - Pictures";
bsGrid.GridTable = new BestStudentPicture();
bsGrid.allowAdd = false;
bsGrid.allowEdit = false;
bsGrid.allowDelete = false;
bsGrid.extraRowHTML = "<a href=\"UploadPhoto.aspx?cid=[paramCID]&sid=[paramSID]\" target=\"_blank\"><img src=\"images\\user_edit.png\" alt=\"upload\" /></a>";
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.UtilityMenu("changelog");
string ms = Request.QueryString["ms"];
ltrMScript.Text = Utils.MenuSelectScript(ms);
if (!Utils.User.UserRoleByName("Change Log").allowView)
{
ltrGrid.Text = "You do not have rights to view.";
return;
}
BestGrid bsGrid = new BestGrid();
bsGrid.PageRequest = Page.Request;
bsGrid.Title = "Change Log";
bsGrid.securityPage = "Change Log";
bsGrid.GridTable = new LogChanges();
bsGrid.allowAdd = false;
bsGrid.allowDelete = false;
bsGrid.allowEdit = false;
ltrGrid.Text = bsGrid.ToHTML();
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
if (HttpContext.Current.Session["CurrentUser"] == null)
{
Response.Redirect("Logout.aspx");
}
if (! Utils.User.UserRoleByName("Setup - Users").allowView)
{
Response.Write("You do not have view rights for this page.");
return;
}
ltrSubMenu.Text = UtilMenu.SetupSubMenu("userinfo");
string ms = Request.QueryString["ms"];
ltrMScript.Text = Utils.MenuSelectScript(ms);
ltrState.Text = Utils.StateOptions();
if (IsPostBack)
{
BestUser bs = new BestUser();
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))
{
bs.userName = Request.Form["g_userName"];
bs.emailId = Request.Form["g_emailId"];
}
if (string.IsNullOrEmpty(bs.userName))
{
ltrValidateMsg.Text = Utils.WarningMessage("User Name is Required.");
cansave = false;
}
if (string.IsNullOrEmpty(bs.emailId))
{
ltrValidateMsg.Text = Utils.WarningMessage("EMail Address is Required.");
cansave = false;
}
if (cansave)
{
bs.firstName = Request.Form["g_firstName"];
bs.lastName = Request.Form["g_lastName"];
bs.middleName = Request.Form["g_middleName"];
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.gender = Request.Form["g_gender"];
bs.Centers = Request.Form["g_Centers"];
bs.userType = Request.Form["g_userType"];
string randPwd = RandomString(8);
bs.password = Utils.GetMD5Hash(randPwd);
bs.passwordExpiration = DateTime.Today.AddDays(3);
if (bs.CurrentRow.Save())
{
Utils.User.emailUtil.Send(bs.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>" + bs.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", bs.firstName + " " + bs.lastName);
}
else
{
ltrValidateMsg.Text = Utils.WarningMessage(bs.CurrentRow.lastError);
}
}
}
}
BestGrid bsGrid = new BestGrid();
bsGrid.PageRequest = Page.Request;
bsGrid.Title = "User Information";
bsGrid.GridTable = new BestUser();
bsGrid.whereClause = "usertype not in ('Student', 'Tutor')";
bsGrid.securityPage = "Setup - Users";
bsGrid.AfterAddHTML="<input type=\"button\" id=\"btnReserPwd\" onclick=\"resetPassword();\" value=\"Reset Password\" />";
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.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();
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
if (HttpContext.Current.Session["CurrentUser"] == null)
{
Response.Redirect("Logout.aspx");
}
ltrSubMenu.Text = UtilMenu.UtilityMenu("exportexcel");
string ms = Request.QueryString["ms"];
ltrMScript.Text = Utils.MenuSelectScript(ms);
if (!Utils.User.UserRoleByName("Export To Excel").allowView)
{
ltrValidateMsg.Text = "You do not have rights to view.";
return;
}
if (IsPostBack)
{
BestExports bs = new BestExports();
string isnew = Request.Form["isnew"];
bool cansave = true;
Guid exportGuid = Guid.NewGuid();
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 (Utils.IsGuid(guid.fieldValue))
{
exportGuid = new Guid(guid.fieldValue);
}
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;
}
}
else
{
bs.guidfield = exportGuid;
}
if (cansave)
{
if (!string.IsNullOrEmpty(isnew)) { bs.exportName = Request.Form["g_exportName"]; }
if (string.IsNullOrEmpty(bs.exportName))
{
ltrValidateMsg.Text = Utils.WarningMessage("Export Name is Required.");
cansave = false;
}
if (cansave)
{
bs.exportType = Request.Form["g_exportType"];
bs.exportTitle = Request.Form["g_exportTitle"];
if (!bs.CurrentRow.Save())
{
ltrValidateMsg.Text = Utils.WarningMessage(bs.CurrentRow.lastError);
}
else
{
/* Insert or Update Export Fields */
string FieldData = Request.Form["hidExportData"] ?? "";
if (!string.IsNullOrEmpty(FieldData))
{
string[] lines = FieldData.Split('\n');
int i = 0;
foreach (string line in lines)
{
if (!string.IsNullOrEmpty(line))
{
string[] fields = line.Replace("\r","").Split('\t');
//0.guidfield 1.exportguid 2.fieldname 3.displayname 4.isnew 5.isdeleted
if (fields[4].Equals("1"))
{
if (fields[5].Equals("0") && (!string.IsNullOrEmpty(fields[2])))
{
/* Add New */
BestExportFields bexpfld = new BestExportFields();
bexpfld.exportguid = exportGuid;
bexpfld.fieldName = fields[2];
bexpfld.displayName = fields[3];
int idx;
int.TryParse(fields[6], out idx);
bexpfld.Ordinal = idx;
if (!bexpfld.CurrentRow.Save())
{
ltrValidateMsg.Text = Utils.WarningMessage(bs.CurrentRow.lastError);
}
}
}
else
{
/* Update */
List<BestField> bparam = new List<BestField>();
BestField fguid = new BestField() { fieldName = "guidfield", fieldSize = 40, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, displayField = false };
fguid.fieldValue = fields[0];
bparam.Add(fguid);
BestExportFields bsFields = new BestExportFields();
bsFields.LoadRows("guidfield=?", bparam);
bsFields.fieldName = fields[2];
bsFields.displayName = fields[3];
int idx;
int.TryParse(fields[6], out idx);
bsFields.Ordinal = idx;
bsFields.CurrentRow.IsDelete = fields[5].Equals("1");
if (!bsFields.CurrentRow.Save())
{
ltrValidateMsg.Text = Utils.WarningMessage(bs.CurrentRow.lastError);
}
}
}
}
}
}
}
}
if ((Request.Form["SaveAndExport"] ?? "").Equals("1"))
{
ltrExportScript.Text = @"<script type=""text/javascript"">$(document).ready(function(){
$('#addiframe').html('<iframe src = ""DownloadExport.aspx?exportguid=" + exportGuid + @""" /></iframe>');
});</script>";
}
}
ltrPageScript.Text = "<script type=\"text/javascript\">" + ExportFieldJS() +"\n" + ExportMastTableJs() + "</script>";
BestGrid bsGrid = new BestGrid();
bsGrid.PageRequest = Page.Request;
bsGrid.Title = "Export Information";
bsGrid.securityPage = "Export To Excel";
bsGrid.GridTable = new BestExports();
bsGrid.extraRowHTML = "<a href=\"DownloadExport.aspx?exportguid=[paramGuid]\" ><img src=\"images\\xls.gif\" alt=\"runexport\" /></a>";
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.SetupSubMenu("services");
if (!Utils.User.UserRoleByName("Setup - Services").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"))
{
BestServices bs = new BestServices();
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.Service = Request.Form["g_Service"];
bs.CenterId = Request.Form["g_CenterId"];
if (string.IsNullOrEmpty(bs.Service))
{
ltrValidateMsg.Text = Utils.WarningMessage("Service is Required.");
cansave = false;
}
if (cansave)
{
if (!bs.CurrentRow.Save())
{
ltrValidateMsg.Text = Utils.WarningMessage(bs.CurrentRow.lastError);
}
}
}
}
BestGrid bsGrid = new BestGrid();
bsGrid.PageRequest = Page.Request;
bsGrid.Title = "Services Information";
bsGrid.GridTable = new BestServices();
bsGrid.securityPage = "Setup - Services";
bsGrid.orderby = "service";
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.TutorMenu("tutorinfo");
string ms = Request.QueryString["ms"];
ltrMScript.Text = Utils.MenuSelectScript(ms);
if (!Utils.User.UserRoleByName("Tutor - Information").allowView)
{
ltrGrid.Text = "You do not have rights to view.";
return;
}
this.ltrStateOpts.Text = Utils.StateOptions();
BestCenters bcs = new BestCenters();
bcs.LoadRows();
for (int rnum = 0; rnum < bcs.TableRows.Count; rnum++)
{
string cid = bcs.TableRows[rnum].Fields["CenterId"].fieldValue;
if (cid.Equals(Utils.User.CenterId))
{
this.CenterId.Items.Add(cid);
}
}
string saveClicked = Request.Form["SaveClicked"] ?? "";
if (IsPostBack && saveClicked.Equals("1"))
{
BestTutors bs = new BestTutors();
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.TutorId = Request.Form["g_TutorId"];
bs.firstName = Request.Form["g_firstName"];
bs.lastName = Request.Form["g_lastName"];
bs.CenterId = this.CenterId.Value;
if (string.IsNullOrEmpty(bs.TutorId))
{
ltrValidateMsg.Text = Utils.WarningMessage("Tutor 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.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.School = Request.Form["g_school"];
bs.yearGraduated = Request.Form["g_yearGraduated"];
bs.GPA = Request.Form["g_GPA"];
bs.Major = Request.Form["g_Major"];
bs.Expertise = Request.Form["g_Expertise"];
bs.learningStyle = Request.Form["g_learningStyle"];
bs.Matchup = Request.Form["g_Matchup"];
bs.gradeLevels = Request.Form["g_gradeLevels"];
bs.otherSkill = Request.Form["g_otherSkill"];
bs.programStyle = Request.Form["g_programStyle"];
string salary = Request.Form["g_salary"];
string perhour = Request.Form["g_perhour"];
if (!string.IsNullOrEmpty(salary))
{
bs.Salary = Convert.ToDecimal(salary);
}
if (!string.IsNullOrEmpty(perhour))
{
bs.PerHour = Convert.ToDecimal(perhour);
}
if (!string.IsNullOrEmpty(Request.Form["g_joinDate"]))
{
bs.joinDate = Convert.ToDateTime(Request.Form["g_joinDate"]);
}
if (!bs.CurrentRow.Save())
{
ltrValidateMsg.Text = Utils.WarningMessage(bs.CurrentRow.lastError);
}
}
}
}
BestDatabase db = new BestDatabase();
OleDbCommand myCmd = db.dbCmd;
myCmd.CommandText = "Best_GetNextTutorId";
OleDbParameter p1 = new OleDbParameter("@makehigherthan", OleDbType.VarChar, 10);
p1.Value = "T0";
myCmd.Parameters.Add(p1);
myCmd.CommandType = System.Data.CommandType.StoredProcedure;
OleDbDataReader read = myCmd.ExecuteReader();
string tutorid = "";
if (read.Read())
{
tutorid = read.GetValue(0).ToString();
}
ltrLoadScript.Text = "<script type=\"text/javascript\">\n newtutorid='" + tutorid + "'\n</script>\n";
BestGrid bsGrid = new BestGrid();
bsGrid.PageRequest = Page.Request;
bsGrid.Title = "Tutuor Information";
bsGrid.GridTable = new BestTutors();
bsGrid.securityPage = "Tutor - 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.ProgramMenu("programinfo");
if (!Utils.User.UserRoleByName("Program - Information").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"))
{
BestPrograms bs = new BestPrograms();
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.programName = Request.Form["g_programName"];
bs.programType = Request.Form["g_programType"];
if (string.IsNullOrEmpty(bs.programType))
{
ltrValidateMsg.Text = Utils.WarningMessage("Program Type is Required.");
cansave = false;
}
if (cansave)
{
bs.amount = Request.Form["g_amount"];
bs.amountType = Request.Form["g_amountType"];
if (!bs.CurrentRow.Save())
{
ltrValidateMsg.Text = Utils.WarningMessage(bs.CurrentRow.lastError);
}
}
}
}
StringBuilder sb = new StringBuilder();
ProgramTypes bprgTypes = new ProgramTypes();
bprgTypes.LoadRows();
sb.Append("<option value=\"\"></option>");
for(int rowNum = 0; rowNum < bprgTypes.TableRows.Count; rowNum++)
{
sb.Append("<option value=\"" + HttpUtility.HtmlEncode(bprgTypes.TableRows[rowNum].Fields["programType"].fieldValue) + "\">" + HttpUtility.HtmlEncode(bprgTypes.TableRows[rowNum].Fields["programType"].fieldValue) + "</option>");
}
ltrprgTypeOptions.Text = sb.ToString();
BestGrid bsGrid = new BestGrid();
bsGrid.PageRequest = Page.Request;
bsGrid.Title = "Programs Information";
bsGrid.GridTable = new BestPrograms();
bsGrid.securityPage = "Program - 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("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();
}
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();
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
if (HttpContext.Current.Session["CurrentUser"] == null)
{
Response.Redirect("Logout.aspx");
}
ltrSubMenu.Text = UtilMenu.TutorMenu("tutornotes");
if (!Utils.User.UserRoleByName("Tutor - Notes").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"))
{
BestTutorNotes bs = new BestTutorNotes();
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_tutorGuid"];
if (string.IsNullOrEmpty(guid))
{
ltrValidateMsg.Text = Utils.WarningMessage("Tutor Name is Required.");
cansave = false;
}
bs.tutorGuid = new Guid(guid);
}
if (cansave)
{
string notedate = Request.Form["g_noteDate"];
if (!string.IsNullOrEmpty(notedate))
{
bs.noteDate = Convert.ToDateTime(notedate);
}
bs.notes = Request.Form["g_notes"];
bs.CenterId = Utils.User.CenterId;
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("autoTutors = [");
BestTutors bstd = new BestTutors();
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() + @"
$('#tutorTag1').autocomplete( { source:autoTutors, delay: 0, select : function( event, ui){
$('#tutorGuid').val( ui.item.value );
$( this ).val( ui.item.label );
return false;
} } ); }); </script>";
BestGrid bsGrid = new BestGrid();
bsGrid.PageRequest = Page.Request;
bsGrid.Title = "Tutor Notes";
bsGrid.GridTable = new BestTutorNotes();
bsGrid.securityPage = "Tutor - Notes";
ltrGrid.Text = bsGrid.ToHTML();
}
