public static System.Collections.Generic.List <EyeWash_Bottle> GetBottleList(int EYE_FK)
{
System.Collections.Generic.List <EyeWash_Bottle> result = new System.Collections.Generic.List <EyeWash_Bottle>();
int ID = -1;
DBAccess db = new DBAccess();
db.AddInt("EYE_FK", EYE_FK);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
SqlDataReader dr = default(SqlDataReader);
//Try
dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectByEYE));
if (dr.HasRows)
{
while (dr.Read())
{
ID = System.Convert.ToInt32(dr.DBtoInt("ID"));
result.Add(EyeWash_Bottle.GetBottle(ID));
}
}
dr.Close();
//Catch ex As Exception
//Throw ex
//End Try
return(result);
}
public static System.Collections.Generic.List <EyeWash_Bottle> GetBottleListExpiredEmail(int CompanyID)
{
System.Collections.Generic.List <EyeWash_Bottle> result = new System.Collections.Generic.List <EyeWash_Bottle>();
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(EyeWash_Bottle.GetBottle(ID));
}
}
dr.Close();
}
catch (Exception ex)
{
throw (ex);
}
return(result);
}
public static int Insert(EyeWash_Bottle rec)
{
DBAccess db = new DBAccess();
AddParms(ref db, rec);
SqlParameter objParam = new SqlParameter("@ID", 0)
{
Direction = ParameterDirection.Output
};
db.Parameters.Add(objParam);
int retval = db.ExecuteNonQuery(_SQLInsert);
if (retval == 1)
{
rec.ID = int.Parse(objParam.Value.ToString());
AddLog(Status: "EyeWash_Bottle", Logtext: string.Format("Create EyeWash_Bottle: ID:{0}", rec.ID), Metode: "Insert");
return(rec.ID);
}
else
{
AddLog(Status: "EyeWash_Bottle", Logtext: string.Format("Failure to Create EyeWash_Bottle:"), logtype: LogTypeEnum.Error, Metode: "Insert");
return(-1);
}
}
public static int Delete(int ID)
{
EyeWash_Bottle B = new EyeWash_Bottle()
{
ID = ID
};
return(Delete(B));
}
public static int Delete(EyeWash_Bottle rec)
{
DBAccess db = new DBAccess();
db.AddInt("ID", rec.ID);
int retval = db.ExecuteNonQuery(_SQLDelete);
AddLog(Status: "EyeWash_Bottle", Logtext: string.Format("Delete EyeWash_Bottle: ID:{0}", rec.ID), Metode: "Delete");
return(retval);
}
private static void AddParms(ref DBAccess db, EyeWash_Bottle rec)
{
var with_1 = rec;
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddInt("EYE_FK", with_1.EYE_FK);
db.AddInt("BottleType", with_1.BottleType);
db.AddDateTime("BottleDeleveryDate", with_1.BottleDeleveryDate);
db.AddDateTime("BottleExpireDate", with_1.BottleExpireDate);
db.AddDateTime("BottleEmailSendt", with_1.BottleEmailSendt);
AddParmsStandard(db, rec);
}
private static void Populate(SqlDataReader dr, EyeWash_Bottle rec)
{
PopulateStandard(dr, rec);
var with_1 = rec;
with_1.Status = (RescueTekniq.BOL.EyeWash_StatusEnum)(dr.DBtoInt("Status"));
with_1.EYE_FK = System.Convert.ToInt32(dr.DBtoInt("EYE_FK"));
with_1.BottleType = System.Convert.ToInt32(dr.DBtoInt("BottleType"));
with_1.BottleDeleveryDate = System.Convert.ToDateTime(dr.DBtoDate("BottleDeleveryDate"));
with_1.BottleExpireDate = System.Convert.ToDateTime(dr.DBtoDate("BottleExpireDate"));
with_1.BottleEmailSendt = dr.DBtoDate("BottleEmailSendt");
}
public static int Save(EyeWash_Bottle rec)
{
int retval = 0;
if (rec.ID > 0)
{
retval = Update(rec);
}
else
{
retval = Insert(rec);
}
return(retval);
}
public static EyeWash_Bottle GetBottle(System.Guid Guid)
{
EyeWash_Bottle c = new EyeWash_Bottle();
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 string Tags(string tekst, RescueTekniq.BOL.EyeWash_Bottle item)
{
string res = "";
StringBuilder sb = new StringBuilder();
sb.Append(tekst);
sb.Replace("[VARE.TYPE]", "Bottle");
sb.Replace("[BOTTLE.MODEL]", "[VARE.NAVN]");
sb.Replace("[BOTTLE.TYPE]", "[VARE.NAVN]");
sb.Replace("[EXPIREDATE]", item.BottleExpireDate.ToString("d. MMMM yyyy"));
sb.Replace("[BOTTLE.EXPIREDATE]", item.BottleExpireDate.ToString("d. MMMM yyyy"));
sb.Replace("[BOTTLE.UDLØBSDATO]", item.BottleExpireDate.ToString("d. MMMM yyyy"));
sb.Replace("[BOTTLE.DELEVERYDATE]", item.BottleDeleveryDate.ToString("d. MMMM yyyy"));
if (Information.IsDate(item.BottleEmailSendt))
{
DateTime dtgBES = (DateTime)item.BottleEmailSendt;
sb.Replace("[BOTTLE.EMAILSENDT]", dtgBES.ToString("d. MMMM yyyy"));
}
sb.Replace("[BOTTLE.GUID]", item.Guid.ToString());
sb.Replace("[BOTTLE.VARENR]", "[VARE.VARENR]");
sb.Replace("[BOTTLE.SALGSPRIS]", "[VARE.SALGSPRIS]");
sb.Replace("[BOTTLE.RABAT]", "[VARE.RABAT]");
sb.Replace("[BOTTLE.PRIS]", "[VARE.PRIS]");
sb.Replace("[BOTTLE.KUNDEPRIS]", "[VARE.KUNDEPRIS]");
sb.Replace("[BOTTLE.FRAGTGEBYR]", "[VARE.FRAGTGEBYR]");
sb.Replace("[BOTTLE.FRAGTPRIS]", "[VARE.FRAGTPRIS]");
sb.Replace("[BOTTLE.MOMS]", "[VARE.MOMS]");
sb.Replace("[BOTTLE.TOTAL]", "[VARE.TOTAL]");
res = sb.ToString();
res = item.KundeGrpPris.Tags(res);
res = item.EYE.Tags(res);
return(res);
}
