// GET: Posts/Create
public ActionResult Create()
{
LoginDatabaseEntites db = new LoginDatabaseEntites();
if (Request.HttpMethod == "POST")
{
var naslov = Request.Form["title"].ToString();
var vsebina = Request.Form["content"].ToString();
var category = Convert.ToInt32(Request.Form["kategorija"]);
var path = Path.Combine("/assets/images", "wha.jpg");
if (Request.Files.Count > 0)
{
HttpPostedFileBase file = Request.Files[0];
var fileName = Guid.NewGuid().ToString() + Path.GetFileName(file.FileName);
path = Path.Combine("/assets/images", fileName);
path.ToList();
file.SaveAs(Server.MapPath(path));
}
DateTime date2 = (DateTime) new SqlDateTime(DateTime.Now);
var temp = new DateTime().Date.ToString("yyyy-MM-dd HH:mm:ss");
blogs novi = new blogs()
{
title = naslov,
content = vsebina,
kategorija = category,
Imagepath = path
};
db.blogs.Add(novi);
db.SaveChanges();
return(RedirectToAction("Index", "cms"));
}
ViewBag.AppDataApplicationType = new SelectList(db.categories, "CatId", "naslov_kategorije");
return(View());
}
[Route("Read/{id}")] // Set the ID parameter
public ActionResult Read(int id)
{
// Read one single blog
LoginDatabaseEntites db = new LoginDatabaseEntites();
var blogs = db.blogs;
blogs post = null;
if (blogs != null && blogs.Count() > 0)
{
post = blogs.Where(x => x.blogid == id).FirstOrDefault();
}
if (post == null)
{
ViewBag.PostFound = false;
return(View());
}
else
{
var categId = post.kategorija;
string kategorija = db.categories.Where(x => x.CatId == categId).Select(x => x.naslov_kategorije).Single();
ViewBag.Categories = kategorija;
ViewBag.PostFound = true;
return(View(post));
}
}
// DELETE: api/BlogDetails/5
public void Delete(int id)
{
LoginDatabaseEntites db = new LoginDatabaseEntites();
var posodobi = db.blogs.Find(id);
db.blogs.Remove(posodobi);
db.SaveChanges();
}
public ActionResult Delete(int id)
{
LoginDatabaseEntites db = new LoginDatabaseEntites();
var posodobi = db.blogs.Find(id);
db.blogs.Remove(posodobi);
db.SaveChanges();
return(RedirectToAction("Index", "Cms"));
}
public ActionResult GetData(int pageIndex, int pageSize)
{
System.Threading.Thread.Sleep(1000);
LoginDatabaseEntites db = new LoginDatabaseEntites();
var query = (from c in db.blogs
orderby c.blogid descending
select c)
.Skip(pageIndex * pageSize)
.Take(pageSize);
return(Json(query.ToList(), JsonRequestBehavior.AllowGet));
}
// GET: Cms
public ActionResult Index()
{
LoginDatabaseEntites db = new LoginDatabaseEntites();
var blogi = db.blogs;
if (blogi.Count() > 0)
{
ViewBag.Empty = false;
ViewBag.AppDataApplicationType = new SelectList(db.categories, "CatId", "naslov_kategorije");
return(View(blogi.ToList()));
}
ViewBag.Empty = true;
return(View());
}
public ActionResult Index()
{
LoginDatabaseEntites db = new LoginDatabaseEntites();
var blogi = db.blogs;
if (blogi.Count() > 0)
{
ViewBag.Empty = false;
var reversani = blogi.ToList();
reversani.Reverse();
return(View(reversani));
}
ViewBag.Empty = true;
return(View());
}
public ActionResult Edit(int id)
{
LoginDatabaseEntites db = new LoginDatabaseEntites();
if (Request.HttpMethod == "POST")
{
var naslov = Request.Form["title"].ToString();
var vsebina = Request.Form["content"].ToString();
var idbloga = Convert.ToInt32(Request.Form["blogid"].ToString());
var category = Convert.ToInt32(Request.Form["kategorija"]);
var path = "";
if (Request.Files.Count > 0)
{
HttpPostedFileBase file = Request.Files[0];
var fileName = Guid.NewGuid().ToString() + Path.GetFileName(file.FileName);
path = Path.Combine("/assets/images", fileName);
path.ToList();
file.SaveAs(Server.MapPath(path));
}
var posodobi = db.blogs.FirstOrDefault(x => x.blogid == id);
posodobi.content = vsebina;
posodobi.title = naslov;
posodobi.kategorija = category;
if (path.Length > 1)
{
posodobi.Imagepath = path;
}
db.SaveChanges();
return(RedirectToAction("Index", "Cms"));
}
else
{
var post = db.blogs.SingleOrDefault(x => x.blogid == id);
if (post != null)
{
ViewBag.Found = true;
List <blogs> blg = new List <blogs>();
blg.Add(post);
ViewBag.AppDataApplicationType = new SelectList(db.categories, "CatId", "naslov_kategorije");
return(View(blg));
}
else
{
ViewBag.Found = false;
}
}
return(View());
}
public ActionResult Autherize(user userModel)
{
using (LoginDatabaseEntites db = new LoginDatabaseEntites()) {
var userDetails = db.users.Where(x => x.Username == userModel.Username && x.Password == userModel.Password).FirstOrDefault();
if (userDetails == null)
{
userModel.LoginErrorMessage = "Wrong username or password";
return(View("Index", userModel));
}
else
{
Session["userID"] = userDetails.UserID;
return(RedirectToAction("Index", "Cms"));
}
}
return(View());
}
public BlogDetailsController()
{
db = new LoginDatabaseEntites();
}
