public void Create(UnusualRequests item) { var insert = database.GetCommand("INSERT INTO Requests(FullName, IllogicalRequest, Occurance) VALUES (@fn,@ir,@oc)"); database.ExecuteInsert(insert, new SQLiteParameter() { ParameterName = "@fn", Value = item.FullName }, new SQLiteParameter() { ParameterName = "@ir", Value = item.QuestionOrRequest }, new SQLiteParameter() { ParameterName = "@oc", Value = item.Occurrence }); }
public void Update(UnusualRequests item) { var insert = database.GetCommand("UPDATE Requests SET FullName = @fn, IllogicalRequest = @ir, Occurance = @oc WHERE Id = @id"); database.ExecuteInsert(insert, new SQLiteParameter() { ParameterName = "@fn", Value = item.FullName }, new SQLiteParameter() { ParameterName = "@ir", Value = item.QuestionOrRequest }, new SQLiteParameter() { ParameterName = "@oc", Value = item.Occurrence }, new SQLiteParameter() { ParameterName = "@id", Value = item.RequestId }); }
public IHttpActionResult Create([FromBody] UnusualRequests req) { if (req == null) { //Cannot create with no data return(BadRequest()); } RequestRepo.Create(req); return(new System.Web.Http.Results.OkResult(this)); }
private List <UnusualRequests> Parse(DataTable results) { List <UnusualRequests> data = new List <UnusualRequests>(); foreach (DataRow row in results.Rows) { UnusualRequests ur = new UnusualRequests(); ur.RequestId = int.Parse(row.ItemArray[0].ToString()); ur.FullName = row.ItemArray[1].ToString(); ur.QuestionOrRequest = row.ItemArray[2].ToString(); ur.Occurrence = DateTime.Parse(row.ItemArray[3].ToString()); data.Add(ur); } return(data); }
public IHttpActionResult Update(int id, [FromBody] UnusualRequests req) { if (req == null) { //need data to process an update return(BadRequest()); } if (RequestRepo.GetById(id) == null) { //This record does not exist return(NotFound()); } RequestRepo.Update(req); return(new System.Web.Http.Results.OkResult(this)); }
private List<UnusualRequests> Parse(DataTable results) { List<UnusualRequests> data = new List<UnusualRequests>(); foreach (DataRow row in results.Rows) { UnusualRequests ur = new UnusualRequests(); ur.RequestId = int.Parse(row.ItemArray[0].ToString()); ur.FullName = row.ItemArray[1].ToString(); ur.QuestionOrRequest = row.ItemArray[2].ToString(); ur.Occurrence = DateTime.Parse(row.ItemArray[3].ToString()); data.Add(ur); } return data; }