Ejemplo n.º 1
0
        public IActionResult Get()
        {
            DALOps dal       = new DALOps(connStr, database);
            var    dotNetObj = dal.GetCollection(dal, collection);

            return(Ok(dotNetObj));
        }
Ejemplo n.º 2
0
        //[Route("api/[controller]/Delete")]
        public IActionResult Delete(string param)
        {
            DALOps dal       = new DALOps(connStr, database);
            var    dotNetObj = dal.DeleteCollection(dal, collection, "personid", param);

            return(Ok(dotNetObj));
        }
Ejemplo n.º 3
0
        public ActionResult <object> Delete(string param)
        {
            DALOps dal       = new DALOps(connStr, database);
            var    dotNetObj = dal.DeleteCollection(dal, collection, "citizenid", param);

            return(dotNetObj);
        }
Ejemplo n.º 4
0
        //[Route("api/[controller]/Put")]
        public IActionResult Put([FromBody] Persons person, string personid)
        {
            DALOps dal = new DALOps(connStr, database);
            Dictionary <object, object> pairs = new Dictionary <object, object>();

            pairs.Add("personid", personid);
            var dotNetObj = dal.UpdateCollection(dal, collection, person, pairs);

            return(Ok(dotNetObj));
        }
Ejemplo n.º 5
0
        //[Route("api/[controller]/Post")]
        public IActionResult Post([FromBody] Persons person)
        {
            DALOps dal  = new DALOps(connStr, database);
            var    coll = dal.GetCollectionCount(dal, collection);

            person.personid = "PH" + (coll + 1).ToString();
            var dotNetObj = dal.InsertToCollection(dal, collection, person);

            return(Ok(dotNetObj));
        }
Ejemplo n.º 6
0
        public IActionResult GetOne(string personid)
        {
            DALOps dal = new DALOps(connStr, database);
            Dictionary <object, object> pairs = new Dictionary <object, object>();

            pairs.Add("personid", personid);
            var dotNetObj = dal.GetCollectionWithParams(dal, collection, pairs);

            return(Ok(dotNetObj));
        }
Ejemplo n.º 7
0
        public ActionResult <object> Put(Citizens citizen)
        {
            DALOps dal = new DALOps(connStr, database);
            Dictionary <object, object> pairs = new Dictionary <object, object>();

            pairs.Add("citizenid", citizen.citizenid);
            var dotNetObj = dal.UpdateCollection(dal, collection, citizen, pairs);

            return(dotNetObj);
        }
Ejemplo n.º 8
0
        public ActionResult <object> Post(Citizens citizen)
        {
            DALOps dal  = new DALOps(connStr, database);
            var    coll = dal.GetCollectionCount(dal, collection);

            citizen.citizenid = "PH" + (coll + 1).ToString();
            var dotNetObj = dal.InsertToCollection(dal, collection, citizen);

            return(dotNetObj);
        }
Ejemplo n.º 9
0
        public ActionResult <object> Get(string citizen_id)
        {
            DALOps dal = new DALOps(connStr, database);
            Dictionary <object, object> pairs = new Dictionary <object, object>();

            pairs.Add("citizenid", citizen_id);
            var dotNetObj = dal.GetCollectionWithParams(dal, collection, pairs);

            return(dotNetObj);
        }
Ejemplo n.º 10
0
        public ActionResult <object> Get()
        {
            DALOps dal = new DALOps(connStr, database);

            #if DALChanges1
            var dotNetObj = dal.GetCollection(collection);
            #else
            var dotNetObj = dal.GetCollection(dal, collection);
            #endif

            return(dotNetObj);
        }