public string GetUsersParam(UsersParam param)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("where 1=1 and IsDelete=0");
if (!string.IsNullOrEmpty(param.UserName))
{
sb.AppendFormat(" and UserName like '%{0}%' ", Utils.SqlSafe(param.UserName));
}
if (!string.IsNullOrEmpty(param.UserAcount))
{
sb.AppendFormat(" and UserAcount like '%{0}%' ", Utils.SqlSafe(param.UserAcount));
}
if (!string.IsNullOrEmpty(param.IdCard))
{
sb.AppendFormat(" and IdCard like '%{0}%' ", Utils.SqlSafe(param.IdCard));
}
if (param.UserGroupId > 0)
{
sb.Append(string.Format(" and UserGroupId ={0}", param.UserGroupId));
}
return(sb.ToString());
}
/// <summary>
/// 获取用户列表
/// </summary>
/// <param name="page">当前页数，默认为 1</param>
/// <param name="limit">每页最大数量，默认为 10</param>
/// <param name="cancellationToken"></param>
/// <returns></returns>
/// TODO: 缺少 customData 配置参数
public async Task <PaginatedUsers> List(
int page = 1,
int limit = 10,
CancellationToken cancellationToken = default)
{
var param = new UsersParam()
{
Page = page,
Limit = limit,
};
var res = await client.Request <UsersResponse>(param.CreateRequest(), cancellationToken);
return(res.Result);
}
private void deleteUserParam()
{
try
{
using (UnitOfWork unit = new UnitOfWork())
{
unit.UserParamRepository.Remove(LastSelectedUserParam);
unit.Save();
}
LastSelectedUserParam = new UsersParam();
}
catch (Exception exception)
{
MessageBox.Show("Сообщение ошибки: " + exception.Message, "Произошла ошибка");
}
refreshTables();
}
private void deleteWeightRow()
{
try
{
if (LastSelected != null)
{
using (UnitOfWork unit = new UnitOfWork())
{
UsersParam toDelete = unit.UserParamRepository.Get(x => x.ParamsDate == lastSelected.ParamsDate && x.IdParams == DeserializedUser.deserializedUser.Id).First();
unit.UserParamRepository.Remove(toDelete);
unit.Save();
StatisticCollection = unit.UserParamRepository.Get(x => x.IdParams == DeserializedUser.deserializedUser.Id);
}
SeriesCollection.Clear();
ChartValues <decimal> weights = new ChartValues <decimal>(StatisticCollection.Select(x => x.UserWeight));
List <string> labels = new List <string>();
foreach (DateTime x in StatisticCollection.Select(x => x.ParamsDate))
{
labels.Add(x.ToString("d"));
}
Labels = labels.ToArray();
SeriesCollection.Add(new LineSeries
{
Title = "Вес",
Values = weights,
LineSmoothness = 0,
PointGeometrySize = 15,
PointForeground = Brushes.Coral,
Stroke = Brushes.Coral,
Fill = Brushes.Transparent
});
}
}
catch (Exception exception)
{
MessageBox.Show("Сообщение ошибки: " + exception.Message, "Произошла ошибка");
}
}
public RegisterPageViewModel()
{
try
{
UpdateViewCommand = new UpdateViewCommand(this);
Message = "Придумайте логин(от 5 до 20 символов) и пароль(от 8 до 20 символов). Логин и пароль могут содержать латинские символы и цифры";
usersDatum = new UsersDatum();
usersParam = new UsersParam();
usersParam.ParamsDate = DateTime.Now;
usersDatum.Birthday = DateTime.Now;
UserLastname = "";
UserSurname = "";
UserName = "";
UserWeight = 10;
UserHeight = 50;
}
catch (Exception exception)
{
MessageBox.Show("Сообщение ошибки: " + exception.Message, "Произошла ошибка");
}
}
public void refreshStatistic()
{
if (DateToChoose.Date.CompareTo(DateTime.Today.Date) != 1)
{
using (UnitOfWork unit = new UnitOfWork())
{
UsersParam userParam = unit.UserParamRepository.Get(x => x.IdParams == DeserializedUser.deserializedUser.Id && x.ParamsDate.Date.Equals(DateToChoose.Date)).LastOrDefault();
UsersDatum usersDatum = unit.UserDatumRepository.Get(x => x.IdData == DeserializedUser.deserializedUser.Id).LastOrDefault();
List <Report> reports = (List <Report>)unit.ReportRepository.Get(x => x.IdReport == DeserializedUser.deserializedUser.Id && DateToChoose.Equals(x.ReportDate.Date));
List <Report> mostReportCategory = (List <Report>)unit.ReportRepository.Get(x => x.IdReport == DeserializedUser.deserializedUser.Id && DateToChoose.Date.Date.Equals(x.ReportDate.Date));
List <Report> lastReports = (List <Report>)unit.ReportRepository.Get(x => x.IdReport == DeserializedUser.deserializedUser.Id);
if (lastReports.Capacity != 0)
{
LastReport = lastReports.Last().ReportDate.ToString();
}
else
{
LastReport = "---";
}
if (mostReportCategory.Capacity != 0)
{
MostCategory = mostReportCategory.GroupBy(i => i.MostCategory).OrderByDescending(grp => grp.Count()).Select(grp => grp.Key).First();
}
else
{
MostCategory = "---";
}
if (userParam != null)
{
CaloriesNeeded = Math.Round((10M * userParam.UserWeight) + (6.25M * userParam.UserHeight) - (5 * (DateTime.Now.Year - usersDatum.Birthday.Year)) + 78);
UserWeight = userParam.UserWeight;
UserHeight = userParam.UserHeight;
}
else
{
UsersParam userParamChanged = unit.UserParamRepository.Get(x => x.IdParams == DeserializedUser.deserializedUser.Id).LastOrDefault();
CaloriesNeeded = Math.Round((10M * userParamChanged.UserWeight) + (6.25M * userParamChanged.UserHeight) - (5 * (DateTime.Now.Year - usersDatum.Birthday.Year)) + 78);
UserWeight = userParamChanged.UserWeight;
UserHeight = userParamChanged.UserHeight;
}
ProteinsNeeded = Math.Round(CaloriesNeeded * 0.3M / 4);
FatsNeeded = Math.Round(CaloriesNeeded * 0.2M / 9);
CarbohydratesNeeded = Math.Round(CaloriesNeeded * 0.5M / 4);
if (ProteinsNeeded <= 1)
{
ProteinsNeeded = 1;
}
if (FatsNeeded <= 1)
{
FatsNeeded = 1;
}
if (CarbohydratesNeeded <= 1)
{
CarbohydratesNeeded = 1;
}
if (CaloriesNeeded <= 1)
{
CaloriesNeeded = 1;
}
CaloriesEaten = Math.Round(reports.Sum(x => x.DayCalories), 2) % 100000;
ProteinsEaten = Math.Round(reports.Sum(x => x.DayProteins), 2) % 100000;
FatsEaten = Math.Round(reports.Sum(x => x.DayFats), 2) % 100000;
CarbohydratesEaten = Math.Round(reports.Sum(x => x.DayCarbohydrates), 2) % 100000;
if ((int)(CaloriesEaten / (CaloriesNeeded / 100)) > 100)
{
CaloriesPercent = 100;
}
else
{
CaloriesPercent = (int)(CaloriesEaten / (CaloriesNeeded / 100));
}
if ((int)(ProteinsEaten / (ProteinsNeeded / 100)) > 100)
{
ProteinsPercent = 100;
}
else
{
ProteinsPercent = (int)(ProteinsEaten / (ProteinsNeeded / 100));
}
if ((int)(FatsEaten / (FatsNeeded / 100)) > 100)
{
FatsPercent = 100;
}
else
{
FatsPercent = (int)(FatsEaten / (FatsNeeded / 100));
}
if ((int)(CarbohydratesEaten / (CarbohydratesNeeded / 100)) > 100)
{
CarbohydratesPercent = 100;
}
else
{
CarbohydratesPercent = (int)(CarbohydratesEaten / (CarbohydratesNeeded / 100));
}
}
}
else
{
using (UnitOfWork unit = new UnitOfWork())
{
UsersParam userParam = unit.UserParamRepository.Get(x => x.IdParams == DeserializedUser.deserializedUser.Id && x.ParamsDate.Date.Equals(DateTime.Today.Date)).LastOrDefault();
UsersDatum usersDatum = unit.UserDatumRepository.Get(x => x.IdData == DeserializedUser.deserializedUser.Id).LastOrDefault();
List <Report> reports = (List <Report>)unit.ReportRepository.Get(x => x.IdReport == DeserializedUser.deserializedUser.Id && DateToChoose.Equals(x.ReportDate.Date));
List <Report> lastReports = (List <Report>)unit.ReportRepository.Get(x => x.IdReport == DeserializedUser.deserializedUser.Id);
if (lastReports.Capacity != 0)
{
LastReport = lastReports.Last().ReportDate.ToString();
}
else
{
LastReport = "---";
}
MostCategory = "---";
if (userParam != null)
{
CaloriesNeeded = Math.Round((10M * userParam.UserWeight) + (6.25M * userParam.UserHeight) - (5 * (DateTime.Now.Year - usersDatum.Birthday.Year)) + 78);
UserWeight = userParam.UserWeight;
UserHeight = userParam.UserHeight;
}
else
{
UsersParam userParamChanged = unit.UserParamRepository.Get(x => x.IdParams == DeserializedUser.deserializedUser.Id).LastOrDefault();
CaloriesNeeded = Math.Round((10M * userParamChanged.UserWeight) + (6.25M * userParamChanged.UserHeight) - (5 * (DateTime.Now.Year - usersDatum.Birthday.Year)) + 78);
UserWeight = userParamChanged.UserWeight;
UserHeight = userParamChanged.UserHeight;
}
ProteinsNeeded = Math.Round(CaloriesNeeded * 0.3M / 4);
FatsNeeded = Math.Round(CaloriesNeeded * 0.2M / 9);
CarbohydratesNeeded = Math.Round(CaloriesNeeded * 0.5M / 4);
if (ProteinsNeeded <= 1)
{
ProteinsNeeded = 1;
}
if (FatsNeeded <= 1)
{
FatsNeeded = 1;
}
if (CarbohydratesNeeded <= 1)
{
CarbohydratesNeeded = 1;
}
if (CaloriesNeeded <= 1)
{
CaloriesNeeded = 1;
}
CaloriesEaten = Math.Round(reports.Sum(x => x.DayCalories), 2) % 100000;
ProteinsEaten = Math.Round(reports.Sum(x => x.DayProteins), 2) % 100000;
FatsEaten = Math.Round(reports.Sum(x => x.DayFats), 2) % 100000;
CarbohydratesEaten = Math.Round(reports.Sum(x => x.DayCarbohydrates), 2) % 100000;
CaloriesPercent = (int)(CaloriesEaten / (CaloriesNeeded / 100));
ProteinsPercent = (int)(ProteinsEaten / (ProteinsNeeded / 100));
FatsPercent = (int)(FatsEaten / (FatsNeeded / 100));
CarbohydratesPercent = (int)(CarbohydratesEaten / (CarbohydratesNeeded / 100));
}
}
}
