public static System.Collections.Generic.List <AED_Trainer> GetAEDTrainerList(int CompanyID)
{
System.Collections.Generic.List <AED_Trainer> result = new System.Collections.Generic.List <AED_Trainer>();
int ID = -1;
DBAccess db = new DBAccess();
db.AddInt("CompanyID", CompanyID);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
SqlDataReader dr = default(SqlDataReader);
try
{
dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectIDByCompany));
if (dr.HasRows)
{
while (dr.Read())
{
ID = System.Convert.ToInt32(dr.DBtoInt("ID"));
result.Add(AED_Trainer.GetAED(ID));
}
}
dr.Close();
}
catch (Exception ex)
{
throw (ex);
}
return(result);
}
public static DataSet GetEyeWash_SearchAll(string Postnr, string SerialNo)
{
DataSet ds = new DataSet();
DataSet dsTemp = new DataSet();
bool flag = false;
DBAccess db = new DBAccess();
//Dim arr As String() = Search.Split(" "c)
//For Each s As String In arr
db.AddNVarChar("Postnr", Postnr, 50);
db.AddNVarChar("SerialNo", SerialNo, 50);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
// EXEC @return_value = [vicjos1_sysadm].[Co2Db_EyeWash_Search]
// @SerialNo = ''
// , @Postnr = '3400'
// , @IsAgent = 0
// , @AgentID = null
dsTemp = db.ExecuteDataSet(_SQLSearch);
db.Parameters.Clear();
ds.Merge(dsTemp);
if (flag == false)
{
DataColumn[] pk = new DataColumn[2];
pk[0] = ds.Tables[0].Columns["ID"];
ds.Tables[0].PrimaryKey = pk;
flag = true;
}
return(ds);
}
public static tilbudHeader GetTilbudByCompany(int CompanyID)
{
DBAccess db = new DBAccess();
tilbudHeader c = new tilbudHeader();
db.AddInt("CompanyID", CompanyID);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectByCompany));
if (dr.HasRows)
{
while (dr.Read())
{
Populate(dr, c);
}
dr.Close();
return(c);
}
else
{
dr.Close();
return(c); //Nothing
}
}
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 System.Collections.Generic.List <AED_Battery> GetBatteryList(int AED_FK)
{
System.Collections.Generic.List <AED_Battery> result = new System.Collections.Generic.List <AED_Battery>();
int ID = -1;
DBAccess db = new DBAccess();
db.AddInt("AED_FK", AED_FK);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
SqlDataReader dr = default(SqlDataReader);
//Try
dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectByAED));
if (dr.HasRows)
{
while (dr.Read())
{
ID = System.Convert.ToInt32(dr.DBtoInt("ID"));
result.Add(AED_Battery.GetBattery(ID));
}
}
dr.Close();
//Catch ex As Exception
//Throw ex
//End Try
return(result);
}
public static System.Collections.Generic.List <Aiva> GetAivaList()
{
System.Collections.Generic.List <Aiva> result = new System.Collections.Generic.List <Aiva>();
int ID = -1;
DBAccess db = new DBAccess();
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
SqlDataReader dr = default(SqlDataReader);
try
{
dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectAll));
if (dr.HasRows)
{
while (dr.Read())
{
Aiva pc = new Aiva();
Populate(dr, pc);
result.Add(pc);
}
}
dr.Close();
}
catch (Exception ex)
{
throw (ex);
}
return(result);
}
public static System.Collections.Generic.List <FirstAidBag_Service> GetBatteryListExpiredEmail(int CompanyID)
{
System.Collections.Generic.List <FirstAidBag_Service> result = new System.Collections.Generic.List <FirstAidBag_Service>();
int ID = -1;
DBAccess db = new DBAccess();
db.AddInt("CompanyID", CompanyID);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
SqlDataReader dr = default(SqlDataReader);
try
{
dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectAllExpiredEmail));
if (dr.HasRows)
{
while (dr.Read())
{
ID = System.Convert.ToInt32(dr.DBtoInt("ID"));
result.Add(FirstAidBag_Service.GetService(ID));
}
}
dr.Close();
}
catch (Exception ex)
{
throw (ex);
}
return(result);
}
public static List <AED_Service> GetServicesByAED(int AED_FK)
{
List <AED_Service> result = new List <AED_Service>();
int ID = -1;
DBAccess db = new DBAccess();
db.AddInt("AED_FK", AED_FK);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
SqlDataReader dr = default(SqlDataReader);
try
{
dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectByAED));
if (dr.HasRows)
{
while (dr.Read())
{
ID = System.Convert.ToInt32(dr.DBtoInt("ID"));
result.Add(AED_Service.GetService(ID));
}
}
dr.Close();
}
catch (Exception ex)
{
throw (ex);
}
return(result);
}
public static System.Collections.Generic.List <EyeWash> GetListSoonExpired(int CompanyID)
{
System.Collections.Generic.List <EyeWash> result = new System.Collections.Generic.List <EyeWash>();
int ID = -1;
DBAccess db = new DBAccess();
db.AddInt("CompanyID", CompanyID);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
SqlDataReader dr = default(SqlDataReader);
//Try
dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectAllSoonExpired));
if (dr.HasRows)
{
while (dr.Read())
{
ID = System.Convert.ToInt32(dr.DBtoInt("ID"));
result.Add(EyeWash.GetEyeWash(ID));
}
}
dr.Close();
//Catch ex As Exception
// Throw ex
//End Try
return(result);
}
public static DataSet Search_EyeWash(string Search)
{
DataSet ds = new DataSet();
DataSet dsTemp = new DataSet();
bool flag = false;
DBAccess db = new DBAccess();
string[] arr = Search.Split(' ');
foreach (string s in arr)
{
db.AddNVarChar("Search", s, 50);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
dsTemp = db.ExecuteDataSet(_SQLSelectBySearch);
db.Parameters.Clear();
//If dsTemp.Tables.Count > 0 Then
ds.Merge(dsTemp);
if (flag == false)
{
DataColumn[] pk = new DataColumn[2];
pk[0] = ds.Tables[0].Columns["ID"];
ds.Tables[0].PrimaryKey = pk;
flag = true;
}
//End If
}
return(ds);
}
public static AED_Trainer GetAED(System.Guid Guid)
{
DBAccess db = new DBAccess();
db.AddGuid("Guid", Guid);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectByGuid));
if (dr.HasRows)
{
AED_Trainer c = new AED_Trainer();
while (dr.Read())
{
Populate(dr, c);
}
dr.Close();
return(c);
}
else
{
dr.Close();
return(null);
}
}
public static DataSet GetAllAED()
{
DBAccess db = new DBAccess();
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
DataSet ds = db.ExecuteDataSet(_SQLSelectAll);
return(ds);
}
public static DataSet GetAivaByCompanyDS(int CompanyID)
{
DBAccess db = new DBAccess();
db.AddInt("CompanyID", CompanyID);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
DataSet ds = db.ExecuteDataSet(_SQLSelectCompanyID);
return(ds);
}
public static DataSet GetAllEyeWash()
{
DBAccess db = new DBAccess();
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
//db.Parameters.Add(New SqlParameter("@sUserName", username))
DataSet ds = db.ExecuteDataSet(_SQLSelectAll);
return(ds);
}
public static DataSet GetBatteryByAED(int AED_FK)
{
DBAccess db = new DBAccess();
db.AddInt("AED_FK", AED_FK);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
DataSet ds = db.ExecuteDataSet(_SQLSelectByAED);
return(ds);
}
public static DataSet GetBottleByEYE(int EYE_FK)
{
DBAccess db = new DBAccess();
db.AddInt("EYE_FK", EYE_FK);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
DataSet ds = db.ExecuteDataSet(_SQLSelectByEYE);
return(ds);
}
public static DataSet GetAllTilbud(TilbudStatusEnum status)
{
DBAccess db = new DBAccess();
db.AddInt("status", System.Convert.ToInt32(status));
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
DataSet ds = db.ExecuteDataSet(_SQLSelectByStatus);
return(ds);
}
public static DataSet GetEyeWashbyGUID_DS(Guid GuID)
{
DBAccess db = new DBAccess();
db.AddGuid("Guid", GuID);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
DataSet ds = db.ExecuteDataSet(_SQLSelectByGuid);
return(ds);
}
public static int GetEyeWashcountByCompany(int CompanyID)
{
int res = 0;
DBAccess db = new DBAccess();
db.AddInt("CompanyID", CompanyID);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
res = Funktioner.ToInt(db.ExecuteScalar(_SQLCountByCompany));
return(res);
}
public static DataSet GetEyeWashbyBilagStatus(int CompanyID, int BilagStatus)
{
DBAccess db = new DBAccess();
db.AddInt("CompanyID", CompanyID);
db.AddInt("BilagStatus", BilagStatus);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
DataSet ds = db.ExecuteDataSet(_SQLSelectByBilagStatus);
return(ds);
}
public static DataSet SelectAllExpired(int CompanyID, int Status, int ExpireTime, DateTime ExpireDate)
{
DBAccess db = new DBAccess();
db.AddInt("CompanyID", CompanyID);
db.AddInt("Status", Status);
db.AddInt("ExpireTime", ExpireTime);
db.AddDateTime("ExpireDate", ExpireDate);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
DataSet ds = db.ExecuteDataSet(_SQLSelectAllExpired);
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 int GetCompanyTilbudCount(int CompanyID)
{
DBAccess db = new DBAccess();
db.AddInt("CompanyID", CompanyID);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
int res = 0;
try
{
res = Funktioner.ToInt(db.ExecuteScalar(_SQLSelectByCompanyCount));
}
catch (Exception)
{
res = 0;
}
return(res);
}
public static FirstAidBag_Service GetService(System.Guid Guid)
{
FirstAidBag_Service c = new FirstAidBag_Service();
DBAccess db = new DBAccess();
db.AddGuid("Guid", Guid);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectByGuid));
if (dr.HasRows)
{
while (dr.Read())
{
Populate(dr, c);
}
}
dr.Close();
return(c);
}
public static FAB GetFAB(int ID)
{
DBAccess db = new DBAccess();
FAB c = new FAB();
db.AddInt("ID", ID);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectOne));
if (dr.HasRows)
{
while (dr.Read())
{
Populate(dr, c);
}
}
dr.Close();
return(c);
}
public static EyeWash GetEyeWashBySerialNo(string SerialNo)
{
DBAccess db = new DBAccess();
EyeWash c = new EyeWash();
db.AddNVarChar("SerialNo", SerialNo, 50);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectBySerialNo));
if (dr.HasRows)
{
while (dr.Read())
{
Populate(dr, c);
}
}
dr.Close();
return(c);
}
public static EyeWash GetEyeWashbyGuid(Guid GuID)
{
DBAccess db = new DBAccess();
EyeWash c = new EyeWash();
db.AddGuid("Guid", GuID);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectByGuid));
if (dr.HasRows)
{
while (dr.Read())
{
Populate(dr, c);
}
}
dr.Close();
return(c);
}
public static DataSet Search_Tilbud(string skills, int CompanyID = -1)
{
DataSet ds = new DataSet();
DataSet dsTemp = new DataSet();
bool flag = false;
DBAccess db = new DBAccess();
string[] arr = skills.Split(' ');
foreach (string s in arr)
{
db.AddInt("Status", Funktioner.ToInt(s));
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
if (CompanyID == -1)
{
//db.AddParameter("@CompanyID", DBNull.Value)
}
else
{
db.AddInt("CompanyID", CompanyID);
}
dsTemp = db.ExecuteDataSet("Co2Db_TilbudHeader_SelectByStatusCompany");
db.Parameters.Clear();
//If dsTemp.Tables.Count > 0 Then
ds.Merge(dsTemp);
if (flag == false)
{
DataColumn[] pk = new DataColumn[2];
pk[0] = ds.Tables[0].Columns["ID"];
ds.Tables[0].PrimaryKey = pk;
flag = true;
}
//End If
}
return(ds);
}
public static PractiMan GetPractiManByModelID(int ModelID)
{
DBAccess db = new DBAccess();
PractiMan pc = new PractiMan();
db.AddInt("ModelID", ModelID);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectModelID));
if (dr.HasRows)
{
while (dr.Read())
{
Populate(dr, pc);
}
}
if (!dr.IsClosed)
{
dr.Close();
}
return(pc);
}
public static Aiva GetAivaByCompanyID(int CompanyID)
{
DBAccess db = new DBAccess();
Aiva pc = new Aiva();
db.AddInt("CompanyID", CompanyID);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectCompanyID));
if (dr.HasRows)
{
while (dr.Read())
{
Populate(dr, pc);
}
}
if (!dr.IsClosed)
{
dr.Close();
}
return(pc);
}
