public bool Post([FromBody] WorkOrderDetailsEntity WODEntity) { try { return(_WODService.CreateWOD(WODEntity)); } catch (Exception ex) { throw new ApiDataException(1000, "Category Not Found", HttpStatusCode.NotFound); } }
public bool Put([FromBody] WorkOrderDetailsEntity WODEntity) { try { if (WODEntity.WorkItemID > 0) { return(_WODService.UpdateWOD(WODEntity.WorkItemID, WODEntity)); } } catch (Exception ex) { throw new ApiDataException(1000, "Category not found", HttpStatusCode.NotFound); } return(false); }
public bool UpdateWOD(int WorkItemID, WorkOrderDetailsEntity obj) { bool res = false; SqlCommand cmd = new SqlCommand("WOD_spSaveWorkOrderDetails"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@p_WorkItemID", obj.WorkItemID); cmd.Parameters.AddWithValue("@p_OrderItemID", obj.OrderItemID); cmd.Parameters.AddWithValue("@p_prdID", obj.prdID); cmd.Parameters.AddWithValue("@p_UOMID", obj.UOMID); cmd.Parameters.AddWithValue("@p_Status", obj.Status); cmd.Parameters.AddWithValue("@p_ActionBy", obj.ActionBy); cmd.Parameters.AddWithValue("@p_IsActive", obj.IsActive); var locMax = _unitOfWork.DbLayer.ExecuteNonQuery(cmd); if (locMax != Int32.MaxValue) { res = true; } return(res); }