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