public ActionResult Edit(int id) { EmployeeModel emp = new EmployeeModel(); string connectionString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; DataTable dataTable = new DataTable(); using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); string query = @"Select * From tbl_UserDetails where Id = @Id"; SqlDataAdapter sqlData = new SqlDataAdapter(query, conn); sqlData.SelectCommand.Parameters.AddWithValue("Id", id); sqlData.Fill(dataTable); } emp.Id = Convert.ToInt32(dataTable.Rows[0][0].ToString()); emp.Name = dataTable.Rows[0][1].ToString(); emp.EmailId = dataTable.Rows[0][2].ToString(); emp.Address = dataTable.Rows[0][3].ToString(); emp.EmployeeGender = dataTable.Rows[0][4].ToString(); emp.Country = emp.GetCountry(); emp.CountryId = Convert.ToInt32(dataTable.Rows[0][5].ToString()); emp.Active = Convert.ToBoolean(dataTable.Rows[0][6]); return(View(emp)); }
public ActionResult Create() { EmployeeModel employeeModel = new EmployeeModel(); employeeModel.Country = employeeModel.GetCountry(); EmployeeRole role = new EmployeeRole(); employeeModel.Role = role.GetEmployeeRole(); return(View(employeeModel)); }