public StatDAL()
{
db = new DBConnect();
}
public ActualiteDAL()
{
db = new DBConnect();
}
/// <summary>
/// GetInfoSet - Fetch the mutliple record from the database based on SQL Query
/// </summary>
/// <param name="sQuery">String</param>
/// <returns>DataSet</returns>
public static DataSet GetInfoSet(string sQuery)
{
DBConnect obj;
DataSet ds = null;
try
{
obj = new DBConnect();
ds = obj.FetchMultipleTable(sQuery);
}
catch
{
ds = null;
}
finally
{
obj = null;
}
return ds;
}
/// <summary>
/// GetInfoById - Fetch the Single record from the database based on SQL Query
/// </summary>
/// <param name="sQuery">String</param>
/// <returns>DataRow</returns>
public static DataRow GetInfoById(string sQuery)
{
DBConnect obj;
DataRow dr = null;
try
{
obj = new DBConnect();
dr = obj.FetchSingleRecord(sQuery);
}
catch
{
dr = null;
}
finally
{
obj = null;
}
return dr;
}
/// <summary>
/// GetInfo - Fetch the mutliple record from the database based on SQL Query
/// </summary>
/// <param name="sQuery">String</param>
/// <returns>DataTable</returns>
public static DataTable GetInfo(string sQuery)
{
DBConnect obj;
DataTable dt = null;
try
{
obj = new DBConnect();
dt = obj.FetchMultipleRecord(sQuery);
}
catch
{
dt = null;
}
finally
{
obj = null;
}
return dt;
}
public Log4NetDAL()
{
db = new DBConnect();
}
