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