public static int Update(int ID, AEDStatusEnum Status, int CompanyID, int ModelID, string SerialNo, string FirmwareVersion, string FirmwareLanguage, DateTime DeleveryDate, DateTime WarencyExpireDate, DateTime BatteryActivationDate, DateTime BatteryWarencyExpireDate, string ResponsibleName, string ResponsiblePhone, string ResponsibleEmail, string LocationAdresse, string LocationPostnr, string LocationBy, string LocationState, int LocationLandID, string Location, string Note)
{
AED_Trainer c = new AED_Trainer(ID);
c.Status = Status;
c.CompanyID = CompanyID;
c.ModelID = ModelID;
c.SerialNo = SerialNo;
c.FirmwareVersion = FirmwareVersion;
c.FirmwareLanguage = FirmwareLanguage;
c.DeleveryDate = DeleveryDate;
c.WarencyExpireDate = WarencyExpireDate;
c.BatteryActivationDate = BatteryActivationDate;
c.BatteryWarencyExpireDate = BatteryWarencyExpireDate;
c.ResponsibleName = ResponsibleName;
c.ResponsiblePhone = ResponsiblePhone;
c.ResponsibleEmail = ResponsibleEmail;
c.LocationAdresse = LocationAdresse;
c.LocationPostnr = LocationPostnr;
c.LocationBy = LocationBy;
c.LocationState = LocationState;
c.LocationLandID = LocationLandID;
c.Location = Location;
c.Note = Note;
return(Update(c));
}
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 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 int MoveToNewOwner(int ID, int NewOwner)
{
AED_Trainer a = new AED_Trainer(ID);
a.CompanyID = NewOwner;
AddLog(Status: "AED_trainer", Logtext: string.Format("Update AED_trainer: 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_Trainer c)
{
DBAccess db = new DBAccess();
db.AddInt("ID", c.ID);
AddParms(ref db, c);
int retval = db.ExecuteNonQuery(_SQLUpdate);
AddLog(Status: "AED_Trainer", Logtext: string.Format("Update AED_Trainer: ID:{0} SNo:{1} ", c.ID, c.SerialNo), Metode: "Update");
return(retval);
}
public static int Save(AED_Trainer A)
{
int retval = 0; //db.ExecuteNonQuery(_SQLUpdate)
if (A.ID > 0)
{
retval = Update(A);
}
else
{
retval = Insert(A);
}
return(retval);
}
private static void Populate(System.Data.SqlClient.SqlDataReader dr, AED_Trainer c)
{
var with_1 = c;
with_1.Status = (RescueTekniq.BOL.AEDStatusEnum)(dr.DBtoInt("Status")); //dr.DBtoInt("Status")
with_1.CompanyID = System.Convert.ToInt32(dr.DBtoInt("CompanyID"));
with_1.ModelID = System.Convert.ToInt32(dr.DBtoInt("ModelID"));
with_1.SerialNo = dr.DBtoString("SerialNo");
with_1.FirmwareVersion = dr.DBtoString("FirmwareVersion");
with_1.FirmwareLanguage = dr.DBtoString("FirmwareLanguage");
with_1.DeleveryDate = System.Convert.ToDateTime(dr.DBtoDate("DeleveryDate"));
with_1.WarencyExpireDate = System.Convert.ToDateTime(dr.DBtoDate("WarencyExpireDate"));
with_1.BatteryActivationDate = System.Convert.ToDateTime(dr.DBtoDate("BatteryActivationDate"));
with_1.BatteryWarencyExpireDate = System.Convert.ToDateTime(dr.DBtoDate("BatteryWarencyExpireDate"));
with_1.BilagStatus = (RescueTekniq.BOL.AEDBilagStatus)(dr.DBtoInt("BilagStatus"));
with_1.BilagSendtDato = System.Convert.ToDateTime(dr.DBtoDate("BilagSendtDato"));
with_1.BilagModtagetDato = System.Convert.ToDateTime(dr.DBtoDate("BilagModtagetDato"));
with_1.ResponsibleName = dr.DBtoString("ResponsibleName");
with_1.ResponsiblePhone = dr.DBtoString("ResponsiblePhone");
with_1.ResponsibleEmail = dr.DBtoString("ResponsibleEmail");
with_1.LocationAdresse = dr.DBtoString("LocationAdresse");
with_1.LocationPostnr = dr.DBtoString("LocationPostnr");
with_1.LocationBy = dr.DBtoString("LocationBy");
with_1.LocationState = dr.DBtoString("LocationState");
with_1.LocationLandID = System.Convert.ToInt32(dr.DBtoInt("LocationLandID"));
with_1.Location = dr.DBtoString("Location");
with_1.RegisterretCSI = System.Convert.ToDateTime(dr.DBtoDate("RegisterretCSI"));
with_1.RegisterretAF = dr.DBtoString("RegisterretAF");
with_1.Note = dr.DBtoString("Note");
PopulateStandard(dr, c);
}
private static void AddParms(ref DBAccess db, AED_Trainer c)
{
var with_1 = c;
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddInt("CompanyID", with_1.CompanyID);
db.AddInt("ModelID", with_1.ModelID);
db.AddNVarChar("SerialNo", with_1.SerialNo, 50);
db.AddNVarChar("FirmwareVersion", with_1.FirmwareVersion, 50);
db.AddNVarChar("FirmwareLanguage", with_1._FirmwareLanguage, 50);
db.AddDateTime("DeleveryDate", with_1.DeleveryDate);
db.AddDateTime("WarencyExpireDate", with_1.WarencyExpireDate);
db.AddDateTime("BatteryActivationDate", with_1.BatteryActivationDate);
db.AddDateTime("BatteryWarencyExpireDate", with_1.BatteryWarencyExpireDate);
db.AddInt("BilagStatus", (System.Int32)with_1.BilagStatus);
db.AddDateTime("BilagSendtDato", with_1.BilagSendtDato);
db.AddDateTime("BilagModtagetDato", with_1.BilagModtagetDato);
db.AddNVarChar("ResponsibleName", with_1.ResponsibleName, 50);
db.AddNVarChar("ResponsiblePhone", with_1.ResponsiblePhone, 16);
db.AddNVarChar("ResponsibleEmail", with_1.ResponsibleEmail, 250);
db.AddNVarChar("LocationAdresse", with_1.LocationAdresse, 50);
db.AddNVarChar("LocationPostnr", with_1.LocationPostnr, 16);
db.AddNVarChar("LocationBy", with_1.LocationBy, 50);
db.AddNVarChar("LocationState", with_1.LocationState, 50);
db.AddInt("LocationLandID", with_1.LocationLandID);
db.AddNVarChar("Location", with_1.Location, -1);
db.AddDateTime("RegisterretCSI", with_1.RegisterretCSI);
db.AddNVarChar("RegisterretAF", with_1.RegisterretAF, 50);
db.AddNVarChar("Note", with_1.Note, -1);
AddParmsStandard(db, c);
}
public static int Insert(AED_Trainer c)
{
DBAccess db = new DBAccess();
AddParms(ref 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_Trainer", Logtext: string.Format("Create AED Trainer: ID:{0} SNo:{1} ", c.ID, c.SerialNo), Metode: "Insert");
return(c.ID); //Integer.Parse(objParam.Value.ToString)
}
else
{
AddLog(Status: "AED_Trainer", Logtext: string.Format("Failure to Create AED_Trainer: SNo:{0}", c.SerialNo), logtype: LogTypeEnum.Error, Metode: "Insert");
return(-1);
}
}
public static string Tags(string tekst, RescueTekniq.BOL.AED_Trainer 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.SERIALNO]", item.SerialNo);
sb.Replace("[AED.LOCATION]", item.Location);
//.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);
}
public static int Delete(AED_Trainer c)
{
return(Delete(c.ID));
}
