private int addEmp()
{
string s = txtName.Text;
employeeBLL emp = new employeeBLL();
try
{
long i = emp.addEmployee(txtName.Text, txtPersonal.Text, txtOffice.Text, richTxtAddress.Text, txtEmail.Text, Convert.ToDateTime(txtdateObirth.Text), Convert.ToInt64(txtSalarry.Text), cmbDesignation.Text, Convert.ToInt64(txtNid.Text), cmbBloodGroup.Text, cmbGender.Text);
nxtId = i;
if (i != 0)
{
return(1);
}
else
{
return(0);
}
}
catch (Exception e)
{
return(0);
}
}
private void profile()
{
employeeBLL emp = new employeeBLL();
DataTable dt = emp.profile(id);
if (dt.Rows.Count == 1)
{
lblName.Text = dt.Rows[0][1].ToString();
lblPersonalPhone.Text = dt.Rows[0][2].ToString();
lblOfficePhone.Text = dt.Rows[0][3].ToString();
lblAddress.Text = dt.Rows[0][4].ToString();
lblEmail.Text = dt.Rows[0][5].ToString();
DateTime dob = Convert.ToDateTime(dt.Rows[0][6]);
string format = "dd-MM-yyyy";
lblDateOfBirth.Text = dob.ToString(format);
lblSalary.Text = dt.Rows[0][7].ToString();
DateTime jd = Convert.ToDateTime(dt.Rows[0][8]);
lblJoinDate.Text = jd.ToString(format);
lblDepartment.Text = dt.Rows[0][9].ToString();
lblNid.Text = dt.Rows[0][11].ToString();
lblBloodGroup.Text = dt.Rows[0][12].ToString();
lblGender.Text = dt.Rows[0][13].ToString();
}
}
public void viewALLEmployee()
{
search = txtSearch.Text;
if (cmbOrder.Text == "NAME")
{
orderby = "name";
}
else if (cmbOrder.Text == "ID")
{
orderby = "id";
}
else if (cmbOrder.Text == "STATUS")
{
orderby = "STATUS";
}
else if (cmbOrder.Text == "JOINDATE")
{
orderby = "JOIN_DATE";
}
asc = cmbAsc.Text;
try
{
employeeBLL emp = new employeeBLL();
DataTable dt = emp.viewEmp(search, orderby, asc);
int i = dt.Rows.Count;
//MessageBox.Show(i + "");
string format = "dd-MM-yyyy";
listView1.Items.Clear();
for (int j = 0; j < i; j++)
{
ListView item = new ListView();
String id = dt.Rows[j][0].ToString();
String name = dt.Rows[j][1].ToString();
String pp = dt.Rows[j][2].ToString();
String po = dt.Rows[j][3].ToString();
String email = dt.Rows[j][5].ToString();
String bl = dt.Rows[j][12].ToString();
String gender = dt.Rows[j][13].ToString();
DateTime joindate = Convert.ToDateTime(dt.Rows[j][8]);
string join = joindate.ToString(format);
String status = dt.Rows[j][10].ToString();
String des = dt.Rows[j][9].ToString();
listView1.Items.Add(id);
listView1.Items[listView1.Items.Count - 1].SubItems.Add(name);
listView1.Items[listView1.Items.Count - 1].SubItems.Add(pp);
listView1.Items[listView1.Items.Count - 1].SubItems.Add(po);
listView1.Items[listView1.Items.Count - 1].SubItems.Add(email);
listView1.Items[listView1.Items.Count - 1].SubItems.Add(bl);
listView1.Items[listView1.Items.Count - 1].SubItems.Add(gender);
listView1.Items[listView1.Items.Count - 1].SubItems.Add(join);
listView1.Items[listView1.Items.Count - 1].SubItems.Add(des);
listView1.Items[listView1.Items.Count - 1].SubItems.Add(status);
//btnDetails.Enabled = false;
}
}
catch (Exception e)
{
//MessageBox.Show("error in data base");
}
}
