public IHttpActionResult Delete(string id) { try { CallViewModel call = new CallViewModel(); call.Id = id; long delRetCall = call.Delete(); switch (delRetCall) { case 1: return(Ok("Ok! Call has been deleted!")); case 2: return(Ok("Error! Call does not Exist!")); default: return(Ok("Call not Deleted!")); } } catch (Exception ex) { return(BadRequest("Update Failed - Contact Tech Support")); } }
public IHttpActionResult Delete(CallViewModel call) { try { long retVal = call.Delete(); switch (retVal) { case 1: return(Ok("Call " + call.Notes + " Deleted!")); case -1: return(Ok("Call " + call.Notes + " not deleted!")); case -2: return(Ok("Data is stale for " + call.Notes + ", Call already deleted!")); default: return(Ok("Call " + call.Notes + " not deleted!")); } } catch (Exception ex) { return(BadRequest("Retrieve failed - " + ex.Message)); } }
// 'DELETE' method to remove and employee from the database public IHttpActionResult Delete(int id) { try { // Create and EmployeeViewModel object to store the employee data CallViewModel call = new CallViewModel(); // The EmployeeViewModel Object ID is that of the ID past into the methods parameters // when called in the JavaScript call.Id = id; // If the number of employees deleted equals 1 then display the message that it was successful // else display a message that it was unsuccessful if (call.Delete() == 1) { return(Ok("Call " + call.Id + " deleted!")); } else { return(Ok("Call " + call.Id + " not deleted!")); } } catch (Exception ex) { return(BadRequest("Delete failed - Contact Tech Support")); } }
public void ComprehensiveVMTests() { CallViewModel cvm = new CallViewModel(); EmployeeViewModel evm = new EmployeeViewModel(); ProblemViewModel pvm = new ProblemViewModel(); cvm.DateOpened = DateTime.Now; cvm.DateClosed = null; cvm.OpenStatus = true; evm.Lastname = "Jarocki"; evm.GetByLastname(); cvm.EmployeeId = evm.Id; evm.Lastname = "Burner"; evm.GetByLastname(); cvm.TechId = evm.Id; pvm.Description = "Memory Upgrade"; pvm.GetByDescription(); cvm.ProblemId = pvm.Id; cvm.Notes = "Kevin has bad RAM, Burner to fix it"; cvm.Add(); Console.WriteLine("New Call Generated - Id = " + cvm.Id); int id = cvm.Id; //need id for delete later cvm.GetById(); cvm.Notes += "\n Ordered new RAM!"; if (cvm.Update() == 1) { Console.WriteLine("Call was updated " + cvm.Notes); } else { Console.WriteLine("Call was not updated!"); } cvm.Notes = "Another change to comments that should not work"; if (cvm.Update() == -2) { Console.WriteLine("Call was not updated data was stale"); } cvm = new CallViewModel(); cvm.Id = id; cvm.GetById(); if (cvm.Delete() == 1) { Console.WriteLine("Call was deleted!"); } else { Console.WriteLine("Call was not deleted"); } cvm.GetById(); }
public void ComprehensiveVMTests() { CallViewModel cvm = new CallViewModel(); EmployeeViewModel evm = new EmployeeViewModel(); ProblemViewModel pvm = new ProblemViewModel(); cvm.DateOpened = DateTime.Now; cvm.DateClosed = null; cvm.OpenStatus = true; evm.Lastname = "Pollock"; evm.GetByLastname(); cvm.EmployeeId = evm.Id; evm.Lastname = "Burner"; evm.GetByLastname(); cvm.TechId = evm.Id; pvm.Description = "Memory Upgrade"; pvm.GetByDescription(); cvm.ProblemId = pvm.Id; cvm.Notes = "Chris has bad RAM, Burner to fix it"; cvm.Add(); Console.WriteLine("New Call Generated - Id = " + cvm.Id); int id = cvm.Id; // need Id for delete later cvm.GetById(); cvm.Notes += "\n Ordered new RAM!"; if (cvm.Update() == 1) { Console.WriteLine("Call was updated " + cvm.Notes); } else { Console.WriteLine("Call was NOT updated!"); } cvm.Notes = "Another change to comments that should not work."; if (cvm.Update() == -2) { Console.WriteLine("Call was NOT updated, data was stale."); } cvm = new CallViewModel(); // need to reset because of Concurrency cvm.Id = id; cvm.GetById(); if (cvm.Delete() == 1) { Console.WriteLine("Call was deleted!"); } else { Console.WriteLine("Call was NOT deleted!"); } cvm.GetById(); // should throw expected exception }
public void Call_ComprehensiveVMTest() { CallViewModel cvm = new CallViewModel(); EmployeeViewModel evm = new EmployeeViewModel(); ProblemViewModel pvm = new ProblemViewModel(); cvm.DateOpened = DateTime.Now; cvm.DateClosed = null; cvm.OpenStatus = true; evm.Email = "*****@*****.**"; evm.GetByEmail(); cvm.EmployeeId = evm.Id; evm.Lastname = "*****@*****.**"; evm.GetByEmail(); cvm.EmployeeName = evm.Lastname; cvm.TechId = evm.Id; pvm.Description = "Memory Upgrade"; pvm.GetByDescription(); cvm.ProblemId = pvm.Id; cvm.Notes = "Sonia has bad RAM, Burner to fix it"; cvm.Add(); output.WriteLine("New Call Generated - Id = " + cvm.Id); int id = cvm.Id; cvm.GetById(); cvm.Notes += "\n Ordered new RAM!"; if (cvm.Update() == 1) { output.WriteLine("Call was updated " + cvm.Notes); } else { output.WriteLine("Call was not updated!"); } cvm.Notes = "Another change to comments that should not work"; if (cvm.Update() == -2) { output.WriteLine("Call was not updated data was stale"); } cvm = new CallViewModel();// need to reset because of concureency error cvm.Id = id; cvm.GetById(); if (cvm.Delete() == 1) { output.WriteLine("Call was deleted"); } else { output.WriteLine("Call was not deleted"); } Exception ex = Assert.Throws <NullReferenceException>(() => cvm.GetById()); // should throw expected exception Assert.Equal("Object reference not set to an instance of an object.", ex.Message); }
public void ComprehensiveVMTestsShouldReturnTrue() { CallViewModel cvm = new CallViewModel(); EmployeeViewModel evm = new EmployeeViewModel(); ProblemViewModel pvm = new ProblemViewModel(); cvm.DateOpened = DateTime.Now; cvm.DateClosed = null; cvm.OpenStatus = true; evm.Lastname = "Smartypants"; evm.GetByLastname(); cvm.EmployeeId = evm.Id; evm.Lastname = "Burner"; evm.GetByLastname(); cvm.TechId = evm.Id; pvm.Description = "Memory Upgrade"; pvm.GetByProblemDescription(); cvm.ProblemId = pvm.Id; cvm.Notes = "Bigshot has bad RAM, Burner to fix it"; cvm.Version = 1; cvm.Create(); this.tstCtx.WriteLine("New Call Generated - Id = " + cvm.Id); cvm.GetById(); this.tstCtx.WriteLine("New Call Retrieved"); cvm.Notes = "\n Ordered new RAM!"; if (cvm.Update() == 1) { this.tstCtx.WriteLine("Call was updated " + cvm.Notes); } else { this.tstCtx.WriteLine("Call was not updated"); } if (cvm.Update() == -2) { this.tstCtx.WriteLine("Call was not updated data was stale"); } if (cvm.Delete() == 1) { this.tstCtx.WriteLine("Call was deleted"); } else { this.tstCtx.WriteLine("Call was not deleted"); } cvm.GetById(); // should throw expected exception }
public IHttpActionResult Delete(string Id) { try { CallViewModel call = new CallViewModel(); call.Id = Id; call.GetByID(Id); call.Delete(); return(Ok("Call deleted!")); } catch (Exception ex) { return(BadRequest("Update failed - " + ex.Message)); } }
public IActionResult Delete(int id) { try { CallViewModel viewModel = new CallViewModel(); viewModel.Id = id; return(viewModel.Delete() == 1 ? Ok(new { msg = "Call " + id + " deleted!" }) : Ok(new { msg = "Call " + id + " not deleted!" })); } catch (Exception ex) { _logger.LogError("Problem in " + GetType().Name + " " + MethodBase.GetCurrentMethod().Name + " " + ex.Message); return(StatusCode(StatusCodes.Status500InternalServerError)); } }
public IHttpActionResult Delete(int id) { try { CallViewModel call = new CallViewModel(); call.Id = id; if (call.Delete() == 1) { return(Ok("Call " + id + " deleted!")); } else { return(Ok("Call not deleted!")); } } catch (Exception e) { return(BadRequest("Delete failed- Contact Tech Support")); } }
public IHttpActionResult Delete(int id) { try { CallViewModel call = new CallViewModel(); call.Id = id; //Use the EmployeeViewModel's delete method and check the return to see if the delete was successful if (call.Delete() == 1) { return(Ok("Call deleted!")); } else { return(Ok("Call not deleted!")); } } catch (Exception ex) { return(BadRequest("Delete failed - Contact Tech Support")); } }
public void CallViewModelComprehensiveTestsReturnTrue() { CallViewModel vm = new CallViewModel(); vm.DateOpened = DateTime.Now; vm.OpenStatus = true; vm.EmployeeId = "56464e723dd4df30e88b8b8c"; // Bigshot vm.TechId = "56464e723dd4df30e88b8b92"; //Burner vm.ProblemId = "56464e723dd4df30e88b8b99"; vm.Notes = "Bigshot has bad RAM, Burner to fix it"; vm.Create(); this.testContextInstance.WriteLine("New Call Id == " + vm.Id); vm.GetByID(vm.Id); this.testContextInstance.WriteLine("Call retrieved"); vm.Notes = vm.Notes + "\nOrdered new Ram"; if (vm.Update() == 1) { this.testContextInstance.WriteLine("Call was updated " + vm.Notes); } else { Trace.WriteLine("Call was not updated"); } if (vm.Delete()) { this.testContextInstance.WriteLine("Call was deleted"); } else { this.testContextInstance.WriteLine("Call was not deleted"); } vm.Update(); //should throw MongoException see attribute }