private void btnPullData_Click(object sender, EventArgs e) { try { ShowStatusBar(string.Empty, true); ICollection <MachineInfo> lstMachineInfo = manipulator.GetLogData(objZkeeper, int.Parse(tbxMachineNumber.Text.Trim())); if (lstMachineInfo != null && lstMachineInfo.Count > 0) { if (manipulator.PreviousCount == lstMachineInfo.Count && lstMachineInfo.Count > 0)// >0 and same as previous, so deleteting is safe { //objZkeeper.ClearGLog(tbxMachineNumber.Text.ToInt()); manipulator.PreviousCount = 0; } else//insert into database { var connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["ZK_db"].ConnectionString; MsSql sql = new MsSql(connectionstring); foreach (var m in lstMachineInfo) { Attn_tblZKMaster objAttn_tblZKMaster = new Attn_tblZKMaster(); objAttn_tblZKMaster.DeviceID = m.MachineNumber.ToString(); objAttn_tblZKMaster.UserID = m.IndRegID.ToString(); var zx = DateTime.Parse(m.DateTimeRecord); objAttn_tblZKMaster.LogTime = DateTime.Parse(m.DateTimeRecord); //var xx =DateTime.ParseExact( m.DateTimeRecord,"MM/dd/yyyy hh:mm:ss tt", CultureInfo.InvariantCulture);//6/6/2018 9:47:31 PM //check already inserted var q = $"select count(*) cnt from Attn_tblZKMaster where DeviceID='{objAttn_tblZKMaster.DeviceID}' and UserID='{objAttn_tblZKMaster.UserID}' and LogTime='{objAttn_tblZKMaster.LogTime}'"; var ds = sql.ExecuteDataSet(q, "tt"); if (ds.Tables[0].Rows[0][0].ToString().ToInt() == 0) { sql.InsertObject(objAttn_tblZKMaster); } } manipulator.PreviousCount = lstMachineInfo.Count; } ///////////////////////// BindToGridView(lstMachineInfo); ShowStatusBar(lstMachineInfo.Count + " records found !!", true); //dd.SaveInformation(lstMachineInfo); } else { DisplayListOutput("No records found"); } } catch (Exception ex) { DisplayListOutput(ex.Message); } }
private void btnPullData_Click(object sender, EventArgs e) { try { // DBAccess.Sql.ExecuteDataSet(""); ShowStatusBar(string.Empty, true); ICollection <MachineInfo> lstMachineInfo = manipulator.GetLogData(objZkeeper, int.Parse(tbxMachineNumber.Text.Trim())); if (lstMachineInfo != null && lstMachineInfo.Count > 0) { if (manipulator.PreviousCount == lstMachineInfo.Count)// >0 and same as previous, so deleteting is safe { //ckeck off peak hour var tfrom = DeviceInfo.OffPeakHourFrom; var tto = DeviceInfo.OffPeakHourTo; if (tfrom.HasValue) { var now = DateTime.Now; var starttime = new DateTime(now.Year, now.Month, now.Day, tfrom.Value.Hours, tfrom.Value.Minutes, tfrom.Value.Seconds); if (DeviceInfo.IsNextDayEndHour.GetValueOrDefault(false)) { now = now.AddDays(1); } var endtime = new DateTime(now.Year, now.Month, now.Day, tto.Value.Hours, tto.Value.Minutes, tto.Value.Seconds); if ((DateTime.Now >= starttime) && (DateTime.Now <= endtime)) { objZkeeper.ClearGLog(tbxMachineNumber.Text.ToInt()); manipulator.PreviousCount = 0; } } else { objZkeeper.ClearGLog(tbxMachineNumber.Text.ToInt()); manipulator.PreviousCount = 0; } } else//insert into database { foreach (MachineInfo m in lstMachineInfo) { Attn_tblZKMaster objAttn_tblZKMaster = new Attn_tblZKMaster(); objAttn_tblZKMaster.DeviceID = m.MachineNumber.ToString(); objAttn_tblZKMaster.UserID = m.IndRegID.ToString(); var zx = DateTime.Parse(m.DateTimeRecord); objAttn_tblZKMaster.LogTime = DateTime.Parse(m.DateTimeRecord); objAttn_tblZKMaster.SerialNumber = m.SerialNumber; //var xx =DateTime.ParseExact( m.DateTimeRecord,"MM/dd/yyyy hh:mm:ss tt", CultureInfo.InvariantCulture);//6/6/2018 9:47:31 PM //check already inserted var q = $"select count(*) cnt from Attn_tblZKMaster where DeviceID='{objAttn_tblZKMaster.DeviceID}' and UserID='{objAttn_tblZKMaster.UserID}' and LogTime='{objAttn_tblZKMaster.LogTime}'"; var ds = DBAccess.Sql.ExecuteDataSet(q, "tt"); if (ds.Tables[0].Rows[0][0].ToString().ToInt() == 0) { DBAccess.Sql.InsertObject(objAttn_tblZKMaster); } } manipulator.PreviousCount = lstMachineInfo.Count; } ///////////////////////// //BindToGridView(lstMachineInfo); ShowStatusBar(lstMachineInfo.Count + " records found !!", true); //dd.SaveInformation(lstMachineInfo); } else { DisplayListOutput("No records found"); } } catch (Exception ex) { DisplayListOutput(ex.Message); } timerGetData.Enabled = true; }