/// <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) { }