public static DataSet GetEyeWashsByCriteriaDS(string fieldnames, string criteria, params SqlParameter[] @params)
{
DBAccess db = new DBAccess();
string query = "";
query += "SELECT ";
if (fieldnames.Trim() != "")
{
query += fieldnames;
}
else
{
query += " * ";
}
query += " FROM vw_Co2Db_EyeWash ";
query += " WHERE ( @IsAgent = 0 OR ( @IsAgent = 1 AND [AgentID] = @AgentID ) )";
if (criteria != "")
{
query += " AND (" + criteria + ")";
}
db.CommandType = CommandType.Text;
db.CommandText = query;
db.AddRange(@params);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
DataSet ds = db.ExecuteDataSet(); //(_SQLSelectByGuid)
return(ds);
}
public static DataSet GetLogLinesByCriteriaDS(string fieldnames, string criteria, string GroupBY, params SqlParameter[] @params)
{
DBAccess db = new DBAccess();
string query = "";
query += "SELECT ";
if (fieldnames.Trim() != "")
{
query += fieldnames;
}
else
{
query += " * ";
}
query += " FROM vw_Co2Db_LogLine ";
if (criteria != "")
{
query += " WHERE (" + criteria + ")";
}
if (GroupBY != "")
{
query += " GROUP BY " + GroupBY;
}
db.CommandType = CommandType.Text;
db.CommandText = query;
db.AddRange(@params);
DataSet ds = db.ExecuteDataSet(); //(_SQLSelectByGuid)
return(ds);
}
public static DataSet GetPageContentsByCriteriaDS(string fieldnames, string criteria, params SqlParameter[] @params)
{
DBAccess db = new DBAccess();
string query = "";
query += "SELECT ";
if (fieldnames.Trim() != "")
{
query += fieldnames;
}
else
{
query += " * ";
}
query += " FROM vw_Co2Db_HtmlPageContent ";
query += " WHERE ( @IsAgent = 0 OR ( @IsAgent = 1 AND [AgentID] = @AgentID ) )";
if (criteria != "")
{
query += " AND (" + criteria + ")";
}
db.CommandType = CommandType.Text;
db.CommandText = query;
db.AddRange(@params);
DataSet ds = db.ExecuteDataSet();
return(ds);
}
public static List <EyeWash> GetEyeWashsByCriteria(string OrderBY, string criteria, params SqlParameter[] @params)
{
DBAccess db = new DBAccess();
//Dim conn As SqlConnection = DataFunctions.GetConnection()
string query = "";
query += "SELECT ";
if (OrderBY != "")
{
query += " TOP (100) PERCENT ";
}
query += " * FROM vw_Co2Db_EyeWash ";
query += " WHERE ( @IsAgent = 0 OR ( @IsAgent = 1 AND [AgentID] = @AgentID ) )";
if (criteria != "")
{
query += " AND (" + criteria + ")";
}
if (OrderBY != "")
{
query += " ORDER BY " + OrderBY;
}
//Dim cmd As New SqlCommand(query, conn)
db.CommandType = CommandType.Text;
db.CommandText = query;
db.AddRange(@params);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
db.Open();
SqlDataReader dr = (SqlDataReader)(db.ExecuteReader()); //cmd.ExecuteReader()
List <EyeWash> list = new List <EyeWash>();
while (dr.Read())
{
EyeWash _EyeWash = new EyeWash();
EyeWash.Populate(dr, _EyeWash);
list.Add(_EyeWash);
}
db.Dispose();
return(list);
}
public static List <PageContent> GetPageContentsByCriteria(string OrderBY, string criteria, params SqlParameter[] @params)
{
DBAccess db = new DBAccess();
//Dim conn As SqlConnection = DataFunctions.GetConnection()
string query = "";
query += "SELECT ";
if (OrderBY != "")
{
query += " TOP (100) PERCENT ";
}
query += " * FROM vw_Co2Db_HtmlPageContent ";
query += " WHERE ( @IsAgent = 0 OR ( @IsAgent = 1 AND [AgentID] = @AgentID ) )";
if (criteria != "")
{
query += " AND (" + criteria + ")";
}
if (OrderBY != "")
{
query += " ORDER BY " + OrderBY;
}
//Dim cmd As New SqlCommand(query, conn)
db.CommandType = CommandType.Text;
db.CommandText = query;
db.AddRange(@params);
db.Open();
SqlDataReader dr = (SqlDataReader)(db.ExecuteReader());
List <PageContent> list = new List <PageContent>();
while (dr.Read())
{
PageContent pc = new PageContent();
PageContent.Populate(dr, pc);
list.Add(pc);
}
db.Dispose();
return(list);
}
public static List <Korrespondance> GetKorrespondancesByCriteria(string OrderBY, string criteria, params SqlParameter[] @params)
{
DBAccess db = new DBAccess();
//Dim conn As SqlConnection = DataFunctions.GetConnection()
string query = "";
query += "SELECT ";
if (OrderBY != "")
{
query += " TOP (100) PERCENT ";
}
query += " *";
query += " FROM vw_Co2Db_Korrespondance ";
if (criteria != "")
{
query += " WHERE (" + criteria + ")";
}
if (OrderBY != "")
{
query += " ORDER BY " + OrderBY;
}
//Dim cmd As New SqlCommand(query, conn)
db.CommandType = CommandType.Text;
db.CommandText = query;
db.AddRange(@params);
db.Open();
SqlDataReader dr = (SqlDataReader)(db.ExecuteReader()); //cmd.ExecuteReader()
List <Korrespondance> list = new List <Korrespondance>();
while (dr.Read())
{
Korrespondance Korr = new Korrespondance();
Populate(dr, Korr);
list.Add(Korr);
}
db.Dispose();
return(list);
}
