private void EditEmployeeDetails_Load(object sender, EventArgs e) { EmployeeArtifact empArtifactObj = new EmployeeArtifact(); List<EmployeeArtifact> list = new List<EmployeeArtifact>(); list = empArtifactObj.GetAllEmployee(); empname_combobox.DataSource = list; empname_combobox.DisplayMember = "FirstName"; empname_combobox.ValueMember = "Id"; /* DbConnectionManager connect = new DbConnectionManager(); SqlConnection conn = connect.connectToDb(); string query = "select * from employee"; SqlCommand cmd = new SqlCommand(query); cmd.Connection = conn; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds, "employee"); empname_combobox.DataSource = ds.Tables["employee"]; empname_combobox.DisplayMember = "fname"; empname_combobox.ValueMember = "id"; DataRowView id = (DataRowView)empname_combobox.SelectedItem; DisplayEmployeeDetails(empname_combobox.SelectedValue.ToString()); connect.diconnectFromDb(conn); * */ }
private void EditEmployeeDetails_Load(object sender, EventArgs e) { EmployeeArtifact empArtifactObj = new EmployeeArtifact(); List <EmployeeArtifact> list = new List <EmployeeArtifact>(); list = empArtifactObj.GetAllEmployee(); empname_combobox.DataSource = list; empname_combobox.DisplayMember = "FirstName"; empname_combobox.ValueMember = "Id"; /* * DbConnectionManager connect = new DbConnectionManager(); * SqlConnection conn = connect.connectToDb(); * string query = "select * from employee"; * SqlCommand cmd = new SqlCommand(query); * cmd.Connection = conn; * SqlDataAdapter da = new SqlDataAdapter(); * da.SelectCommand = cmd; * DataSet ds = new DataSet(); * da.Fill(ds, "employee"); * empname_combobox.DataSource = ds.Tables["employee"]; * empname_combobox.DisplayMember = "fname"; * empname_combobox.ValueMember = "id"; * DataRowView id = (DataRowView)empname_combobox.SelectedItem; * * DisplayEmployeeDetails(empname_combobox.SelectedValue.ToString()); * connect.diconnectFromDb(conn); * */ }
private void ViewEmployee_Load(object sender, EventArgs e) { EmployeeArtifact empArtifactObj = new EmployeeArtifact(); List <EmployeeArtifact> list = new List <EmployeeArtifact>(); list = empArtifactObj.GetAllEmployee(); view_employee.DataSource = list; }
private void SalaryCredentialAssigner_Load(object sender, EventArgs e) { EmployeeArtifact empArtifactObj = new EmployeeArtifact(); List<EmployeeArtifact> list = new List<EmployeeArtifact>(); list = empArtifactObj.GetAllEmployee(); empname_combobox.DataSource = list; empname_combobox.DisplayMember = "FirstName"; empname_combobox.ValueMember = "Id"; }
private void DailyAttendance_Load(object sender, EventArgs e) { EmployeeArtifact empArtifactObj = new EmployeeArtifact(); List <EmployeeArtifact> list = new List <EmployeeArtifact>(); list = empArtifactObj.GetAllEmployee(); empfname_combobox.DataSource = list; empfname_combobox.DisplayMember = "FirstName"; empfname_combobox.ValueMember = "Id"; }
private void SalaryCredentialAssigner_Load(object sender, EventArgs e) { EmployeeArtifact empArtifactObj = new EmployeeArtifact(); List <EmployeeArtifact> list = new List <EmployeeArtifact>(); list = empArtifactObj.GetAllEmployee(); empname_combobox.DataSource = list; empname_combobox.DisplayMember = "FirstName"; empname_combobox.ValueMember = "Id"; }
private void PerspectivePayslip_Load(object sender, EventArgs e) { Month monthObj = new Month(); selectMonth_combobox.DataSource = monthObj.GetMonths(); selectMonth_combobox.DisplayMember = "Name"; selectMonth_combobox.ValueMember = "Id"; EmployeeArtifact empArtifactObj = new EmployeeArtifact(); List <EmployeeArtifact> list = new List <EmployeeArtifact>(); list = empArtifactObj.GetAllEmployee(); fname_combobox.DataSource = list; fname_combobox.DisplayMember = "FirstName"; fname_combobox.ValueMember = "Id"; }