public AnvizDevice(TcpClient socket)
{
DeviceStream = new AnvizStream(socket);
DeviceStream.ReceivedPacket += (s, e) =>
{
switch (e.ResponseCode)
{
case 0x7F:
DevicePing?.Invoke(this, null);
break;
case 0xDF:
ReceivedRecord?.Invoke(this, new Record(e.DATA, 0));
break;
default:
ReceivedPacket?.Invoke(this, e);
break;
}
};
DeviceStream.DeviceError += (s, e) =>
{
DeviceError?.Invoke(this, e);
};
}
public List <ReceivedRecord> GetRows(string storeIdValue = "")
{
string query;
var receivedRecords = new List <ReceivedRecord>();
if (String.IsNullOrEmpty(storeIdValue))
{
query = "SELECT * FROM purchases";
}
else
{
query = $"SELECT * FROM purchases WHERE store_id='{storeIdValue}'";
}
var dataReader = new MySqlCommand(query, Connection).ExecuteReader();
while (dataReader.Read())
{
var receivedRecord = new ReceivedRecord();
receivedRecord.StoreId = dataReader["store_id"].ToString();
receivedRecord.StoreType = char.Parse(dataReader["store_type"].ToString());
receivedRecord.ActivityDays = char.Parse(dataReader["activity_days"].ToString());
receivedRecord.CreditCard = dataReader["credit_card"].ToString();
receivedRecord.PurchaseDate = DateTime.Parse(dataReader["purchase_date"].ToString());
receivedRecord.InsertionDate = DateTime.Parse(dataReader["insertion_date"].ToString());
receivedRecord.TotalPrice = double.Parse(dataReader["total_price"].ToString());
receivedRecord.Installments = int.Parse(dataReader["installments"].ToString());
receivedRecord.PricePerInstallment = double.Parse(dataReader["price_per_installment"].ToString());
receivedRecord.IsValid = dataReader["is_valid"].ToString() == "1" ? true : false;
receivedRecord.WhyInvalid = dataReader["why invalid"].ToString();
receivedRecords.Add(receivedRecord);
}
return(receivedRecords);
}
