}//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); }