Example #1
0
        //--------------------------------------------------------------------

        public int Insert(CompteService pCompteService)
        {
            string[] lsCols   = null;
            string[] lsValues = null;
            this.FillArray(ref lsCols, ref lsValues, pCompteService, true);
            return(DataBase.Insert("[CompteService]", lsCols, lsValues));
        }
Example #2
0
        //---------------------------------------------------------------------
        private void FillArray(ref string[] pCols, ref string[] pValues, CompteService pCompteService, bool pIsInsertID)
        {
            int liCpt    = 0;
            int liNombre = 2;

            if (pIsInsertID)
            {
                pCols            = new string[liNombre + 1];
                pValues          = new string[liNombre + 1];
                pCols[liCpt]     = "iD";
                pValues[liCpt++] = "'" + pCompteService.ID.ToString() + "'";
            }
            else
            {
                pCols   = new string[liNombre];
                pValues = new string[liNombre];
            }


            pCols[liCpt]     = "id_compe";
            pValues[liCpt++] = "'" + Util.DoubleQuote(pCompteService.Id_compe) + "'";

            pCols[liCpt]     = "id_service";
            pValues[liCpt++] = "'" + Util.DoubleQuote(pCompteService.Id_service) + "'";
        }
Example #3
0
        //---------------------------------------------------------------------
        public int Update(CompteService pCompteService)
        {
            string[] lsCols   = null;
            string[] lsValues = null;

            this.FillArray(ref lsCols, ref lsValues, pCompteService, false);
            return(DataBase.UpdateID("CompteService", lsCols, lsValues, pCompteService.ID));
        }
Example #4
0
        //--------------------------------------------------------------------
        private CompteService FillFields(DataRow pDataRow)
        {
            CompteService lCompteService = new CompteService();


            lCompteService.Id_compe = (string)pDataRow["id_compe"];

            lCompteService.Id_service = (string)pDataRow["id_service"];



            lCompteService.ID = new Guid(pDataRow["iD"].ToString());
            return(lCompteService);
        }
Example #5
0
        //--------------------------------------------------------------------
        public CompteService Find(Guid ID)
        {
            CompteService lCompteService = (CompteService)AbstractFind(ID);

            if (Util.isNULL(lCompteService))
            {
                DataRow row = DataBase.SelectID(ID, "[CompteService]");
                if (Util.isNULL(row))
                {
                    return(null);
                }
                lCompteService = this.FillFields(row);
                LoadedMap.Add(lCompteService.ID, lCompteService);
            }
            return(lCompteService);
        }
Example #6
0
 //----------------------------------------------------------------------------------------
 public int Delete(CompteService pCompteService)
 {
     return(DataBase.DeleteID(pCompteService.ID, "[CompteService]"));
 }