public ExceptionTypes SetCurrentBatchStatus(out string errorMessage) { try { DAHelper dah = new DAHelper(); DataSet dsTable = new DataSet(); errorMessage = string.Empty; long executionResult = 0; executionResult = dah.ExecuteScalar(ConstantTexts.Query_Update_MQTRRBatchStatus, new List <SqlParameter>().ToArray(), out object obj, out string erorrMessage); if (executionResult == 0) { return(ExceptionTypes.Success); } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { Console.WriteLine("Error : " + ex.Message); errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } }
public ExceptionTypes GetCaseDiscrepancyCategory(long lQueueID, out long lDiscrepancyCategory, out string errorMessage) { DAHelper dah = new DAHelper(); errorMessage = string.Empty; List <SqlParameter> parameters = new List <SqlParameter>(); //call function to map object properties to SQL parameters for query execution SqlParameter sqlParam = new SqlParameter(); sqlParam.ParameterName = "@lQueueID"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = lQueueID; parameters.Add(sqlParam); string query = "Select DiscrepancyCategoryLkup from Gen_Queue where Gen_QueueId=@lQueueID"; long executionResult = dah.ExecuteScalar(query, parameters.ToArray(), out object DiscrepancyCategoryLkup, out string erorrMessage); lDiscrepancyCategory = (!DiscrepancyCategoryLkup.IsNull()) ? DiscrepancyCategoryLkup.ToInt64() : 0; return((ExceptionTypes)executionResult); }