public void UpdateRecord(Objects.BankAccounts obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_BankAccountsUpdate";
cmd.Parameters.AddWithValue("@BankAccountID", obj.BankAccountID);
cmd.Parameters.AddWithValue("@AccountTitle", obj.AccountTitle);
cmd.Parameters.AddWithValue("@BankName", obj.BankName);
cmd.Parameters.AddWithValue("@BranchCode", obj.BranchCode);
cmd.Parameters.AddWithValue("@BranchName", obj.BranchName);
cmd.Parameters.AddWithValue("@AccountID", obj.AccountID);
new Database(connectionstring).ExecuteNonQueryOnly(cmd);
}
catch (Exception exc)
{
throw exc;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
string vMessage = string.Empty;
if (txtName.Text.Trim() == string.Empty)
{
Message.ShowMessage(MyMessages.MessageType.MissingInfo, "Please Enter Account Title.");
txtName.Focus();
return;
}
Objects.BankAccounts obj = new Objects.BankAccounts();
obj.BankAccountID = int.Parse(txtID.Text);
obj.AccountTitle = txtName.Text.Trim();
obj.BankName = txtBankName.Text.Trim();
obj.BranchName = txtBranchName.Text.Trim();
obj.BranchCode = txtBranchCode.Text.Trim();
obj.AccountID = txtID.Tag.ToString();
decimal vOpDebit = 0;
decimal vOpCredit = 0;
decimal.TryParse(this.txtOpDebit.Text, out vOpDebit);
decimal.TryParse(this.txtOpCredit.Text, out vOpCredit);
var AccDAL = new DAL.AccountChart();
AccDAL.connectionstring = objDAL.connectionstring;
Objects.AccountChart objAcc = new Objects.AccountChart();
objAcc.AccountNo = obj.AccountID;
objAcc.AccountTitle = obj.AccountTitle;
objAcc.AccountType = "ASSET";
objAcc.AccountSubType = "Banks";
objAcc.IsParty = false;
objAcc.IsBank = true;
objAcc.OpeningDebit = vOpDebit;
objAcc.OpeningCredit = vOpCredit;
if (!vOpenMode)
{
//Insert Account
objAcc.AccountNo = AccDAL.getNextNo("ASSET").ToString();
AccDAL.InsertRecord(objAcc);
//Insert Bank Account
obj.BankAccountID = int.Parse(objDAL.getNextNo().ToString());
obj.AccountID = objAcc.AccountNo;
objDAL.InsertRecord(obj);
}
else
{
AccDAL.UpdateRecord(objAcc);
objDAL.UpdateRecord(obj);
}
Message.ShowMessage(MyMessages.MessageType.SaveRecord);
LoadGrid();
btnClear_Click(sender, e);
}
catch (Exception exc)
{
Message.ShowMessage(MyMessages.MessageType.Error, exc.Message);
}
}