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); }