private void makeAttendance()
        {
            conn = new conDB();
            int count = (int)conn.dataReaderScalar("select count(AtID) from Attendance where Date = '" + datetime + "' ");

            //MessageBox.Show(count.ToString());

            if (count == 0)
            {
                int x = (int)conn.dataReaderScalar("select count(EmpID) from Employee where MarkedStatus='on' ");
                //MessageBox.Show(x.ToString());
                SqlDataReader dr = conn.dataReader("select EmpID from Employee where MarkedStatus='on' ");

                for (int i = 0; i < x; i++)
                {
                    while (dr.Read())
                    {
                        IDvalues = dr[0].ToString();
                        //MessageBox.Show(IDvalues);
                        conn = new conDB();
                        conn.executeQry("INSERT INTO Attendance (Date,EmpID) VALUES ('" + datetime + "','" + IDvalues + "') ");
                    }
                }
            }

            conn.closeConnection();
        }
예제 #2
0
        private void pbSearchAll_MouseClick(object sender, MouseEventArgs e)
        {
            if (txtSearchAll.Text == "")
            {
                MessageBox.Show("Search Box is Empty");
            }
            else
            {
                try
                {
                    conn = new conDB();
                    SqlDataReader rdr = conn.dataReader("select * from ViewAllAttendance where FullName like '%" + txtSearchAll.Text + "%' ");
                    BindingSource bs  = new BindingSource();
                    bs.DataSource = rdr;
                    bunifuCustomDataGrid1.DataSource = bs;

                    conn.closeConnection();

                    txtSearchAll.ResetText();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }
        private void lblSetAtt_MouseClick(object sender, MouseEventArgs e)
        {
            string datetime = DateTime.Now.ToString();

            for (int i = 0; i < bunifuCustomDataGrid1.Rows.Count; i++)
            {
                String status = (String)bunifuCustomDataGrid1.Rows[i].Cells[0].Value;
                MessageBox.Show(status);

                String EmpID = bunifuCustomDataGrid1.Rows[i].Cells[1].Value.ToString();
                MessageBox.Show(EmpID);

                String leavestatus = (String)bunifuCustomDataGrid1.Rows[i].Cells[0].Value;
                //MessageBox.Show(leavestatus);

                try
                {
                    if (leavestatus != null)
                    {
                        conn = new conDB();
                        conn.executeQry("update Attendance set LeaveStates='" + status + "',LeaveTime='" + datetime + "' where EmpID='" + EmpID + "' and Date ='" + datetime + "' ");

                        MessageBox.Show("Successful");
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }

            tableLoad();
        }
예제 #4
0
        private void tableLoad()
        {
            conn = new conDB();
            SqlDataReader rdr = conn.dataReader("select * from ViewAllAttendance ");
            BindingSource bs  = new BindingSource();

            bs.DataSource = rdr;
            bunifuCustomDataGrid1.DataSource = bs;

            conn.closeConnection();
        }
        private void tableLoad()
        {
            conn = new conDB();
            SqlDataReader rdr = conn.dataReader("select e.EmpID,e.EmpfName,e.EmplName,a.Date,a.ArivalTime,a.AttendanceStatus from Attendance a,Employee e where e.EmpID=a.EmpID and a.AttendanceStatus='Present' and MarkedStatus='on' and Date ='" + datetime + "' and LeaveStates is null ");
            BindingSource bs  = new BindingSource();

            bs.DataSource = rdr;
            bunifuCustomDataGrid1.DataSource = bs;

            conn.closeConnection();
        }
예제 #6
0
        public void TableLoad()
        {
            conn = new conDB();
            SqlDataReader rdr = conn.dataReader("select e.EmpID,e.EmpfName,e.EmplName,e.Position from Attendance a,Employee e where e.EmpID=a.EmpID and e.MarkedStatus='on' and AttendanceStatus='Waiting' and Date='" + datetime + "' and a.ArivalTime is null ");
            BindingSource bs  = new BindingSource();

            bs.DataSource = rdr;
            bunifuCustomDataGrid1.DataSource = bs;

            conn.closeConnection();
        }
예제 #7
0
        private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
        {
            try
            {
                conn = new conDB();
                SqlDataReader rdr = conn.dataReader("select * from ViewAllAttendance where Date = '" + dateTimePicker1.Value + "' ");
                BindingSource bs  = new BindingSource();
                bs.DataSource = rdr;
                bunifuCustomDataGrid1.DataSource = bs;

                conn.closeConnection();

                txtSearchAll.ResetText();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
예제 #8
0
        private void lblSet_MouseClick(object sender, MouseEventArgs e)
        {
            for (int i = 0; i < bunifuCustomDataGrid1.Rows.Count; i++)
            {
                try
                {
                    conn = new conDB();

                    String status = (String)bunifuCustomDataGrid1.Rows[i].Cells[0].Value;
                    //MessageBox.Show(status);

                    String EmpID = bunifuCustomDataGrid1.Rows[i].Cells[1].Value.ToString();
                    //MessageBox.Show(EmpID);

                    if (status == "Present")
                    {
                        conn.executeQry("update Attendance set ArivalTime='" + datetime
                                        + "', AttendanceStatus='Present' where EmpID='" + EmpID + "' and Date='" + datetime + "' ");
                    }
                    else if (status == "Absent")
                    {
                        conn.executeQry("update Attendance set AttendanceStatus='Absent' where EmpID='" + EmpID + "' and Date='" + datetime + "' ");
                    }
                    else
                    {
                        conn.executeQry("update Attendance set AttendanceStatus='Waiting' where EmpID='" + EmpID + "' and Date='" + datetime + "' ");
                    }

                    MessageBox.Show("Successful");
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }

            TableLoad();
        }