}//end load benefits
public void LoadInComboBox(ComboBox cbo)
{
Benefit s = new Benefit();
DataTable dt = new DataTable();
dt = s.SELECT_ALL();
if (dt != null)
{
foreach (DataRow r in dt.Rows)
{
cbo.Items.Add(r["code"].ToString());
}
}
}//end load benefits
public void LoadInComboBox(ComboBox cbo)
{
Benefit s = new Benefit();
DataTable dt = new DataTable();
dt = s.SELECT_ALL();
if (dt != null)
{
foreach (DataRow r in dt.Rows)
{
cbo.Items.Add(r["code"].ToString());
}
}
}
private void btnsave_Click(object sender, EventArgs e)
{
Benefit b = new Benefit();
b.code = txtcode.Text;
b.name_ = txtname.Text;
b.type_ = (rdbCompanyBenefit.Checked) ? "COMPANY_BENEFIT" :"PREMIUM";
if (chkBracket.Checked)
{
b.amount_lookup = cboBracket.Text;
b.amount = 0;
}
else
{
b.amount_lookup = "here";
if (txtamount.Text != "")
{
b.amount = Convert.ToDecimal(txtamount.Text);
}
else
{
b.amount = 0;
}
}
//b.amount_lookup = txtamount_lookup.Text;
if (b.save())
{
MessageBox.Show("Successful", "Save");
this.Parent.Height = 0;
this.Parent.Controls.Clear();
this.Dispose();
}
else {
MessageBox.Show("There was a problem saving new benefit: \n" + db.err.Message);
this.Parent.Height = 0;
this.Parent.Controls.Clear();
this.Dispose();
}
}
}//end select all
public void LoadOnListView(ListView lv)
{
Benefit s = new 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["code"].ToString());
li.SubItems.Add(r["name_"].ToString());
li.SubItems.Add(r["type_"].ToString());
//li.SubItems.Add(r["amount_lookup"].ToString());
//li.SubItems.Add(r["amount"].ToString());
lv.Items.Add(li);
ctr++;
}
}
}//end load benefits
public void LoadOnListView(ListView lv)
{
Benefit s = new 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["code"].ToString());
li.SubItems.Add(r["name_"].ToString());
li.SubItems.Add(r["type_"].ToString());
//li.SubItems.Add(r["amount_lookup"].ToString());
//li.SubItems.Add(r["amount"].ToString());
lv.Items.Add(li);
ctr++;
}
}
}
private void benefit_ctrl_Load(object sender, EventArgs e)
{
Benefit b = new Benefit();
b.LoadOnListView(this.lv);
}
public void LIST_BENEFITS()
{
MySqlCommand cmd = new MySqlCommand();
DataTable dt = new DataTable();
db.SET_COMMAND_PARAMS(cmd, "BENEFIT_SELECT_BY_EMPID");
cmd.Parameters.AddWithValue("_empid", empid);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
da.Fill(dt);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
foreach(DataRow r in dt.Rows){
Benefit b = new Benefit();
b.code = r["benefit_code"].ToString();
b.name_ = r["emp_benefit_code"].ToString();
benefits.Add(b);
}
}
}
}
private void emp_benefit_new_Load(object sender, EventArgs e)
{
emp.LoadEmployee(cboEmp);
Benefit b = new Benefit();
b.LoadInComboBox(cboBenefits);
}
