private void btnGetAllData_Click(object sender, EventArgs e)
{
using (FingerPrintDB db = new FingerPrintDB())
{
dgvLogs.DataSource = db.Logs.Where(w => w.DateOnlyRecord >= dtpFrom.Value.Date && w.DateOnlyRecord <= dtpTo.Value.Date).ToList();
dgvLogs.Columns["Id"].Visible = false;
}
}
private void btnGetLogs_Click(object sender, EventArgs e)
{
try
{
using (FingerPrintDB db = new FingerPrintDB())
{
SqlParameter dtFrom = new SqlParameter("@dtFrom", dtpFrom.Value.Date);
SqlParameter dtTo = new SqlParameter("@dtTo", dtpTo.Value.Date);
var logs = db.Database.SqlQuery <LogsHours>("GetHours @dtFrom,@dtTo", dtFrom, dtTo).ToList();
logsHours = logs.Select(s => new LogsHoursDisplay
{
IndRegID = s.IndRegID,
Date = s.Date,
Hours = (s.Minutes / 60).ToString("D2") + ":" + (s.Minutes % 60).ToString("D2")
}).ToList();
dgvLogs.DataSource = logsHours;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnInsert_Click(object sender, EventArgs e)
{
try
{
using (FingerPrintDB db = new FingerPrintDB())
{
foreach (var machine in machines)
{
string ipAddress = machine.IP;
string port = machine.Port;
if (ipAddress == string.Empty || port == string.Empty)
{
throw new Exception("The Device IP Address and Port is mandotory !!");
}
int portNumber = 4370;
if (!int.TryParse(port, out portNumber))
{
throw new Exception("Not a valid port number");
}
bool isValidIpA = UniversalStatic.ValidateIP(ipAddress);
if (!isValidIpA)
{
throw new Exception("The Device IP is invalid !!");
}
isValidIpA = UniversalStatic.PingTheDevice(ipAddress);
if (!isValidIpA)
{
throw new Exception("The device at " + ipAddress + ":" + port + " did not respond!!");
}
objZkeeper = new ZkemClient(RaiseDeviceEvent);
objZkeeper.Connect_Net(ipAddress, portNumber);
ICollection <MachineInfo> lstMachineInfo = manipulator.GetLogData(objZkeeper, machine.Number);
foreach (var log in lstMachineInfo)
{
string timeOnly = Convert.ToDateTime(log.DateTimeRecord).ToShortTimeString();
if (db.Logs.Any(f => f.IndRegID == log.IndRegID && f.DateOnlyRecord == log.DateOnlyRecord && f.TimeOnlyRecord == timeOnly) != true)
{
db.Logs.Add(new Log
{
Status = machine.Type,
MachineNumber = machine.Number,
IndRegID = log.IndRegID,
DateTimeRecord = Convert.ToDateTime(log.DateTimeRecord),
DateOnlyRecord = log.DateOnlyRecord,
TimeOnlyRecord = Convert.ToDateTime(log.DateTimeRecord).ToShortTimeString()
});
db.SaveChanges();
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnExportAllData_Click(object sender, EventArgs e)
{
try
{
using (FingerPrintDB db = new FingerPrintDB())
{
var allData = db.Logs.Where(w => w.DateOnlyRecord >= dtpFrom.Value.Date && w.DateOnlyRecord <= dtpTo.Value.Date).ToList();
if (dgvLogs.Rows.Count == 0)
{
return;
}
SaveFileDialog dlg = new SaveFileDialog
{
FileName = "جميع البيانات",
DefaultExt = ".xls",
Filter = "Text documents (.xls)|*.xls"
};
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
int i = 2;
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
xlWorkSheet.Cells[1, 1] = "MachineNumber";
xlWorkSheet.Cells[1, 2] = "Status";
xlWorkSheet.Cells[1, 3] = "IndRegID";
xlWorkSheet.Cells[1, 4] = "DateTimeRecord";
xlWorkSheet.Cells[1, 5] = "DateOnlyRecord";
xlWorkSheet.Cells[1, 6] = "TimeOnlyRecord";
foreach (var item in allData)
{
xlWorkSheet.Cells[i, 1] = item.MachineNumber;
xlWorkSheet.Cells[i, 2] = item.Status;
xlWorkSheet.Cells[i, 3] = item.IndRegID;
xlWorkSheet.Cells[i, 4] = item.DateTimeRecord;
xlWorkSheet.Cells[i, 5] = item.DateOnlyRecord;
xlWorkSheet.Cells[i, 6] = item.TimeOnlyRecord;
i++;
}
xlWorkBook.SaveAs(dlg.FileName, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
ReleaseObject(xlWorkSheet);
ReleaseObject(xlWorkBook);
ReleaseObject(xlApp);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
