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"));
}
