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