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();
}
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();
}
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();
}
private void lblSubmit_MouseClick(object sender, MouseEventArgs e)
{
if (txtNIC.Text == "" || dropdPos.Text == "" || txtfName.Text == "" || txtlName.Text == "" || datetimeBD.Text == "" || txtAddressNo.Text == "" || txtAddressCity.Text == "" || txtAddressStreet.Text == "" || txtTele.Text == "" || txtEmail.Text == "" || photoBox.Image == null)
{
MessageBox.Show("Please Fill all the Details");
}
else
{
try
{
//validatenow();
//MessageBox.Show(lblID.Text);
string query = ("update Employee set EmpNIC = '" + txtNIC.Text
+ "', EmpfName = '" + txtfName.Text
+ "', EmplName = '" + txtlName.Text
+ "', Position = '" + dropdPos.Text.ToString()
+ "', DOB = '" + datetimeBD.Value.ToString()
+ "', Email = '" + txtEmail.Text
+ "', ContactNo = '" + txtTele.Text
+ "', No = '" + txtAddressNo.Text
+ "', Street = '" + txtAddressStreet.Text
+ "', City = '" + txtAddressCity.Text
+ "', Photo = '" + realname
+ "' where EmpID = '" + lblID.Text.ToString() + "' ");
int h = conn.executeQry(query);
if (h == 1)
{
System.IO.File.Copy(FileName, @"C:\Users\House MoNaRa\Documents\Visual Studio 2015\Projects\EmployeeM\EmployeeM\Images\" + realname);
}
conn.closeConnection();
mntForm hh = ((mntForm)container);
hh.Enabled = true;
hh.tbl.loadFirstPage();
resetData();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void lblSubmit_MouseClick(object sender, MouseEventArgs e)
{
if (txtNIC.Text == "" || dropdPos.Text == "" || txtfName.Text == "" || txtlName.Text == "" || datetimeBD.Text == "" || txtAddressNo.Text == "" || txtAddressCity.Text == "" || txtAddressStreet.Text == "" || txtTele.Text == "" || txtEmail.Text == "" || photoBox.Image == null)
{
MessageBox.Show("Please Fill all the Details");
}
else
{
try
{
//validatenow();
System.IO.File.Copy(FileName, @"C:\Users\House MoNaRa\Documents\Visual Studio 2015\Projects\EmployeeM\EmployeeM\Images\" + realname);
string query = "insert into Employee (EmpNIC,EmpfName,EmplName,JoinDate,Position,DOB,Email,No,Street,City,Photo,ContactNo) values ('"
+ txtNIC.Text + "','" + txtfName.Text + "','" + txtlName.Text + "','" + DateTime.Now + "','" + dropdPos.Text.ToString() + "','"
+ datetimeBD.Value.ToString() + "','" + txtEmail.Text + "','" + txtAddressNo.Text + "','" + txtAddressStreet.Text + "','"
+ txtAddressCity.Text + "','" + realname + "','" + txtTele.Text + "')";
conn.executeQry(query);
conn.closeConnection();
resetData();
mntForm hh = ((mntForm)container);
hh.Enabled = true;
hh.tbl.loadFirstPage();
hh.tbl.QuickGo();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
