internal Bank_Account_Transactions Get_Bank_Account_Transaction_Details_By_Transaction_Id(
int p_Bank_Account_Transaction_Id,
int p_User_Id_Bank_Account_Transaction_Owner,
int p_User_Id_Searching_For_Bank_Account_Transaction_Details)
{
Bank_Account_Transactions Bank_Account_Transaction_To_Return = new Bank_Account_Transactions();
SqlParameter spBank_Account_Transaction_Record_Id = new SqlParameter("@Bank_Account_Transaction_Record_Id", SqlDbType.Int);
SqlParameter spUser_Id_Bank_Account_Transaction_Owner = new SqlParameter("@User_Id_Bank_Account_Transaction_Owner", SqlDbType.Int);
SqlParameter spUser_Id_Searching_For_Bank_Account_Transaction_Details = new SqlParameter("@User_Id_Searching_For_Bank_Account_Transaction_Details", SqlDbType.Int);
spBank_Account_Transaction_Record_Id.Value = p_Bank_Account_Transaction_Id;
spUser_Id_Bank_Account_Transaction_Owner.Value = p_User_Id_Bank_Account_Transaction_Owner;
spUser_Id_Searching_For_Bank_Account_Transaction_Details.Value = p_User_Id_Searching_For_Bank_Account_Transaction_Details;
var dataSet = SQLHelper.SelectUsingStoredProcedure_WithDefaultAppConfigConnectionString("p_TLBoard_Get_Bank_Account_Transaction_Details",
new List <SqlParameter>()
{
spBank_Account_Transaction_Record_Id, spUser_Id_Bank_Account_Transaction_Owner, spUser_Id_Searching_For_Bank_Account_Transaction_Details
});
if (dataSet != null && dataSet.Tables[0].Rows.Count > 0)
{
Bank_Account_Transaction_To_Return = Create_Bank_Account_Transaction_Details_From_Data_Row(dataSet.Tables[0].Rows[0]);
}
return(Bank_Account_Transaction_To_Return);
}
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_Account_Transactions transactionDetails = Business_Logic_Layer_Facade.Instance.BankAccount_Transactions_Get_Transaction_Details_By_Transaction_Id(
Bank_Account_Id, user_Id_BankAccount_Owner, user_Id_BankAccount_Owner);
if (transactionDetails != null)
{
Common_Tools.Set_Number_Text_Value_To_TextBox_Label_Text(
transactionDetails.Transaction_Account_Balance,
this.textbox_Transaction_Account_Balance,
this.label_Transaction_Account_Balance);
Common_Tools.Set_DateTime_To_TextBox_And_Label(
transactionDetails.Transaction_Actual_DateTime,
this.textbox_Transaction_Actual_DateTime,
this.label_Transaction_Actual_DateTime);
Common_Tools.Set_Number_Text_Value_To_TextBox_Label_Text(
transactionDetails.Positive_Amount_Entered,
this.textbox_Positive_Amount_Entered,
this.label_Positive_Amount_Entered);
Common_Tools.Set_Number_Text_Value_To_TextBox_Label_Text(
transactionDetails.Negative_Amount_Paid,
this.textbox_Negative_Amount_Paid,
this.label_Negative_Amount_Paid);
Common_Tools.Set_DateTime_To_TextBox_And_Label(
transactionDetails.Transaction_Value_DateTime,
this.textbox_Transaction_Value_DateTime,
this.label_Transaction_Value_DateTime);
this.textbox_Reference_Number.Text = transactionDetails.Reference_Number;
this.label_Reference_Number.Text = transactionDetails.Reference_Number;
this.textbox_Transaction_Bank_Description.Text = transactionDetails.Transaction_Bank_Description;
this.label_Transaction_Bank_Description.Text = transactionDetails.Transaction_Bank_Description;
this.textbox_Transaction_Bank_Inner_Reference_Code.Text = transactionDetails.Transaction_Bank_Inner_Reference_Code;
this.label_Transaction_Bank_Inner_Reference_Code.Text = transactionDetails.Transaction_Bank_Inner_Reference_Code;
this.textbox_Transaction_User_Description.Text = transactionDetails.Transaction_User_Description;
this.label_Transaction_User_Description.Text = transactionDetails.Transaction_User_Description;
this.textbox_Transaction_User_Comments.Text = transactionDetails.Transaction_User_Comments;
this.label_Transaction_User_Comments.Text = transactionDetails.Transaction_User_Comments;
this.checkbox_Is_Visible_To_Anonymous_Users.Checked = transactionDetails.Is_Visible_To_Anonymous_Users;
this.label_Is_Visible_To_Anonymous_Users.Text = transactionDetails.Is_Visible_To_Anonymous_Users ? "Yes" : "No";
this.checkbox_Is_Visible_To_Followers_Users.Checked = transactionDetails.Is_Visible_To_Followers_Users;
this.label_Is_Visible_To_Followers_Users.Text = transactionDetails.Is_Visible_To_Followers_Users ? "Yes" : "No";
this.label_Record_Created_By_User.Text = transactionDetails.Record_Created_By_User_Details.FullName_With_Email;
this.label_Record_Creation_DateTime_UTC.Text = transactionDetails.Record_Creation_DateTime_UTC.ToString("dd/MM/yyyy HH:mm:ss UTC");
this.label_Record_Last_Updated_By_User.Text = transactionDetails.Record_Last_Updated_By_User_Details.FullName_With_Email.ToString();
this.label_Record_Last_Updated_DateTime_UTC.Text = transactionDetails.Record_Last_Updated_DateTime_UTC.ToString("dd/MM/yyyy HH:mm:ss UTC");
}
else
{
throw new Exception("Could not find any details for the transction.");
}
}
internal Bank_Account_Transactions Insert_New_Bank_Account_Transaction_Details(
int p_Bank_Account_Id,
decimal p_Transaction_Account_Balance,
DateTime p_Transaction_Actual_DateTime,
decimal p_Positive_Amount_Entered,
decimal p_Negative_Amount_Paid,
DateTime?p_Transaction_Value_DateTime,
string p_Reference_Number,
string p_Transaction_Bank_Description,
string p_Transaction_Bank_Inner_Reference_Code,
bool p_Is_Visible_To_Anonymous_Users,
bool p_Is_Visible_To_Followers_Users,
int p_Creating_User_Id
)
{
Bank_Account_Transactions new_Registered_Bank_Account_Transaction_To_Return = null;
SqlParameter spBank_Account_Id = new SqlParameter("@Bank_Account_Id", SqlDbType.Int);
SqlParameter spTransaction_Account_Balance = new SqlParameter("@Transaction_Account_Balance", SqlDbType.Decimal);
SqlParameter spTransaction_Actual_DateTime = new SqlParameter("@Transaction_Actual_DateTime", SqlDbType.DateTime);
SqlParameter spPositive_Amount_Entered = new SqlParameter("@Positive_Amount_Entered", SqlDbType.Decimal);
SqlParameter spNegative_Amount_Paid = new SqlParameter("@Negative_Amount_Paid", SqlDbType.Decimal);
SqlParameter spTransaction_Value_DateTime = new SqlParameter("@Transaction_Value_DateTime", SqlDbType.DateTime);
SqlParameter spReference_Number = new SqlParameter("@Reference_Number", SqlDbType.NVarChar, 40);
SqlParameter spTransaction_Bank_Description = new SqlParameter("@Transaction_Bank_Description", SqlDbType.NVarChar, 40);
SqlParameter spTransaction_Bank_Inner_Reference_Code = new SqlParameter("@Transaction_Bank_Inner_Reference_Code", SqlDbType.NVarChar, 15);
SqlParameter spIs_Visible_To_Anonymous_Users = new SqlParameter("@Is_Visible_To_Anonymous_Users", SqlDbType.Bit);
SqlParameter spIs_Visible_To_Followers_Users = new SqlParameter("@Is_Visible_To_Followers_Users", SqlDbType.Bit);
SqlParameter spCreating_User_Id = new SqlParameter("@Creating_User_Id", SqlDbType.Int);
spBank_Account_Id.Value = p_Bank_Account_Id;
spTransaction_Account_Balance.Value = p_Transaction_Account_Balance;
spTransaction_Actual_DateTime.Value = p_Transaction_Actual_DateTime;
spPositive_Amount_Entered.Value = p_Positive_Amount_Entered;
spNegative_Amount_Paid.Value = p_Negative_Amount_Paid;
if (p_Transaction_Value_DateTime.HasValue)
{
spTransaction_Value_DateTime.Value = p_Transaction_Value_DateTime.Value;
}
else
{
spTransaction_Value_DateTime.Value = DBNull.Value;
}
spReference_Number.Value = p_Reference_Number;
spTransaction_Bank_Description.Value = p_Transaction_Bank_Description;
spTransaction_Bank_Inner_Reference_Code.Value = p_Transaction_Bank_Inner_Reference_Code;
spIs_Visible_To_Anonymous_Users.Value = p_Is_Visible_To_Anonymous_Users;
spIs_Visible_To_Followers_Users.Value = p_Is_Visible_To_Followers_Users;
spCreating_User_Id.Value = p_Creating_User_Id;
object new_Bank_Account_Transaction_Id = SQLHelper.ExecuteStoredProcedure_ReturnDataObjectResult(
"p_TLBoard_Insert_Bank_Account_Transaction_Details",
new List <SqlParameter>()
{
spBank_Account_Id,
spTransaction_Account_Balance,
spTransaction_Actual_DateTime,
spPositive_Amount_Entered,
spNegative_Amount_Paid,
spTransaction_Value_DateTime,
spReference_Number,
spTransaction_Bank_Description,
spTransaction_Bank_Inner_Reference_Code,
spIs_Visible_To_Anonymous_Users,
spIs_Visible_To_Followers_Users,
spCreating_User_Id
});
if (new_Bank_Account_Transaction_Id != null)
{
int Bank_Account_Transaction_Id_Registered = Convert.ToInt32(new_Bank_Account_Transaction_Id);
if (Bank_Account_Transaction_Id_Registered > 0)
{
new_Registered_Bank_Account_Transaction_To_Return = Get_Bank_Account_Transaction_Details_By_Transaction_Id(
Bank_Account_Transaction_Id_Registered,
p_Creating_User_Id,
p_Creating_User_Id);
}
}
return(new_Registered_Bank_Account_Transaction_To_Return);
}
private Bank_Account_Transactions Create_Bank_Account_Transaction_Details_From_Data_Row(DataRow dbRow)
{
Bank_Account_Transactions Bank_Account_Transaction_To_Return = new Bank_Account_Transactions();
Bank_Account_Transaction_To_Return.Bank_Account_Transaction_Id = Convert.ToInt32(dbRow["Bank_Account_Transaction_Id"]);
Bank_Account_Transaction_To_Return.Bank_Account_Id = Convert.ToInt32(dbRow["Bank_Account_Id"]);
if (dbRow["Transaction_Account_Balance"] != DBNull.Value)
{
Bank_Account_Transaction_To_Return.Transaction_Account_Balance = (decimal)dbRow["Transaction_Account_Balance"];
}
else
{
Bank_Account_Transaction_To_Return.Transaction_Account_Balance = 0;
}
Bank_Account_Transaction_To_Return.Transaction_Actual_DateTime = (DateTime)dbRow["Transaction_Actual_DateTime"];
if (dbRow["Positive_Amount_Entered"] != DBNull.Value)
{
Bank_Account_Transaction_To_Return.Positive_Amount_Entered = (decimal)dbRow["Positive_Amount_Entered"];
}
if (dbRow["Negative_Amount_Paid"] != DBNull.Value)
{
Bank_Account_Transaction_To_Return.Negative_Amount_Paid = (decimal)dbRow["Negative_Amount_Paid"];
}
if (dbRow["Transaction_Value_DateTime"] != DBNull.Value)
{
Bank_Account_Transaction_To_Return.Transaction_Value_DateTime = (DateTime)dbRow["Transaction_Value_DateTime"];
}
Bank_Account_Transaction_To_Return.Reference_Number = dbRow["Reference_Number"].ToString();
Bank_Account_Transaction_To_Return.Transaction_Bank_Description = dbRow["Transaction_Bank_Description"].ToString();
Bank_Account_Transaction_To_Return.Transaction_Bank_Inner_Reference_Code = dbRow["Transaction_Bank_Inner_Reference_Code"].ToString();
if (dbRow.Table.Columns.IndexOf("Transaction_User_Description") > -1)
{
Bank_Account_Transaction_To_Return.Transaction_User_Description = dbRow["Transaction_User_Description"].ToString();
}
if (dbRow.Table.Columns.IndexOf("Transaction_User_Comments") > -1)
{
Bank_Account_Transaction_To_Return.Transaction_User_Comments = dbRow["Transaction_User_Comments"].ToString();
}
if (dbRow.Table.Columns.IndexOf("Record_Created_By_User_Id") > -1)
{
Bank_Account_Transaction_To_Return.Record_Created_By_User_Id = (int)dbRow["Record_Created_By_User_Id"];
if (dbRow.Table.Columns.IndexOf("Created_By_First_Name") > -1)
{
Bank_Account_Transaction_To_Return.Record_Created_By_User_Details = new Users();
Bank_Account_Transaction_To_Return.Record_Created_By_User_Details.First_Name = dbRow["Created_By_First_Name"].ToString();
Bank_Account_Transaction_To_Return.Record_Created_By_User_Details.Last_Name = dbRow["Created_By_Last_Name"].ToString();
}
Bank_Account_Transaction_To_Return.Record_Creation_DateTime_UTC = (DateTime)dbRow["Record_Creation_DateTime_UTC"];
Bank_Account_Transaction_To_Return.Record_Last_Updated_By_User_Id = (int)dbRow["Record_Last_Updated_By_User_Id"];
if (dbRow.Table.Columns.IndexOf("Last_Updated_By_First_Name") > -1)
{
Bank_Account_Transaction_To_Return.Record_Last_Updated_By_User_Details = new Users();
Bank_Account_Transaction_To_Return.Record_Last_Updated_By_User_Details.First_Name = dbRow["Last_Updated_By_First_Name"].ToString();
Bank_Account_Transaction_To_Return.Record_Last_Updated_By_User_Details.Last_Name = dbRow["Last_Updated_By_Last_Name"].ToString();
}
Bank_Account_Transaction_To_Return.Record_Last_Updated_DateTime_UTC = (DateTime)dbRow["Record_Last_Updated_DateTime_UTC"];
}
Bank_Account_Transaction_To_Return.Is_Visible_To_Anonymous_Users = (bool)dbRow["Is_Visible_To_Anonymous_Users"];
Bank_Account_Transaction_To_Return.Is_Visible_To_Followers_Users = (bool)dbRow["Is_Visible_To_Followers_Users"];
return(Bank_Account_Transaction_To_Return);
}
