Пример #1
0
        protected void GetProgram()
        {
            ResetForm();
            if (Grid.SelectedValue != null)
            {
                var pid     = (new CProgram()).Get(Convert.ToInt32(Grid.SelectedValue));
                var otherId = (new CProgramOtherInfo()).Get(pid.ProgramId);

                if (pid.ProgramGroupId != null)
                {
                    var programGroup = new CProgramGroup().Get(Convert.ToInt32(pid.ProgramGroupId));
                    if (programGroup != null)
                    {
                        RadComboBoxFaculty.SelectedValue = programGroup.FacultyId.ToString();
                        LoadProgramGroup(RadComboBoxFaculty.SelectedValue);
                    }
                    RadComboBoxProgramGroup.SelectedValue = pid.ProgramGroupId.ToString();
                }

                tbProgramFullName.Text = pid.ProgramFullName;

                if (pid.ProgramWebName == null)
                {
                    tbProgramWebName.Text = "N/A";
                }
                else
                {
                    tbProgramWebName.Text = pid.ProgramWebName;
                }

                if (pid.ProgramShortName == null)
                {
                    tbProgramShortName.Text = "N/A";
                }
                else
                {
                    tbProgramShortName.Text = pid.ProgramShortName;
                }

                if (pid.ProgramDescription == null)
                {
                    tbDescript.Text = "N/A";
                }
                else
                {
                    tbDescript.Text = pid.ProgramDescription;
                }

                ddlProgramType.SelectedValue = pid.ProgramType.ToString();
                ddlComType.SelectedValue     = pid.UisType.ToString();
                tbEarningCredit.Text         = pid.EarningCredit.ToString();

                //tbProgramType

                //tbProgramWeek.Text = pid.TotalWeeks.ToString();
                //tbProgramSemester.Text = pid.TotalSemester.ToString();
                //tbProgramMonth.Text = pid.TotalMonth.ToString();
                //tbProgramHoursDay.Text = pid.HoursOfDay.ToString();
                //ddlHours.SelectedValue = pid.HoursOfWeek.ToString();

                tbProgramStartDate.SelectedDate = pid.EstimatedStartDate;

                if (pid.AdmissionRequirement == null)
                {
                    tbProgramAdmission.Text = "N/A";
                }
                else
                {
                    tbProgramAdmission.Text = pid.AdmissionRequirement;
                }

                if (pid.DiplomaCertificationRequirement == null)
                {
                    tbProgramDiploma.Text = "N/A";
                }
                else
                {
                    tbProgramDiploma.Text = pid.DiplomaCertificationRequirement;
                }

                tbPracticum.Text                   = Convert.ToString(pid.PracticumWeeks);
                tbIntership.Text                   = Convert.ToString(pid.IntershipWeeks);
                RadButtonActive.Checked            = Convert.ToBoolean(pid.IsActive);
                tbProgramActiveDate.SelectedDate   = pid.ActiveDate;
                tbProgramInActiveDate.SelectedDate = pid.InActiveDate;

                // OTHER FEE
                var programOtherFeeInfo = (new CProgramOtherFeeInfo()).Get(pid.ProgramId);

                if (programOtherFeeInfo != null)
                {
                    tbFeeComment.Text = programOtherFeeInfo.Comment;
                }

                for (var i = 1; i < 19; i++)
                {
                    var fee = (RadNumericTextBox)RadPaneProgram.FindControl("tbFee" + i);

                    if (programOtherFeeInfo == null)
                    {
                        fee.Value = 0;
                        continue;
                    }

                    switch (i)
                    {
                    case 1:
                        fee.Value = (double)(programOtherFeeInfo.RegFee ?? 0);
                        break;

                    case 2:
                        fee.Value = (double)(programOtherFeeInfo.JRegFee ?? 0);
                        break;

                    case 3:
                        fee.Value = (double)(programOtherFeeInfo.AcademicFee ?? 0);
                        break;

                    case 4:
                        fee.Value = (double)(programOtherFeeInfo.MaterialFee ?? 0);
                        break;

                    case 5:
                        fee.Value = (double)(programOtherFeeInfo.TestFee ?? 0);
                        break;

                    case 6:
                        fee.Value = (double)(programOtherFeeInfo.PracticeFee ?? 0);
                        break;

                    case 7:
                        fee.Value = (double)(programOtherFeeInfo.ExamFee ?? 0);
                        break;

                    case 8:
                        fee.Value = (double)(programOtherFeeInfo.AdminFee ?? 0);
                        break;

                    case 9:
                        fee.Value = (double)(programOtherFeeInfo.InternFee ?? 0);
                        break;

                    case 10:
                        fee.Value = (double)(programOtherFeeInfo.LCFee ?? 0);
                        break;

                    case 11:
                        fee.Value = (double)(programOtherFeeInfo.SDFee ?? 0);
                        break;

                    case 12:
                        fee.Value = (double)(programOtherFeeInfo.UPFee ?? 0);
                        break;

                    case 13:
                        fee.Value = (double)(programOtherFeeInfo.ACFee ?? 0);
                        break;

                    case 14:
                        fee.Value = (double)(programOtherFeeInfo.CFee ?? 0);
                        break;

                    case 15:
                        fee.Value = (double)(programOtherFeeInfo.SupplyFee ?? 0);
                        break;

                    case 16:
                        fee.Value = (double)(programOtherFeeInfo.UniformFee ?? 0);
                        break;

                    case 17:
                        fee.Value = (double)(programOtherFeeInfo.UAGFee ?? 0);
                        break;

                    case 18:
                        fee.Value = (double)(programOtherFeeInfo.OtherFee ?? 0);
                        break;
                    }
                }

                // OTHER INFO
                tbLocalCRC.Text     = otherId.LocalCRC;
                tbDoctorNote.Text   = otherId.DoctorNote;
                tbNoc.Text          = otherId.Noc;
                tbHrsdc.Text        = otherId.Hrsdc;
                tbReference2.Text   = otherId.Reference2;
                tbReference3.Text   = otherId.Reference3;
                tbEng10.Text        = otherId.Eng10;
                tbMath10.Text       = otherId.Math10;
                tbSience11.Text     = otherId.Sience11;
                tbEng12.Text        = otherId.Eng12;
                tbBio12.Text        = otherId.Bio12;
                tbSSience.Text      = otherId.SSience;
                tbSMath.Text        = otherId.SMath;
                tbSEng.Text         = otherId.SEng;
                tbSLBio.Text        = otherId.SLBio;
                tbSLChemi.Text      = otherId.SLChemi;
                tbImmun.Text        = otherId.Immun;
                tbHelpB.Text        = otherId.HelpB;
                tbOthercomment.Text = otherId.Comment;

                RadToolBarProgram.FindItemByText("New").Enabled = true;
                //RadToolBarProgram.FindItemByText("Delete").Enabled = true;
                if (RadToolBarProgram.FindItemByText("Save") != null)
                {
                    RadToolBarProgram.FindItemByText("Save").Text = "Update";
                }
            }
        }
