public void DeleteComment(int commentId)
{
ConnectionHelper conn = new ConnectionHelper();
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("Id", commentId),
};
conn.ExecuteNonQuery("DeleteComment", sqlParams);
}
public void EditComment(int commentId, string editedComment)
{
ConnectionHelper conn = new ConnectionHelper();
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("Id", commentId),
new SqlParameter("EditedComment", editedComment)
};
conn.ExecuteNonQuery("EditComment", sqlParams);
}
public void JoinRso(int rsoId, int userId)
{
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("@UserId", userId),
new SqlParameter("@RsoId", rsoId)
};
ConnectionHelper conn = new ConnectionHelper();
conn.ExecuteNonQuery("JoinRso", sqlParams);
}
public void AddComment(AddCommentRequest request)
{
ConnectionHelper conn = new ConnectionHelper();
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("@UserId", request.UserId),
new SqlParameter("@EventId", request.EventId),
new SqlParameter("@Comment", request.Comment)
};
conn.ExecuteNonQuery("AddComment", sqlParams);
}
public void AddUser(SignupRequest request)
{
ConnectionHelper conn = new ConnectionHelper();
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("@FirstName", request.FirstName),
new SqlParameter("@LastName", request.LastName),
new SqlParameter("@Username", request.Username),
new SqlParameter("Password", request.Password),
new SqlParameter("@UserType", request.UserType)
};
conn.ExecuteNonQuery("AddUser", sqlParams);
}
public void AddUniversity(SaveUniversityRequest request)
{
ConnectionHelper conn = new ConnectionHelper();
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("@Name", request.Name),
new SqlParameter("@PrimaryAddress", request.PrimaryAddress),
new SqlParameter("@SecondaryAddress", request.SecondaryAddress),
new SqlParameter("@City", request.City),
new SqlParameter("@State", request.State),
new SqlParameter("@Zip", request.Zip),
new SqlParameter("@NumberOfStudents", request.NumberOfStudents),
new SqlParameter("@Description", request.Description)
};
conn.ExecuteNonQuery("AddUniversity", sqlParams);
}
public void SaveEvent(SaveEventRequest request)
{
ConnectionHelper conn = new ConnectionHelper();
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("@Name", request.Name),
new SqlParameter("@Type", request.Type),
new SqlParameter("@Category", request.Category),
new SqlParameter("@Description", request.Description),
new SqlParameter("@Date", request.Date),
new SqlParameter("@Location", request.Location),
new SqlParameter("@ContactPhone", request.ContactPhone),
new SqlParameter("@ContactEmail", request.ContactEmail),
new SqlParameter("@EventAdmin", request.EventAdmin),
new SqlParameter("@HostUniversity", request.HostUniversity)
};
conn.ExecuteNonQuery("SaveEvent", sqlParams);
}
public void SaveRso(SaveRsoRequest request)
{
ConnectionHelper conn = new ConnectionHelper();
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("@Name", request.Name),
new SqlParameter("@Description", request.Description)
};
int res = conn.ExecuteNonQuery("CreateRso", sqlParams);
if (res > 0)
{
SqlParameter[] sqlParams2 = new SqlParameter[]
{
new SqlParameter("@RsoName", request.Name),
};
int rsoId = -1;
string connectionString = ConfigurationManager.ConnectionStrings["DatabaseConnection"].ConnectionString;
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "GetRsoId";
command.Connection = connection;
command.Parameters.AddRange(sqlParams2);
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
rsoId = reader.GetInt32(0);
}
}
}
catch (Exception ex)
{
}
finally
{
connection.Close();
}
}
if (rsoId != -1)
{
SqlParameter[] sqlParams3 = new SqlParameter[]
{
new SqlParameter("@RsoId", rsoId),
new SqlParameter("@StudentEmail", request.AdminEmail),
new SqlParameter("@IsAdmin", 1)
};
conn.ExecuteNonQuery("AddMemberToRso", sqlParams3);
foreach (string m in request.Members)
{
SqlParameter[] sqlParams4 = new SqlParameter[]
{
new SqlParameter("@RsoId", rsoId),
new SqlParameter("@StudentEmail", m),
new SqlParameter("@IsAdmin", 0)
};
conn.ExecuteNonQuery("AddMemberToRso", sqlParams4);
}
}
}
}
