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); }