public ActionResult Edit(Project project, int[] prov)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    db.Entry(project).State = System.Data.Entity.EntityState.Modified;
                    db.SaveChanges();

                    //-------update project province-------//
                    int Project_id = project.ProjectId;
                    db.ProRel.RemoveRange(db.ProRel.Where(c => c.ProjectId == Project_id));
                    var PBObject = new ProjectProvRel();

                    //---adding the project_id to this object---//
                    PBObject.ProjectId = Project_id;
                    // TODO: Add insert logic here
                    foreach (int P_id in prov)
                    {
                        PBObject.ProvinceIds = P_id;
                        db.ProRel.Add(PBObject);
                        db.SaveChanges();
                    }

                    // TODO: Add update logic here

                    return(RedirectToAction("Index"));
                }
                return(View());
            }
            catch
            {
                return(View());
            }
        }
        public ActionResult Create(Project project, int[] ProvinceId)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    db.Projects.Add(project);
                    db.SaveChanges();

                    int Project_id = project.ProjectId;
                    var PBObject   = new ProjectProvRel();
                    //---adding the project_id to this object---//
                    PBObject.ProjectId = Project_id;
                    // TODO: Add insert logic here
                    foreach (int P_id in ProvinceId)
                    {
                        PBObject.ProvinceIds = P_id;
                        db.ProRel.Add(PBObject);
                        db.SaveChanges();
                    }
                    return(RedirectToAction("Index"));
                }
                return(View(project));
            }
            catch
            {
                return(View());
            }
        }