protected void Page_Load(object sender, EventArgs e) { db = new ContentManagementEntities(); if (Request.Form["action"] == "login") { rep = new AuthorsRepository(); authorList = rep.List(); for (int i = 0; i < authorList.Count; i++) { if (authorList[i].UserName == Username.Value && authorList[i].Password == Password.Value) { isloginFailed = false; break; } } if (isloginFailed) { Session["username"] = null; Response.Redirect("/AuthorLogin"); } else { author = db.Authors.Where(c => c.UserName == Username.Value).FirstOrDefault(); Session["username"] = author.UserName; Response.Redirect("/AddArticle?id=" + author.Id); } } }
protected void Page_Load(object sender, EventArgs e) { db = new ContentManagementEntities(); authorid = AddArticle.myid; author = db.Authors.Where(c => c.Id == authorid).FirstOrDefault(); rep = new ArticlesRepository(); repAutors = new AuthorsRepository(); repCat = new CategoriesRepository(); articleList = rep.List(); isonclick = false; if (IsPostBack) { isonclick = true; } if (isonclick) { articleListFilter = rep.FilterList(Title.Value, Request.Form["CatType"], Request.Form["Autors"], ArticleBody.Value); } else { articleListFilter = rep.List(); } catList = repCat.List(); authorList = repAutors.List(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["username"] != null) { db = new ContentManagementEntities(); if (Request.Form["action"] == "save") { SaveToDb(); } id = Convert.ToInt32(Request.QueryString["id"]); if (id != 0) { myid = id; } author = author = db.Authors.Where(c => c.Id == myid).FirstOrDefault(); rep = new ArticlesRepository(); repCat = new CategoriesRepository(); repAuthor = new AuthorsRepository(); articleList = rep.List(); catList = repCat.List(); authorsList = repAuthor.List(); } else { Response.Redirect("/AuthorLogin"); } }
protected void Page_Load(object sender, EventArgs e) { db = new ContentManagementEntities(); rep = new ArticlesRepository(); repCat = new CategoriesRepository(); Authorid = AddArticle.myid; AdminVarmi = AdminLogin.isAdmin; catList = repCat.List(); author = db.Authors.Where(c => c.Id == Authorid).FirstOrDefault(); ArticleId = Convert.ToInt32(Request.QueryString["id"].ToString()); article = db.Articles.Where(c => c.Id == ArticleId).FirstOrDefault(); if (AdminVarmi) { author = article.Authors; } if (IsPostBack) { article.ArticleBody = Request.Form["ArticleBody"].ToString(); article.Title = Request.Form["Title"].ToString(); article.IsVisible = true; article.CreateDate = DateTime.Now; article.CategoryId = Convert.ToInt32(Request.Form["CatType"]); article.Authors.Id = Authorid; rep.Update(article); Response.Redirect("/ReadArticleDetail?id=" + article.Id); } }
protected void Page_Load(object sender, EventArgs e) { db = new ContentManagementEntities(); rep = new AuthorsRepository(); Authorid = AddArticle.myid; myAdminId = AdminLogin.adminId; adminmi = AdminLogin.isAdmin; author = db.Authors.Where(c => c.Id == Authorid).FirstOrDefault(); admin = db.Admin.Where(c => c.Id == myAdminId).FirstOrDefault(); }
protected void Page_Load(object sender, EventArgs e) { db = new ContentManagementEntities(); int id = Convert.ToInt32(Request.QueryString["id"]); myArticleid = id; myAuthorId = AddArticle.myid; article = db.Articles.Where(c => c.Id == myArticleid).FirstOrDefault(); isAdminLogin = AdminLogin.isAdmin; }
public void deleteDatabase() { int id = Convert.ToInt32(Request.QueryString["id"]); db = new ContentManagementEntities(); Authors entity = new Authors(); entity = db.Authors.Where(c => c.Id == id).FirstOrDefault(); rep = new AuthorsRepository(); rep.Delete(entity.Id); }
protected void Page_Load(object sender, EventArgs e) { repArticle = new ArticlesRepository(); int id = Convert.ToInt32(Request.QueryString["id"]); db = new ContentManagementEntities(); ArticleId = Convert.ToInt32(Request.QueryString["Aid"]); if (Request.QueryString["act"] == "delete") { deleteDatabase(); Response.Redirect("/AuthorsPage"); } if (Request.QueryString["act"] == "deleteArticle") { deleteArticle(); Response.Redirect("/ReadArticlesPage"); } }
public void SaveToDb() { db = new ContentManagementEntities(); rep = new ArticlesRepository(); entity = new Articles(); id = Convert.ToInt32(Request.QueryString["id"]); if (id != 0) { myid = id; } entity.Authors = db.Authors.Where(c => c.Id == myid).FirstOrDefault(); entity.AuthorId = entity.Authors.Id; entity.ArticleBody = Request.Form["ArticleBody"]; entity.Title = Request.Form["Title"]; int catId = Convert.ToInt32(Request.Form["CatType"]); entity.Categories = db.Categories.Where(c => c.Id == catId).FirstOrDefault(); entity.CreateDate = DateTime.Now; entity.CategoryId = entity.Categories.Id; entity.IsVisible = true; rep.Add(entity, db); Response.Redirect("/ReadArticlesPage"); }
public void Add(Articles entity, ContentManagementEntities db) { db.Articles.Add(entity); db.SaveChanges(); }
public ArticlesRepository() { dbs = new ContentManagementEntities(); }
public CategoriesRepository() { db = new ContentManagementEntities(); }
public AuthorsRepository() { db = new ContentManagementEntities(); }
protected void Page_Load(object sender, EventArgs e) { isAdminFounded = AdminLogin.isAdmin; db = new ContentManagementEntities(); rep = new AuthorsRepository(); authorList = rep.List(); myauthorList = authorList; if (isAdminFounded) { id = Convert.ToInt32(Request.QueryString["id"]); } else { id = AddArticle.myid; } if (x != 0) { author = db.Authors.Where(c => c.Id == x).FirstOrDefault(); myauthorList.RemoveAll(c => c.Id == x); foreach (var item in myauthorList) { if (item.UserName == Username.Value) { aynimi = true; } } if (!aynimi) { if (IsPostBack) { updateDatabase(id); } x = 0; if (isAdminFounded) { Response.Redirect("/AuthorsPage"); } else { Response.Redirect("/ReadArticlesPage"); } } else { Username.Value = "this username is available"; } } if (Request.QueryString["act"] == "update") { if (!IsPostBack) { if (isAdminFounded) { id = Convert.ToInt32(Request.QueryString["id"]); } else { id = AddArticle.myid; } Authors entity = db.Authors.Where(c => c.Id == id).FirstOrDefault(); Name.Value = entity.Name; Password.Value = entity.Password; Surname.Value = entity.Surname; Email.Value = entity.Mail; Username.Value = entity.UserName; } x = id; } }
public AdminsRepository() { db = new ContentManagementEntities(); }