public IActionResult Get() { DALOps dal = new DALOps(connStr, database); var dotNetObj = dal.GetCollection(dal, collection); return(Ok(dotNetObj)); }
//[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)); }
public ActionResult <object> Delete(string param) { DALOps dal = new DALOps(connStr, database); var dotNetObj = dal.DeleteCollection(dal, collection, "citizenid", param); return(dotNetObj); }
//[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)); }
//[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)); }
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)); }
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); }
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); }
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); }
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); }