private CPayment GetFormData(CPayment oPayment)
{
if (txtOId.Text != "")
{
oPayment.Payment_OID = txtOId.Text.Trim();
}
oPayment.Payment_Branch = currentBranch.CompBrn_Code;
oPayment.Payment_Date = dtpPaymentDate.Value.Date;
oPayment.Payment_PartyOID = ddlPartyName.SelectedValue.ToString();
oPayment.Payment_Amount = float.Parse(txtPaymentAmount.Text.Trim());
oPayment.Payment_CurrencyOID = ddlCurrency.SelectedValue.ToString();
oPayment.Payment_CurrencyRate = float.Parse(txtCurrencyRate.Text.Trim());
oPayment.Payment_BDT = float.Parse(txtPaymentInBDT.Text.Trim());
oPayment.Payment_Media = txtPaymentMedia.Text.Trim();
if (rbYes.Checked == true)
{
oPayment.Payment_RecieptConfirmation = 1;
}
else if (rbYes.Checked == false)
{
oPayment.Payment_RecieptConfirmation = 0;
}
oPayment.Payment_ReceivedDate = dtpPaymentReceipetDate.Value.Date;
oPayment.Creator = currentUser.User_OID;
oPayment.CreationDate = DateTime.Now.Date;
oPayment.UpdateBy = currentUser.User_OID;
oPayment.UpdateDate = DateTime.Now.Date;
return(oPayment);
}
private CPayment GetFormData()
{
CPayment oPayment = new CPayment();
oPayment.Payment_OID = txtOId.Text.Trim();
return(oPayment);
}
protected void RadGridPayment_OnSelectedIndexChanged(object sender, EventArgs e)
{
ViewState["InvoiceId"] = RadGridPayment.SelectedValue;
_radGridPaymentHistory.Rebind();
_radGridInvoiceItems.Rebind();
var btnNewPayment = RadToolBarPayment.FindItemByText("New Payment");
var payment = new CPayment().GetvwPayment(Convert.ToInt32(RadGridPayment.SelectedValue));
if (payment != null)
{
if (payment.Balance == 0 || payment.Status != (int)CConstValue.InvoiceStatus.Invoiced)
{
btnNewPayment.Enabled = false;
}
else
{
btnNewPayment.Enabled = true;
}
}
else
{
btnNewPayment.Enabled = false;
}
var btnDetailStudentReciept = RadToolBarPayment.FindItemByText("Student Detail Reciept");
var btnDetailAgencyReciept = RadToolBarPayment.FindItemByText("Agency Detail Reciept");
btnDetailStudentReciept.Enabled = false;
btnDetailAgencyReciept.Enabled = false;
}
protected void RadButtonExcel_OnClick(object sender, EventArgs e)
{
var filterExpression = ConvertFilterExpressionToSqlExpression(RadGridPayment.MasterTableView.Columns);
var tempDt = new CPayment().GetVwPaymentExcel(filterExpression);
ExportExcel(tempDt, "Payment Detail");
}
protected void Button1_Click(object sender, EventArgs e)
{
lblStatus.Text = txtAmount.Text + " " + txtTTID.Text;
lblStatus.ForeColor = System.Drawing.Color.Green;
lblStatus.Font.Size = 12;
int paymentAdded = CPayment.AddPayment(
Convert.ToInt32(txtTTID.Text),
Convert.ToDecimal(txtAmount.Text));
//Check whether transaction was successful
if (paymentAdded != 0)
{
lblStatus.Text = "Payment transaction successful.";
lblStatus.ForeColor = System.Drawing.Color.Green;
lblStatus.Font.Size = 12;
pnlAddPayment.Visible = false;
}
else
{
lblStatus.Text = "Payment transaction not successful." + paymentAdded;
lblStatus.ForeColor = System.Drawing.Color.Red;
lblStatus.Font.Size = 12;
}
}
private CPayment GetResultSetToParty(DataRow dr)
{
CPayment oPayment = new CPayment();
oPayment.Payment_OID = dr[0].ToString();
oPayment.Payment_Branch = dr[1].ToString();
oPayment.Payment_Date = DateTime.Parse(dr[2].ToString());
oPayment.Payment_PartyOID = dr[3].ToString();
oPayment.Payment_PartyName = dr[15].ToString();
oPayment.Payment_Amount = float.Parse(dr[4].ToString());
oPayment.Payment_CurrencyOID = dr[5].ToString();
oPayment.Payment_CurrencyName = dr[16].ToString();
oPayment.Payment_CurrencyRate = float.Parse(dr[6].ToString());
oPayment.Payment_BDT = float.Parse(dr[7].ToString());
oPayment.Payment_Media = dr[8].ToString();
if ((bool)dr[9] == true)
{
oPayment.Payment_RecieptConfirmation = 1;
}
else
{
oPayment.Payment_RecieptConfirmation = 0;
}
oPayment.Payment_ReceivedDate = DateTime.Parse(dr[10].ToString());
oPayment.Payment_Creator = dr[11].ToString();
oPayment.Payment_CreationDate = DateTime.Parse(dr[12].ToString());
oPayment.Payment_UpdateBy = dr[13].ToString();
oPayment.Payment_UpdateDate = DateTime.Parse(dr[14].ToString());
return(oPayment);
}
private void lvPaymentList_DoubleClick(object sender, EventArgs e)
{
if (lvPaymentList.SelectedItems.Count > 0)
{
CPayment oPayment = lvPaymentList.FocusedItem.Tag as CPayment;
txtOId.Text = oPayment.Payment_OID;
dtpPaymentDate.Value = oPayment.Payment_Date;
ddlPartyName.SelectedText = oPayment.Payment_PartyName;
ddlPartyName.SelectedValue = oPayment.Payment_PartyOID;
txtPaymentAmount.Text = oPayment.Payment_Amount.ToString();
ddlCurrency.SelectedText = oPayment.Payment_CurrencyName;
ddlCurrency.SelectedValue = oPayment.Payment_CurrencyOID;
txtCurrencyRate.Text = oPayment.Payment_CurrencyRate.ToString();
txtPaymentInBDT.Text = oPayment.Payment_BDT.ToString();
txtPaymentMedia.Text = oPayment.Payment_Media;
dtpPaymentReceipetDate.Value = oPayment.Payment_ReceivedDate;
if (oPayment.Payment_RecieptConfirmation == 1)
{
rbYes.Select();
}
else if (oPayment.Payment_RecieptConfirmation != 1)
{
rbNo.Select();
}
}
}
public CResult Create(CPayment oPayment)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Parameters.Clear();
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_Payment_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Payment_Branch", oPayment.Payment_Branch);
cmd.Parameters.AddWithValue("@Payment_Date", oPayment.Payment_Date);
cmd.Parameters.AddWithValue("@Payment_PartyOID", oPayment.Payment_PartyOID);
cmd.Parameters.AddWithValue("@Payment_Amount", oPayment.Payment_Amount);
cmd.Parameters.AddWithValue("@Payment_CurrencyOID", oPayment.Payment_CurrencyOID);
cmd.Parameters.AddWithValue("@Payment_CurrencyRate", oPayment.Payment_CurrencyRate);
cmd.Parameters.AddWithValue("@Payment_BDT", oPayment.Payment_BDT);
cmd.Parameters.AddWithValue("@Payment_Media", oPayment.Payment_Media);
cmd.Parameters.AddWithValue("@Payment_RecieptConfirmation", oPayment.Payment_RecieptConfirmation);
cmd.Parameters.AddWithValue("@Payment_ReceivedDate", oPayment.Payment_ReceivedDate);
cmd.Parameters.AddWithValue("@Payment_Creator", oPayment.Creator);
cmd.Parameters.AddWithValue("@Payment_CreationDate", oPayment.CreationDate);
cmd.Parameters.AddWithValue("@Payment_UpdateBy", oPayment.UpdateBy);
cmd.Parameters.AddWithValue("@Payment_UpdateDate", oPayment.UpdateDate);
cmd.ExecuteNonQuery();
oConnManager.Commit();
oResult.IsSuccess = true;
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult Delete(CPayment oPayment)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_Payment_Delete";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Payment_OID", oPayment.Payment_OID);
cmd.Parameters.Add("@IsSuccess", SqlDbType.Char, 1);
cmd.Parameters["@IsSuccess"].Direction = ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
string st = cmd.Parameters["@IsSuccess"].Value.ToString();
oConnManager.Commit();
oResult.Data = st;
oResult.IsSuccess = true;
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
private void DisplayInfo(CSalesMaster sm, MySqlConnection conn)
{
lblOrderNo.InnerText = sm.Number;
lblTransDate.Text = sm.TransDate_ToString;
//lblDelMode.Text = sm.DelModeName;
lblPmtMode.Text = sm.PmtModeName;
//lblPmtNo.Text = "";
//lblPmtDate.Text = "";
string sBillAddr = "";
if (sm.LinkID > 0)
{
CPayment pmt = CSalesMaster.FetchPaymentRecord(conn, sm.LinkID);
if (!pmt.isEmpty)
{
lblPmtMode.Text = pmt.PaymentName;
//lblPmtNo.Text = pmt.Number;
//lblPmtDate.Text = pmt.TransDate_ToString;
}
}
lblBillAddr.Text = sBillAddr;
//lblDelAddr.Text = sm.Address;
SalesDetailCollection col = sm.CollectionSalesDetail(true, conn);
lvwOrder.DataSource = col;
lvwOrder.DataBind();
//lblDelFee.Text = sm.Charge_ToString;
lblSubtotal.Text = sm.Subtotal_ToString;
lblCharge.Text = "Charge";
lblChargeAmt.Text = sm.Charge_ToString;
lblTax.Text = "Tax";
lblTaxAmt.Text = sm.Tax_ToString;
lblTotal.Text = sm.SalesTotal_ToString;
//lblNotes.Text = sm.Notes;
// List<CDeliveryLog> lst = CSalesMaster.ListOfDeliveryLogs(conn, sm.ID);
//lvwDelLog.DataSource = lst;
//lvwDelLog.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
PaymentId = Convert.ToInt32(Request["id"]);
if (!IsPostBack)
{
var global = new CGlobal();
RadComboBoxExtraPayment.DataSource = global.GetDictionary(1440);
RadComboBoxExtraPayment.DataTextField = "Name";
RadComboBoxExtraPayment.DataValueField = "Value";
RadComboBoxExtraPayment.DataBind();
RadDatePickerReceiptDate.SelectedDate = DateTime.Now;
var cPayment = new CPayment();
var payment = cPayment.Get(PaymentId);
if (payment != null)
{
if (payment.ExtraDate != null)
{
RadDatePickerReceiptDate.SelectedDate = payment.ExtraDate;
}
if (payment.ExtraAmount != null)
{
RadNumericTextBoxAmount.Value = (double)payment.ExtraAmount;
}
if (payment.ExtraType != null)
{
foreach (RadComboBoxItem item in RadComboBoxExtraPayment.Items)
{
if (item.Value == payment.ExtraType.ToString())
{
item.Selected = true;
break;
}
}
}
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
CPayment oPayment = lvPaymentList.FocusedItem.Tag as CPayment;
CPaymentBO oPartyBO = new CPaymentBO();
CResult oResult = new CResult();
if (ValidateData())
{
oResult = oPartyBO.Update(GetFormData(oPayment));
if (oResult.IsSuccess)
{
MessageBox.Show("Update successfully");
FillPaymentList();
}
else
{
MessageBox.Show("Not Updated" + oResult.ErrMsg + "");
}
ClearControl(groupBox1);
FillPaymentList();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
CPayment oPayment = new CPayment();
CPaymentBO oPaymentBO = new CPaymentBO();
CResult oResult = new CResult();
if (ValidateData())
{
oResult = oPaymentBO.Create(GetFormData(oPayment));
if (oResult.IsSuccess)
{
MessageBox.Show(" Saved successfully ");
FillPaymentList();
}
else
{
MessageBox.Show(" Not Saved " + oResult.ErrMsg + "");
}
ClearControl(groupBox1);
}
}
private void Payment_SelectedIndexChanged(object sender, EventArgs e)
{
CPayment cPayment = new CPayment();
vwPaymentHistory paymentHistory = cPayment.GetvwPaymentHistory(Convert.ToInt32(_radGridPaymentHistory.SelectedValue));
Erp2016.Lib.Payment reversePayment = cPayment.GetReversePayment(Convert.ToInt32(paymentHistory.PaymentId));
var btnDetailStudentReciept = RadToolBarPayment.FindItemByText("Student Detail Reciept");
var btnDetailAgencyReciept = RadToolBarPayment.FindItemByText("Agency Detail Reciept");
var btnReverse = RadToolBarPayment.FindItemByText("Payment Reverse");
if (paymentHistory.Status != 3 && paymentHistory.OriginalPaymentId == null && reversePayment == null)
{
btnReverse.Enabled = true;
}
else
{
btnReverse.Enabled = false;
}
btnDetailStudentReciept.Enabled = true;
btnDetailAgencyReciept.Enabled = true;
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (txtOId.Text != string.Empty)
{
if ((MessageBox.Show("Do u really want to delete this item. ", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning)) == DialogResult.Yes)
{
CPayment oPayment = GetFormData();
CPaymentBO oPaymentBO = new CPaymentBO();
CResult oresult = new CResult();
oresult = oPaymentBO.Delete(oPayment);
if (oresult.IsSuccess == true)
{
//if (oresult.Data.ToString() == "0")
//{
// MessageBox.Show("Deletion Not Possible", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
// FillPaymentList();
// ClearControl(groupBox1);
//}
//else
//{
MessageBox.Show("Deleted Successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
FillPaymentList();
ClearControl(groupBox1);
//}
}
else
{
MessageBox.Show("Error" + oresult.ErrMsg + "");
}
}
}
}
protected void RadToolBar_ButtonClick(object sender, RadToolBarEventArgs e)
{
switch (e.Item.Text)
{
case "Save":
if (IsValid)
{
var cPayment = new CPayment();
var payment = cPayment.Get(PaymentId);
if (payment != null)
{
payment.ExtraType = Convert.ToInt32(RadComboBoxExtraPayment.SelectedValue);
payment.ExtraAmount = (decimal)RadNumericTextBoxAmount.Value;
payment.ExtraDate = RadDatePickerReceiptDate.SelectedDate;
if (cPayment.Update(payment))
{
RunClientScript("Close();");
}
else
{
ShowMessage("Error updating");
}
}
else
{
ShowMessage("Error can't find payment");
}
}
break;
case "Cancel":
RunClientScript("Close();");
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var reportBook = new ReportBook();
var reportType = Convert.ToInt32(Request["reportType"]);
var idParameters = Request["id"].Split(',');
InstanceReportSource reportSource = new InstanceReportSource();
switch (reportType)
{
case (int)CConstValue.Report.InvoiceStudent:
case (int)CConstValue.Report.InvoiceAgency:
foreach (var id in idParameters)
{
reportBook.Reports.Add(new RInvoice(reportType, CurrentUserId, Convert.ToInt32(id)));
}
// lump sum invoice
if (reportBook.Reports.Count > 1)
{
reportBook.Reports.Add(new RInvoiceLumpSum(reportType, CurrentUserId, Request["id"]));
}
break;
case (int)CConstValue.Report.PaymentStudent:
case (int)CConstValue.Report.PaymentAgency:
var paymentReport = new RPayment(reportType, CurrentUserId, Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(paymentReport);
break;
case (int)CConstValue.Report.DetailPaymentStudent:
case (int)CConstValue.Report.DetailPaymentAgency:
var payment = new CPayment().Get(Convert.ToInt32(idParameters[0]));
var detailPaymentReport = new RPayment(reportType, CurrentUserId, payment.InvoiceId, Request["id"]);
reportBook.Reports.Add(detailPaymentReport);
break;
// Schools
case (int)CConstValue.Report.LetterOfAcceptance:
var letterOfAcceptance = new RLetterOfAcceptance(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(letterOfAcceptance);
break;
case (int)CConstValue.Report.LetterOfAcceptanceInTable:
var letterOfAcceptanceInTable = new RLetterOfAcceptanceInTable(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(letterOfAcceptanceInTable);
break;
case (int)CConstValue.Report.StudentContract:
var letterOfAcceptanceInTable2 = new RLetterOfAcceptanceInTable(Convert.ToInt32(Request["id"]));
var refundPolicy = new RRefundPolicy(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(letterOfAcceptanceInTable2);
reportBook.Reports.Add(refundPolicy);
break;
case (int)CConstValue.Report.OrientationForm:
var orientationForm = new ROrientationForm(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(orientationForm);
break;
case (int)CConstValue.Report.ConfirmationOfCompletionLetter:
var confirmationOfCompletionLetter = new RConfirmationOfCompletionLetter(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(confirmationOfCompletionLetter);
break;
case (int)CConstValue.Report.ConfirmationOfEnrollment:
var confirmationOfEnrollment = new RConfirmationOfEnrollment(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(confirmationOfEnrollment);
break;
// Academy
case (int)CConstValue.Report.Certification:
var certification = new RCertification(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(certification);
break;
case (int)CConstValue.Report.ClassSummary:
var classSummary = new RClassSummary(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(classSummary);
break;
case (int)CConstValue.Report.StartingStudents:
var startingStudents = new RStartingStudents(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(startingStudents);
break;
case (int)CConstValue.Report.CompletedGraduatesStudents:
var completedGraduatesStudents = new RCompletedGraduatesStudents(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(completedGraduatesStudents);
break;
case (int)CConstValue.Report.AttendanceSheet:
var attendanceSheet = new RAttendanceSheet(Convert.ToInt32(Request["id"]));
reportBook.Reports.Add(attendanceSheet);
break;
}
reportSource.ReportDocument = reportBook;
ReportViewer1.ReportSource = reportSource;
}
}
protected void RadToolBarPayment_OnButtonClick(object sender, RadToolBarEventArgs e)
{
switch (e.Item.Text)
{
case "New Payment":
if (RadGridPayment.SelectedValue != null)
{
RunClientScript("ShowNewPaymentWindow('" + RadGridPayment.SelectedValue + "');");
}
break;
case "Agency Detail Reciept":
if (_radGridPaymentHistory.SelectedValue != null)
{
var selectedInvoiceList = new List <int>();
foreach (GridDataItem item in _radGridPaymentHistory.SelectedItems)
{
selectedInvoiceList.Add((int)item.GetDataKeyValue("PaymentId"));
}
RunClientScript("ShowReportPop('" + String.Join(", ", selectedInvoiceList.ToArray()) + "', '" + (int)CConstValue.Report.DetailPaymentAgency + "' );");
}
break;
case "Student Detail Reciept":
if (_radGridPaymentHistory.SelectedValue != null)
{
var selectedInvoiceList = new List <int>();
foreach (GridDataItem item in _radGridPaymentHistory.SelectedItems)
{
selectedInvoiceList.Add((int)item.GetDataKeyValue("PaymentId"));
}
RunClientScript("ShowReportPop('" + String.Join(", ", selectedInvoiceList.ToArray()) + "', '" + (int)CConstValue.Report.DetailPaymentStudent + "' );");
}
//if (_radGridPaymentHistory.SelectedValue != null)
//{
// RunClientScript("ShowReportPop('" + _radGridPaymentHistory.SelectedValue + "', '" + (int)CConstValue.Report.DetailPaymentStudent + "');");
//}
break;
case "Payment Reverse":
if (_radGridPaymentHistory.SelectedValue != null)
{
var payment = new CPayment().Get(Convert.ToInt32(_radGridPaymentHistory.SelectedValue));
if (payment.Amount > 0)
{
var cNewPayment = new CPayment();
var newPayment = new Erp2016.Lib.Payment();
CGlobal.Copy(payment, newPayment);
newPayment.Amount *= -1;
newPayment.OriginalPaymentId = payment.PaymentId;
cNewPayment.Add(newPayment);
RadGridPayment.Rebind();
}
else
{
ShowMessage("Negative price can't reverse");
}
}
break;
}
}
protected void InvoiceToolbarButtonClicked(object sender, RadToolBarEventArgs e)
{
switch (e.Item.Text)
{
case "Confirm":
if (RadGridInvoice.SelectedValue != null)
{
var cInvoice = new CInvoice();
var invoice = cInvoice.Get(Convert.ToInt32(RadGridInvoice.SelectedValue));
invoice.Status = (int)CConstValue.InvoiceStatus.Invoiced; // Invoice Status(34) : Invoiced
invoice.UpdatedId = CurrentUserId;
invoice.UpdatedDate = DateTime.Now;
if (cInvoice.Update(invoice))
{
ShowMessage("Update inquiry successfully");
}
else
{
ShowMessage("Failed to update inquiry");
}
e.Item.Enabled = false;
RadGridInvoice.Rebind();
}
break;
case "Cancel":
if (RadGridInvoice.SelectedValue != null)
{
var cInvoice = new CInvoice();
var invoice = cInvoice.Get(Convert.ToInt32(RadGridInvoice.SelectedValue));
if (invoice.Status == (int)CConstValue.InvoiceStatus.Pending)
{
RunClientScript("ShowCancelWindow(" + RadGridInvoice.SelectedValue + ");");
}
else if (invoice.Status == (int)CConstValue.InvoiceStatus.Invoiced)
{
if (new CPayment().InvoiceCheck(invoice.InvoiceId) == 0)
{
RunClientScript("ShowCancelWindow(" + RadGridInvoice.SelectedValue + ");");
}
else
{
ShowMessage("It can't because of already paid in invoice");
}
}
RadGridInvoice.Rebind();
}
break;
case "Agency Invoice":
if (RadGridInvoice.SelectedValue != null)
{
var selectedInvoiceList = new List <int>();
foreach (GridDataItem item in RadGridInvoice.SelectedItems)
{
selectedInvoiceList.Add((int)item.GetDataKeyValue("InvoiceId"));
}
RunClientScript("ShowReportPop('" + String.Join(", ", selectedInvoiceList.ToArray()) + "', '" + (int)CConstValue.Report.InvoiceAgency + "' );");
}
break;
case "Student Invoice":
if (RadGridInvoice.SelectedValue != null)
{
var selectedInvoiceList = new List <int>();
foreach (GridDataItem item in RadGridInvoice.SelectedItems)
{
selectedInvoiceList.Add((int)item.GetDataKeyValue("InvoiceId"));
}
RunClientScript("ShowReportPop('" + String.Join(", ", selectedInvoiceList.ToArray()) + "', '" + (int)CConstValue.Report.InvoiceStudent + "' );");
}
break;
case "Modify":
if (RadGridInvoice.SelectedValue != null)
{
var cInvoice = new CInvoice();
var invoice = cInvoice.Get(Convert.ToInt32(RadGridInvoice.SelectedValue));
if (invoice.Status == (int)CConstValue.InvoiceStatus.Invoiced ||
invoice.InvoiceType == (int)CConstValue.InvoiceType.General ||
invoice.InvoiceType == (int)CConstValue.InvoiceType.Simple ||
invoice.InvoiceType == (int)CConstValue.InvoiceType.Manual ||
invoice.InvoiceType == (int)CConstValue.InvoiceType.Homestay ||
invoice.InvoiceType == (int)CConstValue.InvoiceType.Dormitory) //invoiced
{
var payments = new CPayment();
if (payments.InvoiceCheck(invoice.InvoiceId) == 0)
{
invoice.Status = (int)CConstValue.InvoiceStatus.Cancelled_MD; // Invoice Status(34) : Cancelled_M
invoice.UpdatedId = CurrentUserId;
invoice.UpdatedDate = DateTime.Now;
if (cInvoice.Update(invoice))
{
var cNewInvoice = new CInvoice();
var newInvoice = new Erp2016.Lib.Invoice();
CGlobal.Copy(invoice, newInvoice);
newInvoice.OriginalInvoiceId = invoice.InvoiceId;
newInvoice.Status = (int)CConstValue.InvoiceStatus.Pending; // pending
newInvoice.CreatedId = CurrentUserId;
newInvoice.CreatedDate = DateTime.Now;
if (cNewInvoice.Add(newInvoice) > 0)
{
var cInvoiceItem = new CInvoiceItem();
List <InvoiceItem> originalInvoiceItems = cInvoiceItem.GetInvoiceItems(invoice.InvoiceId);
List <InvoiceItem> newInvoiceItems = new List <InvoiceItem>();
foreach (InvoiceItem ori in originalInvoiceItems)
{
var newInvoiceItem = new InvoiceItem();
CGlobal.Copy(ori, newInvoiceItem);
newInvoiceItem.InvoiceId = newInvoice.InvoiceId;
newInvoiceItem.CreatedId = CurrentUserId;
newInvoiceItem.CreatedDate = DateTime.Now;
newInvoiceItems.Add(newInvoiceItem);
}
// copy invoiceItems
if (cInvoiceItem.Add(newInvoiceItems) == false)
{
ShowMessage("Error inserting invoice Items");
}
RadGridInvoice.Rebind();
}
}
}
else
{
ShowMessage("It can't because of already paid in invoice");
}
}
}
break;
case "New Simple Invoice":
RunClientScript("ShowNewSimpleInvoice();");
break;
case "Student Page":
if (RadGridInvoice.SelectedValue != null)
{
Response.Redirect("~/Student?id=" + RadGridInvoice.SelectedValues["StudentId"]);
}
break;
case "Payment Page":
if (RadGridInvoice.SelectedValue != null)
{
Response.Redirect("~/Payment?id=" + RadGridInvoice.SelectedValues["StudentId"]);
}
break;
case "Deposit Page":
if (RadGridInvoice.SelectedValue != null)
{
Response.Redirect("~/Deposit?id=" + RadGridInvoice.SelectedValues["StudentId"]);
}
break;
case "CreditMemo Page":
if (RadGridInvoice.SelectedValue != null)
{
Response.Redirect("~/CreditMemo?id=" + RadGridInvoice.SelectedValues["StudentId"]);
}
break;
case "Refund Page":
if (RadGridInvoice.SelectedValue != null)
{
Response.Redirect("~/Refund?id=" + RadGridInvoice.SelectedValues["StudentId"]);
}
break;
}
}
protected void RadGridUnDepositPayment_OnRowDrop(object sender, GridDragDropEventArgs e)
{
//if (e.DraggedItems.Count != 0 && RadGridDepositList.SelectedValue != null && e.DestinationGrid == _radGridDepositPayment)
if (e.DraggedItems.Count != 0 && RadGridDepositList.SelectedValue != null)
{
foreach (var dataItem in e.DraggedItems)
{
var cPayDeposit = new CDepositPayment();
var payDeposit = new Erp2016.Lib.DepositPayment();
payDeposit.DepositId = Convert.ToInt32(RadGridDepositList.SelectedValue.ToString());
payDeposit.PaymentId = Convert.ToInt32(dataItem.GetDataKeyValue("PaymentId").ToString());
payDeposit.CreatedId = CurrentUserId;
if (cPayDeposit.Add(payDeposit) > 0)
{
var cPayment = new CPayment();
var payment = cPayment.Get(Convert.ToInt32(dataItem.GetDataKeyValue("PaymentId").ToString()));
var cHomestayChkInvoice = new CInvoice();
var homestayChkInvoice = cHomestayChkInvoice.Get(payment.InvoiceId);
//if (!string.IsNullOrEmpty(homestayChkInvoice.HomestayRegistrationId.ToString()))
//{
// var homestayId = Convert.ToInt32(homestayChkInvoice.HomestayRegistrationId);
// var payOut = new CHomestayPayoutRequest();
// var payId = payOut.GetHomestayId(homestayId);
// var cPout = new CHomestayPayoutRequest();
// var pout = cPout.Get(payId);
// var cPmethod = new CPaymentMethod();
// var pmethod = cPmethod.Get(payId);
// pout.PayoutStatus = 1;
// if (cPout.Update(pout))
// {
// if (true)
// {
// pmethod.PayoutId = payId;
// pmethod.PayoutMethod1 = 0;
// pmethod.SiteLocationId = CurrentSiteLocationId;
// pmethod.CreatedId = CurrentUserId;
// pmethod.CreatedDate = DateTime.Now;
// cPmethod.Add(pmethod);
// }
// }
//}
}
}
ShowMessage("Completed adding payment(s).");
}
else
{
ShowMessage("Failed adding payment(s).");
}
}
protected void ToolbarButtonClick(object sender, RadToolBarEventArgs e)
{
if (e.Item.Text == @"Payment Confirm" && !string.IsNullOrEmpty(hfInvoiceId.Value) && (btCheckPayment.Checked || btCheckCredit.Checked) && !string.IsNullOrEmpty(Convert.ToString(tbPaymentDate.SelectedDate)))
{
if (IsValid)
{
var paymentAddChk = false;
var creditAddChk = 0;
if (btCheckPayment.Checked && tbPaymentAmount.Value > 0)
{
var cPayment = new CPayment();
var newPayment = new Erp2016.Lib.Payment();
newPayment.InvoiceId = Convert.ToInt32(hfInvoiceId.Value);
newPayment.PaymentDate = Convert.ToDateTime(tbPaymentDate.SelectedDate);
newPayment.Method = Convert.ToInt32(ddlPyamentMethod.SelectedValue);
newPayment.Currency = Convert.ToInt32(ddlCurrency.SelectedValue);
newPayment.Amount = Convert.ToDecimal(tbPaymentAmount.Value);
newPayment.Remark = tbRemark.Text;
newPayment.SiteLocationId = CurrentSiteLocationId;
newPayment.CreatedId = CurrentUserId;
newPayment.CreatedDate = DateTime.Now;
paymentAddChk = cPayment.Add(newPayment) > 0;
}
if (btCheckCredit.Checked && tbCreditAmount.Value > 0)
{
var cPayment = new CPayment();
var creditPayment = new Erp2016.Lib.Payment();
creditPayment.InvoiceId = Convert.ToInt32(hfInvoiceId.Value);
creditPayment.PaymentDate = Convert.ToDateTime(tbPaymentDate.SelectedDate);
creditPayment.Method = 9; //Payment Method : Credit Memo
creditPayment.Amount = Convert.ToDecimal(tbCreditAmount.Value);
creditPayment.Remark = tbRemark.Text;
creditPayment.SiteLocationId = CurrentSiteLocationId;
creditPayment.CreatedId = CurrentUserId;
creditPayment.CreatedDate = DateTime.Now;
creditAddChk = cPayment.Add(creditPayment);
if (creditAddChk > 0)
{
var cCrreditHistory = new CCreditMemoCreditHistory();
var creditHistory = new Erp2016.Lib.CreditMemoCreditHistory();
creditHistory.CreditMemoId = Convert.ToInt32(ddlCreditMemo.SelectedValue);
creditHistory.PayoutMethod = 1; //CreditPayMethod(1218) : Credit(1)
creditHistory.CreditAmount = Convert.ToDecimal(tbCreditAmount.Value);
creditHistory.CreditDate = Convert.ToDateTime(tbPaymentDate.SelectedDate);
creditHistory.PaymentId = creditAddChk;
creditHistory.CreatedId = CurrentUserId;
creditHistory.CreatedDate = DateTime.Now;
cCrreditHistory.Add(creditHistory);
}
else
{
ShowMessage("failed to update inqury (Add CreditMemoPayoutHistory)");
}
}
if (btCheckPayment.Checked && btCheckCredit.Checked)
{
if (paymentAddChk && creditAddChk > 0)
{
RunClientScript("Close();");
}
else
{
ShowMessage("failed to update inqury (Add Payment)");
}
}
else
{
if (btCheckPayment.Checked)
{
if (paymentAddChk)
{
RunClientScript("Close();");
}
else
{
ShowMessage("failed to update inqury (General Pay)");
}
}
else if (btCheckCredit.Checked)
{
if (creditAddChk > 0)
{
RunClientScript("Close();");
}
else
{
ShowMessage("failed to update inqury (Credit Pay)");
}
}
else
{
ShowMessage("failed to update inqury (System failed)");
}
}
}
}
else if (e.Item.Text == "Cancel")
{
RunClientScript("Close();");
}
else
{
ShowMessage("Check Pay Info");
}
}
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;
}
}
}
