/// <summary>
/// Добавление статус пациенту
/// </summary>
/// <param name="patientId"></param>
/// <param name="parameters"></param>
/// <returns>Новый статус пациента</returns>
public async Task <StatusDto> AddStatusAsync(int patientId, ParametersDto parameters)
{
var patient = await Db.PatientEntities.FirstOrDefaultAsync(x => x.PatientId == patientId);
var newStatus = new StatusEntity
{
PatientId = patientId,
PreviousStatusId = patient.StatusId,
IsHospitalized = parameters.IsHospitalized,
IsWheezing = parameters.IsWheezing,
Pef = parameters.Pef,
SpO2 = parameters.SpO2,
CreatedDate = DateTime.UtcNow
};
Db.StatusEntities.Add(newStatus);
Db.SaveChanges();
patient.StatusId = newStatus.StatusId;
await Db.SaveChangesAsync();
var result = StatusDto.FromEntity(newStatus);
return(result);
}
public async Task WriteToTable(StatusEntity entity, ILogger log)
{
var table = await _tableStorage.GetTableAsync();
log.LogInformation("Inserting into table:\n\t {0}\n", table.Uri);
TableOperation insertOrMergeOperation = TableOperation.InsertOrMerge(entity);
}
public async Task Run([TimerTrigger("0 */1 * * * *")] TimerInfo myTimer, ILogger log)
{
log.LogInformation($"Reading at: {DateTime.Now}");
var url = "https://api.publicapis.org/random?auth=null";
try
{
var response = await client.GetAsync(url);
var responseStr = response.ToString();
var payload = response.Content.ReadAsStringAsync().Result;
var status = response.StatusCode.ToString();
var timeDateStr = JsonConvert.SerializeObject(response.Headers.Date);
var SE = new StatusEntity(status, timeDateStr, responseStr);
await _addToTable.WriteToTable(SE, log);
await _addToBlob.WriteToBlob(payload, log);
}
catch (HttpRequestException e)
{
log.LogInformation("exception: " + e);
}
}
/// <summary>
/// 增加一条记录，返回新的ID号。需要有一个单一主键，并且开启有标识符属性（异步方式）
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual async Task <int> InsertAsync(StatusEntity entity)
{
if (entity.StatusID <= 0)
{
entity.StatusID = GetNewID();
}
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into Status (" +
"StatusID," +
"StatusCode," +
"StatusName," +
"StatusType) " +
"values(" +
"@StatusID," +
"@StatusCode," +
"@StatusName," +
"@StatusType)";
if (await Task.Run(() => _DB.ExeSQLResult(strSQL, dict)))
{
return(DataConverter.CLng(entity.StatusID));
}
return(-1);
}
private bool ValidaStatus(StatusEntity status)
{
int cont = 0;
if (_baseValida.ValidaCampoNull(status.nome) ||
_baseValida.ValidaString(status.nome))
{
//statusEntity.nome = statusEntity.nome.Trim(' ');
return(true);
}
if (status.cod_status != 0)
{
var existe = _statusRepository.GetNoTracking(status.cod_status);
if (existe == null)
{
cont++;
}
}
if (status.nome != null)
{
var unique = _statusRepository.GetStatusByName(status.nome);
if (unique != null)
{
cont++;
}
}
if (cont > 0)
{
return(true);
}
return(false);
}
/// <summary>
/// 把实体类转换成键/值对集合
/// </summary>
/// <param name="entity"></param>
/// <param name="dict"></param>
private static void GetParameters(StatusEntity entity, Dictionary <string, object> dict)
{
dict.Add("StatusID", entity.StatusID);
dict.Add("StatusCode", entity.StatusCode);
dict.Add("StatusName", entity.StatusName);
dict.Add("StatusType", entity.StatusType);
}
// PUT: api/Status/5
public bool Put(int id, [FromBody] StatusEntity StatusEntity)
{
if (id > 0)
{
return(_StatusServices.UpdateStatus(id, StatusEntity));
}
return(false);
}
public async Task SetStatus(int roomId, StatusEntity status)
{
await AccessDatabase();
var room = NotFakeDatabse.Rooms.First(r => r.Id == roomId);
room.Status = status;
}
/// <summary>
/// OBTENER LA LISTA DE ESTADOS
/// </summary>
/// <param name="oBe"></param>
/// <returns></returns>
public List <StatusEntity> SHPR_STATUS_LIST(StatusEntity oBe)
{
using (var odr = oDa.SHPR_STATUS_LIST(oBe))
{
var oList = new List <StatusEntity>();
((IList)oList).LoadFromReader <StatusEntity>(odr);
return(oList);
}
}
public void UpdateLatestStatus(TypeTrain type, IStatus status)
{
var entity = new StatusEntity()
{
LineType = type, Status = status.Status, LastUpdate = status.LastUpdate.UtcDateTime
};
_dao.Upsert(entity);
}
public async Task <TData <string> > SaveForm(StatusEntity entity)
{
TData <string> obj = new TData <string>();
await statusService.SaveForm(entity);
obj.Result = entity.Id.ParseToString();
obj.Tag = 1;
return(obj);
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static StatusEntity GetEntityFromrdr(NullableDataReader rdr)
{
StatusEntity info = new StatusEntity();
info.StatusID = rdr.GetInt32("StatusID");
info.StatusCode = rdr.GetInt32("StatusCode");
info.StatusName = rdr.GetString("StatusName");
info.StatusType = rdr.GetInt32("StatusType");
return(info);
}
public ClaimEntity UpdateStatus(ClaimEntity claim, StatusEntity status)
{
claim.Status = status;
claim.StatusId = status.Id;
claim.StatusName = status.Name;
claim.WhenLastModified = DateTime.Now;
ClaimRepo.Update(claim);
return(claim);
}
/// <summary>
/// Создает пациента в базе данных
/// </summary>
/// <param name="firstName"></param>
/// <param name="lastName"></param>
/// <param name="birthDate"></param>
/// <param name="sexType"></param>
/// <returns>Новый пациент</returns>
public async Task <PatientDto> CreatePatientAsync(string firstName, string lastName, DateTime birthDate,
GenderType sexType)
{
var newPatient = new PatientEntity
{
FirstName = firstName,
LastName = lastName,
BirthDate = birthDate,
GenderTypeId = sexType.Id
};
Db.PatientEntities.Add(newPatient);
await Db.SaveChangesAsync();
var newStatus = new StatusEntity
{
CreatedDate = DateTime.UtcNow,
PatientId = newPatient.PatientId,
PreviousStatusId = 0
};
Db.StatusEntities.Add(newStatus);
await Db.SaveChangesAsync();
newStatus.PreviousStatusId = newStatus.StatusId;
await Db.SaveChangesAsync();
var newState = new StateEntity
{
CreatedDate = DateTime.UtcNow,
PatientId = newPatient.PatientId,
StatusId = newStatus.StatusId,
PreviousStateId = 0,
StateTypeId = StateType.Initial.Id
};
Db.StateEntities.Add(newState);
await Db.SaveChangesAsync();
newState.PreviousStateId = newState.StatusId;
await Db.SaveChangesAsync();
newPatient.StatusId = newStatus.StatusId;
newPatient.StateId = newState.StateId;
await Db.SaveChangesAsync();
var result = PatientDto.FromEntity(newPatient);
result.Status = StatusDto.FromEntity(newStatus);
result.PatientState = StateDto.FromEntity(newState);
return(result);
}
private void Append(StatusEntity value, int number)
{
var list = clientData.Nodes[number].Status;
list.Insert(0, value);
var len = list.Count;
if (len > 20)
{
list.RemoveRange(20, len - 20);
}
}
public async Task SaveForm(StatusEntity entity)
{
if (entity.Id.IsNullOrZero())
{
entity.Create();
await this.BaseRepository().Insert(entity);
}
else
{
await this.BaseRepository().Update(entity);
}
}
public ActionResult <StatusEntity> Post([FromBody] StatusEntity statusEntity)
{
if (!ValidaStatus(statusEntity))
{
statusEntity.nome = statusEntity.nome.Trim(' ');
return(new OkObjectResult(_statusRepository.Add(statusEntity)));
}
else
{
return(new BadRequestObjectResult("Nome inválido!"));
}
}
public ActionResult <List <StatusEntity> > GetUserStatuses()
{
var model = new List <StatusEntity>();
foreach (var item in Enum.GetValues(typeof(UserStatus)))
{
var status = new StatusEntity();
status.Id = (int)item;
status.Name = item.ToString();
model.Add(status);
}
return(Ok(model));
}
public ActionResult <StatusEntity> Put([FromBody] StatusEntity status)
{
var nome = Validacoes.StringValidation(status.NOME);
if (nome == true)
{
return(_statusRepository.Update(status));
}
else
{
return(BadRequest("Não foi possível atualizar este status. Por favor, digite um nome válido."));
}
}
public void UpdateStatus_NewClaimIdAndStatusId_UpdatedClaimHasNewStatusId()
{
// Arrange
var interactor = UpdateClaimInteractorFactory.Create();
ClaimEntity claimToUpdate = ClaimFactory.Create();
StatusEntity newStatus = StatusFactory.Create("Closed");
// Run
var result = interactor.UpdateStatus(claimToUpdate, newStatus);
// Assert
result.StatusId.ShouldBe(newStatus.Id);
}
/// <summary>
/// 获取实体
/// </summary>
/// <param name="strWhere">参数化查询条件(例如: and Name = @Name )</param>
/// <param name="dict">参数的名/值集合</param>
/// <returns></returns>
public virtual StatusEntity GetEntity(string strWhere, Dictionary <string, object> dict = null)
{
StatusEntity obj = null;
string strSQL = "select top 1 * from Status where 1=1 " + strWhere;
using (NullableDataReader reader = _DB.GetDataReader(strSQL, dict))
{
if (reader.Read())
{
obj = GetEntityFromrdr(reader);
}
}
return(obj);
}
/// <summary>
/// 获取实体（异步方式）
/// </summary>
/// <param name="strWhere">参数化查询条件(例如: and Name = @Name )</param>
/// <param name="dict">参数的名/值集合</param>
/// <returns></returns>
public virtual async Task <StatusEntity> GetEntityAsync(string strWhere, Dictionary <string, object> dict = null)
{
StatusEntity obj = null;
string strSQL = "select top 1 * from Status where 1=1 " + strWhere;
using (NullableDataReader reader = await Task.Run(() => _DB.GetDataReader(strSQL, dict)))
{
if (reader.Read())
{
obj = GetEntityFromrdr(reader);
}
}
return(obj);
}
private async void InsertRowToTableStorage(string body)
{
var table = tableClient.GetTableReference("status");
await table.CreateIfNotExistsAsync();
StatusEntity status = new StatusEntity();
status.Message = body;
// Create the TableOperation object that inserts the customer entity.
TableOperation insertOperation = TableOperation.InsertOrReplace(status);
// Execute the insert operation.
await table.ExecuteAsync(insertOperation);
}
public List <StatusEntity> GetStatuses()
{
DataTable dt = GetTable();
List <StatusEntity> ls = new List <StatusEntity>();
foreach (DataRow row in dt.Rows)
{
StatusEntity e = new StatusEntity();
e.Id = (int)row["statusid"];
e.Name = row["statusname"].ToString().Trim();
ls.Add(e);
}
return(ls);
}
public static StatusModel MapStatusModel(this StatusEntity statusEntity)
{
if (statusEntity == null)
{
return(null);
}
return(new StatusModel()
{
codigo_status = statusEntity.COD_STATUS,
codigo_perfil = statusEntity.COD_PERFIL,
NomeStatus = statusEntity.NOME,
perfil = statusEntity.PERFIL?.MapPerfilModel()
});
}
private async Task <OneononeComposeEntity> ObtainEmployeeOneononeCompose(OneononeEntity oneonone)
{
var historical = await ObtainHistoricalByPair(oneonone.Leader.Id, oneonone.Led.Id);
StatusEntity status = ObtainStatusByHistorical(historical, oneonone.Frequency);
var oneononeComposeEntity = new OneononeComposeEntity
{
Oneonone = oneonone,
Historical = historical,
Status = status,
};
return(oneononeComposeEntity);
}
/// <summary>
/// 更新一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Update(StatusEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "Update Status SET " +
"StatusCode = @StatusCode," +
"StatusName = @StatusName," +
"StatusType = @StatusType" +
" WHERE " +
"StatusID = @StatusID";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 更新一条记录（异步方式）
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual async Task <bool> UpdateAsync(StatusEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "Update Status SET " +
"StatusCode = @StatusCode," +
"StatusName = @StatusName," +
"StatusType = @StatusType" +
" WHERE " +
"StatusID = @StatusID";
return(await Task.Run(() => _DB.ExeSQLResult(strSQL, dict)));
}
public int AddStatus(StatusEntity status)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbstatus (status_name,status_type)");
strSql.Append("values");
strSql.Append("(@StatusName,@StatusType)");
strSql.Append(";SELECT @@IDENTITY");
SqlParameter[] paras =
{
new SqlParameter("@StatusName", status.StatusName),
new SqlParameter("@StatusType", status.StatusType)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.connStr, CommandType.Text, strSql.ToString(), paras)));
}
public void ApplyAssignEffect()
{
BeforeAssign();
if (Effect is DamageEffect damageEffect)
{
}
if (Effect is AddStatusEffect addStatusEffect)
{
StatusEntity status = EntityFactory.CreateWithParent <StatusEntity>(Target, addStatusEffect.AddStatus);
status.Caster = Creator;
status.Enable();
status.AddComponent <StatusLifeTimeComponent>();
}
AfterAssign();
}
