/// <summary>
/// Obtain a single request for submitter status.
/// </summary>
/// <param name="username">The username.</param>
/// <returns>An object containing information about the request.</returns>
public static SubmitterRequestInfo getSubmitterRequest(string username)
{
IDbCommand cmd = new SqlCommand();
cmd.Connection = new SqlConnection(Globals.UsersConnectionString);
cmd.CommandText = "SELECT Date, Message, SubmitterId FROM SubmitterRequests " +
"WHERE UserName = @UserName";
cmd.Parameters.Add(new SqlParameter("@UserName", username));
SubmitterRequestInfo retVal = null;
IDataReader reader = null;
try {
cmd.Connection.Open();
reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (reader.Read())
{
retVal = new SubmitterRequestInfo();
retVal.UserName = username;
retVal.Date = Convert.ToDateTime(reader["Date"]);
retVal.Message = Convert.ToString(reader["Message"]);
retVal.SubmitterId = Convert.ToString(reader["SubmitterId"]);
}
} catch (SqlException e) {
throw new Exception("An error occurred obtaining your module " +
"submission request status. Please try again. ", e);
} finally {
reader.Close();
}
return(retVal);
}
/// <summary>
/// Get a list of all submitter requests ordered by date.
/// </summary>
/// <returns>The list of submitter requests.</returns>
public static IList getSubmitterRequests()
{
IDbCommand cmd = new SqlCommand();
cmd.Connection = new SqlConnection(Globals.UsersConnectionString);
cmd.CommandText = "SELECT UserName, Date, Message, SubmitterId FROM SubmitterRequests " +
"ORDER BY Date";
IList retVal = new ArrayList();
IDataReader reader = null;
try {
cmd.Connection.Open();
reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
SubmitterRequestInfo sri = null;
sri = new SubmitterRequestInfo();
sri.UserName = Convert.ToString(reader["UserName"]);
sri.Date = Convert.ToDateTime(reader["Date"]);
sri.Message = Convert.ToString(reader["Message"]);
sri.SubmitterId = Convert.ToString(reader["SubmitterId"]);
retVal.Add(sri);
}
} catch (SqlException e) {
throw new Exception("An error occurred obtaining the module " +
"submission requests. ", e);
} finally {
reader.Close();
}
return(retVal);
}
/// <summary>
/// User requests submitter status.
/// </summary>
/// <param name="sri">The information about the request.</param>
public static void addSubmitterRequest(SubmitterRequestInfo sri)
{
IDbCommand cmd = new SqlCommand();
cmd.Connection = new SqlConnection(Globals.UsersConnectionString);
cmd.CommandText = "INSERT INTO SubmitterRequests(UserName, Date, Message, SubmitterId) " +
"VALUES (@UserName, @Date, @Message, @SubmitterId)";
cmd.Parameters.Add(new SqlParameter("@UserName", sri.UserName));
cmd.Parameters.Add(new SqlParameter("@Date", sri.Date));
cmd.Parameters.Add(new SqlParameter("@Message", sri.Message));
cmd.Parameters.Add(new SqlParameter("@SubmitterId", sri.SubmitterId));
try {
cmd.Connection.Open();
cmd.ExecuteNonQuery();
} catch (SqlException e) {
throw new Exception("An error occurred while submitting your request. " +
"Please try again. ", e);
} finally {
cmd.Connection.Close();
}
}