public static int Insert(KundeGrp c) { DBAccess db = new DBAccess(); 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) { return(int.Parse(objParam.Value.ToString())); } else { return(-1); } }
public static System.Collections.Generic.List <KundeGrp> GetKundeGrpList() { System.Collections.Generic.List <KundeGrp> result = new System.Collections.Generic.List <KundeGrp>(); int ID = -1; DBAccess db = new DBAccess(); SqlDataReader dr = default(SqlDataReader); try { dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectAll)); if (dr.HasRows) { while (dr.Read()) { ID = System.Convert.ToInt32(dr.DBtoInt("ID")); result.Add(KundeGrp.GetKundeGrp(ID)); } } dr.Close(); } catch (Exception ex) { throw (ex); } return(result); }
private static void Populate(SqlDataReader dr, KundeGrp c) { var with_1 = c; with_1.Status = (RescueTekniq.BOL.KundeGrpStatusEnum)(dr.DBtoInt("Status")); with_1.KundeGrpNavn = dr.DBtoString("KundeGrpNavn"); with_1.Sort = System.Convert.ToInt32(dr.DBtoInt("Sort")); PopulateStandard(dr, c); }
//SELECT ID, KundeGrpNavn, status, sort, OprettetAf, OprettetDen, OprettetIP, RettetAf, RettetDen, RettetIP //FROM Co2Db_KundeGrp private static void AddParms(ref DBAccess db, KundeGrp c) { var with_1 = c; db.AddInt("Status", (System.Int32)with_1.Status); db.AddNVarChar("KundeGrpNavn", with_1.KundeGrpNavn, 50); db.AddInt("Sort", with_1.Sort); AddParmsStandard(db, c); }
public static int Update(int ID, string KundeGrpNavn, int Status, int Sort) { KundeGrp c = new KundeGrp(ID); c.KundeGrpNavn = KundeGrpNavn; c.Status = (KundeGrpStatusEnum)Status; c.Sort = Sort; return(Update(c)); }
public static int Insert(string KundeGrpNavn, int Status, int Sort) { KundeGrp c = new KundeGrp(); c.KundeGrpNavn = KundeGrpNavn; c.Status = (KundeGrpStatusEnum)Status; c.Sort = Sort; return(Insert(c)); }
public static string Tags(string tekst, RescueTekniq.BOL.KundeGrp item) { string res = ""; StringBuilder sb = new StringBuilder(); sb.Append(tekst); sb.Replace("[VARE.KUNDEGRP]", item.KundeGrpNavn); res = sb.ToString(); return(res); }
public static int Update(KundeGrp c) { DBAccess db = new DBAccess(); if (c.Status == KundeGrpStatusEnum.Opret) { c.Status = KundeGrpStatusEnum.Aktiv; } db.AddInt("ID", c.ID); AddParms(ref db, c); int retval = db.ExecuteNonQuery(_SQLUpdate); return(retval); }
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 KundeGrp GetKundeGrp_Company(int CompanyID) { KundeGrp c = new KundeGrp(); DBAccess db = new DBAccess(); db.AddInt("CompanyID", CompanyID); SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectByCompany)); if (dr.HasRows) { while (dr.Read()) { Populate(dr, c); } } dr.Close(); return(c); }
public static KundeGrp GetKundeGrp(int ID) { DBAccess db = new DBAccess(); db.AddInt("ID", ID); SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectOne)); if (dr.HasRows) { KundeGrp c = new KundeGrp(); while (dr.Read()) { Populate(dr, c); } dr.Close(); return(c); } else { dr.Close(); return(null); } }
public static int Delete(KundeGrp c) { return(Delete(c.ID)); }