Exemplo n.º 1
0
        protected void Page_LoadComplete(object sender, EventArgs e)
        {
            if (HttpContext.Current.Session["CurrentUser"] == null)
            {
                Response.Redirect("Logout.aspx");
            }
            var cUser = Utils.User;

            BestCenters bcenters = new BestCenters();
            bcenters.LoadRows();
            string CenterId = HttpContext.Current.Session["UserCenter"].ToString();

            ltrCenters.Text = string.Join("", bcenters.TableRows.Rows.Select(
                x => (cUser.BestUser.IsAllowedCenter(x.Fields["CenterId"].fieldValue) ?  "<option value=\"" + HttpUtility.HtmlEncode(x.Fields["CenterId"].fieldValue) + "\" " + (x.Fields["CenterId"].fieldValue.Equals(CenterId) ? "selected" :"")  + " >" + HttpUtility.HtmlEncode(x.Fields["CenterId"].fieldValue) + "</option>" : "")
                ).ToArray());

            if (IsPostBack)
            {
                string centerid = Request.Form["centerid"];
                if (! string.IsNullOrEmpty(centerid))
                {
                    HttpContext.Current.Session["UserCenter"] = centerid;
                    UserPrefs up = new UserPrefs(Utils.User.UserName);
                    up.SetPreference("LastCenter", centerid);
                    Response.Redirect("Dashboard.aspx");
                }
            }
        }
Exemplo n.º 2
0
        protected void Page_LoadComplete(object sender, EventArgs e)
        {
            if (HttpContext.Current.Session["CurrentUser"] == null)
            {
                Response.Redirect("Logout.aspx");
            }
            ltrSubMenu.Text = UtilMenu.StudentMenu("studentinfo");
            string ms = Request.QueryString["ms"];
            ltrMScript.Text = Utils.MenuSelectScript(ms);

            string submitMode = Request["submitMode"];
            if (IsPostBack)
            {
                if (!string.IsNullOrEmpty(submitMode))
                {
                    if (submitMode.Equals("add"))
                    {
                        if (!Utils.User.UserRoleByName("Student - Information").allowAdd)
                        {
                            Response.Write("You do not have rights to add.");
                            return;
                        }
                    }

                    if (submitMode.Equals("edit"))
                    {
                        if (!Utils.User.UserRoleByName("Student - Information").allowEdit)
                        {
                            Response.Write("You do not have rights to edit.");
                            return;
                        }
                    }
                }
            }

            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;
                if (cid.Equals(Utils.User.CenterId))
                {
                    this.CenterId.Items.Add(cid);
                }
                //sbc.Append("<option value=\"" + HttpUtility.HtmlEncode(cid) + "\">" + HttpUtility.HtmlEncode(cid) + "</option>");
            }
            //this.ltrCenters.Text = sbc.ToString();
            this.ltrState.Text = Utils.StateOptions();

            StringBuilder jsbp = new StringBuilder();
            jsbp.Append("jsProg=[");
            StringBuilder sbp = new StringBuilder();
            sbp.Append("<option value=\"\"></option>");
            BestPrograms bps = new BestPrograms();
            bps.LoadRows();
            ListItem ltItem = new ListItem("", "");
            this.proposedProg.Items.Add(ltItem);
            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(",");
                ltItem = new ListItem(optext, optval);
                this.proposedProg.Items.Add(ltItem);
            }
            jsbp.Append("]");

            this.ltrprog1.Text = sbp.ToString();
            this.ltrRelation.Text = Utils.RelationshipOptions();

            if (!string.IsNullOrEmpty(submitMode) && submitMode.Equals("add") && !IsPostBack)
            {
                /* Get New Next Student ID */
                BestDatabase db = new BestDatabase();
                OleDbCommand myCmd = db.dbCmd;
                myCmd.CommandText = "Best_GetNextStudentId";
                this.CenterId.SelectedIndex = 0;
                OleDbParameter p1 = new OleDbParameter("@xcenterid", OleDbType.VarChar, 10);
                p1.Value = this.CenterId.Items[0].Value;
                myCmd.Parameters.Add(p1);
                myCmd.CommandType = System.Data.CommandType.StoredProcedure;
                OleDbDataReader read = myCmd.ExecuteReader();
                if (read.Read())
                {
                    string studentid = read.GetValue(0).ToString();
                    this.StudentId.Value = studentid;
                }
            }

            string studentguid = Request.QueryString["studentguid"];
            Guid studentGuid = Guid.NewGuid();
            if (!string.IsNullOrEmpty(studentguid))
            {
                studentGuid = new Guid(studentguid);
            }

            StringBuilder jstdProg = new StringBuilder();
            StringBuilder jstdPick = new StringBuilder();
            StringBuilder jstdGPA = new StringBuilder();
            jstdProg.AppendLine("");
            jstdProg.Append("studentProg = [");
            jstdPick.AppendLine("");
            jstdPick.Append("pickupInfo = [");
            string jsSelState = "";
            jstdGPA.AppendLine("");
            jstdGPA.Append("studentGPA = [");

            if (submitMode.Equals("edit"))
            {
                /* Load Student Master */
                try
                {
                    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 = studentguid;
                    bparams.Add(guid);
                    bstdMast.LoadRows("guidfield=?", bparams);
                    bstdPic.LoadRows("studentguid=?", bparams);
                    bstdPay.LoadRows("studentguid=?", bparams);
                    bstdRef.LoadRows("studentguid=?", bparams);
                    bstdProg.LoadRows("studentguid=?", bparams);
                    bstdPickup.LoadRows("studentguid=?", bparams);
                    bstdGPA.LoadRows("studentguid=?", bparams);
                    jsSelState = bstdMast.state;
                }
                catch (Exception ex)
                {
                    Response.Write("Error:" + HttpUtility.HtmlEncode(ex.Message));
                    return;
                }
                if (!IsPostBack)
                {
                    LoadForm(studentguid);
                }
            }

            if (IsPostBack)
            {
                doSave(studentGuid);
            }

            jstdProg.AppendLine(getStudentProgJS());
            jstdPick.AppendLine(getStudentPickupJS());
            jstdGPA.AppendLine(getStudentGPAJS());

            jstdProg.Append("]");
            jstdPick.Append("]");
            jstdGPA.Append("]");
            StringBuilder jsDateEvents = new StringBuilder();
            jsDateEvents.AppendLine("");
            jsDateEvents.AppendLine("$(document).ready(function(){");
            jsDateEvents.AppendLine("$('#" + this.cellPhone.ClientID + ",#" + this.homePhone.ClientID + ",#" + this.workPhone.ClientID + ",#contact0').mask('(999) 999-9999')");
            jsDateEvents.AppendLine("$('#" + this.joinDate.ClientID + ",#" + this.birthDate.ClientID + "').mask('99/99/9999');");
            jsDateEvents.AppendLine("$('#" + this.joinDate.ClientID + ",#" + this.birthDate.ClientID + "').datepicker({ showOn: 'button', buttonImage: 'images/date.png', buttonImageOnly: true, changeYear: true, changeMonth: true });");
            if (!string.IsNullOrEmpty(jsSelState))
            {
                jsDateEvents.AppendLine("$('#selState').val('" + jsSelState + "');");
            }
            jsDateEvents.AppendLine("$('#+" + this.firstName.ClientID + "').focus();");
            jsDateEvents.AppendLine("});");
            jsDateEvents.AppendLine("parentNameId = '" + this.parentName.ClientID + "';");
            jsDateEvents.AppendLine("payeenameId = '" + this.paymentname1.ClientID + "';");
            this.ltrProgScript.Text = "<script type=\"text/javascript\">" + jsbp.ToString() + jstdProg.ToString() + jstdPick.ToString() + jstdGPA.ToString() + jsDateEvents.ToString() + "</script>";

            if (submitMode.Equals("edit"))
            {
                this.ltrPhoto.Text = "<a href=\"UploadPhoto.aspx?sid=" + HttpUtility.UrlEncode(this.StudentId.Value) + "&cid=" + HttpUtility.UrlEncode(this.CenterId.Value) + "\" target=\"_blank\">Choose Photo</a>";
            }
            this.photoDisplay.Text = "<img id=\"empPhoto\" alt=\"Employee Photo\" src=\"getPhoto.aspx?sid=" + Server.UrlEncode(this.StudentId.Value) + "&cid=" + Server.UrlEncode(this.CenterId.Value) + "\" />";
        }
