private void btnSave_Click(object sender, EventArgs e)
{
if (ValidateFields())
{
clsServiceFee fee = SELECTED_FEE;
if (fee == null)
{
fee = new clsServiceFee();
}
fee.Load_id = m_LoadAccount.LoadId;
fee.AmountFrom = double.Parse(txtAmtFrom.Text);
fee.AmountTo = double.Parse(txtAmtTo.Text);
fee.EcashFee = double.Parse(txtEcashFee.Text);
fee.P2PFee = double.Parse(txtP2P.Text);
fee.Rebate = double.Parse(txtRebatePercentage.Text);
fee.Remarks = txtRemarks.Text;
if (fee.Save())
{
MessageBox.Show("Service Fee Successfully Saved!", "Save Account", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearFields();
ReloadFees();
}
else
{
MessageBox.Show("Service Fee Not Saved!", "Save Account", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void ComputeServiceFee(string txt)
{
try
{
clsServiceFee fee = m_LoadAccount.LstServiceFees.FirstOrDefault(x => double.Parse(txt) <= x.AmountTo);
if (fee != null)
{
if (optCashOut.Checked || optSendOthers.Checked)
{
txtSvcFee1.Text = fee.EcashFee.ToString("n");
txtRebate1.Text = ComputeRebate(double.Parse(txt)).ToString();
}
else if (optCashIn.Checked)
{
txtSvcFee1.Text = "0";
txtRebate1.Text = ComputeRebate(double.Parse(txt)).ToString();
}
else
{
txtSvcFee1.Text = "0";
txtRebate1.Text = "0";
}
}
else
{
txtSvcFee1.Text = "0";
txtRebate1.Text = "0";
}
}
catch { txtSvcFee1.Text = "0"; txtRebate1.Text = "0"; }
}
private void txtAmount1_TextChanged(object sender, EventArgs e)
{
TextBox txt = (TextBox)sender;
if (txt.Text != "")
{
try
{
clsServiceFee fee = m_LoadAccount.LstServiceFees.FirstOrDefault(x => double.Parse(txt.Text) <= x.AmountTo);
if (fee != null)
{
clsServiceFee inhousefee = ComputeGCashremitFee(double.Parse(txt.Text), true);
fee.Rebate = inhousefee.EcashFee - fee.EcashFee;
txtSSSvcFee.Text = inhousefee.EcashFee.ToString("n");
txtSSCommission.Text = fee.Rebate.ToString();
}
else
{
txtSSSvcFee.Text = "";
}
}
catch { txtSSSvcFee.Text = ""; }
}
else
{
txtSSSvcFee.Text = "";
}
}
private void textBox_TextChanged(object sender, EventArgs e)
{
TextBox txt = (TextBox)sender;
clsServiceFee fee = LstServiceFees.Find(x => x.AmountFrom >= double.Parse(txt.Text) && x.AmountTo <= double.Parse(txt.Text));
if (fee != null)
{
txtServiceFee.Text = fee.EcashFee.ToString("n");
}
}
private void ClearFields()
{
txtAmtFrom.Text = "0";
txtAmtTo.Text = "0";
txtEcashFee.Text = "0";
txtP2P.Text = "0";
txtRebatePercentage.Text = "0";
dgvSvcFees.ClearSelection();
SELECTED_FEE = null;
}
private void AddItemToGrid(clsServiceFee act)
{
int rowidx = dgvSvcFees.Rows.Add();
dgvSvcFees.Rows[rowidx].Cells[0].Value = act.ServiceFeeID;
dgvSvcFees.Rows[rowidx].Cells[1].Value = act.AmountFrom;
dgvSvcFees.Rows[rowidx].Cells[2].Value = act.AmountTo;
dgvSvcFees.Rows[rowidx].Cells[3].Value = act.EcashFee;
dgvSvcFees.Rows[rowidx].Cells[4].Value = act.P2PFee;
dgvSvcFees.Rows[rowidx].Cells[5].Value = act.Rebate;
dgvSvcFees.Rows[rowidx].Cells[6].Value = act.Remarks;
}
private clsServiceFee GetSelItem()
{
if (dgvSvcFees.SelectedRows.Count > 0)
{
int id = Convert.ToInt32(dgvSvcFees.SelectedRows[0].Cells[0].Value);
if (id > 0)
{
clsServiceFee ret = m_LoadAccount.LstServiceFees.Find(x => x.ServiceFeeID == id);
return(ret);
}
}
return(null);
}
private void optCancelP2P_CheckedChanged(object sender, EventArgs e)
{
clsServiceFee fee = ComputeGCashremitFee(double.Parse(txtAmount3.Text));
if (fee != null)
{
txtSvcFee3.Text = fee.EcashFee.ToString("n");
txtRebate3.Text = fee.Rebate.ToString();
}
else
{
txtSvcFee3.Text = "0";
txtRebate3.Text = "0";
}
}
private void UpdateFields(clsServiceFee act)
{
if (act != null)
{
txtAmtFrom.Text = act.AmountFrom.ToString();
txtAmtTo.Text = act.AmountTo.ToString();
txtEcashFee.Text = act.EcashFee.ToString();
txtP2P.Text = act.P2PFee.ToString();
txtRebatePercentage.Text = act.Rebate.ToString();
if (m_LoadAccount.LoadType == LoadAccountType.ELoad)
{
txtRemarks.Text = act.Remarks;
}
}
}
private clsServiceFee ComputeGCashremitFee(double amt, bool isPadala = false)
{
clsServiceFee ret = new clsServiceFee();
if (amt <= 1000)
{
ret.EcashFee = 30;
ret.Rebate = 0;
}
else
{
ret.EcashFee = amt * (isPadala ? 0.025 : 0.02);
ret.Rebate = 0;
}
return(ret);
}
private void cmbLoadAmt_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (m_LoadAccount.LstServiceFees.Count > 0)
{
clsServiceFee svc = m_LoadAccount.LstServiceFees.Find(x => x.ServiceFeeID == (int)cmbLoadAmt.SelectedValue);
if (svc != null)
{
txtAmtDue.Text = svc.EcashFee.ToString("n");
txtRebate.Text = svc.Rebate.ToString("n");
txtTransAmount.Text = svc.AmountTo.ToString("n");
}
}
}
catch { }
}
private void txtAmount3_TextChanged(object sender, EventArgs e)
{
TextBox txt = (TextBox)sender;
if (txt.Text != "")
{
try
{
if (double.Parse(txt.Text) > 40000)
{
MessageBox.Show("Maximum transaction amount is 40,000.");
txt.Text = "40000";
}
else
{
clsServiceFee fee = ComputeGCashremitFee(double.Parse(txt.Text));
if (fee != null)
{
txtSvcFee3.Text = fee.EcashFee.ToString("n");
txtRebate3.Text = fee.Rebate.ToString();
}
else
{
txtSvcFee3.Text = "0";
txtRebate3.Text = "0";
}
}
}
catch
{
txtSvcFee3.Text = "0";
txtRebate3.Text = "0";
}
}
else
{
txtSvcFee3.Text = "0";
txtRebate3.Text = "0";
}
}
private clsServiceFee ComputeGCashremitFee(double amt)
{
clsServiceFee ret = new clsServiceFee();
if (optCancelP2P.Checked)
{
ret.EcashFee = 0;
ret.Rebate = 0;
}
else
{
if (amt <= 200)
{
ret.EcashFee = 10;
ret.Rebate = 2.5;
}
else if (amt <= 1000)
{
ret.EcashFee = 50;
ret.Rebate = 12.5;
}
else if (amt <= 2000)
{
ret.EcashFee = 100;
ret.Rebate = 25;
}
else if (amt <= 5000)
{
ret.EcashFee = 150;
ret.Rebate = 37.5;
}
else if (amt <= 40000)
{
ret.EcashFee = 200;
ret.Rebate = 50;
}
}
return(ret);
}
private void txtAmount2_TextChanged(object sender, EventArgs e)
{
TextBox txt = (TextBox)sender;
if (txt.Text != "")
{
try
{
//clsServiceFee fee = m_LoadAccount.LstServiceFees.FirstOrDefault(x => double.Parse(txt.Text) <= x.AmountTo);
//if (fee != null)
//{
clsServiceFee inhousefee = ComputeGCashremitFee(double.Parse(txt.Text), false);
//fee.Rebate = inhousefee.EcashFee - fee.EcashFee;
txtCSSvcFee.Text = inhousefee.EcashFee.ToString("n");
txtCSCommission.Text = "0";
txtCSTotalAmtTrans.Text = txt.Text;
double p = double.Parse(txtCSAmount.Text) - double.Parse(txtCSSvcFee.Text);
txtCSTotalPayment.Text = string.Format("{0:0.00}", p);
//if (optCash.Checked)
//{
// txtTotalCashPayment.Text = string.Format("{0:n}", double.Parse(txt.Text) - fee.EcashFee);
//}
//else
//{
// txtTotalCashPayment.Text = string.Format("{0:n}", double.Parse(txt.Text));
//}
//}
//else txtCSSvcFee.Text = "";
}
catch { txtCSSvcFee.Text = ""; }
}
else
{
txtCSSvcFee.Text = "";
}
}
public bool UploadServiceFees(string filename, int LoadId)
{
try
{
bool ret = false;
Workbook xlsBook = new Workbook();
Worksheet xlsSheet = null;
if (File.Exists(filename))
{
xlsBook.LoadFromFile(filename);
}
xlsSheet = xlsBook.Worksheets[0];
int RowCount = xlsSheet.Rows.Count();
string str = xlsSheet[1, 1].Value.ToString().Trim();
for (int i = 3; i <= RowCount; i++)
{
clsServiceFee fee = new clsServiceFee()
{
ServiceFeeID = xlsSheet[i, 1].Value.ToString().Trim() != "" ? int.Parse(xlsSheet[i, 1].Value.ToString().Trim()) : 0,
Load_id = LoadId,
AmountFrom = xlsSheet[i, 2].Value.ToString().Trim() != "" ? double.Parse(xlsSheet[i, 2].Value.ToString().Trim()) : 0,
AmountTo = xlsSheet[i, 3].Value.ToString().Trim() != "" ? double.Parse(xlsSheet[i, 3].Value.ToString().Trim()) : 0,
EcashFee = xlsSheet[i, 4].Value.ToString().Trim() != "" ? double.Parse(xlsSheet[i, 4].Value.ToString().Trim()) : 0,
P2PFee = xlsSheet[i, 5].Value.ToString().Trim() != "" ? double.Parse(xlsSheet[i, 5].Value.ToString().Trim()) : 0,
Rebate = xlsSheet[i, 6].Value.ToString().Trim() != "" ? double.Parse(xlsSheet[i, 6].Value.ToString().Trim()) : 0,
Remarks = xlsSheet[i, 7].Value.ToString().Trim()
};
ret = fee.Save();
}
return(ret);
}
catch { }
return(false);
}
private void dgvSvcFees_CellClick(object sender, DataGridViewCellEventArgs e)
{
SELECTED_FEE = GetSelItem();
UpdateFields(SELECTED_FEE);
}
