public async Task <IActionResult> AddEmployee(int id) { try { var model = new List <AddUserDepartment>(); var employeeUser = await _userManager.GetUsersInRoleAsync("Employee"); foreach (var emp in employeeUser) { var empModel = new AddUserDepartment() { DepId = id, UserId = emp.Id, FullName = emp.FirstName + " " + emp.FatherName + " " + emp.LastName }; var userDepResult = await _userDepartmentService.GetUsersOfDepartmentAsync(); if (userDepResult.Succeeded) { var userDep = userDepResult.Model; foreach (var item in userDep) { if (item.UserId == emp.Id && item.DepartmentId == id) { empModel.IsSelected = true; } } } model.Add(empModel); } return(View(model)); } catch (Exception) { ViewBag.Error = "Something wrong"; return(View("Error")); } }
protected void AddUserSubmit_Click(object sender, EventArgs e) { string uid = AddUserId.Text.ToString(); string CS = ConfigurationManager.ConnectionStrings["DB"].ConnectionString; SqlConnection con = new SqlConnection(CS); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "Select * from usertnp where id = @uid"; cmd.Parameters.AddWithValue("@uid", uid); cmd.Connection = con; con.Open(); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); con.Close(); bool loginSuccessful = ((ds.Tables.Count > 0) && (ds.Tables[0].Rows.Count > 0)); if (loginSuccessful) { USerExistLabel.Text = "User you entered already exist"; } else { if (AddUserType.SelectedIndex == 0) { USerExistLabel.Text = "Please select a user type"; AddUserType.Focus(); } else if (AddUserType.SelectedIndex == 2 && AddUserDepartment.SelectedIndex == 0) { USerExistLabel.Text = "Please select a department of the coordinator"; AddUserDepartment.Focus(); } else { string pswd = AddUserPassword.Text.ToString(); string email = AddUserEmail.Text.ToString(); string type = AddUserType.SelectedValue.ToString(); SqlCommand insertcmd = new SqlCommand(); insertcmd.CommandText = "insert into usertnp values(@uid,@pswd,@type,@email,@uid)"; insertcmd.Parameters.AddWithValue("@uid", uid); insertcmd.Parameters.AddWithValue("@pswd", pswd); insertcmd.Parameters.AddWithValue("@type", type); insertcmd.Parameters.AddWithValue("@email", email); //Command for inserting in other tables SqlCommand insertcmdforeign = new SqlCommand(); insertcmdforeign.CommandText = "insert into academic_details(aid) values(@uid)"; insertcmdforeign.Parameters.AddWithValue("@uid", uid); insertcmdforeign.Parameters.AddWithValue("@codept", AddUserDepartment.SelectedValue.ToString()); insertcmdforeign.Connection = con; insertcmd.Connection = con; con.Open(); insertcmd.ExecuteNonQuery(); //Execution of foreign if (AddUserType.SelectedIndex == 1) { //Academic details insert through table //insertcmdforeign.ExecuteNonQuery(); insertcmdforeign.CommandText = "insert into notification_details(notid) values(@uid)"; insertcmdforeign.ExecuteNonQuery(); insertcmdforeign.CommandText = "insert into document_details(docid) values(@uid)"; insertcmdforeign.ExecuteNonQuery(); //Personal details insert through table // insertcmdforeign.CommandText = "insert into personal_details(pid) values(@uid)"; //insertcmdforeign.ExecuteNonQuery(); //insertcmdforeign.CommandText = "insert into student_details values(@uid,@uid,@uid,@uid,@uid,@uid,@uid)"; //insertcmdforeign.ExecuteNonQuery(); } else if (AddUserType.SelectedIndex == 2) { insertcmdforeign.CommandText = "insert into coordinator values(@uid,'',@codept)"; insertcmdforeign.ExecuteNonQuery(); } else { insertcmdforeign.CommandText = "insert into admin_details(id) values(@uid)"; insertcmdforeign.ExecuteNonQuery(); } con.Close(); //Clear field after adding user USerExistLabel.Text = ""; UserAddedLabel.Text = "User Added Successfully"; AddUserId.Text = ""; AddUserEmail.Text = ""; AddUserPassword.Text = ""; AddUserType.ClearSelection(); } } }