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);
}
