>String currentOperator, currentSalespoint, closeOperator, closeSalespoint, cDetails; > currentOperator = GetParameterValue(parameters, "tcOperator"); > currentSalespoint = GetParameterValue(parameters, "tcSalespoint"); > cDetails = GetParameterValue(parameters, "tcDetails"); > closeOperator = cDetails.ParseStringFromSqml("CLOSE_OP"); > if (String.IsNullOrWhiteSpace(closeOperator)) > closeOperator = currentOperator; > closeSalespoint = cDetails.ParseStringFromSqml("CLOSE_SP"); > if (String.IsNullOrWhiteSpace(closeSalespoint)) > closeSalespoint = currentSalespoint; > DateTime startTime, endTime; > startTime = cDetails.ParseDateTimeFromSqml("START_TIME"); > endTime = cDetails.ParseDateTimeFromSqml("END_TIME"); >>
>>SqlCommand sqlCommand = new SqlCommand(); >> >> sqlCommand.CommandType = CommandType.Text; >> sqlCommand.CommandText = "select closedrwrs from dbo.prefs_sl;"; >> >> if (database.ExecuteSqlCommand(sqlCommand, ref messageText, ref statusCode)) >> { >> Int16 closeDrawers; >> if (Int16.TryParse(messageText, out closeDrawers)) >> { >> if (closeDrawers < 2) >> { >> statusCode = 610; >> messageText = "System is not set up to close cash drawers"; >> } >> // Ok to close a drawer >> else >> { >> sqlCommand.Parameters.Clear(); >> String currentOperator, currentSalespoint, closeOperator, closeSalespoint, cDetails; >> currentOperator = GetParameterValue(parameters, "tcOperator"); >> currentSalespoint = GetParameterValue(parameters, "tcSalespoint"); >> cDetails = GetParameterValue(parameters, "tcDetails"); >> closeOperator = cDetails.ParseStringFromSqml("CLOSE_OP"); >> if (String.IsNullOrWhiteSpace(closeOperator)) >> closeOperator = currentOperator; >> closeSalespoint = cDetails.ParseStringFromSqml("CLOSE_SP"); >> if (String.IsNullOrWhiteSpace(closeSalespoint)) >> closeSalespoint = currentSalespoint; >> DateTime startTime, endTime; >> startTime = cDetails.ParseDateTimeFromSqml("START_TIME"); >> endTime = cDetails.ParseDateTimeFromSqml("END_TIME"); >> String closeType; >>>>