public static string Tags(string tekst, RescueTekniq.BOL.AED item) { string res = ""; StringBuilder sb = new StringBuilder(); sb.Append(tekst); sb.Replace("[VARE.TYPE]", "AED/Hjertestarter"); sb.Replace("[AED.ANSVARLIG]", item.ResponsibleName); sb.Replace("[AED.ANSVARLIG.NAVN]", item.ResponsibleName); sb.Replace("[AED.ANSVARLIG.EMAIL]", item.ResponsibleEmail); sb.Replace("[AED.ANSVARLIG.TELEFON]", item.ResponsiblePhone); sb.Replace("[AED.NOTE]", item.Note); sb.Replace("[AED.TYPE]", "[VARE.NAVN]"); sb.Replace("[AED.SERIALNO]", item.SerialNo); sb.Replace("[AED.LOCATION]", item.Location); sb.Replace("[AED.LOCATIONFULDADR]", item.LocationFuldAdresse); sb.Replace("[AED.VARENR]", "[VARE.VARENR]"); //item.Vare.VareNr) sb.Replace("[AED.MODEL]", "[VARE.NAVN]"); //item.Vare.Navn) sb.Replace("[AED.EXPIREDATE]", item.WarencyExpireDate.ToString("dd MMMM yyyy")); res = sb.ToString(); res = item.KundeGrpPris.Tags(res); res = item.Virksomhed.Tags(res); return(res); }
/// <summary> /// Creates the PDF document. /// </summary> public Document CreateDocument() { if (!_AED.loaded) { if (_aedID > 0) { _AED = new RescueTekniq.BOL.AED(_aedID); } } if (!_AED.loaded) { throw (new Exception("AED findes ikke, ID ukendt :" + aedID.ToString())); } // Create a new MigraDoc document this.document = new Document(); var with_1 = this.document.Info; with_1.Title = "AED regstering nr. " + System.Convert.ToString(_aedID); with_1.Subject = "AED registering"; with_1.Author = Company.name; with_1.Comment = ""; with_1.Keywords = ""; DefineStyles(); CreatePage(); FillContent(); return(this.document); }
public static System.Collections.Generic.List <AED> GetListSoonExpired(int CompanyID) { System.Collections.Generic.List <AED> result = new System.Collections.Generic.List <AED>(); 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(AED.GetAED(ID)); } } dr.Close(); //Catch ex As Exception // Throw ex //End Try return(result); }
public static int MoveToNewOwner(int ID, int NewOwner) { AED a = new AED(ID); a.CompanyID = NewOwner; AddLog(Status: "AED", Logtext: string.Format("Update AED: ID:{0} SNo:{1} New owner: {2}-{3}", a.ID, a.SerialNo, a.CompanyID, a.Firmanavn), Metode: "MoveToNewOwner"); return(Save(a)); }
public static int Update(AED c) { DBAccess db = new DBAccess(); db.AddInt("ID", c.ID); AddParms(db, c); int retval = db.ExecuteNonQuery(_SQLUpdate); AddLog(Status: "AED", Logtext: string.Format("Update AED: ID:{0} SNo:{1} ", c.ID, c.SerialNo), Metode: "Update"); return(retval); }
public static int Save(AED A) { int retval = 0; //db.ExecuteNonQuery(_SQLUpdate) if (A.ID > 0) { retval = Update(A); } else { retval = Insert(A); } return(retval); }
public static List <AED> GetAEDsByCriteria(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_AED "; 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 <AED> list = new List <AED>(); while (dr.Read()) { AED _AED = new AED(); AED.Populate(dr, _AED); list.Add(_AED); } db.Dispose(); return(list); }
private static AED Populate(System.Data.IDataReader dr, AED rec) { rec = (AED)(PopulateStandard(dr, rec)); rec.Status = (RescueTekniq.BOL.AEDStatusEnum)(dr.DBtoInt("Status")); rec.CompanyID = System.Convert.ToInt32(dr.DBtoInt("CompanyID")); rec.ModelID = System.Convert.ToInt32(dr.DBtoInt("ModelID")); rec.SerialNo = dr.DBtoString("SerialNo"); rec.FirmwareVersion = dr.DBtoString("FirmwareVersion"); rec.FirmwareLanguage = dr.DBtoString("FirmwareLanguage"); rec.DeleveryDate = System.Convert.ToDateTime(dr.DBtoDate("DeleveryDate")); rec.WarencyExpireDate = System.Convert.ToDateTime(dr.DBtoDate("WarencyExpireDate")); rec.EmailSendt = System.Convert.ToDateTime(dr.DBtoDate("EmailSendt")); rec.BatteryActivationDate = System.Convert.ToDateTime(dr.DBtoDate("BatteryActivationDate")); rec.BatteryWarencyExpireDate = System.Convert.ToDateTime(dr.DBtoDate("BatteryWarencyExpireDate")); rec.BilagStatus = (RescueTekniq.BOL.AEDBilagStatus)(dr.DBtoInt("BilagStatus")); rec.BilagSendtDato = System.Convert.ToDateTime(dr.DBtoDate("BilagSendtDato")); rec.BilagModtagetDato = System.Convert.ToDateTime(dr.DBtoDate("BilagModtagetDato")); rec.ResponsibleName = dr.DBtoString("ResponsibleName"); rec.ResponsiblePhone = dr.DBtoString("ResponsiblePhone"); rec.ResponsibleEmail = dr.DBtoString("ResponsibleEmail"); rec.LocationAdresse = dr.DBtoString("LocationAdresse"); rec.LocationPostnr = dr.DBtoString("LocationPostnr"); rec.LocationBy = dr.DBtoString("LocationBy"); rec.LocationState = dr.DBtoString("LocationState"); rec.LocationLandID = System.Convert.ToInt32(dr.DBtoInt("LocationLandID")); rec.Location = dr.DBtoString("Location"); rec.LocationBuildingNo = dr.DBtoString("LocationBuildingNo"); rec.RegisterretCSI = System.Convert.ToDateTime(dr.DBtoDate("RegisterretCSI")); rec.RegisterretAF = dr.DBtoString("RegisterretAF"); rec.Note = dr.DBtoString("Note"); return(rec); }
private static object AddParms(DBAccess db, AED rec) { db.AddInt("Status", (System.Int32)rec.Status); db.AddInt("CompanyID", rec.CompanyID); db.AddInt("ModelID", rec.ModelID); db.AddNVarChar("SerialNo", rec.SerialNo, 50); db.AddNVarChar("FirmwareVersion", rec.FirmwareVersion, 50); db.AddNVarChar("FirmwareLanguage", rec._FirmwareLanguage, 50); db.AddDateTime("DeleveryDate", rec.DeleveryDate); db.AddDateTime("WarencyExpireDate", rec.WarencyExpireDate); db.AddDateTime("EmailSendt", rec.EmailSendt); db.AddDateTime("BatteryActivationDate", rec.BatteryActivationDate); db.AddDateTime("BatteryWarencyExpireDate", rec.BatteryWarencyExpireDate); db.AddInt("BilagStatus", (System.Int32)rec.BilagStatus); db.AddDateTime("BilagSendtDato", rec.BilagSendtDato); db.AddDateTime("BilagModtagetDato", rec.BilagModtagetDato); db.AddNVarChar("ResponsibleName", rec.ResponsibleName, 50); db.AddNVarChar("ResponsiblePhone", rec.ResponsiblePhone, 16); db.AddNVarChar("ResponsibleEmail", rec.ResponsibleEmail, 250); db.AddNVarChar("LocationAdresse", rec.LocationAdresse, 50); db.AddNVarChar("LocationPostnr", rec.LocationPostnr, 16); db.AddNVarChar("LocationBy", rec.LocationBy, 50); db.AddNVarChar("LocationState", rec.LocationState, 50); db.AddInt("LocationLandID", rec.LocationLandID); db.AddNVarChar("Location", rec.Location, -1); db.AddNVarChar("LocationBuildingNo", rec.LocationBuildingNo, 10); db.AddDateTime("RegisterretCSI", rec.RegisterretCSI); db.AddNVarChar("RegisterretAF", rec.RegisterretAF, 50); db.AddNVarChar("Note", rec.Note, -1); rec = (AED)(AddParmsStandard(db, rec)); return(rec); }
public static AED GetAEDBySerialNo(string SerialNo) { DBAccess db = new DBAccess(); AED c = new AED(); 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 AED GetAEDbyGuid(Guid GuID) { DBAccess db = new DBAccess(); AED c = new AED(); 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 int Delete(AED A) { int retval = -1; if (A.ID > 0) { foreach (AED_Electrod E in A.ElectrodList) { E.Delete(); } foreach (AED_Battery B in A.BatteryList) { B.Delete(); } DBAccess db = new DBAccess(); db.AddInt("ID", A.ID); retval = db.ExecuteNonQuery(_SQLDelete); AddLog(Status: "AED", Logtext: string.Format("Delete AED: ID:{0} SNo:{1} ", A.ID, A.SerialNo), Metode: "Delete"); } return(retval); }
public static int Insert(AED c) { DBAccess db = new DBAccess(); AddParms(db, c); SqlParameter objParam = new SqlParameter("@ID", 0); objParam.Direction = ParameterDirection.Output; db.Parameters.Add(objParam); int retval = db.ExecuteNonQuery(_SQLInsert); if (retval == 1) { c.ID = Funktioner.ToInt(objParam.Value, -1); //Integer.Parse(objParam.Value.ToString) AddLog(Status: "AED", Logtext: string.Format("Create AED: ID:{0} SNo:{1} ", c.ID, c.SerialNo), Metode: "Insert"); return(c.ID); //Integer.Parse(objParam.Value.ToString) } else { AddLog(Status: "AED", Logtext: string.Format("Failure to Create AED: SNo:{0}", c.SerialNo), logtype: LogTypeEnum.Error, Metode: "Insert"); return(-1); } }
public static int Delete(int ID) { AED item = new AED(ID); return(Delete(item)); }