private void btnsave_Click(object sender, EventArgs e)
{
if (cboEmp.Text != "")
{
String[] c = cboEmp.Text.ToString().Split('-');
String id = c[1]+ "-" + c[2];
Emp_Benefit eb = new Emp_Benefit();
eb.empid = id;
eb.benefit_code = cboBenefits.Text;
if (chkNa.Checked)
{
eb.emp_benefit_code = "N/A";
}
else {
eb.emp_benefit_code = txtemp_benefit_code.Text;
}
if (eb.save())
{
MessageBox.Show("Successful", "Save");
}
else {
MessageBox.Show("There was a problem saving employee benefits: \n" + db.err.Message, "Failed");
}
this.Parent.Height = 0;
this.Parent.Controls.Clear();
this.Dispose();
}
}
public void LoadOnListView(ListView lv)
{
Emp_Benefit s = new Emp_Benefit();
DataTable dt = new DataTable();
dt = s.SELECT_ALL();
if (dt != null)
{
int ctr = 1;
foreach (DataRow r in dt.Rows)
{
ListViewItem li = new ListViewItem();
li.Text = ctr.ToString();
li.SubItems.Add(r["empid"].ToString());
li.SubItems.Add(r["fullname"].ToString());
li.SubItems.Add(r["position_"].ToString());
li.SubItems.Add(r["benefits"].ToString());
lv.Items.Add(li);
ctr++;
}
}
}
}//end select all
public void LoadOnListView(ListView lv)
{
Emp_Benefit s = new Emp_Benefit();
DataTable dt = new DataTable();
dt = s.SELECT_ALL();
if (dt != null)
{
int ctr = 1;
foreach (DataRow r in dt.Rows)
{
ListViewItem li = new ListViewItem();
li.Text = ctr.ToString();
li.SubItems.Add(r["empid"].ToString());
li.SubItems.Add(r["fullname"].ToString());
li.SubItems.Add(r["position_"].ToString());
li.SubItems.Add(r["benefits"].ToString());
lv.Items.Add(li);
ctr++;
}
}
}//end load benefits
private void emp_benefit_ctrl_Load(object sender, EventArgs e)
{
Emp_Benefit eb = new Emp_Benefit();
eb.LoadOnListView(this.lv);
}
