Example #1
0
        public ActionResult Index(string job, string name, string motto)
        {
            List <Models.project> list = new List <Models.project>();
            var item = new Models.project();

            item.job   = "組長";
            item.name  = "李益銘";
            item.motto = "The Best Of The Men At Work";

            list.Add(item);

            var item2 = new Models.project();

            item2.job   = "組員";
            item2.name  = "方光明";
            item2.motto = "Black Light Syndrome";
            list.Add(item2);
            ViewBag.ListDatas = list;

            var item3 = new Models.project();

            item3.job   = "組員";
            item3.name  = "張維哲";
            item3.motto = "Everything ought to be beautiful in a human being: face, dress, soul and idea";
            list.Add(item3);
            ViewBag.ListDatas = list;

            var item4 = new Models.project();

            item4.job   = "組員";
            item4.name  = "柯軒安";
            item4.motto = "When an opportunity is neglected,it never comes back to you";
            list.Add(item4);
            ViewBag.ListDatas = list;

            var item5 = new Models.project();

            item5.job   = "組員";
            item5.name  = "王偉鈞";
            item5.motto = "Have but few friends, though many acquaintances";
            list.Add(item5);
            ViewBag.ListDatas = list;

            return(View());
        }
Example #2
0
        public ActionResult assignPMtoProject(int pm_id, int post_id)
        // in profile page

        /* choose one pm and then go to another page to create group then it
         * is deleted from posts table but added to project table*/
        {
            var postinstance = db.posts.Find(post_id);
            var pminstance   = db.posts.Find(pm_id);


            if (postinstance != null && pminstance != null)
            {
                var value1 = from d in db.posts
                             where d.id == post_id
                             select d; // post record
                var data_post = value1.ToList();

                var value2 = from d in db.requestProjects
                             where d.PMs_id == pm_id && d.post_id == post_id
                             select d; // request of project records
                var data_request_project = value2.ToList();
                var value3 = from d in db.PMS
                             where d.id == pm_id
                             select d.user_id; // pm id in user table
                Models.project proj = new Models.project()
                {
                    user_id        = Convert.ToInt32(value3),
                    title          = data_post[0].title,
                    description    = data_post[0].description,
                    state          = 0,
                    price          = data_request_project[0].price,
                    project_remove = 0,
                    start_date     = DateTime.Now,
                    end_date       = DateTime.Today.AddDays(data_request_project[0].duration.Day)
                };
                db.projects.Add(proj);
                db.SaveChanges();

                var value4 = db.projects.Max(d => d.id);

                Models.request req = new Models.request()
                {
                    PM_id         = Convert.ToInt32(value3),
                    user_id       = data_post[0].user_id,
                    project_id    = value4,
                    url           = null,
                    request_state = 0,
                };
                db.requests.Add(req);
                db.SaveChanges();
            }
            var delpost = db.posts.Find(post_id);

            if (delpost != null)
            {
                // delete the record of the post that is changed to project
                db.posts.Remove(delpost);
                db.SaveChanges();
            }

            return(View());
        }