/// <summary> /// Get single work request /// </summary> /// <returns></returns> public WorkRequestViewModel GetWorkRequest(int id) { WorkRequestViewModel request = new WorkRequestViewModel(); using (var DataWrapper = new DataWrapper()) { var reader = DataWrapper.QueryWithParams("GetWorkRequest", "@WorkRequestId", id); if (reader.Read()) { request.WorkRequestId = GetIntValue(reader, "WorkRequestId"); request.WorkRequestTitle = GetStringValue(reader, "WorkRequestTitle"); request.WorkRequestDescription = GetStringValue(reader, "WorkRequestDescription"); request.IssueReportedBy = GetStringValue(reader, "IssueReportedBy"); request.IssueReportedDate = Convert.ToDateTime(reader["IssueReportedDate"]); request.DepartmentId = GetIntValue(reader, "DepartmentId"); request.DepartmentName = GetStringValue(reader, "DepartmentName"); request.StatusId = GetIntValue(reader, "StatusId"); request.StatusName = GetStringValue(reader, "StatusName"); request.PriorityId = GetIntValue(reader, "PriorityId"); request.PriorityName = GetStringValue(reader, "PriorityName"); request.RequestTypeId = GetIntValue(reader, "RequestTypeId"); request.RequestTypeName = GetStringValue(reader, "RequestTypeName"); request.DueDate = Convert.ToDateTime(reader["DueDate"]); request.CreatedBy = GetStringValue(reader, "CreatedBy"); request.LastUpdateBy = GetStringValue(reader, "LastUpdateBy"); request.Departments = GetDepartments(); request.Priorities = GetPriorities(); request.RequestTypes = GetRequestTypes(); request.Statuses = GetStatuses(); } } return(request); }
public ActionResult Edit(int id, WorkRequestViewModel model) { try { if (ModelState.IsValid) { model.LastUpdateBy = User.Identity.GetFullName(); model.WorkRequestId = id; DAL.WorkRequests updateRequest = new DAL.WorkRequests(); string result = updateRequest.UpdateWorkRequest(model); if (result == "-1") { TempData["Message"] = "Work request successfully updated!"; } ModelState.Clear(); return(RedirectToAction("Index")); } model.Departments = DAL.WorkRequests.GetDepartments(); model.Priorities = DAL.WorkRequests.GetPriorities(); model.RequestTypes = DAL.WorkRequests.GetRequestTypes(); model.Statuses = DAL.WorkRequests.GetStatuses(); return(View(model)); } catch { ModelState.AddModelError("", "Error saving data"); return(View(model)); } }
public ActionResult Create(WorkRequestViewModel model) { try { if (ModelState.IsValid) { model.CreatedBy = User.Identity.GetFullName(); DAL.WorkRequests wr = new DAL.WorkRequests(); string result = wr.AddWorkRequest(model); if (result == "-1") { TempData["Message"] = "Work request successfully created!"; } ModelState.Clear(); return(RedirectToAction("Index")); } model.Departments = DAL.WorkRequests.GetDepartments(); model.Priorities = DAL.WorkRequests.GetPriorities(); model.RequestTypes = DAL.WorkRequests.GetRequestTypes(); return(View(model)); } catch { ModelState.AddModelError("", "Error saving data"); return(View(model)); } }
// GET: WorkRequests/Edit/5 public ActionResult Edit(int id) { WorkRequestViewModel model = new WorkRequestViewModel(); DAL.WorkRequests wr = new DAL.WorkRequests(); return(View(wr.GetWorkRequest(id))); }
public ActionResult Index() { WorkRequestViewModel model = new WorkRequestViewModel(); DAL.WorkRequests wr = new DAL.WorkRequests(); model.GetAllWorkRequests = wr.GetWorkRequests(); return(View(model)); }
public IActionResult Index() { var model = new WorkRequestViewModel(); WRICard card = new WRICard(); card.ID = 1; model.WRICard = card; return(View(model)); }
// GET: WorkRequests/Create public ActionResult Create() { WorkRequestViewModel model = new WorkRequestViewModel(); model.Departments = DAL.WorkRequests.GetDepartments(); model.Priorities = DAL.WorkRequests.GetPriorities(); model.RequestTypes = DAL.WorkRequests.GetRequestTypes(); return(View(model)); }
public IActionResult CreateNewTask(WorkRequestViewModel model) { if (ModelState.IsValid) { using (var db = _context) { db.Add(model); db.SaveChanges(); } } return(View()); }
/// <summary> /// Add a new work request /// </summary> /// <param name="model"></param> /// <returns></returns> public string AddWorkRequest(WorkRequestViewModel model) { using (SqlCommand cmd = new SqlCommand("AddWorkRequest", connection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@WorkRequestTitle", model.WorkRequestTitle); cmd.Parameters.AddWithValue("@WorkRequestDescription", model.WorkRequestDescription); cmd.Parameters.AddWithValue("@IssueReportedBy", model.IssueReportedBy); cmd.Parameters.AddWithValue("@IssueReportedDate", model.IssueReportedDate); cmd.Parameters.AddWithValue("@DepartmentId", model.DepartmentId); cmd.Parameters.AddWithValue("@PriorityId", model.PriorityId); cmd.Parameters.AddWithValue("@RequestTypeId", model.RequestTypeId); cmd.Parameters.AddWithValue("@DueDate", model.DueDate); cmd.Parameters.AddWithValue("@CreatedBy", model.CreatedBy); connection.Open(); string result = cmd.ExecuteNonQuery().ToString(); return(result); } }