public static string Tags(string tekst, RescueTekniq.BOL.AED_Electrod item)
{
string res = "";
StringBuilder sb = new StringBuilder();
sb.Append(tekst);
sb.Replace("[VARE.TYPE]", "elektroder");
sb.Replace("[ELECTROD.TYPE]", "[VARE.NAVN]");
sb.Replace("[EXPIREDATE]", item.ElectrodExpireDate.ToString("dd MMMM yyyy")); //("MMMM yyyy"))
sb.Replace("[ELECTROD.EXPIREDATE]", item.ElectrodExpireDate.ToString("dd MMMM yyyy")); //("MMMM yyyy"))
sb.Replace("[ELECTROD.UDLØBSDATO]", item.ElectrodExpireDate.ToString("dd MMMM yyyy")); //("MMMM yyyy"))
sb.Replace("[ELECTROD.DELEVERYDATE]", item.ElectrodDeleveryDate.ToString("dd MMMM yyyy")); //
sb.Replace("[ELECTROD.EMAILSENDT]", item.ElectrodEmailSendt.ToString());
sb.Replace("[ELECTROD.GUID]", item.Guid.ToString());
sb.Replace("[ELECTROD.VARENR]", "[VARE.VARENR]");
sb.Replace("[ELECTROD.SALGSPRIS]", "[VARE.SALGSPRIS]");
sb.Replace("[ELECTROD.RABAT]", "[VARE.RABAT]");
sb.Replace("[ELECTROD.PRIS]", "[VARE.PRIS]");
sb.Replace("[ELECTROD.KUNDEPRIS]", "[VARE.KUNDEPRIS]");
sb.Replace("[ELECTROD.FRAGTGEBYR]", "[VARE.FRAGTGEBYR]");
sb.Replace("[ELECTROD.FRAGTPRIS]", "[VARE.FRAGTPRIS]");
sb.Replace("[ELECTROD.MOMS]", "[VARE.MOMS]");
sb.Replace("[ELECTROD.TOTAL]", "[VARE.TOTAL]");
res = sb.ToString();
res = item.KundeGrpPris.Tags(res);
res = item.AED.Tags(res);
return(res);
}
public static int Delete(int ID)
{
AED_Electrod E = new AED_Electrod();
E.ID = ID;
return(Delete(E));
}
public static System.Collections.Generic.List <AED_Electrod> GetBatteryListExpiredEmail(int CompanyID)
{
System.Collections.Generic.List <AED_Electrod> result = new System.Collections.Generic.List <AED_Electrod>();
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(AED_Electrod.GetElectrod(ID));
}
}
dr.Close();
//Catch ex As Exception
//Throw ex
//End Try
return(result);
}
public static int Delete(AED_Electrod E)
{
DBAccess db = new DBAccess();
db.AddInt("ID", E.ID);
int retval = db.ExecuteNonQuery(_SQLDelete);
AddLog(Status: "AED_Electrod", Logtext: string.Format("Delete AED_Electrod: ID:{0}", E.ID), Metode: "Delete");
return(retval);
}
private static void AddParms(ref DBAccess db, AED_Electrod c)
{
var with_1 = c;
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddInt("AED_FK", with_1.AED_FK);
db.AddInt("ElectrodType", with_1.ElectrodType);
db.AddDateTime("ElectrodDeleveryDate", with_1.ElectrodDeleveryDate);
db.AddDateTime("ElectrodExpireDate", with_1.ElectrodExpireDate);
db.AddDateTime("ElectrodEmailSendt", with_1.ElectrodEmailSendt);
AddParmsStandard(db, c);
}
private static void Populate(System.Data.SqlClient.SqlDataReader dr, AED_Electrod c)
{
PopulateStandard(dr, c);
var with_1 = c;
with_1.Status = (RescueTekniq.BOL.AEDStatusEnum)(dr.DBtoInt("Status"));
with_1.AED_FK = System.Convert.ToInt32(dr.DBtoInt("AED_FK"));
with_1.ElectrodType = System.Convert.ToInt32(dr.DBtoInt("ElectrodType"));
with_1.ElectrodDeleveryDate = System.Convert.ToDateTime(dr.DBtoDate("ElectrodDeleveryDate"));
with_1.ElectrodExpireDate = System.Convert.ToDateTime(dr.DBtoDate("ElectrodExpireDate"));
with_1.ElectrodEmailSendt = dr.DBtoDate("ElectrodEmailSendt");
}
public static int Save(AED_Electrod E)
{
int retval = 0;
if (E.ID > 0)
{
retval = Update(E);
}
else
{
retval = Insert(E);
}
return(retval);
}
public static int Update(int ID, AEDStatusEnum Status, int AED_FK, int ElectrodType, DateTime ElectrodDeleveryDate, DateTime ElectrodExpireDate, DateTime ElectrodEmailSendt)
{
AED_Electrod c = new AED_Electrod(ID);
c.Status = Status;
c.AED_FK = AED_FK;
c.ElectrodType = ElectrodType;
c.ElectrodDeleveryDate = ElectrodDeleveryDate;
c.ElectrodExpireDate = ElectrodExpireDate;
c.ElectrodEmailSendt = ElectrodEmailSendt;
return(Update(c));
}
public static AED_Electrod GetElectrod(System.Guid Guid)
{
AED_Electrod c = new AED_Electrod();
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 int Insert(AED_Electrod E)
{
DBAccess db = new DBAccess();
AddParms(ref db, E);
SqlParameter objParam = new SqlParameter("@ID", 0);
objParam.Direction = ParameterDirection.Output;
db.Parameters.Add(objParam);
int retval = db.ExecuteNonQuery(_SQLInsert);
if (retval == 1)
{
E.ID = int.Parse(objParam.Value.ToString());
AddLog(Status: "AED_Electrod", Logtext: string.Format("Create AED_Electrod: ID:{0}", E.ID), Metode: "Insert");
return(E.ID);
}
else
{
AddLog(Status: "AED_Electrod", Logtext: string.Format("Failure to Create AED_Electrod:"), logtype: LogTypeEnum.Error, Metode: "Insert");
return(-1);
}
}
