public ActionResult Edit1(int ID) { GestionProjet model = new GestionProjet(); DataTable dt = model.GetprojectByID(ID); return(RedirectToAction("createUsers", dt)); }
public ActionResult create(string SelectedUsers, string SelectedProject, int ID, FormCollection frm) { string strConString = "data source=DESKTOP-6HSRCAQ\\MSSQLSERVER01; database=Ernst; integrated security=SSPI;"; GestionProjet model = new GestionProjet(); int id = Convert.ToInt32(frm["hdnID"]); DataTable dt = model.GetprojectByID(ID); string[] Users = SelectedUsers.Split(','); string[] Projects = SelectedProject.Split(','); foreach (string User in Users) { if (User != "") { foreach (string Project in Projects) { if (Project != "") { using (SqlConnection con = new SqlConnection(strConString)) { con.Open(); string query = "insert into asso(Id,ProjectId) values (@Id,@ProjectId)"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("Id", Int32.Parse(User)); cmd.Parameters.AddWithValue("ProjectId", Int32.Parse(Project)); cmd.ExecuteNonQuery(); } } } } } return(RedirectToAction("Index", "ProjectUser")); }
public ActionResult Edit(int ID) { GestionProjet model = new GestionProjet(); DataTable dt = model.GetprojectByID(ID); return(View("Edit", dt)); }