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