public ActionResult createUsers(string SelectedUsers, string Project) { string strConString = "data source=DESKTOP-6HSRCAQ\\MSSQLSERVER01; database=Ernst; integrated security=SSPI;"; var model = new GestionProjet(); string[] Users = SelectedUsers.Split(','); string[] Projects = Project.Split(','); model.DeleteProjectAsso(Convert.ToInt32(Projects[1])); 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", "GestionProjet")); }
public ActionResult Delete(int ID) { GestionProjet model = new GestionProjet(); GestionProjet model1 = new GestionProjet(); model.DeleteProject(ID); model.DeleteProjectAsso(ID); return(RedirectToAction("Index")); }