/// <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);
}
}
