예제 #1
0
 public bool Post([FromBody] WorkOrderDetailsEntity WODEntity)
 {
     try
     {
         return(_WODService.CreateWOD(WODEntity));
     }
     catch (Exception ex)
     {
         throw new ApiDataException(1000, "Category Not Found", HttpStatusCode.NotFound);
     }
 }
예제 #2
0
 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);
        }