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); }