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