public bool Update(GrnPOUpdate obj) { try { return(_GrnPOService.Update(obj)); } catch (Exception ex) { throw new ApiDataException(100, "Category Not Found", HttpStatusCode.NotFound); } }
public bool Update(GrnPOUpdate obj) { { bool res = false; SqlCommand cmd = new SqlCommand("BOM_spGRNStatusUpdate"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@p_GrnNo", obj.GrnNo); cmd.Parameters.AddWithValue("@p_StatusID", obj.StatusID); cmd.Parameters.AddWithValue("@p_MaterialType", obj.MaterialType); cmd.Parameters.AddWithValue("@p_ActionBy", obj.ActionBy); cmd.Parameters.AddWithValue("@p_PODetails", obj.PODetails); //cmd.Parameters.AddWithValue("@p_ModifiedBy", obj.ModifiedBy); //cmd.Parameters.AddWithValue("@p_CreatedOn", obj.CreatedOn); //cmd.Parameters.AddWithValue("@p_GrnDetails", obj.GrnDetails); var locMax = _unitOfWork.DbLayer.ExecuteNonQuery(cmd); if (locMax != Int32.MaxValue) { res = true; } return(res); } }