public static int Insert(Vare c)
{
DBAccess db = new DBAccess();
if (c.Status == VareStatusEnum.Initialize)
{
c.Status = VareStatusEnum.Aktiv;
}
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 = int.Parse(objParam.Value.ToString());
AddLog(Status: "Vare", Logtext: string.Format("Create Vare: ID:{0} No:{1} Name:{2}", c.ID, c.VareNr, c.Navn), Metode: "Insert");
return(c.ID); //Integer.Parse(objParam.Value.ToString)
}
else
{
AddLog(Status: "Vare", Logtext: string.Format("Failure to Create Vare: No:{0} Name:{1}", c.VareNr, c.Navn), logtype: LogTypeEnum.Error, Metode: "Insert");
return(-1);
}
}
public static System.Collections.Generic.List <Vare> GetAllVareVareGrpList(int VareGrpID)
{
System.Collections.Generic.List <Vare> result = new System.Collections.Generic.List <Vare>();
DBAccess db = new DBAccess();
db.AddInt("VareGrpID", VareGrpID);
SqlDataReader dr = default(SqlDataReader);
try
{
dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectAllVareGrp));
if (dr.HasRows)
{
while (dr.Read())
{
result.Add(Vare.GetVare(System.Convert.ToInt32(dr.DBtoInt("ID"))));
}
}
dr.Close();
}
catch (Exception ex)
{
throw (ex);
}
return(result);
}
private static void Populate(System.Data.DataTableReader dr, Vare rec)
{
var with_1 = rec;
with_1.VareGrpID = System.Convert.ToInt32(dr.DBtoInt("VareGrpID"));
with_1.VareNr = dr.DBtoString("VareNr");
with_1.Navn = dr.DBtoString("Navn");
with_1.Beskrivelse = dr.DBtoString("Beskrivelse");
with_1._CurrencyID = System.Convert.ToInt32(dr.DBtoInt("CurrencyID"));
with_1._CurrencyRate = System.Convert.ToDecimal(dr.DBtoDecimal("CurrencyRate"));
with_1._Indkobspris = System.Convert.ToDecimal(dr.DBtoDecimal("Indkobspris"));
with_1._FragtPct = System.Convert.ToDecimal(dr.DBtoDecimal("FragtPct"));
with_1._Fragt = System.Convert.ToDecimal(dr.DBtoDecimal("Fragt"));
with_1._KostprisCurrency = System.Convert.ToDecimal(dr.DBtoDecimal("KostprisCurrency"));
with_1._KostprisDKK = System.Convert.ToDecimal(dr.DBtoDecimal("KostprisDKK"));
with_1._DaekningsBidrag = System.Convert.ToDecimal(dr.DBtoDecimal("DaekningsBidrag"));
with_1._DaekningsGrad = System.Convert.ToDecimal(dr.DBtoDecimal("DaekningsGrad"));
with_1._SalgsPris = System.Convert.ToDecimal(dr.DBtoDecimal("SalgsPris"));
with_1.Status = (RescueTekniq.BOL.VareStatusEnum)(dr.DBtoInt("Status"));
with_1.FragtID = System.Convert.ToInt32(dr.DBtoInt("FragtID"));
with_1.FaktaArkPath = dr.DBtoString("FaktaArkPath");
with_1.SupplierItemNo = dr.DBtoString("SupplierItemNo");
with_1.SupplierItemName = dr.DBtoString("SupplierItemName");
PopulateStandard(dr, rec);
}
//UPDATE Co2Db_Vare SET FG = Fragt, KPcur = KostprisCurrency, KPdkk = KostprisDKK, DB = DaekningsBidrag, DG = DaekningsGrad, SP = SalgsPris
//, @Fragt float = null
//, @KostPrisCUR float = null
//, @KostPrisDKK float = null
//, @DaekningsBidrag float = null
//, @DaekningsGrad float
//, @SalgsPris float = null
private static void AddParms(ref DBAccess db, Vare rec)
{
var with_1 = rec;
db.AddInt("VareGrpID", with_1.VareGrpID);
db.AddNVarChar("VareNr", with_1.VareNr, 50);
db.AddNVarChar("Navn", with_1.Navn, 255);
db.AddNVarChar("Beskrivelse", with_1.Beskrivelse, -1);
db.AddInt("CurrencyID", with_1.CurrencyID);
db.AddDecimal("CurrencyRate", with_1.CurrencyRate);
db.AddDecimal("Indkobspris", with_1.Indkobspris);
db.AddDecimal("FragtPct", with_1.FragtPct);
db.AddDecimal("Fragt", with_1.Fragt);
db.AddDecimal("KostPrisCUR", with_1.KostprisCurrency);
db.AddDecimal("KostPrisDKK", with_1.KostprisDKK);
db.AddDecimal("DaekningsBidrag", with_1.DaekningsBidrag);
db.AddDecimal("DaekningsGrad", with_1.DaekningsGrad);
db.AddDecimal("SalgsPris", with_1.SalgsPris);
db.AddInt("Status", (System.Int32)with_1.Status);
db.AddInt("FragtID", with_1.FragtID);
db.AddNVarChar("FaktaArkPath", with_1.FaktaArkPath, 250);
db.AddNVarChar("SupplierItemNo", with_1.SupplierItemNo, 50);
db.AddNVarChar("SupplierItemName", with_1.SupplierItemName, 255);
AddParmsStandard(db, rec);
}
public static int UpdateSupplierItemName(int ID, string SupplierItemName)
{
int res = -1;
Vare rec = new Vare(ID);
if (rec.isLoaded)
{
rec.SupplierItemName = SupplierItemName;
res = rec.Save();
}
return(res);
}
public static int Update(Vare c)
{
DBAccess db = new DBAccess();
db.AddInt("ID", c.ID);
AddParms(ref db, c);
int retval = db.ExecuteNonQuery("Co2Db_Vare_Update");
AddLog(Status: "Vare", Logtext: string.Format("Update Vare: ID:{0} No:{1} ", c.ID, c.VareNr), Metode: "Update");
return(retval);
}
public static int Save(Vare rec)
{
int retval = 0;
if (rec.ID > 0)
{
retval = Update(rec);
}
else
{
retval = Insert(rec);
}
return(retval);
}
public static List <Vare> Search_Varelist(string Search, VareStatusEnum Status, int VareGrpID)
{
DataSet ds = new DataSet();
DataSet dsTemp = new DataSet();
bool flag = false;
DBAccess db = new DBAccess();
List <Vare> res = new List <Vare>();
string[] arr = Search.Split(' ');
foreach (string s in arr)
{
db.AddNVarChar("Search", s, 50);
db.AddInt("Status", System.Convert.ToInt32(Status));
db.AddInt("VareGrpID", VareGrpID);
dsTemp = db.ExecuteDataSet(_SQLSelectBySearch);
db.Parameters.Clear();
//If dsTemp.Tables.Count > 0 Then
ds.Merge(dsTemp);
if (flag == false)
{
DataColumn[] pk = new DataColumn[2];
pk[0] = ds.Tables[0].Columns["ID"];
ds.Tables[0].PrimaryKey = pk;
flag = true;
}
//End If
}
Vare rec = default(Vare);
DataTableReader dr = ds.Tables[0].CreateDataReader();
if (dr.HasRows)
{
while (dr.Read())
{
rec = new Vare();
Populate(dr, rec);
res.Add(rec);
}
}
return(res);
}
public static string Tags(string tekst, RescueTekniq.BOL.Vare item)
{
string res = "";
StringBuilder sb = new StringBuilder();
sb.Append(tekst);
sb.Replace("[VARE.VARENR]", item.VareNr);
sb.Replace("[VARE.NAVN]", item.Navn);
sb.Replace("[VARE.MODEL]", item.Navn);
sb.Replace("[VARE.BESKRIVELSE]", item.Beskrivelse);
sb.Replace("[VARE.KOSTPRIS]", System.Convert.ToString(item.KostprisDKK));
sb.Replace("[VARE.VEJLPRIS]", System.Convert.ToString(item.SalgsPris));
sb.Replace("[VARE.SUPPLIERITEMNO]", item.SupplierItemNo);
sb.Replace("[VARE.LEVARANDØRVARENR]", item.SupplierItemNo);
sb.Replace("[VARE.CURRENCY.CODE]", "[CURRENCY.CODE]");
sb.Replace("[VARE.CURRENCY.DATE]", "[CURRENCY.DATE]");
sb.Replace("[VARE.CURRENCY.DESC]", "[CURRENCY.DESC]");
sb.Replace("[VARE.CURRENCY.RATE]", "[CURRENCY.RATE]");
sb.Replace("[VARE.CURRENCY.SYMBOL]", "[CURRENCY.SYMBOL]");
sb.Replace("[VARE.CURRENCYCODE]", "[CURRENCY.CODE]");
sb.Replace("[VARE.CURRENCYDATE]", "[CURRENCY.DATE]");
sb.Replace("[VARE.CURRENCYDESC]", "[CURRENCY.DESC]");
sb.Replace("[VARE.CURRENCYRATE]", "[CURRENCY.RATE]");
sb.Replace("[VARE.CURRENCYSYMBOL]", "[CURRENCY.SYMBOL]");
res = sb.ToString();
res = item.Currency.Tags(res);
res = item.VareGrp.Tags(res);
return(res);
}
public static Vare GetVare(string Varenr)
{
DBAccess db = new DBAccess();
Vare c = new Vare();
db.AddNVarChar("Varenr", Varenr, 250);
try
{
SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectByVarenr));
if (dr.HasRows)
{
while (dr.Read())
{
Populate(dr, c);
}
}
dr.Close();
}
catch (Exception)
{
}
return(c);
}
public static Vare GetVare(int ID)
{
DBAccess db = new DBAccess();
db.AddInt("ID", ID);
Vare c = new Vare();
try
{
SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectOne));
if (dr.HasRows)
{
while (dr.Read())
{
Populate(dr, c);
}
dr.Close();
}
}
catch (Exception)
{
}
return(c);
}
public static int Update(int ID, int VareGrpID, string VareNr, string Navn, string Beskrivelse, int CurrencyID, decimal CurrencyRate, decimal Indkobspris, decimal FragtPct, decimal DaekningsGrad, TilbudStatusEnum Status, int FragtID, string FaktaArkPath)
{
Vare c = new Vare(ID);
c.VareGrpID = VareGrpID;
c.VareNr = VareNr;
c.Navn = Navn;
c.Beskrivelse = Beskrivelse;
c.CurrencyID = CurrencyID;
c.CurrencyRate = CurrencyRate;
c.Indkobspris = Indkobspris;
c.FragtPct = FragtPct;
c.DaekningsGrad = DaekningsGrad;
c.Status = (RescueTekniq.BOL.VareStatusEnum)Status;
c.FragtID = FragtID;
c.FaktaArkPath = FaktaArkPath;
return(Update(c));
}
public static int Insert(int VareGrpID, string VareNr, string Navn, string Beskrivelse, int CurrencyID, decimal CurrencyRate, decimal Indkobspris, decimal FragtPct, decimal DaekningsGrad, VareStatusEnum Status, int FragtID, string FaktaArkPath)
{
Vare c = new Vare();
c.VareGrpID = VareGrpID;
c.VareNr = VareNr;
c.Navn = Navn;
c.Beskrivelse = Beskrivelse;
c.CurrencyID = CurrencyID;
c.CurrencyRate = CurrencyRate;
c.Indkobspris = Indkobspris;
c.FragtPct = FragtPct;
c.DaekningsGrad = DaekningsGrad;
c.Status = VareStatusEnum.Aktiv;
c.FragtID = FragtID;
c.FaktaArkPath = FaktaArkPath;
return(Insert(c));
}
public static int Delete(Vare c)
{
return(Delete(c.ID));
}
