/// <summary>
        /// To set parameters for completing the create ticket procedure
        /// </summary>
        /// <param name="objCDOEntity"></param>
        /// <returns type=objectarray >sp_parames</returns>
        public SqlParameter[] GetSpParametersSaveTicketIssueDetails(IssueTicketEntity issueTicketEntity)
        {
            SqlParameter[] sp_parames = null;
            BGSGeneral.cGeneral objBGSGeneral = new BGSGeneral.cGeneral();
            try
            {
                if (issueTicketEntity != null)
                {
                    sp_parames = new SqlParameter[9];
                    sp_parames[0] = new SqlParameter(DBConstants.CONST_SP_PARAM_TICKETNUMBER, issueTicketEntity.BarCode);
                    sp_parames[1] = new SqlParameter(DBConstants.CONST_SP_PARAM_DATEPRINTED, issueTicketEntity.Date);
                    sp_parames[2] = new SqlParameter(DBConstants.CONST_SP_PARAM_WINDOWUSER, System.Environment.UserName.ToString());
                    sp_parames[3] = new SqlParameter(DBConstants.CONST_SP_PARAM_USERID, "userstring");
                    sp_parames[4] = new SqlParameter(DBConstants.CONST_SP_PARAM_MACHINENAME, objBGSGeneral.GetMachineName());
                    sp_parames[5] = new SqlParameter(DBConstants.CONST_SP_PARAM_TOTALVALUE, issueTicketEntity.dblValue);
                    sp_parames[6] = new SqlParameter(DBConstants.CONST_SP_PARAM_CASHTOTAL, issueTicketEntity.dblValue);
                    sp_parames[7] = new SqlParameter(DBConstants.CONST_SP_PARAM_CASHABLE, false);

                    SqlParameter ReturnValue = new SqlParameter();
                    ReturnValue.ParameterName = DBConstants.CONST_SP_PARAM_RETURNVALUE;
                    ReturnValue.Direction = ParameterDirection.ReturnValue;
                    sp_parames[8] = ReturnValue;
                }
            }
            catch (Exception ex)
            {
                ExceptionManager.Publish(ex);
            }

            return sp_parames;
        }
        /// <summary>
        /// To set parameters for ticket creation algorithm
        /// </summary>
        /// <param name="objCDOEntity"></param>
        /// <returns type=objectarray >sp_parames</returns>
        public SqlParameter[] GetSpParametersCreateTicketStart(IssueTicketEntity issueTicketEntity)
        {
            SqlParameter[] sp_parames = null;

            try
            {
                BGSGeneral.cGeneral objBGSGeneral = new BGSGeneral.cGeneral();
                if (issueTicketEntity != null)
                {
                    sp_parames = new SqlParameter[7];

                    SqlParameter param0 = new SqlParameter();
                    param0.ParameterName = DBConstants.CONST_SP_PARAM_INSTALLATIONID;
                    param0.Direction = ParameterDirection.Input;
                    param0.Value = 0;
                    sp_parames[0] = param0;

                    SqlParameter param1 = new SqlParameter();
                    param1.ParameterName = DBConstants.CONST_SP_PARAM_DATAPAKSERIALNUMBER;
                    param1.Direction = ParameterDirection.Input;
                    param1.Value = 0;
                    sp_parames[1] = param1;

                    SqlParameter param2 = new SqlParameter();
                    param2.ParameterName = DBConstants.CONST_SP_PARAM_TICKETVALUE;
                    param2.Direction = ParameterDirection.Input;
                    param2.Value = issueTicketEntity.lnglValue;
                    sp_parames[2] = param2;

                    SqlParameter param3 = new SqlParameter();
                    param3.ParameterName = DBConstants.CONST_SP_PARAM_SERVERNAME;
                    param3.Direction = ParameterDirection.Input;
                    param3.Value = objBGSGeneral.GetMachineName();
                    sp_parames[3] = param3;

                    sp_parames[4] = new SqlParameter();
                    sp_parames[4].ParameterName = DBConstants.CONST_SP_PARAM_RETURNTICKETNUMBER;
                    sp_parames[4].Direction = ParameterDirection.Output;
                    sp_parames[4].Value = string.Empty;
                    sp_parames[4].SqlDbType = SqlDbType.VarChar;
                    sp_parames[4].Size = 18;

                    SqlParameter param5 = new SqlParameter();
                    param5.ParameterName = DBConstants.CONST_SP_PARAM_TICKETTYPE;
                    param5.Direction = ParameterDirection.Input;
                    param5.Value = issueTicketEntity.Type;
                    sp_parames[5] = param5;

                    SqlParameter ReturnValue = new SqlParameter();
                    ReturnValue.ParameterName = DBConstants.CONST_SP_PARAM_RETURNVALUE;
                    ReturnValue.Direction = ParameterDirection.ReturnValue;
                    sp_parames[6] = ReturnValue;
                }
            }
            catch (Exception ex)
            {
                ExceptionManager.Publish(ex);
            }
            return sp_parames;

        }