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