internal Credit_Cards_Statement_Transaction Get_Credit_Card_Statement_Transaction_Details( int p_User_ID_Bank_Owner, long p_Credit_Card_Statement_Transaction_Id, int p_User_ID_Searching) { Credit_Cards_Statement_Transaction ccStatement_Transactions_To_Return = null; SqlParameter spUser_Id_Bank_Owner = new SqlParameter("@User_Id_Bank_Owner", SqlDbType.Int); SqlParameter spCredit_Card_Statement_Transaction_Id = new SqlParameter("@Credit_Card_Statement_Transaction_Id", SqlDbType.BigInt); SqlParameter spSearching_User_Idarching = new SqlParameter("@User_ID_Searching", SqlDbType.Int); spUser_Id_Bank_Owner.Value = p_User_ID_Bank_Owner; spCredit_Card_Statement_Transaction_Id.Value = p_Credit_Card_Statement_Transaction_Id; spSearching_User_Idarching.Value = p_User_ID_Searching; var dataSet = SQLHelper.SelectUsingStoredProcedure_WithDefaultAppConfigConnectionString( "p_TLBoard_Get_Credit_Card_Statement_Transaction_Details", new List <SqlParameter>() { spUser_Id_Bank_Owner, spCredit_Card_Statement_Transaction_Id, spSearching_User_Idarching }); if (dataSet != null && dataSet.Tables[0].Rows.Count > 0) { ccStatement_Transactions_To_Return = Create_Credit_Card_Statement_Details_From_Data_Row(dataSet.Tables[0].Rows[0]); } return(ccStatement_Transactions_To_Return); }
private Credit_Cards_Statement_Transaction Create_Credit_Card_Statement_Details_From_Data_Row(DataRow dbRow) { Credit_Cards_Statement_Transaction Credit_Card_Statement_To_Return = new Credit_Cards_Statement_Transaction(); Credit_Card_Statement_To_Return.Credit_Card_Statement_Transaction_Id = Convert.ToInt32(dbRow["Credit_Card_Statement_Transaction_Id"]); Credit_Card_Statement_To_Return.Bank_Account_Credit_Card_Statement_Id = Convert.ToInt32(dbRow["Bank_Account_Credit_Card_Statement_Id"]); if (dbRow.Table.Columns.IndexOf("Bank_Account_Owner_User_Id") > -1) { Credit_Card_Statement_To_Return.Bank_Account_Owner_User_Id = Convert.ToInt32(dbRow["Bank_Account_Owner_User_Id"]); } if (dbRow["Transaction_Date"] != DBNull.Value) { Credit_Card_Statement_To_Return.Transaction_Date = (DateTime)dbRow["Transaction_Date"]; } else { Credit_Card_Statement_To_Return.Transaction_Date = null; } Credit_Card_Statement_To_Return.Business_Name = dbRow["Business_Name"].ToString(); if (dbRow["Transaction_Amount"] != DBNull.Value) { Credit_Card_Statement_To_Return.Transaction_Amount = Convert.ToDecimal(dbRow["Transaction_Amount"]); } else { Credit_Card_Statement_To_Return.Transaction_Amount = null; } if (dbRow["Transaction_Amount_Currency_Id"] != DBNull.Value) { Credit_Card_Statement_To_Return.Transaction_Amount_Currency_Id = Convert.ToByte(dbRow["Transaction_Amount_Currency_Id"]); } else { Credit_Card_Statement_To_Return.Transaction_Amount_Currency_Id = null; } if (dbRow["Transaction_Actual_Payment_Amount"] != DBNull.Value) { Credit_Card_Statement_To_Return.Transaction_Actual_Payment_Amount = Convert.ToDecimal(dbRow["Transaction_Actual_Payment_Amount"]); } else { Credit_Card_Statement_To_Return.Transaction_Actual_Payment_Amount = null; } Credit_Card_Statement_To_Return.Description = dbRow["Description"].ToString(); if (dbRow["Has_Been_Actually_Charged_In_Statement"] != DBNull.Value) { Credit_Card_Statement_To_Return.Has_Been_Actually_Charged_In_Statement = (bool)dbRow["Has_Been_Actually_Charged_In_Statement"]; } else { Credit_Card_Statement_To_Return.Has_Been_Actually_Charged_In_Statement = false; } if (dbRow["Total_Charged_In_Statement"] != DBNull.Value) { Credit_Card_Statement_To_Return.Total_Charged_In_Statement = Convert.ToDecimal(dbRow["Total_Charged_In_Statement"]); } else { Credit_Card_Statement_To_Return.Total_Charged_In_Statement = null; } Credit_Card_Statement_To_Return.User_Description = dbRow["User_Description"].ToString(); Credit_Card_Statement_To_Return.User_Comments = dbRow["User_Comments"].ToString(); Credit_Card_Statement_To_Return.Is_Visible_To_Anonymous_Users = (bool)dbRow["Is_Visible_To_Anonymous_Users"]; Credit_Card_Statement_To_Return.Is_Available_For_Download_For_Anonymous_Users = (bool)dbRow["Is_Available_For_Download_For_Anonymous_Users"]; Credit_Card_Statement_To_Return.Is_Visible_To_Followers_Users = (bool)dbRow["Is_Visible_To_Followers_Users"]; Credit_Card_Statement_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) { Credit_Card_Statement_To_Return.Record_Created_By_User_Id = Convert.ToInt32(dbRow["Record_Created_By_User_Id"]); Credit_Card_Statement_To_Return.Record_Created_By_User_Details = new Users(); Credit_Card_Statement_To_Return.Record_Created_By_User_Details.User_Id = Credit_Card_Statement_To_Return.Record_Created_By_User_Id; if (dbRow.Table.Columns.IndexOf("Created_By_First_Name") > -1) { Credit_Card_Statement_To_Return.Record_Created_By_User_Details.First_Name = dbRow["Created_By_First_Name"].ToString(); Credit_Card_Statement_To_Return.Record_Created_By_User_Details.Last_Name = dbRow["Created_By_Last_Name"].ToString(); } Credit_Card_Statement_To_Return.Record_Creation_DateTime_UTC = (DateTime)dbRow["Record_Creation_DateTime_UTC"]; Credit_Card_Statement_To_Return.Record_Last_Updated_By_User_Id = Convert.ToInt32(dbRow["Record_Last_Updated_By_User_Id"]); Credit_Card_Statement_To_Return.Record_Last_Updated_By_User_Details = new Users(); Credit_Card_Statement_To_Return.Record_Last_Updated_By_User_Details.User_Id = Credit_Card_Statement_To_Return.Record_Last_Updated_By_User_Id; if (dbRow.Table.Columns.IndexOf("Last_Updated_By_First_Name") > -1) { Credit_Card_Statement_To_Return.Record_Last_Updated_By_User_Details.First_Name = dbRow["Last_Updated_By_First_Name"].ToString(); Credit_Card_Statement_To_Return.Record_Last_Updated_By_User_Details.Last_Name = dbRow["Last_Updated_By_Last_Name"].ToString(); } Credit_Card_Statement_To_Return.Record_Last_Updated_DateTime_UTC = (DateTime)dbRow["Record_Last_Updated_DateTime_UTC"]; } Credit_Card_Statement_To_Return.Is_Deleted = (bool)dbRow["Is_Deleted"]; return(Credit_Card_Statement_To_Return); }