protected void btnSearch_Click(object sender, EventArgs e) { //Search and show employee that match search criteria. var source = new EmployeeDAL.EmployeeContext().SpGetEmployee(txtSearchStr.Text); lblResultMessage.Text = $@"{source.Count} record(s) found."; gvEmployee.DataSource = source; gvEmployee.DataBind(); }
private void GetAllEmployee() { //Get all registered employee. var source = new EmployeeDAL.EmployeeContext().SpGetEmployee(""); lblResultMessage.Text = $@"{source.Count} record(s) found."; gvEmployee.DataSource = source; gvEmployee.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { try { //Fill the form if editing. var employee = new EmployeeDAL.EmployeeContext().SpGetEmployeeById(Convert.ToInt32(Request.Params["id"])); TxtEmployeeId.Text = employee.EmployeeId.ToString(); TxtFirstName.Text = employee.FirstName; TxtLastName.Text = employee.LastName; TxtPhone.Text = employee.Phone; TxtZip.Text = employee.Zip; TxtHireDate.Text = employee.HireDate?.ToString("MM/dd/yyyy"); } catch (Exception ex) { LblResult.Text = ex.Message; LblResult.Visible = true; } } }