private void GetSiteLocation() { RadComboBoxSiteLocation.Items.Clear(); List <SiteLocation> siteLocationList = new List <SiteLocation>(); if (Grid.SelectedValue != null) { var cProgramSiteLocation = new CProgramSiteLocation(); var programSiteLocation = cProgramSiteLocation.GetProgramSiteLocationList(Convert.ToInt32(Grid.SelectedValue)); if (programSiteLocation.Count > 0) { var siteLocation = new CSiteLocation().Get(programSiteLocation[0].SiteLocationId); siteLocationList = new CSiteLocation().GetSiteLocationBySiteId(siteLocation.SiteId); RadTextBoxSite.Text = (new CSite()).Get(siteLocation.SiteId).Abbreviation; } foreach (var siteLocation in siteLocationList) { RadComboBoxSiteLocation.Items.Add(new RadComboBoxItem(siteLocation.Name, siteLocation.SiteLocationId.ToString())); } foreach (var agencySiteLo in programSiteLocation) { foreach (RadComboBoxItem siteLocation in RadComboBoxSiteLocation.Items) { if (agencySiteLo.SiteLocationId == Convert.ToInt32(siteLocation.Value)) { siteLocation.Checked = true; } } } } else { var cSiteLocation = new CSiteLocation(); siteLocationList = cSiteLocation.GetSiteLocationBySiteId(CurrentSiteId); foreach (var siteLocation in siteLocationList) { RadComboBoxSiteLocation.Items.Add(new RadComboBoxItem(siteLocation.Name, siteLocation.SiteLocationId.ToString())); } RadTextBoxSite.Text = (new CSite()).Get(CurrentSiteId).Abbreviation; } RadComboBoxSiteLocation_OnSelectedIndexChanged(null, null); }
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"); } } } }