public void LoadMyPassSlips(ListView lv) { PassSlip s = new PassSlip(); DataTable dt = new DataTable(); s.empid = empid; dt = s.SELECT_BY_EMPID(); 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["passtype"].ToString()); li.SubItems.Add(r["destination"].ToString()); li.SubItems.Add(r["purpose"].ToString()); li.SubItems.Add(r["datetime_in"].ToString()); li.SubItems.Add(r["datetime_out"].ToString()); li.SubItems.Add(r["allowance"].ToString()); li.SubItems.Add(r["status_"].ToString()); lv.Items.Add(li); ctr++; } } }
private void btnSubmit_Click(object sender, EventArgs e) { //IF PASS TYPE NOT SET if (cbopasstype.Text != "") { //CREATE A NEW PASS SLIP INSTANCE PassSlip ps = new PassSlip(); ps.empid = Global.CURRENT_USER.empid; ps.destination = txtdestination.Text; ps.passtype = cbopasstype.Text; ps.allowance = Convert.ToDecimal(txtallowance.Text); ps.purpose = txtpurpose.Text; if (ps.apply_new()) { MessageBox.Show("Successful"); } else { MessageBox.Show("There was a problem saving pass slip : \n" + db.err.Message); } } }
}//end load ins listview public void LoadMyPassSlips(ListView lv) { PassSlip s = new PassSlip(); DataTable dt = new DataTable(); s.empid = empid; dt = s.SELECT_BY_EMPID(); 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["passtype"].ToString()); li.SubItems.Add(r["destination"].ToString()); li.SubItems.Add(r["purpose"].ToString()); li.SubItems.Add(r["datetime_in"].ToString()); li.SubItems.Add(r["datetime_out"].ToString()); li.SubItems.Add(r["allowance"].ToString()); li.SubItems.Add(r["status_"].ToString()); lv.Items.Add(li); ctr++; } } }//end load ins listview
private void passslip_current_user_Load(object sender, EventArgs e) { PassSlip ps = new PassSlip(); ps.empid = Global.CURRENT_USER.empid; //MessageBox.Show(Global.CURRENT_USER.empid); ps.LoadMyPassSlips(lv); }
private void btnsave_Click(object sender, EventArgs e) { //CREATE A NEW PASS SLIP INSTANCE PassSlip ps = new PassSlip(); ps.empid = emp.empid; ps.destination = txtdestination.Text; ps.passtype = cbopasstype.Text; ps.allowance = Convert.ToDecimal(txtallowance.Text); //GET DATA FOR TIME IN //year,month,day,hour,minute,second int yr, mnth, dy, hr, min, sec; yr = dtdate.Value.Year; mnth=dtdate.Value.Month; dy = dtdate.Value.Day; hr = dttimein.Value.Hour; min = dttimein.Value.Minute; sec = dttimein.Value.Second; ps.datetime_in = new DateTime(yr,mnth,dy,hr,min,sec); //GET DATA FOR TIME OUT hr = dttimeout.Value.Hour; min = dttimeout.Value.Minute; sec = dttimeout.Value.Second; ps.datetime_out = new DateTime(yr, mnth, dy, hr, min, sec); if (ps.save()) { MessageBox.Show("Successful"); } else { MessageBox.Show("There was a problem saving pass slip : \n" + db.err.Message); } }
private void passslip_ctrl_Load(object sender, EventArgs e) { PassSlip p = new PassSlip(); p.LoadOnListView(lv); }