/// <summary>
/// ?????
/// </summary>
/// <param name="modelDB"></param>
public static void DBRemove(DatabaseEntity modelDB)
{
DataTableEntity modelDT = new DataTableEntity {
Name = "Database"
};
modelDT = DataTableManage.Read(DBMaster.DB, modelDT);
DataRowManage.Delete(modelDT, new DataWhereEntity[] { new DataWhereEntity {
ColumnName = "ID", Predicate = info => Convert.ToInt32(info) == modelDB.ID
} });
ListDB.Remove(modelDB);
modelDB.MasterFile.FileStream.Close();
}
public static async Task Run([EventGridTrigger] JObject eventGridEventJobject, ILogger log)
{
log.LogInformation($"EventGridTrigger triggered at: {DateTime.UtcNow}");
string encodedJSonString = await GeneralHelpers.ParseEventGridTelemetryBody(eventGridEventJobject);
if (!string.IsNullOrEmpty(encodedJSonString))
{
string jsonString = await GeneralHelpers.Base64Decode(encodedJSonString);
DataTableEntity mappedWeatherEntity = await MapPayloadToTableEntityAsync(jsonString);
await SaveDataToStorageTableAsync(mappedWeatherEntity, log);
}
}
public ActionResult GetBookList(DataTableEntity pModel, string key)
{
int recordCount = 0;
var list = new BookService().GetBookList(key, pModel.PageIndex, pModel.PageSize, out recordCount);
var data = new DataTableReturnEntity <BookInfoEntity>
{
data = list,
draw = pModel.Draw,
recordsFiltered = recordCount,
recordsTotal = recordCount
};
return(JsonCResult(data));
}
/// <summary>
/// ?????
/// </summary>
/// <param name="modelDB"></param>
public static void DBAdd(DatabaseEntity modelDB)
{
DataTableEntity modelDT = new DataTableEntity {
Name = "Database"
};
modelDT = DataTableManage.Read(DBMaster.DB, modelDT);
Manage.ListDB.Add(modelDB);
List <DataRowEntity> listDR = DataRowManage.Read(modelDT, new string[] { "ID" });
modelDB.ID = (listDR.Count == 0) ? 1 : listDR.Max(info => Convert.ToInt32(info.Contents[0])) + 1;
DataRowManage.Create(modelDT, new DataRowEntity {
Columns = new string[] { "ID", "Name", "Path" }, Contents = new object[] { modelDB.ID, modelDB.Name, modelDB.MasterFile.FilePath }
});
}
public static async Task <DataTableEntity> MapPayloadToTableEntityAsync(string payloadJsonString)
{
DataTableEntity dataTableEntity = new DataTableEntity(ConfigReader.PartitionKey, Guid.NewGuid());
List <PayloadEntity> payloadList = new List <PayloadEntity>();
PayloadEntity data = await GeneralHelpers.ConvertToObject(payloadJsonString);
payloadList.Add(data);
foreach (PayloadEntity payload in payloadList)
{
dataTableEntity.DataFormat = payload.DataFormat;
dataTableEntity.Humidity = payload.Humidity;
dataTableEntity.Temperature = payload.Temperature;
dataTableEntity.Pressure = payload.Pressure;
dataTableEntity.Battery = payload.Battery;
}
return(await Task.FromResult(dataTableEntity));
}
/// <summary>
/// ??
/// </summary>
public static void Start()
{
if (!File.Exists(Config.DBMasterPath))
{
DBMaster.Create();
}
//??????
DBMaster.Open();
ListDB = new List <DatabaseEntity>();
ListDB.Add(DBMaster.DB);
//???????
DataTableEntity modelDT = new DataTableEntity {
Name = "Database"
};
modelDT = DataTableManage.Read(DBMaster.DB, modelDT);
string[] listColumn = new string[] { "Name" };
List <DataRowEntity> listDR = DataRowManage.Read(modelDT,
new string[] { "ID", "Name", "Path" },
new DataWhereEntity[] { new DataWhereEntity {
ColumnName = "ID", Predicate = info => Convert.ToInt32(info) != 1
} });
//????
foreach (DataRowEntity modelDR in listDR)
{
DatabaseEntity modelDB = new DatabaseEntity
{
MasterFile = new DataFileEntity {
FilePath = modelDR.Contents[2].ToString()
}
};
DatabaseManage.Read(modelDB);
modelDB.ID = Convert.ToInt32(modelDR.Contents[0]);
ListDB.Add(modelDB);
}
IsRun = true;
}
public static async Task SaveDataToStorageTableAsync(DataTableEntity data, ILogger log)
{
log.LogInformation($"Trying to save data to Storage Table with data set: {data}");
if (data != null)
{
CloudStorageAccount cloudStorageConnection = CloudStorageAccount.Parse(ConfigReader.StorageConnectionString);
CloudTableClient client = cloudStorageConnection.CreateCloudTableClient();
CloudTable table = client.GetTableReference(ConfigReader.StorageTable);
TableOperation tableOperation = TableOperation.Insert(data);
try
{
await table.ExecuteAsync(tableOperation).ConfigureAwait(false);
}
catch (Exception ex)
{
log.LogError($"Table ExecuteAsync failed: {ex.Message}");
log.LogError($"Inner Exception: {ex.InnerException}");
}
}
}
public void ReadData(DataTableEntity entity, JsonData data)
{
}