Пример #2
0
        protected void ResetForm()
        {
            LoadFaculty();
            LoadProgramGroup(null);

            tbProgramFullName.Text  = "";
            tbProgramWebName.Text   = "";
            tbProgramShortName.Text = "";
            tbDescript.Text         = "";
            //tbProgramWeek.Text = "";
            //tbProgramSemester.Text = "";
            //tbProgramMonth.Text = "";
            //tbProgramHoursDay.Text = "";
            //ddlHours.SelectedValue = "";
            tbProgramStartDate.SelectedDate = null;
            tbProgramAdmission.Text         = "";
            tbProgramDiploma.Text           = "";
            tbPracticum.Text                   = "";
            tbIntership.Text                   = "";
            RadButtonActive.Checked            = true;
            tbProgramActiveDate.SelectedDate   = null;
            tbProgramInActiveDate.SelectedDate = null;

            // other fee info
            for (var i = 1; i < 19; i++)
            {
                var fee = (RadNumericTextBox)RadPaneProgram.FindControl("tbFee" + i);
                fee.Value = null;
            }
            tbFeeComment.Text = "";

            // other info
            tbLocalCRC.Text     = "";
            tbDoctorNote.Text   = "";
            tbNoc.Text          = "";
            tbHrsdc.Text        = "";
            tbReference2.Text   = "";
            tbReference3.Text   = "";
            tbEng10.Text        = "";
            tbMath10.Text       = "";
            tbSience11.Text     = "";
            tbEng12.Text        = "";
            tbBio12.Text        = "";
            tbSSience.Text      = "";
            tbSMath.Text        = "";
            tbSEng.Text         = "";
            tbSLBio.Text        = "";
            tbSLChemi.Text      = "";
            tbImmun.Text        = "";
            tbHelpB.Text        = "";
            tbOthercomment.Text = "";

            RadToolBarProgram.FindItemByText("New").Enabled = false;
            //RadToolBarProgram.FindItemByText("Delete").Enabled = false;
            if (RadToolBarProgram.FindItemByText("Update") != null)
            {
                RadToolBarProgram.FindItemByText("Update").Text = "Save";
            }

            GetSiteLocation();
        }
