public HttpResponseMessage Put([FromBody] JObject data)
{
try
{
UserManga userManga = data["usermanga"].ToObject <UserManga>();
String token = data["token"].ToObject <string>();
if (!SessionHandler.isUser(token, userManga.userid))
{
return(new HttpResponseMessage(HttpStatusCode.Unauthorized));
}
if (DBHandler.GetUserManga(userManga.mangaid, userManga.userid) == null)
{
return(new HttpResponseMessage(HttpStatusCode.Conflict));
}
userManga = DBHandler.EditUserManga(userManga);
if (userManga == null)
{
return(new HttpResponseMessage(HttpStatusCode.InternalServerError));
}
return(this.Request.CreateResponse(HttpStatusCode.OK, userManga));
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(new HttpResponseMessage(HttpStatusCode.InternalServerError));
}
public static UserManga EditUserManga(UserManga userManga)
{
try
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = "Data Source=localhost;" +
"Initial Catalog=mangadb;" +
"Integrated Security=SSPI;";
conn.Open();
string sql = "UPDATE USERMANGA SET " +
"OWNED=@OWNED, COMMENT=@COMMENT, SCORE=@SCORE " +
"WHERE MANGAID=@MANGAID AND USERID=@USERID";
SqlCommand sqlC = new SqlCommand(sql, conn);
sqlC.Parameters.Add(new SqlParameter("@OWNED", userManga.owned ?? (object)DBNull.Value));
sqlC.Parameters.Add(new SqlParameter("@COMMENT", userManga.comment ?? (object)DBNull.Value));
sqlC.Parameters.Add(new SqlParameter("@SCORE", userManga.score ?? (object)DBNull.Value));
sqlC.Parameters.Add(new SqlParameter("@MANGAID", userManga.mangaid));
sqlC.Parameters.Add(new SqlParameter("@USERID", userManga.userid));
if (sqlC.ExecuteNonQuery() > 0)
{
return(userManga);
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(null);
}
// GET: api/usermanga
public HttpResponseMessage Get(long mangaId, long userId, string token)
{
if (!SessionHandler.isUser(token, userId))
{
return(new HttpResponseMessage(HttpStatusCode.Unauthorized));
}
UserManga userManga = DBHandler.GetUserManga(mangaId, userId);
return(this.Request.CreateResponse(HttpStatusCode.OK, userManga));
}
internal static List <UserManga> GetAllUserManga(long userId)
{
List <UserManga> userMangaList = new List <UserManga>();
try
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = "Data Source=localhost;" +
"Initial Catalog=mangadb;" +
"Integrated Security=SSPI;";
conn.Open();
string sql = "SELECT " +
"MANGAID, " +
"USERID, " +
"OWNED, " +
"COMMENT, " +
"SCORE " +
"FROM USERMANGA " +
"WHERE UserID=@USERID";
SqlCommand sqlCommand = new SqlCommand(sql, conn);
sqlCommand.Parameters.Add(new SqlParameter("@USERID", userId));
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
UserManga userManga = new UserManga();
userManga.mangaid = (long)reader.GetValue(0);
userManga.userid = (long)reader.GetValue(1);
userManga.owned = reader.IsDBNull(2) ? null : (int?)reader.GetValue(2);
userManga.comment = reader.IsDBNull(3) ? null : (string)reader.GetValue(3);
userManga.score = reader.IsDBNull(4) ? null : (int?)reader.GetValue(4);
userMangaList.Add(userManga);
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(userMangaList);
}
public static UserManga InsertUserManga(UserManga userManga, long mangaId, long userId)
{
try
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = "Data Source=localhost;" +
"Initial Catalog=mangadb;" +
"Integrated Security=SSPI;";
conn.Open();
string sql = "INSERT INTO USERMANGA (" +
"MANGAID, USERID, OWNED, COMMENT, SCORE" +
") output INSERTED.MANGAID VALUES (" +
"@MANGAID, @USERID, @OWNED, @COMMENT, @SCORE" +
");";
SqlCommand sqlC = new SqlCommand(sql, conn);
sqlC.Parameters.Add(new SqlParameter("@MANGAID", mangaId));
sqlC.Parameters.Add(new SqlParameter("@USERID", userId));
sqlC.Parameters.Add(new SqlParameter("@OWNED", userManga.owned ?? (object)DBNull.Value));
sqlC.Parameters.Add(new SqlParameter("@COMMENT", userManga.comment ?? (object)DBNull.Value));
sqlC.Parameters.Add(new SqlParameter("@SCORE", userManga.score ?? (object)DBNull.Value));
SqlDataReader reader = sqlC.ExecuteReader();
return(GetUserManga(mangaId, userId));
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(null);
}