public static bool Insert(AccountHolderType objAccountHolderType)
{
ISalesPOSDBManager dbManager = new SalesPOSDBManager();
Boolean chk = false;
try
{
dbManager.Open();
IDbDataParameter[] param = SalesPOSDBManagerFactory.GetParameters(dbManager.ProviderType, 5);
//param[0] = dbManager.getparam("@UnitId", objUnitInfo.UnitId.ToString());
param[0] = dbManager.getparam("@AccountHolderType", objAccountHolderType.AccountHolderTypeName.ToString());
param[1] = dbManager.getparam("@ActivityID", objAccountHolderType.ActivityID.ToString());
param[2] = dbManager.getparam("@CreatedDate", objAccountHolderType.CreatedDate);
param[3] = dbManager.getparam("@CreatedBy", objAccountHolderType.CreatedBy.ToString());
param[4] = dbManager.getparam("@AccountHolderTypePrefix", objAccountHolderType.AccountHolderTypePrefix.ToString());
IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "USP_AccountHolderType_Add", param);
chk = dbManager.ExecuteQuery(cmd);
}
catch (Exception ex)
{
return(false);
}
finally
{
dbManager.Dispose();
}
return(chk);
}
/// <summary>
/// Adds a <see cref="BankPaymentAccount"/> with the specified account details
/// to the specified user
/// </summary>
/// <param name="customerId"></param>
/// <param name="accountHolderName"></param>
/// <param name="accountHolderType"></param>
/// <param name="accountNumber"></param>
/// <param name="routingNumber"></param>
/// <param name="country"></param>
/// <param name="currency"></param>
/// <returns></returns>
public async Task <BankPaymentAccount> AddBankAccountAsync(
string customerId,
string accountHolderName,
AccountHolderType accountHolderType,
string accountNumber,
string routingNumber,
string country = "US",
string currency = "usd")
{
var formData = new List <KeyValuePair <string, string> >();
string accountHolderTypeValue;
switch (accountHolderType)
{
case AccountHolderType.Individual:
accountHolderTypeValue = "individual";
break;
case AccountHolderType.Company:
accountHolderTypeValue = "company";
break;
default:
throw new ArgumentException(string.Format(
"Invalid value for {0}", nameof(AccountHolderType)));
}
formData.Add(new KeyValuePair <string, string>("source[object]", "bank_account"));
formData.Add(new KeyValuePair <string, string>("source[currency]", currency));
formData.Add(new KeyValuePair <string, string>("source[country]", country));
formData.Add(new KeyValuePair <string, string>("source[account_holder_name]", accountHolderName));
formData.Add(new KeyValuePair <string, string>("source[account_holder_type]", accountHolderTypeValue));
formData.Add(new KeyValuePair <string, string>("source[account_number]", accountNumber));
formData.Add(new KeyValuePair <string, string>("source[routing_number]", routingNumber));
var result = await _client.PostFormDataAsync <BankPaymentAccount>($"customers/{customerId}/sources", formData);
if (_client.HasError)
{
return(null);
}
return(result);
}
/// <summary>
/// Converts a AccountHolderType value to a corresponding string value
/// </summary>
/// <param name="enumValue">The AccountHolderType value to convert</param>
/// <returns>The representative string value</returns>
public static string ToValue(AccountHolderType enumValue)
{
switch (enumValue)
{
//only valid enum elements can be used
//this is necessary to avoid errors
case AccountHolderType.INDIVIDUAL:
case AccountHolderType.BUSINESS:
case AccountHolderType.SOLE_TRADER:
case AccountHolderType.JOINT:
case AccountHolderType.BANKING_AS_A_SERVICE:
return(StringValues[(int)enumValue]);
//an invalid enum value was requested
default:
return(null);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (isValid())
{
if (!this._isNew) //(this.btnAdd.Enabled)
{
//this._GridRowSelectedIndex = this.dgvUnitList.SelectedRows[0].Index;
if (_SelctedAccountHolderTypeId > 0)
{
//update here
bool chk = true;
AccountHolderType objAccountHolderType = new AccountHolderType();
objAccountHolderType.AccountHolderTypeID = this._SelctedAccountHolderTypeId;
objAccountHolderType.AccountHolderTypeName = this.txtAccountHolderTypeName.Text.Trim();
objAccountHolderType.AccountHolderTypePrefix = this.txtPrefix.Text.ToUpper();
objAccountHolderType.ActivityID = Convert.ToInt64(this.cmbActivity.SelectedValue);
objAccountHolderType.UpdatedBy = 1;
objAccountHolderType.UpdatedDate = DateTime.Now;
DataTable dt1 = bllAccountHolderType.IsDuplicate_AccountHolder_Type(this._SelctedAccountHolderTypeId, this.txtAccountHolderTypeName.Text.ToString(), "Update");
if (dt1.Rows.Count > 0)
{
MessageBox.Show("Duplicate Account Holder Type Found. Please change the Account Holder Type.");
this.txtAccountHolderTypeName.Focus();
this.txtAccountHolderTypeName.SelectAll();
//this._isNew = true;
}
else
{
chk = bllAccountHolderType.Update(objAccountHolderType);
if (chk)
{
LoadGrid();
//show success message here
MessageBox.Show("Successfully Updated the record.");
ClearFields();
this._isNew = true;
}
}
}
else
{
MessageBox.Show("No data found for update.");
}
}
else
{
//this._GridRowSelectedIndex = this.dgvUnitList.Rows.Count;
bool chk = true;
//insert validation method
//insert here
AccountHolderType objAccountHolderType = new AccountHolderType();
objAccountHolderType.AccountHolderTypeName = this.txtAccountHolderTypeName.Text.Trim();
objAccountHolderType.AccountHolderTypePrefix = this.txtPrefix.Text.ToUpper();
objAccountHolderType.ActivityID = Convert.ToInt64(this.cmbActivity.SelectedValue);
objAccountHolderType.CreatedBy = 1;
objAccountHolderType.CreatedDate = DateTime.Now;
DataTable dt1 = bllAccountHolderType.IsDuplicate_AccountHolder_Type(0, this.txtAccountHolderTypeName.Text.ToString(), "Update");
if (dt1.Rows.Count > 0)
{
MessageBox.Show("Duplicate Account Holder Type Found. Please change the Account Holder Type.");
this.txtAccountHolderTypeName.Focus();
txtAccountHolderTypeName.SelectAll();
//this._isNew = true;
}
else
{
chk = bllAccountHolderType.Insert(objAccountHolderType);
if (chk)
{
LoadGrid();
ClearFields();
this._isNew = true;
}
}
}
}
}
