public bool DeleteQuestion(short QuestionID)
{
Common.ConnectionManagement myconnector = new Common.ConnectionManagement(_connectionstring);
List <SqlParameter> procParams = new List <SqlParameter>();
procParams.Add(new SqlParameter("QuestionID", QuestionID));
Common.SQLQueryResult queryRes = myconnector.ExecuteNonQueryProcedure("srvy.DeleteQuestion", procParams, 600);
_lastSqlException = queryRes.SqlError;
if (queryRes.SqlError != null)
{
return(false);
}
else
{
return(true);
}
}
//-----------------------------------------
//-------- Answer Table Methods ----------
//-----------------------------------------
public bool InsertAnswer(short QuestionID, bool?YesNo, string Description)
{
Common.ConnectionManagement myconnector = new Common.ConnectionManagement(_connectionstring);
List <SqlParameter> procParams = new List <SqlParameter>();
procParams.Add(new SqlParameter("@QuestionID", QuestionID));
procParams.Add(new SqlParameter("@YesNo", YesNo));
procParams.Add(new SqlParameter("@Description", Description));
Common.SQLQueryResult queryRes = myconnector.ExecuteNonQueryProcedure("srvy.InsertAnswer", procParams, 600);
_lastSqlException = queryRes.SqlError;
if (queryRes.SqlError != null)
{
return(false);
}
else
{
return(true);
}
}
public SQLQueryResult ExecuteQueryProcedure(string storedprocedureName, List <SqlParameter> paramList, int timeout_overwrite = 0)
{
SQLQueryResult res = new SQLQueryResult();
_connection = new SqlConnection(_connectionstring);
try
{
SqlCommand objCmd = new SqlCommand();
objCmd.Connection = _connection;
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = storedprocedureName;
if (timeout_overwrite > 0)
{
objCmd.CommandTimeout = timeout_overwrite;
}
SqlDataAdapter objAdapter = new SqlDataAdapter();
objAdapter.SelectCommand = objCmd;
//Parameter List
foreach (SqlParameter param in paramList)
{
try
{
if (param.Value != null && param.Value.ToString() != string.Empty)
{
objCmd.Parameters.Add(param);
}
else
{
objCmd.Parameters.Add(new SqlParameter(param.ParameterName, DBNull.Value));
}
}
catch (Exception ex)
{
}
}
objAdapter.Fill(res.QueryOutput, "OutputDataSet");
//Checking for output variables
foreach (SqlParameter param in paramList)
{
try
{
if (param.Direction == ParameterDirection.Output)
{
string paramKey = param.ParameterName.ToString();
string paramValue = param.Value.ToString();
res.OutputParams.Add(paramKey, paramValue);
}
}
catch (Exception ex)
{
}
}
}
catch (SqlException ex)
{
res.SqlError = ex;
}
return(res);
}
