private void buttonTransfer_Click(object sender, EventArgs e)
{
try
{
if (txtGuestAcc.Text != string.Empty && txtTransferAmount.Text != string.Empty)
{
GateWay gateWayObject = new GateWay();
DataTable dataTableObject = new DataTable();
string sqlString = "select account_no from customer where account_no='" + txtGuestAcc.Text + "'"; // determine whether the account is exist.
dataTableObject = gateWayObject.SelectData(sqlString);
//DataRow dr = dataTableObject.Rows[0];
if (dataTableObject.Rows.Count == 1 && txtGuestAcc.Text != customerObject.acc_no)
{
customerObject.balance -= Convert.ToDecimal(txtTransferAmount.Text);
string updateCustomerString = "update customer set balance=" + customerObject.balance + " where account_no='" + customerObject.acc_no + "'";
string updateGusetString = "update customer set balance=balance+" + txtTransferAmount.Text + " where account_no='" + txtGuestAcc.Text + "'";
//insert into transfer_history table
string insertString = @"INSERT INTO [transfer_history] (date, acc_from, acc_to, ammount, notification) VALUES (@date, @acc_from, @acc_to, @ammount, @notification)";
List <SqlParameter> parameter = new List <SqlParameter>();
parameter.Add(new SqlParameter("@date", (DateTime.Now).ToString()));
parameter.Add(new SqlParameter("@acc_from", customerObject.acc_no));
parameter.Add(new SqlParameter("@acc_to", txtGuestAcc.Text));
parameter.Add(new SqlParameter("@ammount", Convert.ToDecimal(txtTransferAmount.Text)));
parameter.Add(new SqlParameter("@notification", 1));
if (gateWayObject.updateData(updateCustomerString) && gateWayObject.updateData(updateGusetString) && gateWayObject.InsertData(insertString, parameter))
{
MessageBox.Show("Transfer Successfull.\nNew balance" + customerObject.balance);
}
else
{
MessageBox.Show("Error in Transfer.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Invalid account number.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Account number or Amount should not be empty.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (FormatException ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
txtGuestAcc.Clear();
txtTransferAmount.Clear();
}
private void buttonDepositDepositCash_Click(object sender, EventArgs e)
{
try
{
customerObject.balance += Convert.ToDecimal(textBoxDepositCash.Text);
GateWay gateWayObject = new GateWay();
string updateString = "update customer set balance=" + customerObject.balance + " where account_no='" + customerObject.acc_no + "'";
string insertString = @"INSERT INTO [diposit_history] (account_no, date, ammount) VALUES (@account_no, @date, @ammount)";
List <SqlParameter> parameter = new List <SqlParameter>();
parameter.Add(new SqlParameter("@account_no", customerObject.acc_no));
parameter.Add(new SqlParameter("@date", (DateTime.Now).ToString()));
parameter.Add(new SqlParameter("@ammount", Convert.ToDecimal(textBoxDepositCash.Text)));
if (gateWayObject.updateData(updateString) && gateWayObject.InsertData(insertString, parameter))
{
MessageBox.Show("Deposit Successfull.\nNew balance" + customerObject.balance);
}
else
{
MessageBox.Show("Error in Deposit.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (FormatException ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
textBoxDepositCash.Clear();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtNewUserName.Text != string.Empty && txtNewPinCode.Text != string.Empty && txtConfirmNewPinCode.Text != string.Empty)
{
try
{
GateWay gateWayObject = new GateWay();
DataTable dataTableObject = new DataTable();
customerObject.userName = txtNewUserName.Text;
customerObject.pinCode = txtNewPinCode.Text;
if (txtNewPinCode.Text != txtConfirmNewPinCode.Text)
{
throw new Exception("Confirm PinCode does not match.");
}
dataTableObject = gateWayObject.SelectData("select * from customer");
bool found = false;
for (int i = 0; i < dataTableObject.Rows.Count; i++) // check if the user name already exist
{
if (dataTableObject.Rows[i]["user_name"].ToString() == customerObject.userName)
{
found = true;
break;
}
}
if (found)
{
MessageBox.Show("This user name already exist.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
string updateString = "update customer set user_name='" + customerObject.userName + "',pin_code='" + customerObject.pinCode + "' where account_no='" + customerObject.acc_no + "'";
if (gateWayObject.updateData(updateString))
{
MessageBox.Show("UserName and PinCode is updated.");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Field should not be empty.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
btnClear_Click(this, new EventArgs());
}
private void lblNotification_Click(object sender, EventArgs e)
{
VisibleFalse();
lblDescription.Location = new Point(200, 200);
lblDescription.Text = "";
for (int i = 0; i < dataTableObject.Rows.Count; i++)
{
lblDescription.Text += dataTableObject.Rows[i]["c_name"].ToString() + " sends you TK " + dataTableObject.Rows[i]["ammount"].ToString() + "\n";
}
lblDescription.Visible = true;
lblNotification.Visible = false;
string sqlString = "update transfer_history set notification = 0 where acc_to='" + customerObject.acc_no + "' and notification = 1";
if (!gateWayObject.updateData(sqlString))
{
MessageBox.Show("Notiication update error.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
