public void LoadOnListView(ListView lv) { Leave s = new Leave(); 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["fullname"].ToString()); li.SubItems.Add(r["leavetype"].ToString()); li.SubItems.Add(r["leavedate"].ToString()); li.SubItems.Add(r["noofdays"].ToString()); li.SubItems.Add(r["datefiled"].ToString()); lv.Items.Add(li); ctr++; } } }
private void btnsave_Click(object sender, EventArgs e) { Leave l = new Leave(); l.empid = emp.empid; l.reason = txtreason.Text; l.noofdays = Convert.ToDecimal(txtnoofdays.Text); l.leavedate = dtleavedate.Value; l.leavetype = cboleavetype.Text; l.datefiled = dtdatefiled.Value; l.status_ = "AWAITING_APPROVAL"; l.approvedby = ""; if (l.save()) { MessageBox.Show("Successful"); } else { MessageBox.Show("There was a problem saving leave :\n" + db.err.Message); } }
private void leave_ctrl_Load(object sender, EventArgs e) { Leave l = new Leave(); l.LoadOnListView(lv); }