private void btnSearch_Click(object sender, EventArgs e)
{
try
{
if (tbxSearch.Text != "")
{
string parameter = tbxSearch.Text;
dsView ds = new dsView();
dsViewTableAdapters.vEmployeeGridTableAdapter taEmployee = new dsViewTableAdapters.vEmployeeGridTableAdapter();
DataTable dt = taEmployee.GetDataByString(parameter);
grdEmployee.AutoGenerateColumns = false;
grdEmployee.Rows.Clear();
int count = 0;
foreach (DataRow item in dt.Rows)
{
count++;
grdEmployee.Rows.Add(item[0], item[1], item[2], item[3], item[4], item[5], item[6]);
}
tbxCount.Text = count.ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void FillEmployeeForm(Int32 employeeId)
{
dsView ds = new dsView();
HRManger.dsViewTableAdapters.vEmployeeGridTableAdapter taEmployee = new HRManger.dsViewTableAdapters.vEmployeeGridTableAdapter();
taEmployee.FillById(ds.vEmployeeGrid, employeeId);
var Employee = ds.vEmployeeGrid.NewvEmployeeGridRow();
if (ds.vEmployeeGrid.Rows.Count > 0)
{
Employee = ds.vEmployeeGrid[0];
tbxEmployeeName.Text = Employee.EmployeeName.ToString();
tbxCode.Text = Employee.Code.ToString();
tbxDepartment.Text = Employee.DeptName;
tbxDesignation.Text = Employee.DesgName;
pbxEmployee.ImageLocation = Employee.ImageUrl;
}
}
private void FillGrid()
{
dsView ds = new dsView();
dsViewTableAdapters.vEmployeeGridTableAdapter taEmployeeGrid = new dsViewTableAdapters.vEmployeeGridTableAdapter();
DataTable dt = taEmployeeGrid.GetData();
grdEmployee.AutoGenerateColumns = false;
grdEmployee.Rows.Clear();
int count = 0;
foreach (DataRow item in dt.Rows)
{
count++;
grdEmployee.Rows.Add(item[0], item[1], item[2], item[3], item[4], item[5], item[6]);
}
tbxCount.Text = count.ToString();
}
