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