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