/// <summary>
/// Get All by a table in DB with where Clause
/// </summary>
/// <param name="obj">a object in Model</param>
/// <param name="whereClause"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public static DataSet GetAllByDataSet(object obj, string whereClause, DGCParameter[] parameters)
{
DataSet ds = null;
Database db = CreateDB();
try
{
string query = GenerateQuery.CommandTextList(obj, whereClause);
DbCommand cmd = db.GetSqlStringCommand(query);
GenerateQuery.PrepareParametersList(cmd, parameters);
ds = db.ExecuteDataSet(cmd);
}
catch (Exception ex)
{
Write2Log.WriteLogs("DBHElper", "GetAllByDataSet(object obj, string whereClause, DGCParameter[] parameters)", ex.Message);
}
return(ds);
}