Пример #3
0
        protected void ToolbarClick(object sender, RadToolBarEventArgs e)
        {
            if (e.Item.Text == "New")
            {
                Grid.SelectedIndexes.Clear();
                ResetForm();
            }
            else if (e.Item.Text == "Save")
            {
                var cProg = new CProgram();
                var prog  = new Erp2016.Lib.Program();

                if (string.IsNullOrEmpty(RadComboBoxProgramGroup.SelectedValue) == false)
                {
                    prog.ProgramGroupId = Convert.ToInt32(RadComboBoxProgramGroup.SelectedValue);
                }

                prog.ProgramFullName    = tbProgramFullName.Text;
                prog.ProgramWebName     = tbProgramWebName.Text;
                prog.ProgramShortName   = tbProgramShortName.Text;
                prog.ProgramDescription = tbDescript.Text;

                if (string.IsNullOrEmpty(ddlProgramType.SelectedValue) == false)
                {
                    prog.ProgramType = Convert.ToInt32(ddlProgramType.SelectedValue);
                }
                else
                {
                    prog.ProgramType = null;
                }

                if (string.IsNullOrEmpty(ddlComType.SelectedValue) == false)
                {
                    prog.UisType = Convert.ToInt32(ddlComType.SelectedValue);
                }
                else
                {
                    prog.UisType = null;
                }

                prog.EarningCredit = Convert.ToDecimal(tbEarningCredit.Value);

                //if (tbProgramWeek.Text != "")
                //    prog.TotalWeeks = Convert.ToInt32(tbProgramWeek.Text);
                //else
                //    prog.TotalWeeks = null;

                //if (tbProgramSemester.Text != "")
                //    prog.TotalSemester = Convert.ToInt32(tbProgramSemester.Text);
                //else
                //    prog.TotalSemester = null;

                //if (tbProgramMonth.Text != "")
                //    prog.TotalMonth = Convert.ToInt32(tbProgramMonth.Text);
                //else
                //    prog.TotalMonth = null;

                //if (tbProgramHoursDay.Text != "")
                //    prog.HoursOfDay = Convert.ToInt32(tbProgramHoursDay.Text);
                //else
                //    prog.HoursOfDay = null;

                //prog.HoursOfWeek = Convert.ToInt32(ddlHours.SelectedValue);
                prog.EstimatedStartDate              = tbProgramStartDate.SelectedDate;
                prog.AdmissionRequirement            = tbProgramAdmission.Text;
                prog.DiplomaCertificationRequirement = tbProgramDiploma.Text;

                if (string.IsNullOrEmpty(tbPracticum.Text) == false)
                {
                    prog.PracticumWeeks = Convert.ToInt32(tbPracticum.Text);
                }
                else
                {
                    prog.PracticumWeeks = null;
                }

                if (string.IsNullOrEmpty(tbIntership.Text) == false)
                {
                    prog.IntershipWeeks = Convert.ToInt32(tbIntership.Text);
                }
                else
                {
                    prog.IntershipWeeks = null;
                }

                prog.IsActive     = RadButtonActive.Checked;
                prog.ActiveDate   = tbProgramActiveDate.SelectedDate;
                prog.InActiveDate = tbProgramInActiveDate.SelectedDate;
                prog.CreatedId    = CurrentUserId;
                prog.CreatedDate  = DateTime.Now;
                prog.UpdatedId    = CurrentUserId;
                prog.UpdatedDate  = DateTime.Now;

                int programId = cProg.Add(prog);
                if (programId > 0)
                {
                    var cProgramSiteLocation = new CProgramSiteLocation();
                    cProgramSiteLocation.DelProgramSiteLocationList(programId);

                    foreach (var siteLocation in RadComboBoxSiteLocation.CheckedItems)
                    {
                        var programSiteLocation = new ProgramSiteLocation()
                        {
                            CreatedId      = CurrentUserId,
                            ProgramId      = programId,
                            SiteLocationId = Convert.ToInt32(siteLocation.Value),
                            CreatedDate    = DateTime.Now
                        };
                        cProgramSiteLocation.Add(programSiteLocation);
                    }

                    // other info fee
                    var cProgramOtherFeeInfo = new CProgramOtherFeeInfo();
                    var programOtherFeeInfo  = new ProgramOtherFeeInfo();

                    for (var i = 1; i < 19; i++)
                    {
                        var fee = (RadNumericTextBox)RadPaneProgram.FindControl("tbFee" + i);

                        programOtherFeeInfo.ProgramId = prog.ProgramId;

                        decimal feeValue = (decimal)(fee.Value ?? 0);

                        switch (i)
                        {
                        case 1:
                            programOtherFeeInfo.RegFee = feeValue;
                            //oid.InvoiceCoaItemId = 7;
                            break;

                        case 2:
                            programOtherFeeInfo.JRegFee = feeValue;
                            //oid.InvoiceCoaItemId = 7;
                            break;

                        case 3:
                            programOtherFeeInfo.AcademicFee = feeValue;
                            //oid.InvoiceCoaItemId = 11;
                            break;

                        case 4:
                            programOtherFeeInfo.MaterialFee = feeValue;
                            //oid.InvoiceCoaItemId = 11;
                            break;

                        case 5:
                            programOtherFeeInfo.TestFee = feeValue;
                            //oid.InvoiceCoaItemId = 31;
                            break;

                        case 6:
                            programOtherFeeInfo.PracticeFee = feeValue;
                            //oid.InvoiceCoaItemId = 27;
                            break;

                        case 7:
                            programOtherFeeInfo.ExamFee = feeValue;
                            //oid.InvoiceCoaItemId = 31;
                            break;

                        case 8:
                            programOtherFeeInfo.AdminFee = feeValue;
                            //oid.InvoiceCoaItemId = 13;
                            break;

                        case 9:
                            programOtherFeeInfo.InternFee = feeValue;
                            //oid.InvoiceCoaItemId = 27;
                            break;

                        case 10:
                            programOtherFeeInfo.LCFee = feeValue;
                            //oid.InvoiceCoaItemId = 27;
                            break;

                        case 11:
                            programOtherFeeInfo.SDFee = feeValue;
                            //oid.InvoiceCoaItemId = 27;
                            break;

                        case 12:
                            programOtherFeeInfo.UPFee = feeValue;
                            //oid.InvoiceCoaItemId = 27;
                            break;

                        case 13:
                            programOtherFeeInfo.ACFee = feeValue;
                            //oid.InvoiceCoaItemId = 13;
                            break;

                        case 14:
                            programOtherFeeInfo.CFee = feeValue;
                            //oid.InvoiceCoaItemId = 45;
                            break;

                        case 15:
                            programOtherFeeInfo.SupplyFee = feeValue;
                            //oid.InvoiceCoaItemId = 11;
                            break;

                        case 16:
                            programOtherFeeInfo.UniformFee = feeValue;
                            //oid.InvoiceCoaItemId = 11;
                            break;

                        case 17:
                            programOtherFeeInfo.UAGFee = feeValue;
                            //oid.InvoiceCoaItemId = 13;
                            break;

                        case 18:
                            programOtherFeeInfo.OtherFee = feeValue;
                            //oid.InvoiceCoaItemId = 0;
                            break;
                        }
                    }
                    programOtherFeeInfo.Comment     = tbFeeComment.Text;
                    programOtherFeeInfo.CreatedId   = CurrentUserId;
                    programOtherFeeInfo.CreatedDate = DateTime.Now;

                    cProgramOtherFeeInfo.Add(programOtherFeeInfo);

                    // other info
                    var cOtid = new CProgramOtherInfo();
                    var otid  = new ProgramOtherInfo();

                    otid.ProgramId   = prog.ProgramId;
                    otid.LocalCRC    = tbLocalCRC.Text;
                    otid.DoctorNote  = tbDoctorNote.Text;
                    otid.Noc         = tbNoc.Text;
                    otid.Hrsdc       = tbHrsdc.Text;
                    otid.Reference2  = tbReference2.Text;
                    otid.Reference3  = tbReference3.Text;
                    otid.Eng10       = tbEng10.Text;
                    otid.Math10      = tbMath10.Text;
                    otid.Sience11    = tbSience11.Text;
                    otid.Eng12       = tbEng12.Text;
                    otid.Bio12       = tbBio12.Text;
                    otid.SSience     = tbSSience.Text;
                    otid.SMath       = tbSMath.Text;
                    otid.SEng        = tbSEng.Text;
                    otid.SLBio       = tbSLBio.Text;
                    otid.SLChemi     = tbSLChemi.Text;
                    otid.Immun       = tbImmun.Text;
                    otid.HelpB       = tbHelpB.Text;
                    otid.Comment     = tbOthercomment.Text;
                    otid.CreatedId   = CurrentUserId;
                    otid.CreatedDate = DateTime.Now;
                    otid.UpdatedId   = CurrentUserId;
                    otid.UpdatedDate = otid.CreatedDate;

                    if (cOtid.Add(otid) > 0)
                    {
                        ShowMessage("New program is added");
                        Grid.Rebind();
                    }
                }
                else
                {
                    ShowMessage("Failed to add program, please try again");
                }
            }
            else if (e.Item.Text == "Update")
            {
                if (Grid.SelectedValue != null)
                {
                    var cProg = new CProgram();
                    var prog  = cProg.Get(Convert.ToInt32(Grid.SelectedValue));

                    if (RadComboBoxProgramGroup.SelectedValue != null)
                    {
                        prog.ProgramGroupId = Convert.ToInt32(RadComboBoxProgramGroup.SelectedValue);
                    }

                    prog.ProgramFullName    = tbProgramFullName.Text;
                    prog.ProgramWebName     = tbProgramWebName.Text;
                    prog.ProgramShortName   = tbProgramShortName.Text;
                    prog.ProgramDescription = tbDescript.Text;

                    if (ddlProgramType.SelectedValue != "")
                    {
                        prog.ProgramType = Convert.ToInt32(ddlProgramType.SelectedValue);
                    }
                    else
                    {
                        prog.ProgramType = null;
                    }

                    if (ddlComType.SelectedValue != "")
                    {
                        prog.UisType = Convert.ToInt32(ddlComType.SelectedValue);
                    }
                    else
                    {
                        prog.UisType = null;
                    }

                    prog.EarningCredit = Convert.ToDecimal(tbEarningCredit.Value);

                    //if (tbProgramWeek.Text != "")
                    //    prog.TotalWeeks = Convert.ToInt32(tbProgramWeek.Text);
                    //else
                    //    prog.TotalWeeks = null;

                    //if (tbProgramSemester.Text != "")
                    //    prog.TotalSemester = Convert.ToInt32(tbProgramSemester.Text);
                    //else
                    //    prog.TotalSemester = null;

                    //if (tbProgramMonth.Text != "")
                    //    prog.TotalMonth = Convert.ToInt32(tbProgramMonth.Text);
                    //else
                    //    prog.TotalMonth = null;

                    //if (tbProgramHoursDay.Text != "")
                    //    prog.HoursOfDay = Convert.ToInt32(tbProgramHoursDay.Text);
                    //else
                    //    prog.HoursOfDay = null;

                    //prog.HoursOfWeek = Convert.ToInt32(ddlHours.SelectedValue);
                    prog.EstimatedStartDate              = tbProgramStartDate.SelectedDate;
                    prog.AdmissionRequirement            = tbProgramAdmission.Text;
                    prog.DiplomaCertificationRequirement = tbProgramDiploma.Text;

                    if (tbPracticum.Text != "")
                    {
                        prog.PracticumWeeks = Convert.ToInt32(tbPracticum.Text);
                    }
                    else
                    {
                        prog.PracticumWeeks = null;
                    }

                    if (tbIntership.Text != "")
                    {
                        prog.IntershipWeeks = Convert.ToInt32(tbIntership.Text);
                    }
                    else
                    {
                        prog.IntershipWeeks = null;
                    }

                    prog.IsActive     = RadButtonActive.Checked;
                    prog.ActiveDate   = tbProgramActiveDate.SelectedDate;
                    prog.InActiveDate = tbProgramInActiveDate.SelectedDate;
                    prog.UpdatedId    = CurrentUserId;
                    prog.UpdatedDate  = DateTime.Now;

                    if (cProg.Update(prog))
                    {
                        var cProgramSiteLocation = new CProgramSiteLocation();
                        cProgramSiteLocation.DelProgramSiteLocationList(prog.ProgramId);

                        foreach (var siteLocation in RadComboBoxSiteLocation.CheckedItems)
                        {
                            var programSiteLocation = new ProgramSiteLocation()
                            {
                                CreatedId      = CurrentUserId,
                                ProgramId      = prog.ProgramId,
                                SiteLocationId = Convert.ToInt32(siteLocation.Value),
                                CreatedDate    = DateTime.Now
                            };
                            cProgramSiteLocation.Add(programSiteLocation);
                        }

                        var cProgramOtherFeeInfo = new CProgramOtherFeeInfo();
                        var programOtherFeeInfo  = cProgramOtherFeeInfo.Get(Convert.ToInt32(Grid.SelectedValue));
                        if (programOtherFeeInfo != null)
                        {
                            for (var i = 1; i < 19; i++)
                            {
                                var     fee      = (RadNumericTextBox)RadPaneProgram.FindControl("tbFee" + i);
                                decimal feeValue = (decimal)(fee.Value ?? 0);

                                switch (i)
                                {
                                case 1:
                                    programOtherFeeInfo.RegFee = feeValue;
                                    break;

                                case 2:
                                    programOtherFeeInfo.JRegFee = feeValue;
                                    break;

                                case 3:
                                    programOtherFeeInfo.AcademicFee = feeValue;
                                    break;

                                case 4:
                                    programOtherFeeInfo.MaterialFee = feeValue;
                                    break;

                                case 5:
                                    programOtherFeeInfo.TestFee = feeValue;
                                    break;

                                case 6:
                                    programOtherFeeInfo.PracticeFee = feeValue;
                                    break;

                                case 7:
                                    programOtherFeeInfo.ExamFee = feeValue;
                                    break;

                                case 8:
                                    programOtherFeeInfo.AdminFee = feeValue;
                                    break;

                                case 9:
                                    programOtherFeeInfo.InternFee = feeValue;
                                    break;

                                case 10:
                                    programOtherFeeInfo.LCFee = feeValue;
                                    break;

                                case 11:
                                    programOtherFeeInfo.SDFee = feeValue;
                                    break;

                                case 12:
                                    programOtherFeeInfo.UPFee = feeValue;
                                    break;

                                case 13:
                                    programOtherFeeInfo.ACFee = feeValue;
                                    break;

                                case 14:
                                    programOtherFeeInfo.CFee = feeValue;
                                    break;

                                case 15:
                                    programOtherFeeInfo.SupplyFee = feeValue;
                                    break;

                                case 16:
                                    programOtherFeeInfo.UniformFee = feeValue;
                                    break;

                                case 17:
                                    programOtherFeeInfo.UAGFee = feeValue;
                                    break;

                                case 18:
                                    programOtherFeeInfo.OtherFee = feeValue;
                                    break;
                                }
                            }

                            programOtherFeeInfo.Comment     = tbFeeComment.Text;
                            programOtherFeeInfo.UpdatedId   = CurrentUserId;
                            programOtherFeeInfo.UpdatedDate = DateTime.Now;

                            cProgramOtherFeeInfo.Update(programOtherFeeInfo);
                        }

                        var cOtid = new CProgramOtherInfo();
                        var otid  = cOtid.Get(Convert.ToInt32(Grid.SelectedValue));
                        if (otid != null)
                        {
                            otid.ProgramId   = prog.ProgramId;
                            otid.LocalCRC    = tbLocalCRC.Text;
                            otid.DoctorNote  = tbDoctorNote.Text;
                            otid.Noc         = tbNoc.Text;
                            otid.Hrsdc       = tbHrsdc.Text;
                            otid.Reference2  = tbReference2.Text;
                            otid.Reference3  = tbReference3.Text;
                            otid.Eng10       = tbEng10.Text;
                            otid.Math10      = tbMath10.Text;
                            otid.Sience11    = tbSience11.Text;
                            otid.Eng12       = tbEng12.Text;
                            otid.Bio12       = tbBio12.Text;
                            otid.SSience     = tbSSience.Text;
                            otid.SMath       = tbSMath.Text;
                            otid.SEng        = tbSEng.Text;
                            otid.SLBio       = tbSLBio.Text;
                            otid.SLChemi     = tbSLChemi.Text;
                            otid.Immun       = tbImmun.Text;
                            otid.HelpB       = tbHelpB.Text;
                            otid.Comment     = tbOthercomment.Text;
                            otid.UpdatedId   = CurrentUserId;
                            otid.UpdatedDate = DateTime.Now;

                            cOtid.Update(otid);
                        }

                        ShowMessage("Program updated");
                        RefreshProgramList();
                    }
                    else
                    {
                        ShowMessage("Failed to update program, please try again");
                    }
                }
            }
        }