public static int Insert(KundeGrp_Pris c) { DBAccess db = new DBAccess(); c.Dato = DateTime.Now; if (c.Status <= (int)KundeGrpStatusEnum.Opret) { c.Status = KundeGrpStatusEnum.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 = Funktioner.ToInt(objParam.Value, -1); //Integer.Parse(objParam.Value.ToString) return(c.ID); //Integer.Parse(objParam.Value.ToString) } else { return(-1); } }
//SELECT ID, status, KundeGrpID, KundeGrpNavn, VareID, SalgsPris, Rabat, KundePris, FragtGebyr, Dato, VareNr, Navn, VareGrpID, VareGrpNr FROM vw_Co2Db_KundeGrp_Pris private static void Populate(SqlDataReader dr, KundeGrp_Pris c) { var with_1 = c; with_1.Status = (RescueTekniq.BOL.KundeGrpStatusEnum)(dr.DBtoInt("Status")); with_1.KundeGrpID = System.Convert.ToInt32(dr.DBtoInt("KundeGrpID")); with_1._KundeGrpNavn = dr.DBtoString("KundeGrpNavn"); with_1._SalgsPris = System.Convert.ToDecimal(dr.DBtoDecimal("SalgsPris")); with_1.Rabat = System.Convert.ToDecimal(dr.DBtoDecimal("Rabat")); with_1._KundePris = System.Convert.ToDecimal(dr.DBtoDecimal("KundePris")); with_1.FragtGebyr = System.Convert.ToDecimal(dr.DBtoDecimal("FragtGebyr")); with_1.Dato = System.Convert.ToDateTime(dr.DBtoDate("Dato")); with_1.VareID = System.Convert.ToInt32(dr.DBtoInt("VareID")); with_1._VareNr = dr.DBtoString("VareNr"); with_1._VareNavn = dr.DBtoString("Navn"); with_1._VareGrpID = System.Convert.ToInt32(dr.DBtoInt("VareGrpID")); with_1._VareGrpNavn = dr.DBtoString("VareGrpNr"); with_1._ProvisionRate = System.Convert.ToDecimal(dr.DBtoDecimal("ProvisionRate")); PopulateStandard(dr, c); }
public static int Update(KundeGrp_Pris c) { DBAccess db = new DBAccess(); c.Dato = DateTime.Now; db.AddInt("ID", c.ID); AddParms(ref db, c); int retval = db.ExecuteNonQuery(_SQLUpdate); return(retval); }
// SET [KundeGrpID] = <KundeGrpID, int,> // ,[VareID] = <VareID, int,> // ,[status] = <status, int,> // ,[Rabat] = <Rabat, float,> // ,[FragtGebyr] = <FragtGebyr, float,> // ,[Dato] = <Dato, datetime,> private static void AddParms(ref DBAccess db, KundeGrp_Pris c) { var with_1 = c; db.AddInt("KundeGrpID", with_1.KundeGrpID); db.AddInt("VareID", with_1.VareID); db.AddInt("Status", (System.Int32)with_1.Status); db.AddDecimal("Rabat", with_1.Rabat); db.AddDecimal("FragtGebyr", with_1.FragtGebyr); db.AddDateTime("Dato", with_1.Dato); db.AddDecimal("ProvisionRate", with_1.ProvisionRate); AddParmsStandard(db, c); }
// SET [KundeGrpID] = <KundeGrpID, int,> // ,[VareID] = <VareID, int,> // ,[status] = <status, int,> // ,[Rabat] = <Rabat, float,> // ,[FragtGebyr] = <FragtGebyr, float,> // ,[Dato] = <Dato, datetime,> public static int Insert(KundeGrpStatusEnum Status, int KundeGrpID, int VareID, decimal Rabat, decimal FragtGebyr, DateTime Dato) { KundeGrp_Pris c = new KundeGrp_Pris(); c.Status = Status; c.KundeGrpID = KundeGrpID; c.VareID = VareID; c.Rabat = Rabat; c.FragtGebyr = FragtGebyr; c.Dato = Dato; return(Insert(c)); }
public static KundeGrp_Pris GetCompany_VarePris(int CompanyID, int VareID) { KundeGrp kg = KundeGrp.GetKundeGrp_Company(CompanyID); KundeGrp_Pris kgp = KundeGrp_Pris.GetKundeGrp_VarePris(kg.ID, VareID); if (!kgp.loaded) { kgp = new KundeGrp_Pris(); kgp.KundeGrpID = kg.ID; kgp.VareID = VareID; kgp.Rabat = 0; kgp.FragtGebyr = 99.989999999999995M; kgp.Insert(); } return(kgp); }
public static int Update(int ID, KundeGrpStatusEnum Status, int KundeGrpID, int VareID, decimal Rabat, decimal FragtGebyr, DateTime Dato) { KundeGrp_Pris c = new KundeGrp_Pris(ID); if (c.Status <= (int)KundeGrpStatusEnum.Opret) { c.Status = KundeGrpStatusEnum.Aktiv; } c.Status = Status; c.KundeGrpID = KundeGrpID; c.VareID = VareID; c.Rabat = Rabat; c.FragtGebyr = FragtGebyr; c.Dato = Dato; return(Update(c)); }
public static System.Collections.Generic.List <KundeGrp_Pris> GetKundeGrp_PrisList(int KundeGrpID, string Sort, int SortDir) { System.Collections.Generic.List <KundeGrp_Pris> result = new System.Collections.Generic.List <KundeGrp_Pris>(); int ID = -1; // @Sort='VareNr' // @Sort='VareNavn' // @Sort='ID' // @Sort='Dato' if (Sort == "") { Sort = "VareNr"; } DBAccess db = new DBAccess(); db.AddInt("KundeGrpID", KundeGrpID); db.AddNVarChar("Sort", Sort, 50); db.AddInt("SortDir", SortDir); SqlDataReader dr = default(SqlDataReader); try { dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectIDByKundeGrp)); if (dr.HasRows) { while (dr.Read()) { ID = System.Convert.ToInt32(dr.DBtoInt("ID")); result.Add(KundeGrp_Pris.GetKundeGrp_Pris(ID)); } } dr.Close(); } catch (Exception ex) { throw (ex); } return(result); }
public static KundeGrp_Pris GetKundeGrp_Pris(int ID) { KundeGrp_Pris c = new KundeGrp_Pris(); DBAccess db = new DBAccess(); db.AddInt("ID", ID); SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectOne)); if (dr.HasRows) { while (dr.Read()) { Populate(dr, c); } } dr.Close(); return(c); }
public static string Tags(string tekst, RescueTekniq.BOL.KundeGrp_Pris item) { string InvoceVat = ConfigurationManager.AppSettings["invoice.vat"]; decimal vat = 25; try { vat = decimal.Parse(InvoceVat); } catch { } string res = ""; StringBuilder sb = new StringBuilder(); // = New StringBuilder sb.Append(tekst); sb.Replace("[VARE.SALGSPRIS]", item.SalgsPris.ToString("C")); sb.Replace("[VARE.RABAT]", item.Rabat.ToString("0.0000 %")); sb.Replace("[VARE.PRIS]", item.KundePris.ToString("C")); sb.Replace("[VARE.KUNDEPRIS]", item.KundePris.ToString("C")); sb.Replace("[VARE.FRAGTPRIS]", item.FragtGebyr.ToString("C")); sb.Replace("[VARE.FRAGTGEBYR]", item.FragtGebyr.ToString("C")); decimal moms = 0; decimal total = 0; moms = (item.KundePris + item.FragtGebyr) * (vat / 100); //0.25 total = item.KundePris + item.FragtGebyr + moms; sb.Replace("[VARE.MOMS]", moms.ToString("C")); sb.Replace("[VARE.TOTAL]", total.ToString("C")); res = sb.ToString(); res = item.Vare.Tags(res); res = item.KundeGrp.Tags(res); return(res); }
public static KundeGrp_Pris GetKundeGrp_VarePris(int KundeGrpID, string VareNr) { KundeGrp_Pris c = new KundeGrp_Pris(); DBAccess db = new DBAccess(); db.AddInt("KundeGrpID", KundeGrpID); db.AddNVarChar("VareNr", VareNr, 50); SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectByKundeGrpVareNr)); if (dr.HasRows) { while (dr.Read()) { Populate(dr, c); } } dr.Close(); return(c); }
public static int Delete(KundeGrp_Pris c) { return(Delete(c.ID)); }