public HttpResponseMessage Post([FromBody] WaterConsumptionViewModel item)
{
try
{
var identity = (ClaimsIdentity)User.Identity;
//Getting the ID value
var ID = Convert.ToInt64(identity.Claims.FirstOrDefault(c => c.Type == "loggedUserId").Value);
var isAdmin = Convert.ToBoolean(identity.Claims.FirstOrDefault(c => c.Type == "isAdmin").Value);
var entity = item.FromViewModel();
if (!isAdmin)
{
entity.UserId = ID;
}
if (entity.UniqueId.HasValue)
{
_waterConsumptionService.Update(entity);
}
else
{
_waterConsumptionService.Insert(entity);
}
return(Request.CreateResponse(System.Net.HttpStatusCode.Accepted));
}
catch (Exception)
{
return(Request.CreateResponse(System.Net.HttpStatusCode.InternalServerError));
}
}
public static WaterConsumption FromViewModel(this WaterConsumptionViewModel viewModel)
{
return(new WaterConsumption
{
BathroomUnits = viewModel.BathroomUnits,
KitchenUnits = viewModel.KitchenUnits,
UniqueId = viewModel.Id,
CreationDate = Convert.ToDateTime(viewModel.CreationDate),
UserId = viewModel.UserId
});
}
public async Task <WaterConsumptionModel> GetSingleWaterConsumption(int patientId, int waterId)
{
WaterConsumptionViewModel waterConsumption = null;
using (SqlConnection sqlCOnnection = new SqlConnection(Environment.GetEnvironmentVariable("sqldb_connection")))
{
await sqlCOnnection.OpenAsync();
var sqlStringCommand = $"SELECT w.*, u.short, u.unit " +
$"FROM WaterConsumption AS w " +
$"INNER JOIN WeightUnit AS u ON u.id = w.weight_unit_id " +
$"WHERE w.id = @ID AND w.patient_id = @PATIENTID";
using (SqlCommand sqlCommand = new SqlCommand(sqlStringCommand, sqlCOnnection))
{
sqlCommand.Parameters.Add("@PATIENTID", SqlDbType.Int).Value = patientId;
sqlCommand.Parameters.Add("@ID", SqlDbType.Int).Value = waterId;
using (SqlDataReader sqlDataReader = await sqlCommand.ExecuteReaderAsync())
{
try
{
while (await sqlDataReader.ReadAsync())
{
waterConsumption = new WaterConsumptionViewModel
{
Id = (int)sqlDataReader["id"],
Amount = (double)sqlDataReader["amount"],
Date = (DateTime)sqlDataReader["date"],
PatientId = (int)sqlDataReader["patient_id"],
WeightUnit = new WeightUnitModel
{
Id = (int)sqlDataReader["weight_unit_id"],
Short = (string)sqlDataReader["short"],
Unit = (string)sqlDataReader["unit"]
}
};
}
}
catch
{
waterConsumption = new WaterConsumptionViewModel
{
Error = true
};
}
}
}
sqlCOnnection.Close();
}
return(waterConsumption);
}
private async Task <List <WaterConsumptionViewModel> > ReadFromDataReaderAsync(SqlDataReader reader)
{
List <WaterConsumptionViewModel> waterConsumptionViews = new List <WaterConsumptionViewModel>();
try
{
while (await reader.ReadAsync())
{
WaterConsumptionViewModel waterConsumption = new WaterConsumptionViewModel
{
Id = (int)reader["id"],
Amount = (double)reader["amount"],
Date = (DateTime)reader["date"],
PatientId = (int)reader["patient_id"],
WeightUnit = new WeightUnitModel
{
Id = (int)reader["weight_unit_id"],
Short = (string)reader["short"],
Unit = (string)reader["unit"]
}
};
waterConsumptionViews.Add(waterConsumption);
try
{
MinumumRestriction = (int)reader["maxAmount"];
}
catch { }
}
}
catch
{
WaterConsumptionViewModel waterConsumption = new WaterConsumptionViewModel
{
Error = true
};
waterConsumptionViews.Add(waterConsumption);
}
return(waterConsumptionViews);
}
private void ReadFromDataReader(SqlDataReader reader)
{
waterConsumptions = new List <WaterConsumptionViewModel>();
try
{
while (reader.Read())
{
WaterConsumptionViewModel waterConsumption = new WaterConsumptionViewModel
{
Id = (int)reader["id"],
Amount = (double)reader["amount"],
Date = (DateTime)reader["date"],
PatientId = (int)reader["patient_id"],
WeightUnit = new WeightUnitModel
{
Id = (int)reader["weight_unit_id"],
Short = (string)reader["short"],
Unit = (string)reader["unit"]
}
};
waterConsumptions.Add(waterConsumption);
try
{
MinumumRestriction = (int)reader["maxAmount"];
}
catch { }
}
}
catch (Exception e)
{
WaterConsumptionViewModel waterConsumption = new WaterConsumptionViewModel
{
Error = true
};
waterConsumptions.Add(waterConsumption);
}
}
