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