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