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);
                }
            }
        }
Beispiel #2
0
        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");
            }
        }
Beispiel #4
0
        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);
            }
        }
Beispiel #5
0
 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();
 }
Beispiel #6
0
        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();
 }
Beispiel #14
0
        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();
 }