public async Task <WorkOrder> CreateWorkOrder(WorkOrderForCreateDto workOrderForCreate)
{
WorkOrder workOrder = new WorkOrder();
using (var conn = new SqlConnection(_config["ConnectionStrings:DefaultConnection"]))
{
var cmd = new SqlCommand("pr_createWorkOrder", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@workOrderTypeId", workOrderForCreate.WorkOrderTypeId));
cmd.Parameters.Add(new SqlParameter("@title", workOrderForCreate.Title));
cmd.Parameters.Add(new SqlParameter("@description", workOrderForCreate.Description));
if (workOrderForCreate.AssignedTo > 0)
{
cmd.Parameters.Add(new SqlParameter("@assignedTo", workOrderForCreate.AssignedTo));
}
else
{
cmd.Parameters.Add(new SqlParameter("@assignedTo", DBNull.Value));
}
cmd.Parameters.Add(new SqlParameter("@requestFor", workOrderForCreate.RequestFor));
cmd.Parameters.Add(new SqlParameter("@submittedBy", workOrderForCreate.SubmittedBy));
cmd.Parameters.Add("@new_id", SqlDbType.Int).Direction = ParameterDirection.Output;
conn.Open();
await cmd.ExecuteNonQueryAsync();
workOrder.Id = Convert.ToInt32(cmd.Parameters["@new_id"].Value);
}
return(workOrder);
}
public async Task <WorkOrder> CreateWorkOrder(WorkOrderForCreateDto workOrderForCreate)
{
var result = await _workOrderDL.CreateWorkOrder(workOrderForCreate);
var createdWorkOrder = await _workOrderDL.GetById(result.Id);
return(createdWorkOrder);
}
public async Task <IActionResult> CreateWorkOrder(WorkOrderForCreateDto workOrderForCreate)
{
var result = await _workOrderRepository.CreateWorkOrder(workOrderForCreate);
return(CreatedAtRoute("GetById", new { id = result.Id }, result));
}
