internal ExpResponse DJBanUser(int DJID, int mobileID)
{
ExpResponse r = new ExpResponse();
SqlCommand cmd = new SqlCommand("insert into DJBannedUsers (DJID, mobileID) values (@DJID, @mobileID);", con);
cmd.Parameters.AddWithValue("@DJID", DJID);
cmd.Parameters.AddWithValue("@mobileID", mobileID);
try
{
r.result = cmd.ExecuteNonQuery();
return r;
}
catch (SqlException e)
{
if (e.Number == 2601)
r.setAll(true, "That user is already banned", e.StackTrace, e.Number);
else
r.setErMsgStk(true, e.Message, e.StackTrace);
return r;
}
catch (Exception e)
{
r.setErMsgStk(true, "Exception in DJBanUser: " + e.Message, e.StackTrace);
return r;
}
}
internal ExpResponse DJModifyAchievement(int DJID, Achievement achievement)
{
ExpResponse r = new ExpResponse();
try
{
MemoryStream streamAchievement = new MemoryStream();
DataContractSerializer achievementSerializer = new DataContractSerializer(typeof(Achievement));
achievementSerializer.WriteObject(streamAchievement, achievement);
byte[] serializedAchievementBytes = streamAchievement.ToArray();
SqlCommand cmd = new SqlCommand("update Achievements set Object = @achievement, Name = @name, ObjectSize = @achievementSize, Visible = @visible where ID = @achievementID and DJID = @DJID;", con);
cmd.Parameters.AddWithValue("@achievement", serializedAchievementBytes);
cmd.Parameters.AddWithValue("@name", achievement.name);
cmd.Parameters.AddWithValue("@achievementSize", serializedAchievementBytes.Length);
cmd.Parameters.AddWithValue("@visible", Common.GetBitFromBool(achievement.visible));
cmd.Parameters.AddWithValue("@achievementID", achievement.ID);
cmd.Parameters.AddWithValue("@DJID", DJID);
r.result = int.Parse(cmd.ExecuteScalar().ToString());
return r;
}
catch (SqlException e)
{
r.setAll(true, "SQLException in DBDJModifyAchievement number: " + e.Number + " " + e.Message, e.StackTrace, e.Number);
return r;
}
catch (Exception e)
{
r.setErMsgStk(true, "Exception in DJModifyAchievement: " + e.Message, e.StackTrace);
return r;
}
}
internal ExpResponse DJAddAchievement(int DJID, Achievement achievement)
{
MemoryStream streamAchievement = new MemoryStream();
DataContractSerializer achievementSerializer = new DataContractSerializer(typeof(Achievement));
achievementSerializer.WriteObject(streamAchievement, achievement);
byte[] serializedAchievementBytes = streamAchievement.ToArray();
ExpResponse r = new ExpResponse();
SqlCommand cmd = new SqlCommand("insert into Achievements (DJID, Object, Name, ObjectSize, Visible) values (@DJID, @achievement, @name, @objectSize, @visible); SELECT SCOPE_IDENTITY();", con);
cmd.Parameters.AddWithValue("@DJID", DJID);
cmd.Parameters.AddWithValue("@achievement", serializedAchievementBytes);
cmd.Parameters.AddWithValue("@name", achievement.name);
cmd.Parameters.AddWithValue("@objectSize", serializedAchievementBytes.Length);
cmd.Parameters.AddWithValue("@visible", Common.GetBitFromBool(achievement.visible));
try
{
r.result = int.Parse(cmd.ExecuteScalar().ToString());
return r;
}
catch (SqlException e)
{
if (e.Number == 2601)
r.setAll(true, "An achievement with that name already exists, please choose a new name.", e.StackTrace, e.Number);
else
r.setErMsgStk(true, "Exception in DJAddAchievement: " + e.Message, e.StackTrace);
return r;
}
catch (Exception e)
{
r.setErMsgStk(true, "Exception in DJAddAchievement: " + e.Message, e.StackTrace);
return r;
}
}
