public static object Exist_DB(string query, string HoleID, decimal FromV)
{
try
{
object oRes;
SqlParameter[] arr = oData.GetParameters(2);
arr[0].ParameterName = "@HoleID";
arr[0].Value = HoleID;
arr[1].ParameterName = "@SKDHSamples";
arr[1].Value = FromV;
oRes = oData.ExecuteScalar(query, arr, CommandType.Text);
return(oRes);
}
catch (Exception eX)
{
throw new Exception("Save error LabSubmitIn. " + eX.Message);;
}
}
public DataTable getRfVeinsCodes()
{
DataTable result;
try
{
DataSet dataSet = new DataSet();
SqlParameter[] parameters = oData.GetParameters(0);
dataSet = oData.ExecuteDataset("[dbo].[usp_getRfVeinsCodes]", parameters, CommandType.StoredProcedure);
result = dataSet.Tables[0];
}
catch (Exception ex)
{
throw new Exception("Error in dtRfVeinsCodesAll: " + ex.Message);
}
return(result);
}
