public static int insertAccountInfo(BankAccounts ObjBAcc, int UserId = 0)
{
List <SqlParameter> prm = new List <SqlParameter>();
try
{
using (DbManager DB = DbManager.GetDbManager())
{
prm.Add(DB.MakeInParam("@intbankaccounttypeid", SqlDbType.Int, 0, ObjBAcc._bankaccounttypeid));
prm.Add(DB.MakeInParam("@bankName", SqlDbType.NVarChar, 120, ObjBAcc.BankName));
prm.Add(DB.MakeInParam("@branch", SqlDbType.NVarChar, 120, ObjBAcc.BranchName));
prm.Add(DB.MakeInParam("@accountTitle", SqlDbType.NVarChar, 120, ObjBAcc.AccountTitle));
prm.Add(DB.MakeInParam("@accountNumber", SqlDbType.NVarChar, 120, ObjBAcc.AccountNumber));
prm.Add(DB.MakeInParam("@routingNumber", SqlDbType.NVarChar, 120, ObjBAcc.RoutingNumber));
prm.Add(DB.MakeInParam("@IBANNumber", SqlDbType.NVarChar, 120, ObjBAcc.IBANNumber));
prm.Add(DB.MakeInParam("@swiftCode", SqlDbType.NVarChar, 120, ObjBAcc.SwiftCode));
prm.Add(DB.MakeInParam("@streetName", SqlDbType.NVarChar, 150, ObjBAcc.StreetName));
prm.Add(DB.MakeInParam("@streetNumber", SqlDbType.NVarChar, 50, ObjBAcc.StreetNumber));
prm.Add(DB.MakeInParam("@city", SqlDbType.NVarChar, 75, ObjBAcc.City));
prm.Add(DB.MakeInParam("@zipCode", SqlDbType.NVarChar, 10, ObjBAcc.ZipCode));
prm.Add(DB.MakeInParam("@primaryPhone", SqlDbType.NVarChar, 20, ObjBAcc.PrimaryPhone));
prm.Add(DB.MakeInParam("@stateid", SqlDbType.Int, 4, ObjBAcc.StateId));
prm.Add(DB.MakeInParam("@intUserId", SqlDbType.Int, 0, UserId));
prm.Add(DB.MakeInParam("@IsETF", SqlDbType.Bit, 0, ObjBAcc._isetf));
DB.RunProc("up_InsertBankAccounts", prm.ToArray());
}
}
catch (Exception ex)
{
new SqlLog().InsertSqlLog(0, "BankAccounts.InsertAccountInfo", ex);
}
return(0);
}
public static int insertAccountInfo(BankAccounts ObjBAcc, int UserId = 0)
{
List<SqlParameter> prm = new List<SqlParameter>();
try
{
using (DbManager DB = DbManager.GetDbManager())
{
prm.Add(DB.MakeInParam("@intbankaccounttypeid", SqlDbType.Int, 0, ObjBAcc._bankaccounttypeid));
prm.Add(DB.MakeInParam("@bankName", SqlDbType.NVarChar, 120, ObjBAcc.BankName));
prm.Add(DB.MakeInParam("@branch", SqlDbType.NVarChar, 120, ObjBAcc.BranchName));
prm.Add(DB.MakeInParam("@accountTitle", SqlDbType.NVarChar, 120, ObjBAcc.AccountTitle));
prm.Add(DB.MakeInParam("@accountNumber", SqlDbType.NVarChar, 120, ObjBAcc.AccountNumber));
prm.Add(DB.MakeInParam("@routingNumber", SqlDbType.NVarChar, 120, ObjBAcc.RoutingNumber));
prm.Add(DB.MakeInParam("@IBANNumber", SqlDbType.NVarChar, 120, ObjBAcc.IBANNumber));
prm.Add(DB.MakeInParam("@swiftCode", SqlDbType.NVarChar, 120, ObjBAcc.SwiftCode));
prm.Add(DB.MakeInParam("@streetName", SqlDbType.NVarChar, 150, ObjBAcc.StreetName));
prm.Add(DB.MakeInParam("@streetNumber", SqlDbType.NVarChar, 50, ObjBAcc.StreetNumber));
prm.Add(DB.MakeInParam("@city", SqlDbType.NVarChar, 75, ObjBAcc.City));
prm.Add(DB.MakeInParam("@zipCode", SqlDbType.NVarChar, 10, ObjBAcc.ZipCode));
prm.Add(DB.MakeInParam("@primaryPhone", SqlDbType.NVarChar, 20, ObjBAcc.PrimaryPhone));
prm.Add(DB.MakeInParam("@stateid", SqlDbType.Int, 4, ObjBAcc.StateId));
prm.Add(DB.MakeInParam("@intUserId", SqlDbType.Int, 0, UserId));
prm.Add(DB.MakeInParam("@IsETF", SqlDbType.Bit, 0, ObjBAcc._isetf));
DB.RunProc("up_InsertBankAccounts", prm.ToArray());
}
}
catch (Exception ex)
{
new SqlLog().InsertSqlLog(0, "BankAccounts.InsertAccountInfo", ex);
}
return 0;
}