private void btnLoad_Click(object sender, EventArgs e)
{
if (ValidateInput())
{
clsSubDAccount subd = clsSubDAccount.GetSubDAccount(txtMobileNum.Text);
clsLoadWalletTransaction wallet = new clsLoadWalletTransaction();
wallet.Load_Id = m_LoadAccount.LoadId;
wallet.UserId = myPosWide.m_user.UserId;
wallet.SubDId = subd != null ? subd.Id_subdAccounts : 0;
wallet.Timestamp = DateTime.Now;
wallet.LoadAmount = double.Parse(txtLoadAmount.Text);
wallet.MobileNum = txtMobileNum.Text;
wallet.DiscountPercentage = double.Parse(txtDisCount.Text);
wallet.AmtDue = double.Parse(txtAmtDue.Text);
frmInput input = new frmInput();
double amountdue = wallet.AmtDue;
input.Title = "Payment";
input.Value = amountdue.ToString("0.00");
input.Caption = "Enter Tendered Amount";
if (input.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
if (Convert.ToDouble(input.Value) >= amountdue)
{
wallet.TenderedAmount = Convert.ToDouble(input.Value);
if (wallet.Save())
{
Clear();
m_LoadAccount = clsLoadAccount.GetLoadAccount(m_LoadAccount.LoadId);
wallet.PrintReceipt();
RefreshAccount();
}
else
{
MessageBox.Show("Transaction not saved.", "Payment", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
if (MessageBox.Show("Amount entered is less than the Amount Due. Charge to Sub-D Account?", "Payment", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == System.Windows.Forms.DialogResult.Yes)
{
wallet.TenderedAmount = Convert.ToDouble(input.Value);
if (wallet.Save())
{
Clear();
m_LoadAccount = clsLoadAccount.GetLoadAccount(m_LoadAccount.LoadId);
wallet.PrintReceipt();
RefreshAccount();
}
else
{
MessageBox.Show("Transaction not saved.", "Payment", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
}
}
private void ClearFields()
{
txtName.Text = "";
txtMobile.Text = "";
txtDiscount.Text = "0";
txtBalance.Text = "0.00";
dgvSubDAccounts.ClearSelection();
SelectedSubD = null;
}
private void AddItemToGrid(clsSubDAccount act)
{
int rowidx = dgvAccounts.Rows.Add();
dgvAccounts.Rows[rowidx].Cells[0].Value = act.Id_subdAccounts;
dgvAccounts.Rows[rowidx].Cells[1].Value = act.Name;
dgvAccounts.Rows[rowidx].Cells[2].Value = act.MobileNum;
dgvAccounts.Rows[rowidx].Cells[3].Value = act.Balance;
}
private void SelectAcnt()
{
if (dgvAccounts.Rows.Count >= 1)
{
SelectedAccount = GetAccountInfo(Convert.ToInt32(dgvAccounts.SelectedRows[0].Cells[0].Value));
DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
}
private void UpdateFields(clsSubDAccount act)
{
if (act != null)
{
txtName.Text = act.Name;
txtMobile.Text = act.MobileNum;
txtBalance.Text = act.Balance.ToString("0.00");
txtDiscount.Text = act.Discount.ToString("0");
}
}
private clsSubDAccount GetSelItem()
{
if (dgvSubDAccounts.SelectedRows.Count > 0)
{
int id = Convert.ToInt32(dgvSubDAccounts.SelectedRows[0].Cells[0].Value);
if (id > 0)
{
clsSubDAccount ret = m_LstSubD.Find(x => x.Id_subdAccounts == id);
return(ret);
}
}
return(null);
}
public bool UploadSubD(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();
for (int i = 2; i <= RowCount; i++)
{
clsSubDAccount subd = null;
try
{
subd = new clsSubDAccount()
{
Id_subdAccounts = 0,
LoadId = loadid,
Name = xlsSheet[i, 1].Value.ToString().Trim(),
MobileNum = xlsSheet[i, 2].Value.ToString().Trim(),
Balance = (string.IsNullOrEmpty(xlsSheet[i, 3].Value.ToString()) ? 0 : Convert.ToDouble(xlsSheet[i, 3].Value.ToString()))
};
}
catch
{
subd = new clsSubDAccount()
{
Id_subdAccounts = 0,
LoadId = loadid,
Name = xlsSheet[i, 1].Value.ToString().Trim(),
MobileNum = xlsSheet[i, 2].Value.ToString().Trim(),
Balance = 0
};
}
ret = subd.Save();
}
return(ret);
}
catch { }
return(false);
}
private void btnSearch_Click(object sender, EventArgs e)
{
frmSelectCustomer sel = new frmSelectCustomer(m_LoadAccount, txtCustomer.Text.Trim());
if (sel.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
clsSubDAccount subd = sel.SelectedAccount;
if (subd != null)
{
txtCustomer.Text = subd.Name;
txtMobileNum.Text = subd.MobileNum;
txtDisCount.Text = subd.Discount.ToString();
lblBalance.Text = "Account Balance: " + subd.Balance.ToString("n");
txtLoadAmount.Focus();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (ValidateFields())
{
clsSubDAccount subd = SelectedSubD;
if (subd == null)
{
subd = new clsSubDAccount();
}
subd.LoadId = m_LoadAccount.LoadId;
subd.Name = txtName.Text;
subd.MobileNum = txtMobile.Text;
subd.Discount = Convert.ToDouble(txtDiscount.Text);
if (subd.Save())
{
ClearFields();
ReloadSubD();
}
else
{
MessageBox.Show("Service Fee Not Saved!", "Save Account", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void DisplayAccounts()
{
if (txtName.Text.Trim() == "")
{
return;
}
accounts = clsSubDAccount.GetSubDAccounts(m_loadaccount.LoadId, txtName.Text.Trim());
if (accounts != null)
{
if (accounts.Count == 1)
{
SelectedAccount = accounts[0];
DialogResult = System.Windows.Forms.DialogResult.OK;
}
else
{
dgvAccounts.Rows.Clear();
foreach (clsSubDAccount a in accounts)
{
AddItemToGrid(a);
}
}
}
}
private void dgvSvcFees_CellClick(object sender, DataGridViewCellEventArgs e)
{
SelectedSubD = GetSelItem();
UpdateFields(SelectedSubD);
}