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