public ActionResult AssignedEmployees(FormCollection fc) { bool result = false; try { var SelectedEmployees = fc["SelectedEmployees"].Split(','); var ProjectID = Convert.ToInt32(fc["ProjectID"].ToString()); foreach (string employeeID in SelectedEmployees) { ProjectMemberAssisgnment model = new ProjectMemberAssisgnment(); model.ProjectId = ProjectID; model.ProjectMemberId = Convert.ToInt32(employeeID); result = objDB.SaveAssignedEmployees(model); } } catch (Exception ex) { } if (result) { return(Json("Project Category Saved")); } else { return(Json("Project Category Not Saved")); } }
public bool SaveAssignedEmployees(ProjectMemberAssisgnment memberAssisgnment) { bool result = false; try { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DHRM_COREEntities"].ConnectionString)) { SqlCommand cmd = new SqlCommand("insert into [tblProjectMemberAssignment]([project_id],[project_member_id]) values(@ProjectID,@EmployeeID);", con); if (con.State != ConnectionState.Open) { con.Open(); } cmd.Parameters.Clear(); cmd.Parameters.Add("@ProjectID", SqlDbType.Int).Value = memberAssisgnment.ProjectId; cmd.Parameters.Add("@EmployeeID", SqlDbType.Int).Value = memberAssisgnment.ProjectMemberId; cmd.ExecuteNonQuery(); result = true; } } catch (Exception ex) { } return(result); }