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