예제 #1
0
        public ActionResult ClubApplicationManagment(int userID, string button)
        {
            UserModel clubuser = new UserModel();
            ClubModel club     = new ClubModel();
            UserModel user     = new UserModel();

            string query;

            if (button == "refresh")
            {
                user.userID = (int)HttpContext.Session.GetInt32("UserID");
                query       = "select u.userID, u.fname, u.lname from user as u join clubapplication as ca on u.userID = ca.userID join club as c on c.clubID = ca.clubID where c.userID = @userID";
                StringBuilder applicationListHtml = new StringBuilder("<table id=\"pplTbl\"><tr><th>User ID</th><th>First Name</th><th>Last Name</th></tr>");
                users = SqliteDataAccess.LoadManyObjects(user, query);

                foreach (var app in users)
                {
                    applicationListHtml.Append("<tr><td>");
                    applicationListHtml.Append(app.userID);
                    applicationListHtml.Append("</td><td>");
                    applicationListHtml.Append(app.fname);
                    applicationListHtml.Append("</td><td>");
                    applicationListHtml.Append(app.lname);
                    applicationListHtml.Append("</td></tr>");
                }

                applicationListHtml.Append("</table>");

                Console.WriteLine(applicationListHtml);

                //ViewBag.ClubApps = applicationListHtml;
                TempData["ClubApps"] = applicationListHtml.ToString();
            }
            else if (button == "accept" && userID != 0)
            {
                //check if userID + clubID exist in clubapplication
                ClubModel exist = new ClubModel();
                exist.userID = userID;
                query        = "select * from clubapplication where userID=@userID";
                exist        = SqliteDataAccess.SingleObject(exist, query);
                if (exist == null)
                {
                    Console.WriteLine("User has not applied to this club");
                    return(View("~/Views/Home/Application.cshtml"));
                }
                else
                {
                    club.userID = (int)HttpContext.Session.GetInt32("UserID");
                    query       = "select * from club where userID=@userID";
                    club        = SqliteDataAccess.SingleObject(club, query);
                    user.userID = userID;
                    Console.WriteLine("user ID:" + user.userID);
                    user.club = club.clubID;
                    Console.WriteLine("user club:" + user.club);
                    query = "update user set club = @club where userID = @userID";
                    SqliteDataAccess.SaveSingleObject(user, query);
                    query = "delete from clubapplication where userID=@userID";
                    SqliteDataAccess.DenyApplication(user, query);
                }
            }
            else if (button == "deny" && userID != 0)
            {
                query       = "delete from clubapplication where userID=@userID";
                user.userID = userID;
                SqliteDataAccess.DenyApplication(user, query);
            }
            else
            {
                Console.WriteLine("Shit went wrong!");
            }



            return(RedirectToAction("Application", "Home"));
        }