private void btnSearch_Click(object sender, EventArgs e)
{
DataTable dtSearchResult = new DataTable();
Boolean flag = false;
if (txtEmpNo.Text.Equals(""))
{
MessageBox.Show("Enter Employee Number to search");
}
else
{
dtSearchResult = dbAccessLayer.RetrieveTable("tblempmaster", new String[] { "EmpNo" }, new String[] { txtEmpNo.Text });
}
if (dtSearchResult != null)
{
if (dtSearchResult.Rows.Count > 0)
{
txtEmpNo.Text = dtSearchResult.Rows[0][0].ToString();
txtEmpName.Text = dtSearchResult.Rows[0][1].ToString();
cmbBoxEmpType.SelectedValue = dtSearchResult.Rows[0][2].ToString();
cmbBoxEmpDept.SelectedValue = dtSearchResult.Rows[0][3].ToString();
cmbBoxShip.SelectedValue = dtSearchResult.Rows[0][4].ToString();
if (Boolean.Parse(dtSearchResult.Rows [0][5].ToString()))
{
rdBtnActive.Checked = true;
}
else
{
rdBtnInactive.Checked = true;
}
txtFromDate.Text = dtSearchResult.Rows[0][6].ToString();
txtToDate.Text = dtSearchResult.Rows[0][7].ToString();
txtPassWord.Text = dtSearchResult.Rows[0][8].ToString();
flag = true;
}
else
{
flag = false;
}
}
else
{
flag = false;
}
if (!flag)
{
MessageBox.Show("No results found");
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
DataTable dtSearchResult = new DataTable();
Boolean flag = false;
if (txtShipNo.Text.Equals(""))
{
MessageBox.Show("Enter Ship Number to search");
}
else
{
dtSearchResult = dbAccessLayer.RetrieveTable("tblshipmaster", new String[] { "ShipNo" }, new String[] { txtShipNo.Text });
}
if (dtSearchResult != null)
{
if (dtSearchResult.Rows.Count > 0)
{
txtShipNo.Text = dtSearchResult.Rows[0][0].ToString();
txtShipName.Text = dtSearchResult.Rows[0][1].ToString();
cmbBoxFleet.SelectedValue = dtSearchResult.Rows[0][2].ToString();
cmbBoxShipType.SelectedValue = dtSearchResult.Rows[0][3].ToString();
txtShipSize.Text = dtSearchResult.Rows[0][4].ToString();
txtShipCapacity.Text = dtSearchResult.Rows[0][5].ToString();
flag = true;
}
else
{
flag = false;
}
}
else
{
flag = false;
}
if (!flag)
{
MessageBox.Show("No results found");
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
DataTable dtSearchResult = new DataTable();
Boolean flag = false;
if (txtShipTypeID.Text.Equals(""))
{
MessageBox.Show("Enter Ship Id to search");
}
else
{
dtSearchResult = dbAccessLayer.RetrieveTable("tblshiptypemaster", new String[] { "ShiptypeID" }, new String[] { txtShipTypeID.Text });
}
if (dtSearchResult != null)
{
if (dtSearchResult.Rows.Count > 0)
{
txtShipTypeID.Text = dtSearchResult.Rows[0][0].ToString();
txtShipTypeName.Text = dtSearchResult.Rows[0][1].ToString();
txtShipTypeDesc.Text = dtSearchResult.Rows[0][2].ToString();
flag = true;
}
else
{
flag = false;
}
}
else
{
flag = false;
}
if (!flag)
{
MessageBox.Show("No results found");
}
}