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