protected void Page_Load(object sender, EventArgs e)
{
// CreditMemoId in new or CreditMemoPayoutId in modify
Id = Convert.ToInt32(Request["id"]);
if (!IsPostBack)
{
FileDownloadList1.InitFileDownloadList((int)CConstValue.Upload.CreditMemo);
CreditMemoPayout1.SetCreditVisible(false);
CreditMemoPayout1.SetReadonly(false);
// new
if (Request["type"] == "0")
{
//
}
// modify
else
{
var cCreditMemoPayout = new CCreditMemoPayout().Get(Id);
RadNumericTextBoxAmount.Value = (double)cCreditMemoPayout.Amount;
RadNumericTextBoxAmount.ReadOnly = true;
CreditMemoPayout1.SetData(cCreditMemoPayout);
// get Filedownload List
FileDownloadList1.GetFileDownload(Id);
}
}
}
private bool SetReqeust(int creditMemoPayoutId)
{
var cApprovalHistory = new CApprovalHistory();
cApprovalHistory.DelApprovalHistory((int)CConstValue.Approval.CreditMemoPayout, creditMemoPayoutId);
// approve request
var approval = new CApproval().ApproveRequstCreate((int)CConstValue.Approval.CreditMemoPayout, CurrentUserId, creditMemoPayoutId);
if (approval > 0)
{
var cP = new CCreditMemoPayout();
var c = cP.Get(creditMemoPayoutId);
c.ApprovalStatus = approval;
c.ApprovalId = CurrentUserId;
c.ApprovalDate = DateTime.Now;
//c.ApprovalMemo = "";
cP.Update(c);
new CMail().SendMail(CConstValue.Approval.CreditMemoPayout, CConstValue.MailStatus.ToApproveUser, c.CreditMemoPayoutId, string.Empty, CurrentUserId);
return(true);
}
return(false);
}
protected void CreditMemoPayout1_OnPreRender(object sender, EventArgs e)
{
if (RadGridRefund.SelectedValue != null)
{
var cCreditMemoPayout = new CCreditMemoPayout();
var creditMemoPayout = cCreditMemoPayout.Get(Convert.ToInt32(RadGridRefund.SelectedValues["CreditMemoPayoutId"]));
if (creditMemoPayout != null)
{
CreditMemoPayout1.SetData(creditMemoPayout);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//if (Request["__EVENTTARGET"] == "btnNew" &&
//Request["__EVENTARGUMENT"] == "MyArgument")
//{
// //do something
//}
// Refund_R
InvoiceItemGrid1.SetTypeOfInvoiceCoaItem(2);
RefundId = Convert.ToInt32(Request["id"]);
// find user control
_sqlDataSourceInvoiceItems = InvoiceItemGrid1.GetSqlDataSourceInvoiceItems();
_radGridInvoiceItems = InvoiceItemGrid1.GetRadGridInvoiceItems();
// connect event of invoice Items.
_radGridInvoiceItems.PreRender += _radGridInvoiceItems_PreRender;
//_radGridInvoiceItems.MasterTableView.CommandItemSettings.ShowSaveChangesButton = false;
FileDownloadList1.InitFileDownloadList((int)CConstValue.Upload.Refund);
CreditMemoPayout1.SetReadonly(false);
if (!IsPostBack)
{
//// new
//if (Request["type"] == "0")
//{
// // nothing
//}
//else
//{
var cRefund = new CRefund();
var refund = cRefund.Get(RefundId);
FileDownloadList1.GetFileDownload(refund.RefundId);
InvoiceItemGrid1.InvoiceId = refund.InvoiceId;
InvoiceItemGrid1.SetEditMode(true);
CreditMemoPayout1.SetCreditVisible(true);
var cCreditMemoPayout = new CCreditMemoPayout();
var creditMemoPayout = cCreditMemoPayout.Get(refund.CreditMemoPayoutId);
CreditMemoPayout1.SetData(creditMemoPayout);
//}
}
}
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 RadToolBar_ButtonClick(object sender, RadToolBarEventArgs e)
{
switch (e.Item.Text)
{
case "TempSave":
case "Request":
if (IsValid)
{
var cC = new CCreditMemoPayout();
var c = new Erp2016.Lib.CreditMemoPayout();
// new
if (Request["type"] == "0")
{
c = new Erp2016.Lib.CreditMemoPayout();
c.CreatedId = CurrentUserId;
c.CreatedDate = DateTime.Now;
c.CreditMemoId = Id;
}
// modify
else
{
c = cC.Get(Id);
}
c = CreditMemoPayout1.GetData(c);
c.Amount = (decimal)RadNumericTextBoxAmount.Value;
c.IsActive = true;
c.SiteLocationId = CurrentSiteLocationId;
int creditMemoPayoutId;
// new
if (Request["type"] == "0")
{
decimal availableAmount = new CCreditMemo().GetAvailableCreditAmount(Id);
if (availableAmount >= c.Amount)
{
decimal originalAmount = new CCreditMemo().GetOriginalCreditAmount(Id);
if ((originalAmount - availableAmount) + c.Amount < 0)
{
ShowMessage("result of available amount can't be negative amount");
}
else
{
creditMemoPayoutId = cC.Add(c);
// save file
FileDownloadList1.SaveFile(Id);
if (e.Item.Text == "TempSave")
{
RunClientScript("Close();");
}
else
{
if (SetReqeust(creditMemoPayoutId))
{
RunClientScript("Close();");
}
else
{
ShowMessage("error requesting");
}
}
}
}
else
{
ShowMessage("paid amount is bigger than available credit amount");
}
}
// modify
else
{
c.UpdatedId = CurrentUserId;
c.UpdatedDate = DateTime.Now;
cC.Update(c);
creditMemoPayoutId = c.CreditMemoPayoutId;
// save file
FileDownloadList1.SaveFile(Id);
if (SetReqeust(creditMemoPayoutId))
{
RunClientScript("Close();");
}
else
{
ShowMessage("error requesting");
}
}
}
break;
case "Close":
RunClientScript("Close();");
break;
}
}
protected void ToolbarButtonClick(object sender, RadToolBarEventArgs e)
{
switch (e.Item.Text)
{
case "Request":
if (IsValid)
{
var cInvoice = new CInvoice();
var original = cInvoice.Get(InvoiceId);
if (original != null)
{
original.Status = (int)CConstValue.InvoiceStatus.Invoiced_Hold;
original.UpdatedId = CurrentUserId;
if (cInvoice.Update(original))
{
var cRefundInvoice = new CInvoice();
var refundInvoice = new Erp2016.Lib.Invoice();
CGlobal.Copy(original, refundInvoice);
refundInvoice.OriginalInvoiceId = original.InvoiceId;
switch (original.InvoiceType)
{
case (int)CConstValue.InvoiceType.General:
case (int)CConstValue.InvoiceType.Simple:
case (int)CConstValue.InvoiceType.Manual:
refundInvoice.InvoiceType = (int)CConstValue.InvoiceType.Refund_RF;
break;
case (int)CConstValue.InvoiceType.Homestay:
refundInvoice.InvoiceType = (int)CConstValue.InvoiceType.Refund_HR;
break;
case (int)CConstValue.InvoiceType.Dormitory:
refundInvoice.InvoiceType = (int)CConstValue.InvoiceType.Refund_DR;
break;
}
refundInvoice.Status = (int)CConstValue.InvoiceStatus.Pending;
refundInvoice.CreatedId = CurrentUserId;
refundInvoice.CreatedDate = DateTime.Now;
var invoiceId = cRefundInvoice.Add(refundInvoice);
if (invoiceId > 0)
{
var refundInvoiceItems = new CInvoiceItem();
refundInvoiceItems.RefundItemsUpdate(original.InvoiceId, invoiceId, Convert.ToDecimal(RefundInfo1.GetRefundRate().Value), CurrentUserId);
var cCreditMemo = new CCreditMemo();
var creditMemo = new CreditMemo();
creditMemo.CreditMemoType = (int)CConstValue.CreditMemoType.Refund;
creditMemo.InvoiceId = invoiceId; //Refund Invoice Id
creditMemo.OriginalCreditMemoAmount = 0;
creditMemo.CreatedId = CurrentUserId;
creditMemo.CreatedDate = DateTime.Now;
creditMemo.IsActive = false;
var creditMemoId = cCreditMemo.Add(creditMemo);
if (creditMemoId > 0)
{
var cCreditMemoPayout = new CCreditMemoPayout();
var creditMemoPayout = new CreditMemoPayout();
creditMemoPayout.CreditMemoId = creditMemoId;
creditMemoPayout.Amount = 0;
creditMemoPayout.IsActive = false;
creditMemoPayout.CreatedId = CurrentUserId;
creditMemoPayout.CreatedDate = DateTime.Now;
var creditMemoPayoutId = cCreditMemoPayout.Add(creditMemoPayout);
if (creditMemoPayoutId > 0)
{
var cRefund = new CRefund();
var refund = new Refund();
refund.CreditMemoPayoutId = creditMemoPayoutId;
refund.InvoiceId = invoiceId;
refund.RefundDate = Convert.ToDateTime(RefundInfo1.RadActualDate().SelectedDate);
refund.RefundRate = Convert.ToDouble(RefundInfo1.GetRefundRate().Value);
refund.RefundReason = RefundInfo1.GetReason().Text;
refund.IsActive = false;
refund.CreatedId = CurrentUserId;
refund.CreatedDate = DateTime.Now;
if (cRefund.Add(refund) > 0)
{
// save uploading file
FileDownloadList1.SaveFile(refund.RefundId);
RunClientScript("Close();");
}
ShowMessage("failed to update inqury (Add Refund Info)");
}
else
{
ShowMessage("failed to update inqury (Add CreditMemoPayout)");
}
}
else
{
ShowMessage("failed to update inqury (Add CreditMemo)");
}
}
else
{
ShowMessage("failed to update inqury (Add Refund Invoice)");
}
}
else
{
ShowMessage("failed to update inqury (Update Original Invoice)");
}
}
else
{
ShowMessage("failed to update inqury (Original Invoice is null)");
}
}
break;
case "Close":
RunClientScript("Close();");
break;
}
}
protected void RadToolBar_ButtonClick(object sender, RadToolBarEventArgs e)
{
switch (e.Item.Text)
{
case "TempSave":
case "Request":
if (IsValid)
{
var cRefund1 = new CRefund();
var refund1 = cRefund1.Get(RefundId);
FileDownloadList1.SaveFile(refund1.RefundId);
var cCreditMemoPayout = new CCreditMemoPayout();
var creditMemoPayout = cCreditMemoPayout.Get(refund1.CreditMemoPayoutId);
creditMemoPayout = CreditMemoPayout1.GetData(creditMemoPayout);
creditMemoPayout.UpdatedId = CurrentUserId;
if (cCreditMemoPayout.Update(creditMemoPayout))
{
if (cRefund1.Update(refund1))
{
if (e.Item.Text == "TempSave")
{
RunClientScript("Close();");
}
else
{
var cApprovalHistory = new CApprovalHistory();
cApprovalHistory.DelApprovalHistory((int)CConstValue.Approval.Refund, RefundId);
// approve request
var approval = new CApproval().ApproveRequstCreate((int)CConstValue.Approval.Refund, CurrentUserId, RefundId);
if (approval > 0)
{
var cRefund = new CRefund();
var refund = cRefund.Get(RefundId);
refund.ApprovalStatus = approval;
refund.ApprovalId = CurrentUserId;
refund.ApprovalDate = DateTime.Now;
//packageProgram.ApprovalMemo = "";
cRefund.Update(refund);
new CMail().SendMail(CConstValue.Approval.Refund, CConstValue.MailStatus.ToApproveUser, refund.RefundId, string.Empty, CurrentUserId);
RunClientScript("Close();");
}
else
{
ShowMessage("error requesting");
}
}
}
else
{
ShowMessage("Error updating refund");
}
}
else
{
ShowMessage("Error updating creditMemoPayout");
}
}
else
{
ShowMessage("Error can't find refund");
}
break;
case "Close":
RunClientScript("Close();");
break;
}
}
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 RadToolBar_ButtonClick(object sender, RadToolBarEventArgs e)
{
switch (e.Item.Text)
{
case "Save":
if (IsValid)
{
var cC = new CCreditMemoPayoutHistory();
var c = new Erp2016.Lib.CreditMemoPayoutHistory();
//// new
//if (Request["type"] == "0")
//{
//c = new Erp2016.Lib.CreditMemoPayoutHistory();
c.CreatedId = CurrentUserId;
c.CreatedDate = DateTime.Now;
c.CreditMemoPayoutId = Id;
//}
//// modify
//else
//{
// c = cC.Get(Id);
//}
c.PayoutAmount = (decimal)RadNumericTextBoxAmount.Value;
c.PayoutDate = (DateTime)RadDatePickerDate.SelectedDate;
c.CheckNo = RadTextBoxCheckNo.Text;
c.WireTransferNo = RadTextBoxWireTransferNo.Text;
c.Remark = RadTextBoxRemark.Text;
//// new
//if (Request["type"] == "0")
//{
decimal availableAmount = new CCreditMemoPayout().GetAvailablePayoutAmount(Id);
if (availableAmount >= c.PayoutAmount)
{
cC.Add(c);
RunClientScript("Close();");
}
else
{
ShowMessage("paid amount is bigger than available payout amount");
}
//}
//// modify
//else
//{
// c.UpdatedId = CurrentUserId;
// c.UpdatedDate = DateTime.Now;
// cC.Update(c);
// creditMemoPayoutId = c.CreditMemoPayoutId;
//}
}
break;
case "Close":
RunClientScript("Close();");
break;
}
}
public static void SetFilterCheckListItems(GridFilterCheckListItemsRequestedEventArgs e)
{
object dataSource = null;
string dataField = (e.Column as IGridDataColumn).GetActiveDataField();
switch (dataField)
{
// Common
case "SiteName":
dataSource = new CSite().GetSiteNameList();
break;
case "SiteLocationName":
dataSource = new CSiteLocation().GetSiteLocationNameList();
break;
case "CountryName":
dataSource = new CCountry().GetCountryNameList();
break;
case "AgencyName":
dataSource = new CAgency().GetAgencyNameList();
break;
case "ProgramName":
dataSource = new CProgram().GetProgramNameList();
break;
case "InvoiceCoaItemId":
dataSource = new CInvoiceCoaItem().GetInvoiceCoaItemIdNameList();
break;
case "InvoiceName":
dataSource = new CProgram().GetInvoiceNameList();
break;
case "StudentName":
dataSource = new CStudent().GetStudentNameList();
break;
case "UserName":
dataSource = new CUser().GetUserNameList();
break;
case "Status":
dataSource = new CApproval().GetStatusNameList();
break;
case "ApprovalUserName":
dataSource = new CUser().GetApprovalUserNameList();
break;
case "InstructorName":
dataSource = new CUser().GetInstructorNameList();
break;
case "ProgramStatusName":
dataSource = new CProgramRegistration().GetProgramStatusList();
break;
// Dashboard
case "Type":
dataSource = new CApproval().GetApprovalTypeNameList();
break;
// Invoice
case "InvoiceType":
dataSource = new CInvoice().GetInvoiceTypeList();
break;
case "InvoiceStatus":
dataSource = new CInvoice().GetInvoiceStatusList();
break;
// Deposit
case "DepositStatus":
dataSource = new CDeposit().GetDepositStatusNameList();
break;
case "DepositBank":
dataSource = new CDeposit().GetDepositBankNameList();
break;
case "PaidMethod":
dataSource = new CDeposit().GetPaidMethodNameList();
break;
case "ExtraTypeName":
dataSource = new CDeposit().GetExtraTypeNameList();
break;
// CreditMemo
case "CreditMemoType":
dataSource = new CCreditMemo().GetCreditMemoTypeNameList();
break;
case "PayoutMethodName":
dataSource = new CCreditMemoPayout().GetPayoutMethodNameList();
break;
// Academic
case "FacultyName":
dataSource = new CFaculty().GetFacultyNameList();
break;
case "ProgramGroupName":
dataSource = new CProgramGroup().GetProgramGroupNameList();
break;
// Vacation
case "VacationType":
dataSource = new CVacation().GetVacationTypeNameList();
break;
// User
case "CreatedUserName":
dataSource = new CUser().GetCreatedUserNameList();
break;
case "UpdatedUserName":
dataSource = new CUser().GetUpdatedUserNameList();
break;
case "PositionName":
dataSource = new CUser().GetPositionNameList();
break;
case "Email":
dataSource = new CUser().GetEmailNameList();
break;
case "LoginId":
dataSource = new CUser().GetLoginIdNameList();
break;
// PurchaseOrder
case "PurchaseOrderTypeName":
dataSource = new CPurchaseOrder().GetPurchaseOrderTypeNameList();
break;
case "PriorityTypeName":
dataSource = new CPurchaseOrder().GetPriorityTypeNameList();
break;
case "ReviewTypeName":
dataSource = new CPurchaseOrder().GetReviewTypeNameList();
break;
////Invoice#
//case "SchoolName":
// dataSource = new CSite().GetSiteNameList();
// break;
// Inventory
case "AssignedUserName":
dataSource = new CUser().GetAssignedUserNameList();
break;
case "InventoryCategoryName":
dataSource = new CInventory().GetInventoryCategoryNameList();
break;
case "InventoryCategoryItemName":
dataSource = new CInventory().GetInventoryCategoryItemNameList();
break;
case "ConditionName":
dataSource = new CInventory().GetConditionNameList();
break;
case "InUseName":
dataSource = new CInventory().GetInUseNameList();
break;
}
if (dataSource != null)
{
SetFilter(e, dataField, dataSource);
}
}
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);
}
}
}
}
public void GetCreditMemoPayoutInfo()
{
// toolbar
foreach (RadToolBarItem toolbarItem in RadToolBarCreditMemo.Items)
{
if (toolbarItem.Text == "Disbursement")
{
if (RadGridCreditMemo.SelectedValue != null)
{
var creditMemo = new CCreditMemo().GetVwCreditMemo(Convert.ToInt32(RadGridCreditMemo.SelectedValue));
if (creditMemo != null)
{
var cCreditMemoPayout = new CCreditMemoPayout();
var creditMemoPayoutList = cCreditMemoPayout.GetCreditMemoPayoutList(creditMemo.CreditMemoId);
bool hasNullOfDisbursement = false;
foreach (var c in creditMemoPayoutList)
{
if (c.Disbursement == false && c.ApprovalStatus == (int)CConstValue.ApprovalStatus.Approved)
{
toolbarItem.Enabled = true;
hasNullOfDisbursement = true;
break;
}
}
if (hasNullOfDisbursement == false)
{
toolbarItem.Enabled = false;
}
}
else
{
toolbarItem.Enabled = false;
}
}
else
{
toolbarItem.Enabled = false;
}
}
else
{
if (toolbarItem.Text == "View Invoice" || toolbarItem.Text == "View Payment" || toolbarItem.Text == "View Deposit" ||
toolbarItem.Text == "Student Page" || toolbarItem.Text == "Invoice Page" || toolbarItem.Text == "Payment Page" ||
toolbarItem.Text == "Deposit Page" || toolbarItem.Text == "Refund Page" || toolbarItem.Text == "Excel")
{
continue;
}
toolbarItem.Enabled = false;
}
}
// toolbar
foreach (RadToolBarItem toolbarItem in RadToolBarCreditMemoPayout.Items)
{
if (toolbarItem.Text == "New Payout")
{
if (RadGridCreditMemo.SelectedValue != null)
{
toolbarItem.Enabled = true;
}
else
{
toolbarItem.Enabled = false;
}
}
}
if (RadGridCreditMemoPayout.SelectedValue != null)
{
var cCreditMemoPayout = new CCreditMemoPayout();
var creditMemoPayout = cCreditMemoPayout.Get(Convert.ToInt32(RadGridCreditMemoPayout.SelectedValue));
CreditMemoPayout1.SetData(creditMemoPayout);
// toolbar
foreach (RadToolBarItem toolbarItem in RadToolBarCreditMemoPayout.Items)
{
// request active check
if (toolbarItem.Text == "Request")
{
if ((creditMemoPayout.ApprovalStatus == null || creditMemoPayout.ApprovalStatus == (int)CConstValue.ApprovalStatus.Revise) && creditMemoPayout.CreatedId == CurrentUserId)
{
toolbarItem.Enabled = true;
}
else
{
toolbarItem.Enabled = false;
}
}
else if (toolbarItem.Text == "Cancel")
{
if ((creditMemoPayout.ApprovalStatus == null ||
creditMemoPayout.ApprovalStatus == (int)CConstValue.ApprovalStatus.Revise ||
creditMemoPayout.ApprovalStatus == (int)CConstValue.ApprovalStatus.Requested) && creditMemoPayout.CreatedId == CurrentUserId)
{
toolbarItem.Enabled = true;
}
else
{
toolbarItem.Enabled = false;
}
}
else if (toolbarItem.Text == "Approve" || toolbarItem.Text == "Reject" || toolbarItem.Text == "Revise")
{
// approve active check
var refundApproveInfo = new CGlobal();
var supervisor = refundApproveInfo.CheckApprovalEnable((int)CConstValue.Approval.CreditMemoPayout, Convert.ToInt32(RadGridCreditMemoPayout.SelectedValue));
// supervisor or loy employees
if ((CurrentUserId == supervisor) &&
creditMemoPayout.ApprovalStatus != (int)CConstValue.ApprovalStatus.Approved &&
creditMemoPayout.ApprovalStatus != (int)CConstValue.ApprovalStatus.Rejected &&
creditMemoPayout.ApprovalStatus != (int)CConstValue.ApprovalStatus.Canceled &&
creditMemoPayout.ApprovalStatus != null &&
CurrentUserId != creditMemoPayout.ApprovalId)
{
toolbarItem.Enabled = true;
}
else
{
toolbarItem.Enabled = false;
}
}
}
foreach (RadToolBarItem toolbarItem in RadToolBarCreditMemoPayoutHistory.Items)
{
if (toolbarItem.Text == "Add Payout")
{
if (creditMemoPayout.ApprovalStatus == (int)CConstValue.ApprovalStatus.Approved &&
creditMemoPayout.Disbursement &&
(CurrentGroupId == (int)CConstValue.UserGroupForCreditPayoutHistory.Accounting ||
CurrentGroupId == (int)CConstValue.UserGroupForCreditPayoutHistory.IT))
{
toolbarItem.Enabled = true;
}
else
{
toolbarItem.Enabled = false;
}
}
else if (toolbarItem.Text == "Payout Reverse")
{
if (CurrentGroupId == (int)CConstValue.UserGroupForCreditPayoutHistory.Accounting ||
CurrentGroupId == (int)CConstValue.UserGroupForCreditPayoutHistory.IT)
{
toolbarItem.Enabled = true;
}
else
{
toolbarItem.Enabled = false;
}
}
}
// get DownloadList
FileDownloadList1.GetFileDownload(Convert.ToInt32(RadGridCreditMemoPayout.SelectedValue));
}
else
{
foreach (RadToolBarItem toolbarItem in RadToolBarCreditMemoPayoutHistory.Items)
{
toolbarItem.Enabled = false;
}
// get DownloadList
FileDownloadList1.GetFileDownload(0);
}
RefreshApprovalList();
}
protected void RadToolBarCreditMemo_OnButtonClick(object sender, RadToolBarEventArgs e)
{
if (RadGridCreditMemo.SelectedValue != null)
{
switch (e.Item.Text)
{
case "Disbursement":
var cCreditMemoPayout = new CCreditMemoPayout();
var creditMemoPayoutList = cCreditMemoPayout.GetCreditMemoPayoutList(Convert.ToInt32(RadGridCreditMemo.SelectedValue));
var currentDate = DateTime.Now;
foreach (var creditMemoPayout in creditMemoPayoutList)
{
if (creditMemoPayout.Disbursement == false && creditMemoPayout.ApprovalStatus == (int)CConstValue.ApprovalStatus.Approved)
{
creditMemoPayout.Disbursement = true;
creditMemoPayout.DisbursementDate = currentDate;
creditMemoPayout.UpdatedId = CurrentUserId;
creditMemoPayout.UpdatedDate = currentDate;
cCreditMemoPayout.Update(creditMemoPayout);
}
}
RadGridCreditMemo.Rebind();
RadGridCreditMemoPayout.Rebind();
break;
case "View Invoice":
RunClientScript("ShowInvoiceWindow(" + RadGridCreditMemo.SelectedValues["InvoiceId"] + ");");
break;
case "View Payment":
RunClientScript("ShowPaymentHistoryWindow(" + RadGridCreditMemo.SelectedValues["InvoiceId"] + ");");
break;
case "View Deposit":
var cPayment = new CPayment();
var payment = cPayment.Get(Convert.ToInt32(RadGridCreditMemo.SelectedValues["PaymentId"]));
if (payment != null)
{
var depositPayment = new CDepositPayment().GetByPaymentId(payment.PaymentId);
if (depositPayment != null)
{
RunClientScript("ShowDepositPaymentWindow(" + depositPayment.DepositId + ");");
}
}
break;
case "Student Page":
Response.Redirect("~/Student?id=" + RadGridCreditMemo.SelectedValues["StudentId"]);
break;
case "Invoice Page":
Response.Redirect("~/Invoice?id=" + RadGridCreditMemo.SelectedValues["StudentId"]);
break;
case "Payment Page":
Response.Redirect("~/Payment?id=" + RadGridCreditMemo.SelectedValues["StudentId"]);
break;
case "Deposit Page":
Response.Redirect("~/Deposit?id=" + RadGridCreditMemo.SelectedValues["StudentId"]);
break;
case "Refund Page":
Response.Redirect("~/Refund?id=" + RadGridCreditMemo.SelectedValues["StudentId"]);
break;
}
}
}
