private void GetAttendance_Click(object sender, EventArgs e)
{
DataSet1TableAdapters.RecordTBLTableAdapter recordTBL = new DataSet1TableAdapters.RecordTBLTableAdapter();
DataTable dt = recordTBL.GetDataByDATE(dateTimePicker1.Text);
dataGridView2.DataSource = dt;
}
public void IN(string dateIn, string personName, string groupId)
{
DataSet1TableAdapters.RecordTBLTableAdapter recordTBL = new DataSet1TableAdapters.RecordTBLTableAdapter();
var date = DateTime.Now.ToString();
recordTBL.AddRecord(date, personName, groupId, dateIn);
}
public void OUT(string PersonName)
{
DataSet1TableAdapters.RecordTBLTableAdapter recordTBL = new DataSet1TableAdapters.RecordTBLTableAdapter();
DateTime time = DateTime.Now;
string format = "HH:mm:ss";
string dateOUT = time.ToString(format);
string DATE = time.ToString();
Console.WriteLine(dateOUT);
recordTBL.UpdateOUTQuery(dateOUT, DATE, PersonName);
}
private void CamIN_Click(object sender, EventArgs e)
{
DateTime time = DateTime.Now;
string format = "HH:mm:ss";
string dateIn = time.ToString(format);
string personName = "ELON";
string groupId = "lidi";
DataSet1TableAdapters.RecordTBLTableAdapter recordTBL = new DataSet1TableAdapters.RecordTBLTableAdapter();
Console.WriteLine(dateIn);
IN(dateIn, personName, groupId);
//recordTBL.AddRecord(dateTimePicker1.Text, personName, groupId, dateIn);
}
