public static System.Collections.Generic.List <TilbudsLinie> GetTilbudsLinierList(int TilbudID) { System.Collections.Generic.List <TilbudsLinie> result = new System.Collections.Generic.List <TilbudsLinie>(); DBAccess db = new DBAccess(); db.AddInt("TilbudID", TilbudID); SqlDataReader dr = default(SqlDataReader); try { dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectAll)); //CType(db.ExecuteReader(_SQLSelectAllID), SqlDataReader) if (dr.HasRows) { while (dr.Read()) { result.Add(TilbudsLinie.GetTilbudsLinie(System.Convert.ToInt32(dr.DBtoInt("ID")))); } } dr.Close(); } catch (Exception ex) { throw (ex); } return(result); }
public static int Delete(TilbudsLinie tl) { DBAccess db = new DBAccess(); db.AddInt("ID", tl.ID); int retval = db.ExecuteNonQuery(_SQLDelete); AddLog(Status: "TilbudsLinie", Logtext: string.Format("Delete TilbudsLinie: ID:{0} Tilbud.ID:{1} ", tl.ID, tl.TilbudID), Metode: "Delete"); return(retval); }
public static int Update(TilbudsLinie c) { DBAccess db = new DBAccess(); db.AddInt("ID", c.ID); AddParms(ref db, c); int retval = db.ExecuteNonQuery(_SQLUpdate); AddLog(Status: "TilbudsLinie", Logtext: string.Format("Update TilbudsLinie: ID:{0} Tilbud.ID:{1} ", c.ID, c.TilbudID), Metode: "Update"); return(retval); }
public static int Insert(int TilbudID, int VareID, decimal Salgspris, decimal Tilbudspris, decimal Rabat, TilbudStatusEnum Status, int Pos, int Antal) { TilbudsLinie c = new TilbudsLinie(); c.TilbudID = TilbudID; c.VareID = VareID; c.Salgspris = Salgspris; c.Rabat = Rabat; c.Tilbudspris = Tilbudspris; c.Status = Status; c.Pos = Pos; c.Antal = Antal; return(Insert(c)); }
private static void Populate(SqlDataReader dr, TilbudsLinie c) { var with_1 = c; with_1.TilbudID = System.Convert.ToInt32(dr.DBtoInt("TilbudID")); with_1.VareID = System.Convert.ToInt32(dr.DBtoInt("VareID")); with_1.Salgspris = dr.DBtoDecimal("Salgspris"); with_1.Rabat = System.Convert.ToDecimal(dr.DBtoDecimal("Rabat")); with_1.Tilbudspris = System.Convert.ToDecimal(dr.DBtoDecimal("Tilbudspris")); with_1.Status = (RescueTekniq.BOL.TilbudStatusEnum)(dr.DBtoInt("Status")); with_1.Pos = System.Convert.ToInt32(dr.DBtoInt("Pos")); with_1.Antal = System.Convert.ToInt32(dr.DBtoInt("Antal")); PopulateStandard(dr, c); }
private static void AddParms(ref DBAccess db, TilbudsLinie c) { var with_1 = c; db.AddInt("TilbudID", with_1.TilbudID); db.AddInt("VareID", with_1.VareID); db.AddDecimal("Salgspris", with_1.Salgspris); db.AddDecimal("Rabat", with_1.Rabat); db.AddDecimal("Tilbudspris", with_1.Tilbudspris); db.AddInt("Status", (System.Int32)with_1.Status); db.AddInt("Pos", with_1.Pos); db.AddInt("Antal", with_1.Antal); AddParmsStandard(db, c); }
public static TilbudsLinie GetTilbudsLinie(int ID) { DBAccess db = new DBAccess(); db.Parameters.Add(new SqlParameter("@ID", ID)); SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectOne)); if (dr.HasRows) { TilbudsLinie c = new TilbudsLinie(); while (dr.Read()) { Populate(dr, c); } dr.Close(); return(c); } else { dr.Close(); return(null); } }
public static int Insert(TilbudsLinie 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: "TilbudsLinie", Logtext: string.Format("Create TilbudsLinie: ID:{0} Tilbud.ID:{1} ", c.ID, c.TilbudID), Metode: "Insert"); return(c.ID); //Integer.Parse(objParam.Value.ToString) } else { AddLog(Status: "TilbudsLinie", Logtext: string.Format("Failure to Create TilbudsLinie: Tilbud.ID:{0}", c.TilbudID), logtype: LogTypeEnum.Error, Metode: "Insert"); return(-1); } }
public static int Delete(int ID) { TilbudsLinie item = new TilbudsLinie(ID); return(item.Delete()); }