public HttpResponseMessage PostByCategory(int id)
{
try
{
BlogForPrContext db = new BlogForPrContext();
var result = db.Categories.Find(id).Posts.Select(i => new
{
i.Id,
i.Title,
i.Info,
i.Text,
i.DatetimeOfCreated,
i.CategoryId,
i.Categories.CategoryName
}).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
catch (Exception ex)
{
string msg = "A problem caused during getting posts by id. Exception message : " + ex.Message;
return(Request.CreateResponse(HttpStatusCode.OK, msg));
}
}
public HttpResponseMessage Post(int id)
{
try
{
BlogForPrContext db = new BlogForPrContext();
var result = db.Posts.Find(id);
Posts post = new Posts()
{
Id = result.Id,
Title = result.Title,
Info = result.Info,
Text = result.Text,
CategoryId = result.CategoryId,
DatetimeOfCreated = result.DatetimeOfCreated
};
return(Request.CreateResponse(HttpStatusCode.OK, post));
}
catch (Exception ex)
{
string msg = "A problem caused during getting posts by id. Exception message : " + ex.Message;
return(Request.CreateResponse(HttpStatusCode.OK, msg));
}
}
public HttpResponseMessage Login()
{
try
{
BlogForPrContext db = new BlogForPrContext();
Admin admin = db.Admin.FirstOrDefault();
return(Request.CreateResponse(HttpStatusCode.OK, admin.Password));
}
catch (Exception ex)
{
string msg = "A problem caused during login as admin. Exception message : " + ex.Message;
return(Request.CreateResponse(HttpStatusCode.BadRequest, msg));
}
}
public string DeleteCategory(int id)
{
try
{
BlogForPrContext db = new BlogForPrContext();
var tempCat = db.Categories.Find(id);
db.Categories.Remove(tempCat);
int result = db.SaveChanges();
return(result == 1 ? "Deleted succesfuly!" : "Delete Failed!");
}
catch (Exception ex)
{
string msg = "A problem caused during deleting category. Exception message : " + ex.Message;
return(msg);
}
}
public string AddCategory(Categories entity)
{
try
{
BlogForPrContext db = new BlogForPrContext();
db.Categories.Add(entity);
var result = db.SaveChanges();
return(result == 1 ? "Added succesfuly!" : "Adding Failed!");
}
catch (Exception ex)
{
string msg = "A problem caused during adding category. Exception message : " + ex.Message;
return(msg);
}
}
public string AddPost(Posts entity)
{
try
{
BlogForPrContext db = new BlogForPrContext();
entity.DatetimeOfCreated = DateTime.Now;
db.Posts.Add(entity);
int result = db.SaveChanges();
return(result == 1 ? "Added succesfuly!" : "Adding Failed!");
}
catch (Exception ex)
{
string msg = "A problem caused during adding post. Exception message : " + ex.Message;
return(msg);
}
}
public string UpdateCategory(Categories entity)
{
try
{
BlogForPrContext db = new BlogForPrContext();
var tempCat = db.Categories.Find(entity.Id);
tempCat.CategoryName = entity.CategoryName;
int result = db.SaveChanges();
return(result == 1 ? "Updated succesfuly!" : "Update Failed!");
}
catch (Exception ex)
{
string msg = "A problem caused during updating category. Exception message : " + ex.Message;
return(msg);
}
}
public HttpResponseMessage Categories()
{
try
{
BlogForPrContext db = new BlogForPrContext();
var categories = db.Categories.Select(i => new
{
i.Id,
i.CategoryName
}).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, categories));
}
catch (Exception ex)
{
string msg = "A problem caused during getting categories. Exception message : " + ex.Message;
return(Request.CreateResponse(HttpStatusCode.OK, msg));
}
}
public string ChangePassword(Admin entity)
{
try
{
BlogForPrContext db = new BlogForPrContext();
Admin tempAdmin = db.Admin.FirstOrDefault();
int result = 0;
tempAdmin.Password = entity.Password;
result = db.SaveChanges();
return(result == 1 ? "Password updated!" : "Error");
}
catch (Exception ex)
{
string msg = "A problem caused during changing password as admin. Exception message : " + ex.Message;
return(msg);
}
}
public string UpdatePost(Posts entity)
{
try
{
BlogForPrContext db = new BlogForPrContext();
var tempPost = db.Posts.Find(entity.Id);
tempPost.Title = entity.Title;
tempPost.Info = entity.Info;
tempPost.Text = entity.Text;
tempPost.CategoryId = entity.CategoryId;
int result = db.SaveChanges();
return(result == 1 ? "Updated succesfuly!" : "Update Failed!");
}
catch (Exception ex)
{
string msg = "A problem caused during updating post. Exception message : " + ex.Message;
return(msg);
}
}
