protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { FileDownloadList1.InitFileDownloadList((int)CConstValue.Upload.PackageProgram); hfId.Value = Request["id"]; hfType.Value = Request["type"]; ResetForm(); LoadFaculty(); // new if (hfType.Value == "0") { GetSiteLocation(false); mainToolBar.FindItemByText("Request").Enabled = false; } // modify else { GetSiteLocation(true); var cP = new CPackageProgram().GetViewPackageProgram(Convert.ToInt32(hfId.Value)); RadTextBoxPackageProgramName.Text = cP.PackageProgramName; var cProgram = new CProgram(); var program = cProgram.Get((int)cP.ProgramId); if (program != null) { if (program.ProgramGroupId != null) { var programGroup = new CProgramGroup().Get(Convert.ToInt32(program.ProgramGroupId)); if (programGroup != null) { RadComboBoxFaculty.SelectedValue = programGroup.FacultyId.ToString(); LoadProgramGroup(RadComboBoxFaculty.SelectedValue); } RadComboBoxProgramGroup.SelectedValue = program.ProgramGroupId.ToString(); LoadProgram(RadComboBoxProgramGroup.SelectedValue); } RadComboBoxProgram.SelectedValue = program.ProgramId.ToString(); } RadDatePickerStartDate.SelectedDate = cP.StartDate; RadDatePickerEndDate.SelectedDate = cP.EndDate; RadTextBoxDescription.Text = cP.Description; //btnToggleActive.Checked = (bool)cP.IsActive; //btnToggleActive.Visible = true; // UP LOAD FileDownloadList1.GetFileDownload(Convert.ToInt32(hfId.Value)); } } RadComboBoxFaculty.OpenDropDownOnLoad = false; RadComboBoxProgramGroup.OpenDropDownOnLoad = false; RadComboBoxProgram.OpenDropDownOnLoad = false; }
private void SetPackageProgramData(string value) { var split = value.Split(','); if (string.IsNullOrEmpty(split[0])) { return; } var packageProgramId = Convert.ToInt32(split[0]); ViewState["PackageProgramId"] = packageProgramId; var programId = Convert.ToInt32(split[1]); var cCP = new CProgram(); var cP = cCP.Get(programId); if (cP != null) { // program Group if (cP.ProgramGroupId != null) { var cProgramGroup = (new CProgramGroup()).Get((int)cP.ProgramGroupId); if (cProgramGroup != null) { radTextBoxProgramGroup.Text = cProgramGroup.Name; // faculty if (cProgramGroup.FacultyId != null) { var cFaculty = (new CFaculty()).Get((int)cProgramGroup.FacultyId); radTextBoxFaculty.Text = cFaculty.Name; } } } // program name radTextBoxProgramName.Text = cP.ProgramFullName; } var cPackageProgram = new CPackageProgram(); var packageProgram = cPackageProgram.GetPackageProgram(packageProgramId); tbPrgStartDate.SelectedDate = packageProgram.StartDate; tbPrgEndDate.SelectedDate = packageProgram.EndDate; var standardTuition = cPackageProgram.GetStandardTuition(packageProgramId).ToString(); tbPrgStandardTuition.Text = standardTuition; tbPrgTuition.Text = standardTuition; }
private string GetTableNameForViewType(string selectedText) { bool isApprovalList = selectedText == "My Approval" ? true : false; string tableName = string.Empty; switch (_menuId) { case (int)CConstValue.Menu.PackageProgram: var cPackageProgram = new CPackageProgram(); tableName = isApprovalList ? cPackageProgram.GetTableNameForVwPackageProgramApprovalList() : cPackageProgram.GetTableNameForVwPackageProgram(); break; case (int)CConstValue.Menu.CreditMemo: var cCreditMemo = new CCreditMemoPayout(); tableName = isApprovalList ? cCreditMemo.GetTableNameForvwCreditMemoPayoutApprovalList() : cCreditMemo.GetTableNameForVwCreditMemoPayout(); break; case (int)CConstValue.Menu.Refund: var cRefund = new CRefund(); tableName = isApprovalList ? cRefund.GetTableNameForVwRefundApprovalList() : cRefund.GetTableNameForVwRefund(); break; case (int)CConstValue.Menu.Scholarship: var cScholarship = new CScholarship(); tableName = isApprovalList ? cScholarship.GetTableNameForVwScholarshipApprovalList() : cScholarship.GetTableNameForVwScholarship(); break; case (int)CConstValue.Menu.Promotion: var cPromotion = new CPromotion(); tableName = isApprovalList ? cPromotion.GetTableNameForVwPromotionApprovalList() : cPromotion.GetTableNameForVwPromotion(); break; case (int)CConstValue.Menu.Agency: var cAgency = new CAgency(); tableName = isApprovalList ? cAgency.GetTableNameForVwAgencyApprovalList() : cAgency.GetTableNameForVwAgency(); break; } return(tableName); }
protected void MainToolBar_ButtonClick(object sender, RadToolBarEventArgs e) { if (e.Item.Text == @"Reject" && !string.IsNullOrEmpty(hfId.Value)) { if (IsValid) { try { var type = Convert.ToInt32(hfType.Value); var id = Convert.ToInt32(hfId.Value); var idNumber = string.Empty; var cApprovalHistory = new CApprovalHistory(); var approvalHistory = cApprovalHistory.Get(type, id, CurrentUserId); approvalHistory.ApprovalDate = DateTime.Now; approvalHistory.ApprovalMemo = tbRemark.Text; // Reject approvalHistory.ApprovalStep = (int)CConstValue.ApprovalStatus.Rejected; if (type == (int)CConstValue.Approval.Refund) { var cC = new CRefund(); var c = cC.Get(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; if (cC.Update(c)) { var cInvoiceInfo = new CInvoice(); var invoiceInfo = cInvoiceInfo.Get(c.InvoiceId); var cOriginalInvoiceInfo = new CInvoice(); var originalInvoiceInfo = cOriginalInvoiceInfo.Get(Convert.ToInt32(invoiceInfo.OriginalInvoiceId)); invoiceInfo.Status = (int)CConstValue.InvoiceStatus.Cancelled_RF; // Canceled_R invoiceInfo.UpdatedId = CurrentUserId; originalInvoiceInfo.Status = (int)CConstValue.InvoiceStatus.Invoiced; // Invoiced originalInvoiceInfo.UpdatedId = CurrentUserId; cInvoiceInfo.Update(invoiceInfo); cOriginalInvoiceInfo.Update(originalInvoiceInfo); } } // Agency else if (type == (int)CConstValue.Approval.Agency) { var cC = new CAgency(); var c = cC.Get(id); idNumber = c.AgencyNumber; c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } else if (type == (int)CConstValue.Approval.CorporateCreditCard) { var cC = new CCorporateCreditCard(); var c = cC.Get(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } // BusinessTrip else if (type == (int)CConstValue.Approval.BusinessTrip) { var cC = new CBusinessTrip(); var c = cC.Get(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } // PackageProgram else if (type == (int)CConstValue.Approval.Package) { var cC = new CPackageProgram(); var c = cC.GetPackageProgram(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } // Expense else if (type == (int)CConstValue.Approval.Expense) { var cC = new CExpense(); var c = cC.Get(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } // Purchase Order else if (type == (int)CConstValue.Approval.PurchaseOrder) { var cP = new CPurchaseOrder(); var c = cP.Get(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cP.Update(c); } // Hire else if (type == (int)CConstValue.Approval.Hire) { var cC = new CHire(); var c = cC.Get(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } // Vacation else if (type == (int)CConstValue.Approval.Vacation) { var cC = new CVacation(); var c = cC.Get(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } //Scholarship else if (type == (int)CConstValue.Approval.Scholarship) { var cC = new CScholarship(); var c = cC.Get(id); idNumber = c.ScholarshipMasterNo; c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } //Promotion else if (type == (int)CConstValue.Approval.Promotion) { var cC = new CPromotion(); var c = cC.Get(id); idNumber = c.PromotionMasterNo; c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } // CreditMemo else if (type == (int)CConstValue.Approval.CreditMemoPayout) { var cC = new CCreditMemoPayout(); var c = cC.Get(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } // update approvalHistory cApprovalHistory.Update(approvalHistory); new CMail().SendMail((CConstValue.Approval)type, CConstValue.MailStatus.ToRequestUser, id, idNumber, CurrentUserId); RunClientScript("Close();"); } catch (Exception ex) { ShowMessage(ex.Message); } } } }
protected void RadGrid_OnSelectedIndexChanged(object sender, EventArgs e) { ResetForm(); // detail information var packageProgram = new CPackageProgram().GetPackageProgram(Convert.ToInt32(RadGridProgramPackage.SelectedValue)); LabelPackageProgramName.Text = packageProgram.PackageProgramName; var program = (new CProgram()).Get((int)packageProgram.ProgramId); if (program != null) { RadTextBoxProgram.Text = program.ProgramFullName; if (program.ProgramGroupId != null) { var programGroup = new CProgramGroup().Get((int)program.ProgramGroupId); if (programGroup != null) { if (programGroup.FacultyId != null) { RadTextBoxFaculty.Text = new CFaculty().Get((int)programGroup.FacultyId)?.Name; } RadTextBoxProgramGroup.Text = programGroup.Name; } } } LabelDescription.Text = packageProgram.Description; LabelPackageStartDate.Text = string.Format("{0:MM-dd-yyyy}", packageProgram.StartDate); LabelPackageEndDate.Text = string.Format("{0:MM-dd-yyyy}", packageProgram.EndDate); GetSiteLocation(); // toolbar foreach (RadToolBarItem toolbarItem in RadToolBarPackageProgram.Items) { // request active check if (toolbarItem.Text == "Request") { if ((packageProgram.ApprovalStatus == null || packageProgram.ApprovalStatus == (int)CConstValue.ApprovalStatus.Revise) && packageProgram.CreatedId == CurrentUserId) { toolbarItem.Enabled = true; } else { toolbarItem.Enabled = false; } } else if (toolbarItem.Text == "Cancel") { if ((packageProgram.ApprovalStatus == null || packageProgram.ApprovalStatus == (int)CConstValue.ApprovalStatus.Revise || packageProgram.ApprovalStatus == (int)CConstValue.ApprovalStatus.Requested) && packageProgram.CreatedId == CurrentUserId) { toolbarItem.Enabled = true; } else { toolbarItem.Enabled = false; } } else if (toolbarItem.Text == "Approve" || toolbarItem.Text == "Reject") { // approve active check var refundApproveInfo = new CGlobal(); var supervisor = refundApproveInfo.CheckApprovalEnable((int)CConstValue.Approval.Package, Convert.ToInt32(packageProgram.PackageProgramId)); // supervisor or loy employees if ((CurrentUserId == supervisor) && packageProgram.ApprovalStatus != (int)CConstValue.ApprovalStatus.Approved && packageProgram.ApprovalStatus != (int)CConstValue.ApprovalStatus.Rejected && packageProgram.ApprovalStatus != (int)CConstValue.ApprovalStatus.Canceled && packageProgram.ApprovalStatus != null && CurrentUserId != packageProgram.ApprovalId) { toolbarItem.Enabled = true; } else { toolbarItem.Enabled = false; } } } // Detail View if (CurrentUserId == packageProgram.CreatedId && packageProgram.ApprovalStatus == null) { RadGridPackageProgramDetail.AllowAutomaticInserts = true; RadGridPackageProgramDetail.AllowAutomaticUpdates = true; RadGridPackageProgramDetail.AllowAutomaticDeletes = true; //RadGridPackageProgramDetail.MasterTableView.EditMode = GridEditMode.Batch; RadGridPackageProgramDetail.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.Top; // hidden delete button RadGridPackageProgramDetail.MasterTableView.Columns[RadGridPackageProgramDetail.MasterTableView.Columns.Count - 1].Visible = true; } else { RadGridPackageProgramDetail.AllowAutomaticInserts = false; RadGridPackageProgramDetail.AllowAutomaticUpdates = false; RadGridPackageProgramDetail.AllowAutomaticDeletes = false; //RadGridPackageProgramDetail.MasterTableView.EditMode = GridEditMode.InPlace; RadGridPackageProgramDetail.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.None; // hidden delete button RadGridPackageProgramDetail.MasterTableView.Columns[RadGridPackageProgramDetail.MasterTableView.Columns.Count - 1].Visible = false; } //SetApprovalList(); }
protected void MainToolBar_ButtonClick(object sender, RadToolBarEventArgs e) { if (e.Item.Text == "Cancel" && !string.IsNullOrEmpty(hfId.Value)) { if (IsValid) { try { var type = Convert.ToInt32(hfType.Value); var id = Convert.ToInt32(hfId.Value); var cApprovalHistory = new CApprovalHistory(); var approvalHistory = cApprovalHistory.Get(type, id, CurrentUserId); bool isExists = true; if (approvalHistory == null) { approvalHistory = new ApprovalHistory(); approvalHistory.ApprovalUser = CurrentUserId; isExists = false; } approvalHistory.ApprovalDate = DateTime.Now; approvalHistory.ApprovalMemo = tbRemark.Text; approvalHistory.ApprovalStep = (int)CConstValue.ApprovalStatus.Canceled; // update approvalHistory if (isExists) { cApprovalHistory.Update(approvalHistory); } if (type == (int)CConstValue.Approval.Refund) { var cRefund = new CRefund(); var refund = cRefund.Get(id); refund.ApprovalDate = approvalHistory.ApprovalDate; refund.ApprovalId = approvalHistory.ApprovalUser; refund.ApprovalMemo = approvalHistory.ApprovalMemo; refund.ApprovalStatus = approvalHistory.ApprovalStep; if (cRefund.Update(refund)) { var cInvoiceInfo = new CInvoice(); var invoiceInfo = cInvoiceInfo.Get(refund.InvoiceId); var cOriginalInvoiceInfo = new CInvoice(); var originalInvoiceInfo = cOriginalInvoiceInfo.Get(Convert.ToInt32(invoiceInfo.OriginalInvoiceId)); invoiceInfo.Status = (int)CConstValue.InvoiceStatus.Cancelled_RF; // Canceled_R invoiceInfo.UpdatedId = CurrentUserId; originalInvoiceInfo.Status = (int)CConstValue.InvoiceStatus.Invoiced; // Invoiced originalInvoiceInfo.UpdatedId = CurrentUserId; cInvoiceInfo.Update(invoiceInfo); cOriginalInvoiceInfo.Update(originalInvoiceInfo); } } else if (type == (int)CConstValue.Approval.Agency) { var cAgency = new CAgency(); var agency = cAgency.Get(id); agency.ApprovalDate = approvalHistory.ApprovalDate; agency.ApprovalId = approvalHistory.ApprovalUser; agency.ApprovalMemo = approvalHistory.ApprovalMemo; agency.ApprovalStatus = approvalHistory.ApprovalStep; cAgency.Update(agency); } else if (type == (int)CConstValue.Approval.CreditMemoPayout) { var cCreditMemoPayout = new CCreditMemoPayout(); var creditMemoPayout = cCreditMemoPayout.Get(id); creditMemoPayout.ApprovalDate = approvalHistory.ApprovalDate; creditMemoPayout.ApprovalId = approvalHistory.ApprovalUser; creditMemoPayout.ApprovalMemo = approvalHistory.ApprovalMemo; creditMemoPayout.ApprovalStatus = approvalHistory.ApprovalStep; cCreditMemoPayout.Update(creditMemoPayout); } else if (type == (int)CConstValue.Approval.Package) { var cPackageProgram = new CPackageProgram(); var packageProgram = cPackageProgram.GetPackageProgram(id); packageProgram.ApprovalDate = approvalHistory.ApprovalDate; packageProgram.ApprovalId = approvalHistory.ApprovalUser; packageProgram.ApprovalMemo = approvalHistory.ApprovalMemo; packageProgram.ApprovalStatus = approvalHistory.ApprovalStep; cPackageProgram.Update(packageProgram); } else if (type == (int)CConstValue.Approval.Promotion) { var cPromotion = new CPromotion(); var promotion = cPromotion.Get(id); promotion.ApprovalDate = approvalHistory.ApprovalDate; promotion.ApprovalId = approvalHistory.ApprovalUser; promotion.ApprovalMemo = approvalHistory.ApprovalMemo; promotion.ApprovalStatus = approvalHistory.ApprovalStep; cPromotion.Update(promotion); } else if (type == (int)CConstValue.Approval.Scholarship) { var cScholarship = new CScholarship(); var scholarship = cScholarship.Get(id); scholarship.ApprovalDate = approvalHistory.ApprovalDate; scholarship.ApprovalId = approvalHistory.ApprovalUser; scholarship.ApprovalMemo = approvalHistory.ApprovalMemo; scholarship.ApprovalStatus = approvalHistory.ApprovalStep; cScholarship.Update(scholarship); } else if (type == (int)CConstValue.Approval.CorporateCreditCard) { var cCorporateCreditCard = new CCorporateCreditCard(); var corporateCreditCard = cCorporateCreditCard.Get(id); corporateCreditCard.ApprovalDate = approvalHistory.ApprovalDate; corporateCreditCard.ApprovalId = approvalHistory.ApprovalUser; corporateCreditCard.ApprovalMemo = approvalHistory.ApprovalMemo; corporateCreditCard.ApprovalStatus = approvalHistory.ApprovalStep; cCorporateCreditCard.Update(corporateCreditCard); } // BusinessTrip else if (type == (int)CConstValue.Approval.BusinessTrip) { var cBusinessTrip = new CBusinessTrip(); var businessTrip = cBusinessTrip.Get(id); businessTrip.ApprovalDate = approvalHistory.ApprovalDate; businessTrip.ApprovalId = approvalHistory.ApprovalUser; businessTrip.ApprovalMemo = approvalHistory.ApprovalMemo; businessTrip.ApprovalStatus = approvalHistory.ApprovalStep; cBusinessTrip.Update(businessTrip); } // Purchase Order else if (type == (int)CConstValue.Approval.PurchaseOrder) { var cPurchaseOrder = new CPurchaseOrder(); var purchaseOrder = cPurchaseOrder.Get(id); purchaseOrder.ApprovalDate = approvalHistory.ApprovalDate; purchaseOrder.ApprovalId = approvalHistory.ApprovalUser; purchaseOrder.ApprovalMemo = approvalHistory.ApprovalMemo; purchaseOrder.ApprovalStatus = approvalHistory.ApprovalStep; cPurchaseOrder.Update(purchaseOrder); } // Expense else if (type == (int)CConstValue.Approval.Expense) { var cExpense = new CExpense(); var expense = cExpense.Get(id); expense.ApprovalDate = approvalHistory.ApprovalDate; expense.ApprovalId = approvalHistory.ApprovalUser; expense.ApprovalMemo = approvalHistory.ApprovalMemo; expense.ApprovalStatus = approvalHistory.ApprovalStep; cExpense.Update(expense); } // Hire else if (type == (int)CConstValue.Approval.Hire) { var cHire = new CHire(); var hire = cHire.Get(id); hire.ApprovalDate = approvalHistory.ApprovalDate; hire.ApprovalId = approvalHistory.ApprovalUser; hire.ApprovalMemo = approvalHistory.ApprovalMemo; hire.ApprovalStatus = approvalHistory.ApprovalStep; cHire.Update(hire); } // Vacation else if (type == (int)CConstValue.Approval.Vacation) { var cVacation = new CVacation(); var vacation = cVacation.Get(id); vacation.ApprovalDate = approvalHistory.ApprovalDate; vacation.ApprovalId = approvalHistory.ApprovalUser; vacation.ApprovalMemo = approvalHistory.ApprovalMemo; vacation.ApprovalStatus = approvalHistory.ApprovalStep; cVacation.Update(vacation); } RunClientScript("Close();"); } catch (Exception ex) { ShowMessage(ex.Message); } } } }
protected void mainToolBar_ButtonClick(object sender, RadToolBarEventArgs e) { switch (e.Item.Text) { case "TempSave": case "Request": if (IsValid) { var cProgram = new CPackageProgram(); Erp2016.Lib.PackageProgram packageProgram1 = null; // new if (hfType.Value == "0") { packageProgram1 = new Erp2016.Lib.PackageProgram(); packageProgram1.CreatedId = CurrentUserId; packageProgram1.CreatedDate = DateTime.Now; } // modify else { packageProgram1 = cProgram.GetPackageProgram(Convert.ToInt32(hfId.Value)); } packageProgram1.ProgramId = Convert.ToInt32(RadComboBoxProgram.SelectedValue); packageProgram1.PackageProgramName = RadTextBoxPackageProgramName.Text; packageProgram1.Description = RadTextBoxDescription.Text; packageProgram1.StartDate = RadDatePickerStartDate.SelectedDate; packageProgram1.EndDate = RadDatePickerEndDate.SelectedDate; int packageProgramId; // new if (hfType.Value == "0") { packageProgram1.IsActive = false; packageProgramId = cProgram.Add(packageProgram1); } // modify else { packageProgram1.UpdatedId = CurrentUserId; packageProgram1.UpdatedDate = DateTime.Now; //packageProgram.IsActive = btnToggleActive.Checked; cProgram.Update(packageProgram1); packageProgramId = packageProgram1.PackageProgramId; } var cPackageProgramSiteLocation = new CPackageProgramSiteLocation(); cPackageProgramSiteLocation.DelPackageProgramSiteLocation(packageProgramId); foreach (var siteLocation in RadComboBoxSiteLocation.CheckedItems) { var packageProgramSiteLocation = new PackageProgramSiteLocation() { CreatedId = CurrentUserId, PackageProgramId = packageProgramId, SiteLocationId = Convert.ToInt32(siteLocation.Value), CreatedDate = DateTime.Now }; cPackageProgramSiteLocation.Add(packageProgramSiteLocation); } FileDownloadList1.SaveFile(packageProgramId); if (e.Item.Text == "TempSave") { RunClientScript("Close();"); } else { var cApprovalHistory = new CApprovalHistory(); cApprovalHistory.DelApprovalHistory((int)CConstValue.Approval.Package, packageProgramId); // approve request var approval = new CApproval().ApproveRequstCreate((int)CConstValue.Approval.Package, CurrentUserId, packageProgramId); if (approval > 0) { var cP = new CPackageProgram(); var packageProgram = cP.GetPackageProgram(packageProgramId); packageProgram.ApprovalStatus = approval; packageProgram.ApprovalId = CurrentUserId; packageProgram.ApprovalDate = DateTime.Now; //packageProgram.ApprovalMemo = ""; cP.Update(packageProgram); new CMail().SendMail(CConstValue.Approval.Package, CConstValue.MailStatus.ToApproveUser, packageProgram.PackageProgramId, string.Empty, CurrentUserId); RunClientScript("Close();"); } else { ShowMessage("error requesting"); } } } break; case "Close": RunClientScript("Close();"); break; } }
protected void MainToolBar_ButtonClick(object sender, RadToolBarEventArgs e) { if (e.Item.Text == @"Approve" && !string.IsNullOrEmpty(hfId.Value)) { if (IsValid) { var type = Convert.ToInt32(hfType.Value); var id = Convert.ToInt32(hfId.Value); var idNumber = string.Empty; var cApprovalHistory = new CApprovalHistory(); var approvalHistory = cApprovalHistory.Get(type, id, CurrentUserId); approvalHistory.ApprovalDate = DateTime.Now; approvalHistory.ApprovalMemo = tbRemark.Text; // cal int approvalStatus = cApprovalHistory.CheckApprovalStep(type, id); if (approvalStatus == (int)CConstValue.ApprovalStatus.Approved) { approvalStatus = new CGlobal().GetApprovalValue(type); } approvalHistory.ApprovalStep = approvalStatus; // update approvalHistory cApprovalHistory.Update(approvalHistory); //Refund & Commission if (type == (int)CConstValue.Approval.Refund) { var cRefundInfo = new CRefund(); var refundInfo = cRefundInfo.Get(Convert.ToInt32(hfId.Value)); refundInfo.ApprovalDate = approvalHistory.ApprovalDate; refundInfo.ApprovalId = approvalHistory.ApprovalUser; refundInfo.ApprovalMemo = approvalHistory.ApprovalMemo; refundInfo.ApprovalStatus = approvalHistory.ApprovalStep; if (cRefundInfo.Update(refundInfo)) { //if last approve if (refundInfo.ApprovalStatus == (int)CConstValue.ApprovalStatus.Approved) { var vwRefund = cRefundInfo.GetVwRefund(refundInfo.RefundId); var refundAmount = Math.Abs((decimal)vwRefund.RefundAmount); var sumOfMdfAndCp = new CCreditMemo().GetSumOfMdfAndCp(vwRefund.RefundId); var cCreditMemoPayout = new CCreditMemoPayout(); var creditMemoPayout = cCreditMemoPayout.Get(refundInfo.CreditMemoPayoutId); var cCreditMemo = new CCreditMemo(); var creditMemo = cCreditMemo.Get(creditMemoPayout.CreditMemoId); creditMemo.OriginalCreditMemoAmount = refundAmount - sumOfMdfAndCp; creditMemo.CreditMemoStartDate = DateTime.Now; creditMemo.CreditMemoEndDate = DateTime.Now.AddYears(1); creditMemo.IsActive = true; creditMemo.UpdatedId = CurrentUserId; creditMemo.UpdatedDate = DateTime.Now; // Approved creditMemoPayout.ApprovalStatus = (int)CConstValue.ApprovalStatus.Approved; creditMemoPayout.ApprovalDate = DateTime.Now; creditMemoPayout.ApprovalId = CurrentUserId; creditMemoPayout.Amount = refundAmount; creditMemoPayout.PayoutMethod = vwRefund.PayoutMethod; creditMemoPayout.IsActive = true; creditMemoPayout.UpdatedId = CurrentUserId; creditMemoPayout.UpdatedDate = DateTime.Now; cCreditMemoPayout.Update(creditMemoPayout); if (cCreditMemo.Update(creditMemo)) { var cInvoiceInfo = new CInvoice(); var invoiceInfo = cInvoiceInfo.Get(refundInfo.InvoiceId); var cOriginalInvoiceInfo = new CInvoice(); var originalInvoiceInfo = cOriginalInvoiceInfo.Get(Convert.ToInt32(invoiceInfo.OriginalInvoiceId)); invoiceInfo.Status = (int)CConstValue.InvoiceStatus.Invoiced; // Invoiced invoiceInfo.UpdatedId = CurrentUserId; originalInvoiceInfo.Status = (int)CConstValue.InvoiceStatus.Cancelled_RF; // Canceled_RF originalInvoiceInfo.UpdatedId = CurrentUserId; var startDate = DateTime.Now; var endDate = DateTime.Now; //invoice status update if (cInvoiceInfo.Update(invoiceInfo) && cOriginalInvoiceInfo.Update(originalInvoiceInfo)) { // Program if (invoiceInfo.ProgramRegistrationId != null) { var cProgramRegiInfo = new CProgramRegistration(); var programRegiInfo = cProgramRegiInfo.Get(Convert.ToInt32(invoiceInfo.ProgramRegistrationId)); programRegiInfo.UpdatedId = CurrentUserId; programRegiInfo.UpdatedDate = DateTime.Now; programRegiInfo.ProgramRegistrationType = 12; // cancel cProgramRegiInfo.Update(programRegiInfo); startDate = programRegiInfo.StartDate.Value; endDate = programRegiInfo.EndDate.Value; } // Homestay else if (invoiceInfo.HomestayRegistrationId != null) { var cHomestayStudentRequest = new CHomestayStudentRequest(); var homestayStudentRequest = cHomestayStudentRequest.GetHomestayStudentRequest(Convert.ToInt32(invoiceInfo.HomestayRegistrationId)); homestayStudentRequest.UpdateUserId = CurrentUserId; homestayStudentRequest.UpdatedDate = DateTime.Now; homestayStudentRequest.HomestayStudentStatus = 1; // cancel cHomestayStudentRequest.Update(homestayStudentRequest); startDate = homestayStudentRequest.StartDate.Value; endDate = homestayStudentRequest.EndDate.Value; } // Dormitory else if (invoiceInfo.DormitoryRegistrationId != null) { var cDormitoryStudentRequest = new CDormitoryRegistrations(); var dormitoryStudentRequest = cDormitoryStudentRequest.GetDormitoryStudentRequest(Convert.ToInt32(invoiceInfo.ProgramRegistrationId)); dormitoryStudentRequest.DormitoryStudentStatus = 1; // cancel dormitoryStudentRequest.UpdatedId = CurrentUserId; dormitoryStudentRequest.UpdatedDate = DateTime.Now; cDormitoryStudentRequest.Update(dormitoryStudentRequest); startDate = dormitoryStudentRequest.StartDate.Value; endDate = dormitoryStudentRequest.EndDate.Value; } // Rev var cInterimInvoice = new CInvoice(); var interimInvoice = new Invoice(); CGlobal.Copy(invoiceInfo, interimInvoice); interimInvoice.OriginalInvoiceId = invoiceInfo.InvoiceId; interimInvoice.InvoiceType = (int)CConstValue.InvoiceType.Refund_RV; interimInvoice.Status = (int)CConstValue.InvoiceStatus.Invoiced; interimInvoice.CreatedId = CurrentUserId; interimInvoice.CreatedDate = DateTime.Now; if (cInterimInvoice.Add(interimInvoice) > 0) { var totalDays = Convert.ToDateTime(endDate) - Convert.ToDateTime(startDate); var interimDays = Convert.ToDateTime(endDate) - Convert.ToDateTime(refundInfo.RefundDate); var interimRate = Math.Round((interimDays.TotalDays / totalDays.TotalDays), 2) * 100; var cInvoiceItem = new CInvoiceItem(); var cOriginalInvoiceItemModels = cInvoiceItem.GetInvoiceItemModels(invoiceInfo.InvoiceId); List <InvoiceItem> newInvoiceItems = new List <InvoiceItem>(); foreach (CInvoiceItemModel ori in cOriginalInvoiceItemModels) { if (ori.InvoiceCoaItem.RevenueRecognition == 1) { var newInvoiceRevItem = new InvoiceItem(); CGlobal.Copy(ori.InvoiceItem, newInvoiceRevItem); newInvoiceRevItem.InvoiceId = interimInvoice.InvoiceId; newInvoiceRevItem.StandardPrice *= (decimal)interimRate; newInvoiceRevItem.StudentPrice *= (decimal)interimRate; newInvoiceRevItem.AgencyPrice *= (decimal)interimRate; newInvoiceRevItem.CreatedId = CurrentUserId; newInvoiceRevItem.CreatedDate = DateTime.Now; newInvoiceRevItem.Remark = "Refund Rev"; newInvoiceItems.Add(newInvoiceRevItem); } } if (newInvoiceItems.Count > 0) { // copy invoiceItems if (cInvoiceItem.Add(newInvoiceItems)) { RunClientScript("Close();"); } else { ShowMessage("failed to update inqury (Refund Ref Invoice Item)"); } } else { RunClientScript("Close();"); } } else { ShowMessage("failed to update inqury (Refund Ref Invoice)"); } } else { ShowMessage("failed to update inqury (Original Invoice and Refund Invoice)"); } } else { ShowMessage("failed to update inqury (CreditMemo Info)"); } } else { RunClientScript("Close();"); } } else { ShowMessage("failed to update inqury (Refund Info)"); } } // Agency else if (type == (int)CConstValue.Approval.Agency) { try { var cAgency = new CAgency(); var agency = cAgency.Get(id); idNumber = agency.AgencyNumber; agency.ApprovalDate = approvalHistory.ApprovalDate; agency.ApprovalId = approvalHistory.ApprovalUser; agency.ApprovalMemo = approvalHistory.ApprovalMemo; agency.ApprovalStatus = approvalHistory.ApprovalStep; cAgency.Update(agency); RunClientScript("Close();"); } catch (Exception ex) { ShowMessage(ex.Message); } } // BusinessTrip else if (type == (int)CConstValue.Approval.BusinessTrip) { try { var cBusinessTrip = new CBusinessTrip(); var businessTrip = cBusinessTrip.Get(id); businessTrip.ApprovalDate = approvalHistory.ApprovalDate; businessTrip.ApprovalId = approvalHistory.ApprovalUser; businessTrip.ApprovalMemo = approvalHistory.ApprovalMemo; businessTrip.ApprovalStatus = approvalHistory.ApprovalStep; cBusinessTrip.Update(businessTrip); RunClientScript("Close();"); } catch (Exception ex) { ShowMessage(ex.Message); } } // Purchase Order else if (type == (int)CConstValue.Approval.PurchaseOrder) { try { var cPurchaseOrder = new CPurchaseOrder(); var purchaseOrder = cPurchaseOrder.Get(id); purchaseOrder.ApprovalDate = approvalHistory.ApprovalDate; purchaseOrder.ApprovalId = approvalHistory.ApprovalUser; purchaseOrder.ApprovalMemo = approvalHistory.ApprovalMemo; purchaseOrder.ApprovalStatus = approvalHistory.ApprovalStep; cPurchaseOrder.Update(purchaseOrder); RunClientScript("Close();"); } catch (Exception ex) { ShowMessage(ex.Message); } } // Package Program else if (type == (int)CConstValue.Approval.Package) { try { var cP = new CPackageProgram(); var packageProgram = cP.GetPackageProgram(id); packageProgram.ApprovalDate = approvalHistory.ApprovalDate; packageProgram.ApprovalId = approvalHistory.ApprovalUser; packageProgram.ApprovalMemo = approvalHistory.ApprovalMemo; packageProgram.ApprovalStatus = approvalHistory.ApprovalStep; if (packageProgram.ApprovalStatus == (int)CConstValue.ApprovalStatus.Approved) { packageProgram.IsActive = true; } cP.Update(packageProgram); RunClientScript("Close();"); } catch (Exception ex) { ShowMessage(ex.Message); } } //Scholarship// else if (type == (int)CConstValue.Approval.Scholarship) { try { var cScholar = new CScholarship(); var scholar = cScholar.Get(Convert.ToInt32(id)); idNumber = scholar.ScholarshipMasterNo; scholar.ApprovalDate = approvalHistory.ApprovalDate; scholar.ApprovalId = approvalHistory.ApprovalUser; scholar.ApprovalMemo = approvalHistory.ApprovalMemo; scholar.ApprovalStatus = approvalHistory.ApprovalStep; if (scholar.ApprovalStatus == (int)CConstValue.ApprovalStatus.Approved) { scholar.IsActive = true; } cScholar.Update(scholar); RunClientScript("Close();"); } catch (Exception ex) { ShowMessage(ex.Message); } } //Promotion// else if (type == (int)CConstValue.Approval.Promotion) { try { var cPromo = new CPromotion(); var promo = cPromo.Get(Convert.ToInt32(id)); idNumber = promo.PromotionMasterNo; promo.ApprovalDate = approvalHistory.ApprovalDate; promo.ApprovalId = approvalHistory.ApprovalUser; promo.ApprovalMemo = approvalHistory.ApprovalMemo; promo.ApprovalStatus = approvalHistory.ApprovalStep; if (promo.ApprovalStatus == (int)CConstValue.ApprovalStatus.Approved) { promo.IsActive = true; } cPromo.Update(promo); RunClientScript("Close();"); } catch (Exception ex) { ShowMessage(ex.Message); } } // Expense Program else if (type == (int)CConstValue.Approval.Expense) { try { var cExpense = new CExpense(); var expense = cExpense.Get(id); expense.ApprovalDate = approvalHistory.ApprovalDate; expense.ApprovalId = approvalHistory.ApprovalUser; expense.ApprovalMemo = approvalHistory.ApprovalMemo; expense.ApprovalStatus = approvalHistory.ApprovalStep; cExpense.Update(expense); RunClientScript("Close();"); } catch (Exception ex) { ShowMessage(ex.Message); } } // Hire else if (type == (int)CConstValue.Approval.Hire) { try { var cHire = new CHire(); var hire = cHire.Get(id); hire.ApprovalDate = approvalHistory.ApprovalDate; hire.ApprovalId = approvalHistory.ApprovalUser; hire.ApprovalMemo = approvalHistory.ApprovalMemo; hire.ApprovalStatus = approvalHistory.ApprovalStep; cHire.Update(hire); RunClientScript("Close();"); } catch (Exception ex) { ShowMessage(ex.Message); } } // Vacation else if (type == (int)CConstValue.Approval.Vacation) { try { var cVacationDetail = new CVacation(); var vacation = cVacationDetail.Get(id); vacation.ApprovalDate = approvalHistory.ApprovalDate; vacation.ApprovalId = approvalHistory.ApprovalUser; vacation.ApprovalMemo = approvalHistory.ApprovalMemo; vacation.ApprovalStatus = approvalHistory.ApprovalStep; cVacationDetail.Update(vacation); RunClientScript("Close();"); } catch (Exception ex) { ShowMessage(ex.Message); } } // CreditMemoPayout else if (type == (int)CConstValue.Approval.CreditMemoPayout) { try { var cCreditMemo = new CCreditMemoPayout(); var creditMemo = cCreditMemo.Get(id); creditMemo.ApprovalDate = approvalHistory.ApprovalDate; creditMemo.ApprovalId = approvalHistory.ApprovalUser; creditMemo.ApprovalMemo = approvalHistory.ApprovalMemo; creditMemo.ApprovalStatus = approvalHistory.ApprovalStep; cCreditMemo.Update(creditMemo); RunClientScript("Close();"); } catch (Exception ex) { ShowMessage(ex.Message); } } if (approvalHistory.ApprovalStep != (int)CConstValue.ApprovalStatus.Approved) //if has a next approver, request approve { var approvalInfo = new CApproval(); var supervisor = approvalInfo.GetSupuervisor(type, CurrentUserId); if (supervisor > 0) { var cNextApprove = new CApprovalHistory(); var nextApprove = cNextApprove.Get(type, id, supervisor); nextApprove.IsApprovalRequest = true; cNextApprove.Update(nextApprove); } new CMail().SendMail((CConstValue.Approval)type, CConstValue.MailStatus.ToApproveUserAndRequestUser, id, idNumber, CurrentUserId); } // approved else { new CMail().SendMail((CConstValue.Approval)type, CConstValue.MailStatus.ToRequestUser, id, idNumber, CurrentUserId); } } } }
protected void MainToolBar_ButtonClick(object sender, RadToolBarEventArgs e) { if (e.Item.Text == "Revise" && !string.IsNullOrEmpty(hfId.Value)) { if (IsValid) { try { var type = Convert.ToInt32(hfType.Value); var id = Convert.ToInt32(hfId.Value); var cApprovalHistory = new CApprovalHistory(); var approvalHistory = cApprovalHistory.Get(type, id, CurrentUserId); approvalHistory.ApprovalDate = DateTime.Now; approvalHistory.ApprovalMemo = tbRemark.Text; // Revice approvalHistory.ApprovalStep = (int)CConstValue.ApprovalStatus.Revise; if (type == (int)CConstValue.Approval.Refund) { var cC = new CRefund(); var c = cC.Get(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } else if (type == (int)CConstValue.Approval.Agency) { var cC = new CAgency(); var c = cC.Get(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } else if (type == (int)CConstValue.Approval.CorporateCreditCard) { var cC = new CCorporateCreditCard(); var c = cC.Get(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } else if (type == (int)CConstValue.Approval.BusinessTrip) { var cC = new CBusinessTrip(); var c = cC.Get(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } else if (type == (int)CConstValue.Approval.Package) { var cC = new CPackageProgram(); var c = cC.GetPackageProgram(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } else if (type == (int)CConstValue.Approval.Expense) { var cC = new CExpense(); var c = cC.Get(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } else if (type == (int)CConstValue.Approval.PurchaseOrder) { var cC = new CPurchaseOrder(); var c = cC.Get(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } else if (type == (int)CConstValue.Approval.Hire) { var cC = new CHire(); var c = cC.Get(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } else if (type == (int)CConstValue.Approval.Vacation) { var cC = new CVacation(); var c = cC.Get(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } else if (type == (int)CConstValue.Approval.Scholarship) { var cC = new CScholarship(); var c = cC.Get(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } else if (type == (int)CConstValue.Approval.Promotion) { var cC = new CPromotion(); var c = cC.Get(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } else if (type == (int)CConstValue.Approval.CreditMemoPayout) { var cC = new CCreditMemoPayout(); var c = cC.Get(id); c.ApprovalDate = approvalHistory.ApprovalDate; c.ApprovalId = approvalHistory.ApprovalUser; c.ApprovalMemo = approvalHistory.ApprovalMemo; c.ApprovalStatus = approvalHistory.ApprovalStep; cC.Update(c); } // update approvalHistory cApprovalHistory.Update(approvalHistory); new CMail().SendMail((CConstValue.Approval)type, CConstValue.MailStatus.ToRequestUser, id, string.Empty, CurrentUserId); RunClientScript("Close();"); } catch (Exception ex) { ShowMessage(ex.Message); } } } }