Exemplo n.º 3
0
        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();
        }
Exemplo n.º 4
0
        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();
        }
Exemplo n.º 5
0
        protected void Page_LoadComplete(object sender, EventArgs e)
        {
            if (HttpContext.Current.Session["CurrentUser"] == null)
            {
                Response.Redirect("Logout.aspx");
            }
            ltrSubMenu.Text = UtilMenu.SetupSubMenu("centers");
            if (!Utils.User.UserRoleByName("Setup - Center Information").allowView)
            {
                ltrGrid.Text = "You do not have rights to view.";
                return;
            }

            string ms = Request.QueryString["ms"];
            this.ltrMScript.Text = Utils.MenuSelectScript(ms);

            ltrState.Text = Utils.StateOptions();

            string saveClicked = Request.Form["SaveClicked"] ?? "";
            if (IsPostBack && saveClicked.Equals("1"))
            {
                BestCenters bs = new BestCenters();
                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.CenterId = Request.Form["g_CenterId"]; }
                    if (string.IsNullOrEmpty(bs.CenterId))
                    {
                        ltrValidateMsg.Text = Utils.WarningMessage("Center Id is Required.");
                        cansave = false;
                    }
                    if (cansave)
                    {
                        bs.address1 = Request.Form["g_address1"];
                        bs.address2 = Request.Form["g_address2"];
                        bs.city = Request.Form["g_city"];
                        bs.contactEMail = Request.Form["g_contactEMail"];
                        bs.contactName = Request.Form["g_contactName"];
                        bs.contactPhone = Request.Form["g_contactPhone"];
                        bs.state = Request.Form["g_state"];
                        bs.zip = Request.Form["g_zip"];

                        if (!bs.CurrentRow.Save())
                        {
                            ltrValidateMsg.Text = Utils.WarningMessage(bs.CurrentRow.lastError);
                        }
                    }
                }
            }

            BestGrid bsGrid = new BestGrid();
            bsGrid.PageRequest = Page.Request;
            bsGrid.Title = "Center Information";
            bsGrid.securityPage = "Setup - Center Information";
            bsGrid.GridTable = new BestCenters();
            ltrGrid.Text = bsGrid.ToHTML();
        }