internal Bank_Accounts Get_Bank_Account_Details_By_Bank_Account_Id(int p_Bank_Account_Id, int p_User_Id_Bank_Account_Owner)
{
Bank_Accounts Bank_Account_To_Return = new Bank_Accounts();
SqlParameter spBank_Account_Id = new SqlParameter("@Bank_Account_Id", SqlDbType.Int);
SqlParameter spUser_Id = new SqlParameter("@User_Id", SqlDbType.Int);
spBank_Account_Id.Value = p_Bank_Account_Id;
spUser_Id.Value = p_User_Id_Bank_Account_Owner;
var dataSet = SQLHelper.SelectUsingStoredProcedure_WithDefaultAppConfigConnectionString("p_TLBoard_Get_Bank_Account_Details",
new List <SqlParameter>()
{
spBank_Account_Id, spUser_Id
});
if (dataSet != null && dataSet.Tables[0].Rows.Count > 0)
{
Bank_Account_To_Return = Create_Bank_Account_Details_From_Data_Row(dataSet.Tables[0].Rows[0]);
}
return(Bank_Account_To_Return);
}
protected void button_Create_Bank_Account_Click(object sender, EventArgs e)
{
if (this.Page.IsValid)
{
bool l_Bank_Account_Successfully_Created = false;
int l_New_Bank_Account_Id = 0;
string exception_During_Process = "";
string exception_During_Process_Extra_Data = "";
int p_User_Id = base.Authenticated_User_ID;
string p_Bank_Name = this.textbox_Bank_Name.Text;
string p_Bank_Number = this.textbox_Bank_Number.Text;
string p_Branch_Name = this.textbox_Branch_Name.Text;
string p_Branch_Number = this.textbox_Branch_Number.Text;
string p_Account_Number = this.textbox_Account_Number.Text;
string p_Account_Name = this.textbox_Account_Name.Text;
string p_IBAN = this.textbox_IBAN.Text;
byte?p_Currency_Id = new byte?();
if (!string.IsNullOrEmpty(this.dropdown_Currency.SelectedValue))
{
p_Currency_Id = byte.Parse(this.dropdown_Currency.SelectedValue);
}
DateTime?p_Opened_Account_DateTime = new DateTime?();
if (!string.IsNullOrEmpty(this.textbox_Opened_Account_DateTime.Text))
{
bool parsed_Successfully = false;
DateTime date_Parsed = new DateTime();
try
{
parsed_Successfully = DateTime.TryParseExact(this.textbox_Opened_Account_DateTime.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out date_Parsed);
}
catch
{
parsed_Successfully = false;
}
if (parsed_Successfully)
{
p_Opened_Account_DateTime = date_Parsed;
}
}
short?p_Branch_Country_Id = new short?();
short?p_Branch_State_Id = new short?();
if (!string.IsNullOrEmpty(this.dropdown_Branch_Country.SelectedValue))
{
p_Branch_Country_Id = short.Parse(this.dropdown_Branch_Country.SelectedValue);
if (!string.IsNullOrEmpty(this.dropdown_Branch_State.SelectedValue))
{
p_Branch_State_Id = short.Parse(this.dropdown_Branch_State.SelectedValue);
}
}
string p_Branch_City = this.textbox_Branch_City.Text;
string p_Branch_Address_Description = this.textbox_Branch_Address.Text;
string p_Branch_ZipCode = this.textbox_Branch_Address.Text;
string p_Branch_Phone = this.textbox_Branch_Phone.Text;
string p_Branch_Main_Email_Address = this.textbox_Branch_Main_Email_Address.Text;
string p_Branch_Main_Contact = this.textbox_Branch_Main_Contact.Text;
string p_Main_Contact_Phone_Number = this.textbox_Main_Contact_Phone_Number.Text;
DateTime?p_Account_Active_From_Date = new DateTime?();
if (!string.IsNullOrEmpty(this.textbox_Account_Active_From_Date.Text))
{
bool parsed_Successfully = false;
DateTime date_Parsed = new DateTime();
try
{
parsed_Successfully = DateTime.TryParseExact(this.textbox_Account_Active_From_Date.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out date_Parsed);
}
catch
{
parsed_Successfully = false;
}
if (parsed_Successfully)
{
p_Account_Active_From_Date = date_Parsed;
}
}
DateTime?p_Account_Active_To_Date = new DateTime?();
if (!string.IsNullOrEmpty(this.textbox_Account_Active_To_Date.Text))
{
bool parsed_Successfully = false;
DateTime date_Parsed = new DateTime();
try
{
parsed_Successfully = DateTime.TryParseExact(this.textbox_Account_Active_To_Date.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out date_Parsed);
}
catch
{
parsed_Successfully = false;
}
if (parsed_Successfully)
{
p_Account_Active_To_Date = date_Parsed;
}
}
bool p_Is_Visible_To_Anonymous_Users = this.checkbox_Is_Visible_To_Anonymous_Users.Checked;
bool p_Is_Available_For_Download_For_Anonymous_Users = this.checkbox_Is_Available_For_Download_For_Anonymous_Users.Checked;
bool p_Is_Visible_To_Followers_Users = this.checkbox_Is_Visible_To_Followers_Users.Checked;
bool p_Is_Available_For_Download_For_Followers_Users = this.checkbox_Is_Available_For_Download_For_Followers_Users.Checked;
bool p_Is_Active = this.checkbox_Is_Active.Checked;
Bank_Accounts new_Bank_Account_Details = null;
try
{
new_Bank_Account_Details = Business_Logic_Layer_Facade.Instance.BankAccounts_Insert_New_Bank_Account_Details(
p_Bank_Name, p_Bank_Number, p_Branch_Name,
p_Branch_Number, p_Account_Number, p_Account_Name,
p_IBAN, p_Currency_Id, p_Opened_Account_DateTime,
p_Branch_Country_Id, p_Branch_State_Id, p_Branch_City,
p_Branch_Address_Description, p_Branch_ZipCode, p_Branch_Phone,
p_Branch_Main_Email_Address, p_Branch_Main_Contact, p_Main_Contact_Phone_Number,
p_Account_Active_From_Date, p_Account_Active_To_Date,
p_Is_Visible_To_Anonymous_Users, p_Is_Available_For_Download_For_Anonymous_Users,
p_Is_Visible_To_Followers_Users, p_Is_Available_For_Download_For_Followers_Users,
p_Is_Active, p_User_Id
);
l_New_Bank_Account_Id = new_Bank_Account_Details.Bank_Account_Id;
l_Bank_Account_Successfully_Created = true;
}
catch (Exception exc)
{
exception_During_Process = exc.Message;
if (exc.InnerException != null)
{
exception_During_Process_Extra_Data = exc.InnerException.Message;
}
}
if (l_Bank_Account_Successfully_Created && l_New_Bank_Account_Id > 0)
{
// The user details was successfully created..
// Show success message and redirect the user to view page or back to users page (depends on where the user came from)
Response.Redirect("list_BankAccounts.aspx");
}
else
{
// show error message to the user for the failed process
this.lbl_Insert_Process_Error_Result.Text = exception_During_Process;
if (!string.IsNullOrEmpty(exception_During_Process_Extra_Data))
{
this.lbl_Insert_Process_Error_Result.Text += " (" + exception_During_Process_Extra_Data + ")";
}
}
}
}
private void Set_Page_FormControls_Values()
{
int Bank_Account_Id = int.Parse(this.Request.QueryString["id"]);
int user_Id_BankAccount_Owner = base.Authenticated_User_ID;
Bank_Accounts BankAccountDetails = Business_Logic_Layer_Facade.Instance.BankAccounts_Get_Bank_Account_Details(
Bank_Account_Id, user_Id_BankAccount_Owner);
if (BankAccountDetails != null)
{
this.textbox_Bank_Name.Text = BankAccountDetails.Bank_Name;
this.label_Bank_Name.Text = BankAccountDetails.Bank_Name;
this.textbox_Bank_Number.Text = BankAccountDetails.Bank_Number;
this.label_Bank_Number.Text = BankAccountDetails.Bank_Number;
this.textbox_Branch_Name.Text = BankAccountDetails.Branch_Name;
this.label_Branch_Name.Text = BankAccountDetails.Branch_Name;
this.textbox_Branch_Number.Text = BankAccountDetails.Branch_Number;
this.label_Branch_Number.Text = BankAccountDetails.Branch_Number;
this.textbox_Account_Number.Text = BankAccountDetails.Account_Number;
this.label_Account_Number.Text = BankAccountDetails.Account_Number;
this.textbox_Account_Name.Text = BankAccountDetails.Account_Name;
this.label_Account_Name.Text = BankAccountDetails.Account_Name;
this.textbox_IBAN.Text = BankAccountDetails.IBAN;
this.label_IBAN.Text = BankAccountDetails.IBAN;
this.textbox_IBAN.Text = BankAccountDetails.IBAN;
this.label_Currency.Text = BankAccountDetails.IBAN;
Common_Tools.Set_ComboBox_Selected_Value_And_Label_Text(
BankAccountDetails.Currency_Id.ToString(),
this.dropdown_Currency,
this.label_Currency);
Common_Tools.Set_DateTime_To_TextBox_And_Label(
BankAccountDetails.Opened_Account_DateTime,
this.textbox_Opened_Account_DateTime,
this.label_Opened_Account_DateTime);
Common_Tools.Set_ComboBox_Selected_Value_And_Label_Text(
BankAccountDetails.Branch_Country_Id.ToString(),
this.dropdown_Branch_Country,
this.label_Branch_Country);
this.Bind_States_ComboBox();
if (BankAccountDetails.Branch_State_Id.HasValue)
{
Common_Tools.Set_ComboBox_Selected_Value_And_Label_Text(
BankAccountDetails.Branch_State_Id.ToString(),
this.dropdown_Branch_State,
this.label_Branch_State);
}
this.textbox_Branch_City.Text = BankAccountDetails.Branch_City;
this.label_Branch_City.Text = BankAccountDetails.Branch_City;
this.textbox_Branch_Address.Text = BankAccountDetails.Branch_Address;
this.label_Branch_Address.Text = BankAccountDetails.Branch_Address;
this.textbox_Branch_Zipcode.Text = BankAccountDetails.Branch_Zipcode;
this.label_Branch_Zipcode.Text = BankAccountDetails.Branch_Zipcode;
this.textbox_Branch_Zipcode.Text = BankAccountDetails.Branch_Zipcode;
this.label_Branch_Zipcode.Text = BankAccountDetails.Branch_Zipcode;
this.textbox_Branch_Phone.Text = BankAccountDetails.Branch_Phone;
this.label_Branch_Phone.Text = BankAccountDetails.Branch_Phone;
this.textbox_Branch_Main_Email_Address.Text = BankAccountDetails.Branch_Main_Email_Address;
this.label_Branch_Main_Email_Address.Text = BankAccountDetails.Branch_Main_Email_Address;
this.textbox_Branch_Main_Contact.Text = BankAccountDetails.Branch_Main_Contact;
this.label_Branch_Main_Contact.Text = BankAccountDetails.Branch_Main_Contact;
this.textbox_Main_Contact_Phone_Number.Text = BankAccountDetails.Main_Contact_Phone_Number;
this.label_Main_Contact_Phone_Number.Text = BankAccountDetails.Main_Contact_Phone_Number;
Common_Tools.Set_DateTime_To_TextBox_And_Label(
BankAccountDetails.Account_Active_From_Date,
this.textbox_Account_Active_From_Date,
this.label_Account_Active_From_Date);
Common_Tools.Set_DateTime_To_TextBox_And_Label(
BankAccountDetails.Account_Active_To_Date,
this.textbox_Account_Active_To_Date,
this.label_Account_Active_To_Date);
this.checkbox_Is_Visible_To_Anonymous_Users.Checked = BankAccountDetails.Is_Visible_To_Anonymous_Users;
this.label_Is_Visible_To_Anonymous_Users.Text = BankAccountDetails.Is_Visible_To_Anonymous_Users ? "Yes" : "No";
this.checkbox_Is_Available_For_Download_For_Anonymous_Users.Checked = BankAccountDetails.Is_Available_For_Download_For_Anonymous_Users;
this.label_Is_Available_For_Download_For_Anonymous_Users.Text = BankAccountDetails.Is_Available_For_Download_For_Anonymous_Users ? "Yes" : "No";
this.checkbox_Is_Visible_To_Followers_Users.Checked = BankAccountDetails.Is_Visible_To_Followers_Users;
this.label_Is_Visible_To_Followers_Users.Text = BankAccountDetails.Is_Visible_To_Followers_Users ? "Yes" : "No";
this.checkbox_Is_Available_For_Download_For_Followers_Users.Checked = BankAccountDetails.Is_Available_For_Download_For_Followers_Users;
this.label_Is_Available_For_Download_For_Followers_Users.Text = BankAccountDetails.Is_Available_For_Download_For_Followers_Users ? "Yes" : "No";
this.checkbox_Is_Active.Checked = BankAccountDetails.Is_Active;
this.label_Is_Active.Text = BankAccountDetails.Is_Active ? "Yes" : "No";
this.label_Record_Created_By_User.Text = BankAccountDetails.Record_Created_By_User_Details.FullName_With_Email;
this.label_Record_Creation_DateTime_UTC.Text = BankAccountDetails.Record_Creation_DateTime_UTC.ToString("dd/MM/yyyy HH:mm:ss UTC");
this.label_Record_Last_Updated_By_User.Text = BankAccountDetails.Record_Last_Updated_By_User_Details.FullName_With_Email.ToString();
this.label_Record_Last_Updated_DateTime_UTC.Text = BankAccountDetails.Record_Last_Updated_DateTime_UTC.ToString("dd/MM/yyyy HH:mm:ss UTC");
}
}
internal Bank_Accounts Insert_New_Bank_Account_Details(
string p_Bank_Name, string p_Bank_Number,
string p_Branch_Name, string p_Branch_Number,
string p_Account_Number, string p_Account_Name,
string p_IBAN, byte?p_Currency_Id,
DateTime?p_Opened_Account_DateTime, short?p_Branch_Country_Id,
short?p_Branch_State_Id, string p_Branch_City,
string p_Branch_Address_Description, string p_Branch_ZipCode,
string p_Branch_Phone, string p_Branch_Main_Email_Address,
string p_Branch_Main_Contact, string p_Main_Contact_Phone_Number,
DateTime?p_Account_Active_From_Date, DateTime?p_Account_Active_To_Date,
bool p_Is_Visible_To_Anonymous_Users, bool p_Is_Available_For_Download_For_Anonymous_Users,
bool p_Is_Visible_To_Followers_Users, bool p_Is_Available_For_Download_For_Followers_Users,
bool p_Is_Active,
int p_Creating_User_Id)
{
Bank_Accounts new_Registered_Bank_Account_To_Return = null;
SqlParameter spBank_Name = new SqlParameter("@Bank_Name", SqlDbType.NVarChar, 40);
SqlParameter spBank_Number = new SqlParameter("@Bank_Number", SqlDbType.NVarChar, 10);
SqlParameter spBranch_Name = new SqlParameter("@Branch_Name", SqlDbType.NVarChar, 40);
SqlParameter spBranch_Number = new SqlParameter("@Branch_Number", SqlDbType.NVarChar, 50);
SqlParameter spAccount_Number = new SqlParameter("@Account_Number", SqlDbType.NVarChar, 50);
SqlParameter spAccount_Name = new SqlParameter("@Account_Name", SqlDbType.NVarChar, 50);
SqlParameter spIBAN = new SqlParameter("@IBAN", SqlDbType.NVarChar, 50);
SqlParameter spCurrency_Id = new SqlParameter("@Currency_Id", SqlDbType.TinyInt);
SqlParameter spOpened_Account_DateTime = new SqlParameter("@Opened_Account_DateTime", SqlDbType.DateTime);
SqlParameter spBranch_Country_Id = new SqlParameter("@Branch_Country_Id", SqlDbType.SmallInt);
SqlParameter spBranch_State_Id = new SqlParameter("@Branch_State_Id", SqlDbType.SmallInt);
SqlParameter spBranch_City = new SqlParameter("@Branch_City", SqlDbType.NVarChar, 100);
SqlParameter spBranch_Address_Description = new SqlParameter("@Branch_Address_Description", SqlDbType.NVarChar, 255);
SqlParameter spBranch_ZipCode = new SqlParameter("@Branch_ZipCode", SqlDbType.NVarChar, 20);
SqlParameter spBranch_Phone = new SqlParameter("@Branch_Phone", SqlDbType.NVarChar, 50);
SqlParameter spBranch_Main_Email_Address = new SqlParameter("@Branch_Main_Email_Address", SqlDbType.NVarChar, 100);
SqlParameter spBranch_Main_Contact = new SqlParameter("@Branch_Main_Contact", SqlDbType.NVarChar, 100);
SqlParameter spMain_Contact_Phone_Number = new SqlParameter("@Main_Contact_Phone_Number", SqlDbType.NVarChar, 50);
SqlParameter spAccount_Active_From_Date = new SqlParameter("@Account_Active_From_Date", SqlDbType.DateTime);
SqlParameter spAccount_Active_To_Date = new SqlParameter("@Account_Active_To_Date", SqlDbType.DateTime);
SqlParameter spIs_Visible_To_Anonymous_Users = new SqlParameter("@Is_Visible_To_Anonymous_Users", SqlDbType.Bit);
SqlParameter spIs_Available_For_Download_For_Anonymous_Users = new SqlParameter("@Is_Available_For_Download_For_Anonymous_Users", SqlDbType.Bit);
SqlParameter spIs_Visible_To_Followers_Users = new SqlParameter("@Is_Visible_To_Followers_Users", SqlDbType.Bit);
SqlParameter spIs_Available_For_Download_For_Followers_Users = new SqlParameter("@Is_Available_For_Download_For_Followers_Users", SqlDbType.Bit);
SqlParameter spIs_Active = new SqlParameter("@Is_Active", SqlDbType.Bit);
SqlParameter spCreating_User_Id = new SqlParameter("@Creating_User_Id", SqlDbType.Int);
spBank_Name.Value = p_Bank_Name;
spBank_Number.Value = p_Bank_Number;
spBranch_Name.Value = p_Branch_Name;
spBranch_Number.Value = p_Branch_Number;
spAccount_Number.Value = p_Account_Number;
spAccount_Name.Value = p_Account_Name;
spIBAN.Value = p_IBAN;
if (p_Currency_Id.HasValue)
{
spCurrency_Id.Value = p_Currency_Id;
}
else
{
spCurrency_Id.Value = DBNull.Value;
}
if (p_Opened_Account_DateTime.HasValue)
{
spOpened_Account_DateTime.Value = p_Opened_Account_DateTime.Value;
}
else
{
spOpened_Account_DateTime.Value = DBNull.Value;
}
if (p_Branch_Country_Id.HasValue)
{
spBranch_Country_Id.Value = p_Branch_Country_Id;
}
else
{
spBranch_Country_Id.Value = DBNull.Value;
}
if (p_Branch_State_Id.HasValue)
{
spBranch_State_Id.Value = p_Branch_State_Id.Value;
}
else
{
spBranch_State_Id.Value = DBNull.Value;
}
spBranch_City.Value = p_Branch_City;
spBranch_Address_Description.Value = p_Branch_Address_Description;
spBranch_ZipCode.Value = p_Branch_ZipCode;
spBranch_Phone.Value = p_Branch_Phone;
spBranch_Main_Email_Address.Value = p_Branch_Main_Email_Address;
spBranch_Main_Contact.Value = p_Branch_Main_Contact;
spMain_Contact_Phone_Number.Value = p_Main_Contact_Phone_Number;
if (p_Account_Active_From_Date.HasValue)
{
spAccount_Active_From_Date.Value = p_Account_Active_From_Date;
}
else
{
spAccount_Active_From_Date.Value = DBNull.Value;
}
if (p_Account_Active_To_Date.HasValue)
{
spAccount_Active_To_Date.Value = p_Account_Active_To_Date;
}
else
{
spAccount_Active_To_Date.Value = DBNull.Value;
}
spIs_Visible_To_Anonymous_Users.Value = p_Is_Visible_To_Anonymous_Users;
spIs_Available_For_Download_For_Anonymous_Users.Value = p_Is_Available_For_Download_For_Anonymous_Users;
spIs_Visible_To_Followers_Users.Value = p_Is_Visible_To_Followers_Users;
spIs_Available_For_Download_For_Followers_Users.Value = p_Is_Available_For_Download_For_Followers_Users;
spIs_Active.Value = p_Is_Active;
spCreating_User_Id.Value = p_Creating_User_Id;
object new_Bank_Account_Id = SQLHelper.ExecuteStoredProcedure_ReturnDataObjectResult("p_TLBoard_Insert_Bank_Account_Details",
new List <SqlParameter>()
{
spBank_Name,
spBank_Number,
spBranch_Name,
spBranch_Number,
spAccount_Number,
spAccount_Name,
spIBAN,
spCurrency_Id,
spOpened_Account_DateTime,
spBranch_Country_Id,
spBranch_State_Id,
spBranch_City,
spBranch_Address_Description,
spBranch_ZipCode,
spBranch_Phone,
spBranch_Main_Email_Address,
spBranch_Main_Contact,
spMain_Contact_Phone_Number,
spAccount_Active_From_Date,
spAccount_Active_To_Date,
spIs_Visible_To_Anonymous_Users,
spIs_Available_For_Download_For_Anonymous_Users,
spIs_Visible_To_Followers_Users,
spIs_Available_For_Download_For_Followers_Users,
spIs_Active,
spCreating_User_Id
});
if (new_Bank_Account_Id != null)
{
int Bank_Account_Id_Registered = Convert.ToInt32(new_Bank_Account_Id);
if (Bank_Account_Id_Registered > 0)
{
new_Registered_Bank_Account_To_Return = Get_Bank_Account_Details_By_Bank_Account_Id(Bank_Account_Id_Registered, p_Creating_User_Id);
}
}
return(new_Registered_Bank_Account_To_Return);
}
private Bank_Accounts Create_Bank_Account_Details_From_Data_Row(DataRow dbRow)
{
Bank_Accounts Bank_Account_To_Return = new Bank_Accounts();
Bank_Account_To_Return.Bank_Account_Id = Convert.ToInt32(dbRow["Bank_Account_Id"]);
Bank_Account_To_Return.User_Id = Convert.ToInt32(dbRow["User_Id"]);
Bank_Account_To_Return.Bank_Name = dbRow["Bank_Name"].ToString();
Bank_Account_To_Return.Bank_Number = dbRow["Bank_Number"].ToString();
Bank_Account_To_Return.Branch_Name = dbRow["Branch_Name"].ToString();
Bank_Account_To_Return.Branch_Number = dbRow["Branch_Number"].ToString();
Bank_Account_To_Return.Account_Number = dbRow["Account_Number"].ToString();
Bank_Account_To_Return.Account_Name = dbRow["Account_Name"].ToString();
Bank_Account_To_Return.IBAN = dbRow["IBAN"].ToString();
if (dbRow["Currency_Id"] != DBNull.Value)
{
Bank_Account_To_Return.Currency_Id = (byte)dbRow["Currency_Id"];
if (dbRow.Table.Columns.IndexOf("Currency_Symbol") > -1)
{
Bank_Account_To_Return.Currency_Symbol = dbRow["Currency_Symbol"].ToString();
}
}
if (dbRow.Table.Columns.IndexOf("Latest_Transaction_Actual_DateTime") > -1 &&
dbRow["Latest_Transaction_Actual_DateTime"] != DBNull.Value)
{
Bank_Account_To_Return.Latest_Transaction_Actual_DateTime = (DateTime)dbRow["Latest_Transaction_Actual_DateTime"];
if (dbRow["Latest_Transaction_Account_Balance"] != DBNull.Value)
{
Bank_Account_To_Return.Latest_Transaction_Account_Balance = (decimal)dbRow["Latest_Transaction_Account_Balance"];
}
}
if (dbRow["Opened_Account_DateTime"] != DBNull.Value)
{
Bank_Account_To_Return.Opened_Account_DateTime = (DateTime)dbRow["Opened_Account_DateTime"];
}
if (dbRow["Branch_Country_Id"] != DBNull.Value)
{
Bank_Account_To_Return.Branch_Country_Id = (short)dbRow["Branch_Country_Id"];
if (dbRow.Table.Columns.IndexOf("Branch_Country_Name") > -1)
{
Bank_Account_To_Return.Branch_Country_Name = dbRow["Branch_Country_Name"].ToString();
}
if (dbRow["Branch_State_Id"] != DBNull.Value)
{
Bank_Account_To_Return.Branch_State_Id = (short)dbRow["Branch_State_Id"];
}
}
Bank_Account_To_Return.Branch_City = dbRow["Branch_City"].ToString();
if (dbRow.Table.Columns.IndexOf("Branch_Address_Description") > -1)
{
Bank_Account_To_Return.Branch_Address = dbRow["Branch_Address_Description"].ToString();
Bank_Account_To_Return.Branch_Zipcode = dbRow["Branch_ZipCode"].ToString();
}
if (dbRow.Table.Columns.IndexOf("Branch_Phone") > -1)
{
Bank_Account_To_Return.Branch_Phone = dbRow["Branch_Phone"].ToString();
}
if (dbRow.Table.Columns.IndexOf("Branch_Main_Email_Address") > -1)
{
Bank_Account_To_Return.Branch_Main_Email_Address = dbRow["Branch_Main_Email_Address"].ToString();
}
if (dbRow.Table.Columns.IndexOf("Branch_Main_Contact") > -1)
{
Bank_Account_To_Return.Branch_Main_Contact = dbRow["Branch_Main_Contact"].ToString();
}
if (dbRow.Table.Columns.IndexOf("Main_Contact_Phone_Number") > -1)
{
Bank_Account_To_Return.Main_Contact_Phone_Number = dbRow["Main_Contact_Phone_Number"].ToString();
}
if (dbRow.Table.Columns.IndexOf("Account_Active_From_Date") > -1)
{
if (dbRow["Account_Active_From_Date"] != DBNull.Value)
{
Bank_Account_To_Return.Account_Active_From_Date = (DateTime)dbRow["Account_Active_From_Date"];
}
if (dbRow["Account_Active_To_Date"] != DBNull.Value)
{
Bank_Account_To_Return.Account_Active_To_Date = (DateTime)dbRow["Account_Active_To_Date"];
}
}
Bank_Account_To_Return.Is_Visible_To_Anonymous_Users = (bool)dbRow["Is_Visible_To_Anonymous_Users"];
Bank_Account_To_Return.Is_Available_For_Download_For_Anonymous_Users = (bool)dbRow["Is_Available_For_Download_For_Anonymous_Users"];
Bank_Account_To_Return.Is_Visible_To_Followers_Users = (bool)dbRow["Is_Visible_To_Followers_Users"];
Bank_Account_To_Return.Is_Available_For_Download_For_Followers_Users = (bool)dbRow["Is_Available_For_Download_For_Followers_Users"];
if (dbRow.Table.Columns.IndexOf("Record_Creation_DateTime_UTC") > -1)
{
Bank_Account_To_Return.Record_Created_By_User_Id = Convert.ToInt32(dbRow["Record_Created_By_User_Id"]);
Bank_Account_To_Return.Record_Created_By_User_Details = new Users();
Bank_Account_To_Return.Record_Created_By_User_Details.User_Id = Bank_Account_To_Return.Record_Created_By_User_Id;
if (dbRow.Table.Columns.IndexOf("Created_By_First_Name") > -1)
{
Bank_Account_To_Return.Record_Created_By_User_Details.First_Name = dbRow["Created_By_First_Name"].ToString();
Bank_Account_To_Return.Record_Created_By_User_Details.Last_Name = dbRow["Created_By_Last_Name"].ToString();
}
Bank_Account_To_Return.Record_Creation_DateTime_UTC = (DateTime)dbRow["Record_Creation_DateTime_UTC"];
Bank_Account_To_Return.Record_Last_Updated_By_User_Id = Convert.ToInt32(dbRow["Record_Last_Updated_By_User_Id"]);
Bank_Account_To_Return.Record_Last_Updated_By_User_Details = new Users();
Bank_Account_To_Return.Record_Last_Updated_By_User_Details.User_Id = Bank_Account_To_Return.Record_Last_Updated_By_User_Id;
if (dbRow.Table.Columns.IndexOf("Last_Updated_By_First_Name") > -1)
{
Bank_Account_To_Return.Record_Last_Updated_By_User_Details.First_Name = dbRow["Last_Updated_By_First_Name"].ToString();
Bank_Account_To_Return.Record_Last_Updated_By_User_Details.Last_Name = dbRow["Last_Updated_By_Last_Name"].ToString();
}
Bank_Account_To_Return.Record_Last_Updated_DateTime_UTC = (DateTime)dbRow["Record_Last_Updated_DateTime_UTC"];
}
Bank_Account_To_Return.Is_Active = (bool)dbRow["Is_Active"];
Bank_Account_To_Return.Is_Deleted = (bool)dbRow["Is_Deleted"];
return(Bank_Account_To_Return);
}
