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