public DataTable LedgerItemsRaw(int Guarantor, bool IsPulledStatus)
{
DataTable rValdtWorking = new DataTable();
MySqlConnection con = new MySqlConnection(this._MySqlConnectionString);
try
{
con.Open();
MySqlDataAdapter da = new MySqlDataAdapter(PP_ODSQLPullStrings_LedgerItem.PullAll_FromOD(Guarantor, IsPulledStatus), con);
da.Fill(rValdtWorking);
}
catch (Exception exc)
{
exc.ToString();
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
for (int i = 0; i < Columns.Length; i++) // If exception is thrown here I want to know it because it means my columns array is not right.
{
rValdtWorking.Columns[i].ColumnName = Columns[i];
}
return(rValdtWorking);
}
/// <summary>
/// Returns the Number of Guarantors
/// </summary>
/// <param name="Guarantor"></param>
/// <param name="IsPulledStatus"></param>
/// <returns></returns>
public int LedgerItemsRawCount(int Guarantor, bool IsPulledStatus)
{
DataTable rValdtWorking = new DataTable();
int ItemsInRawQuery = -1;
MySqlConnection con = new MySqlConnection(this._MySqlConnectionString);
try
{
con.Open();
string command = PP_ODSQLPullStrings_LedgerItem.PullAll_FromOD(Guarantor, IsPulledStatus);
command = "SELECT Count(Distinct (tb1.Guarantor)) FROM ( " + command + ") as tb1";
MySqlDataAdapter da = new MySqlDataAdapter(command, con);
da.Fill(rValdtWorking);
if (rValdtWorking != null && rValdtWorking.Rows.Count != 0 && rValdtWorking.Columns.Count != 0)
{
if (rValdtWorking.Rows[0][0] != null)
{
ItemsInRawQuery = Int32.Parse(rValdtWorking.Rows[0][0].ToString());
}
}
}
catch (Exception exc)
{
exc.ToString();
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(ItemsInRawQuery);
}