/// <summary>
/// Get Affiliate report sell after successfully authenticated
/// </summary>
/// <param name="userAuth"></param>
/// <param name="user"></param>
/// <returns></returns>
private async Task GetData(Update up, FilterDate filterDate)
{
List <AffiliateReportDto> list = new List <AffiliateReportDto>();
//if sender pm is admin? can get all affiliate sell report else affiliate only get their report
var userAuth = GetUserByChatId(up.Message.Chat.Id);
if (userAuth == null)
{
await LogOutUser(up);
return;
}
try
{
var affiliateReportFile = await GetAffiliateReportApi(filterDate.ToString(), userAuth.UserType, userAuth.UserName);
var inputOnlineFile = new InputOnlineFile(affiliateReportFile, "AffiliateSellReport.pdf");
var message = await _botService.Client.SendTextMessageAsync(up.Message.Chat.Id, "Sending file...");
await _botService.Client.SendDocumentAsync(up.Message.Chat.Id, inputOnlineFile);
await _botService.Client.DeleteMessageAsync(up.Message.Chat.Id, message.MessageId);
}
catch (Exception ex)
{
await InvalidLogin(up, "❌ Invalid Login. " + ex.Message);
await LogOutUser(up);
}
}
private void InitializeFilters()
{
_parameter = System.Linq.Expressions.Expression.Parameter(typeof(ServiceLog), "s");
_parameterSD = System.Linq.Expressions.Expression.Parameter(typeof(ServiceDone), "sd");
_parameterSU = System.Linq.Expressions.Expression.Parameter(typeof(SpareUsed), "su");
_filterDate = new FilterDate(_parameter);
_filterSearch = new FilterSearch(_parameter);
_filterStatus = new FilterId(_parameter);
_filterDept = new FilterId(_parameter);
_filterRepairer = new FilterId(_parameter);
_filterTypeModel = new FilterId(_parameter);
_filterModel = new FilterId(_parameter);
_filterSparesUsed = new FilterIdAnd(_parameterSU);
_filterServicesDone = new FilterIdAnd(_parameterSD);
_filters = new List <BL.IFilter>();
_filters.Add(_filterDate);
_filters.Add(_filterSearch);
_filters.Add(_filterStatus);
_filters.Add(_filterRepairer);
_filters.Add(_filterDept);
_filters.Add(_filterTypeModel);
_filters.Add(_filterModel);
_filterDate.FilterCreated += OnFilterChanged;
_filterSearch.FilterCreated += OnFilterChanged;
}
public FilterSetting()
{
Id = Guid.NewGuid().ToString();
Name = string.Empty;
IsDefault = false;
FilterNamesInclude = new List <string>();
FilterNamesExclude = new List <string>();
UseRegularExpressionMatching = false;
FilterDateUsed = false;
FilterDate = new FilterDate();
FilterAttributeArchiveUsed = false;
FilterAttributeAchiveType = "Included";
FilterAttributeSystemUsed = false;
FilterAttributeSystemType = "Included";
FilterAttributeHiddenUsed = false;
FilterAttributeHiddenType = "Included";
FilterAttributeReadOnlyUsed = false;
FilterAttributeReadOnlyType = "Included";
}
private ConditionState CheckCondition(object field, IFilterEntity entity)
{
if (entity == null)
{
return(ConditionState.NOT_USED);
}
if (entity is FilterText)
{
FilterText innerEntity = (FilterText)entity;
if (string.IsNullOrEmpty(innerEntity.Condition) || string.IsNullOrEmpty(innerEntity.Value))
{
return(ConditionState.NOT_USED);
}
string innerField = Convert.ToString(field);
if (innerEntity.Condition.Equals("contains"))
{
return(innerField.Contains(innerEntity.Value) ? ConditionState.PASSED : ConditionState.NOT_PASSED);
}
else if (innerEntity.Condition.Equals("equals"))
{
return(innerField.Equals(innerEntity.Value) ? ConditionState.PASSED : ConditionState.NOT_PASSED);
}
else
{
return(ConditionState.NOT_USED);
}
}
else if (entity is FilterDate)
{
FilterDate innerEntity = (FilterDate)entity;
if (innerEntity.From == null || innerEntity.To == null)
{
return(ConditionState.NOT_USED);
}
DateTime innerField = Convert.ToDateTime(field);
DateTime from = DateTime.Parse(innerEntity.From);
DateTime to = DateTime.Parse(innerEntity.To);
int fromResult = DateTime.Compare(from, innerField);
if (fromResult <= 0)
{
int toResult = DateTime.Compare(innerField, to);
if (toResult <= 0)
{
return(ConditionState.PASSED);
}
}
return(ConditionState.NOT_PASSED);
}
else
{
return(ConditionState.NOT_PASSED);
}
}
public object Clone()
{
var filterDate = new FilterDate
{
Date = Date,
Type = Type
};
return(filterDate);
}
public IHttpActionResult GetMealAndFoodsPerDay(FilterDate date)
{
IEnumerable <MealViewModel> mealVm;
CultureInfo provider = CultureInfo.CurrentCulture;
var dateFormat = DateTime.ParseExact(date.filterDate, "MM/dd/yyyy", provider);
var totalCalories = mealService.SumOfNutrientsPerDay(dateFormat);
var mealAndFoods = mealService.GetMealAndFoodsPerDay(dateFormat);
if (totalCalories == null || mealAndFoods == null)
{
return(Content(HttpStatusCode.NotFound, "Meals not found."));
}
mealVm = mapper.Map <IEnumerable <Meal>, IEnumerable <MealViewModel> >(mealAndFoods);
return(Content(HttpStatusCode.OK, new { totalCalories, mealVm }));
}
public object Clone()
{
var filterSetting = new FilterSetting
{
Id = Id,
Name = Name,
IsDefault = IsDefault,
FilterDateUsed = FilterDateUsed,
FilterDate = (FilterDate)FilterDate.Clone(),
FilterNamesInclude = FilterNamesInclude,
FilterNamesExclude = FilterNamesExclude,
UseRegularExpressionMatching = UseRegularExpressionMatching,
FilterAttributeArchiveUsed = FilterAttributeArchiveUsed,
FilterAttributeAchiveType = FilterAttributeAchiveType,
FilterAttributeSystemUsed = FilterAttributeSystemUsed,
FilterAttributeSystemType = FilterAttributeSystemType,
FilterAttributeHiddenUsed = FilterAttributeHiddenUsed,
FilterAttributeHiddenType = FilterAttributeHiddenType,
FilterAttributeReadOnlyUsed = FilterAttributeReadOnlyUsed,
FilterAttributeReadOnlyType = FilterAttributeReadOnlyType
};
return(filterSetting);
}
/// <summary>
/// Заполняет фильтры уникальными значениями свойств.
/// </summary>
public static void GetFilters()
{
// Очистить все фильтры.
FilterOtv.Clear();
FilterNewOtv.Clear();
FilterUser.Clear();
FilterLocation.Clear();
FilterPodrazdelenie.Clear();
FilterTypeOs.Clear();
FilterSostoyanie.Clear();
FilterDate.Clear();
FilterOtdel.Clear();
FilterTypeInvNumn.Clear();
FilterStatusRec.Clear();
// Добавить во все фильтры пункты Все и Пустые значения.
FilterOtv.Add("Все");
FilterOtv.Add("Пустые значения");
FilterNewOtv.Add("Все");
FilterNewOtv.Add("Пустые значения");
FilterUser.Add("Все");
FilterUser.Add("Пустые значения");
FilterLocation.Add("Все");
FilterLocation.Add("Пустые значения");
FilterPodrazdelenie.Add("Все");
FilterPodrazdelenie.Add("Пустые значения");
FilterTypeOs.Add("Все");
FilterTypeOs.Add("Пустые значения");
FilterSostoyanie.Add("Все");
FilterSostoyanie.Add("Пустые значения");
FilterDate.Add("Все");
FilterDate.Add("Пустые значения");
FilterOtdel.Add("Все");
FilterOtdel.Add("Пустые значения");
FilterStatusRec.Add("Все");
FilterStatusRec.Add("Пустые значения");
FilterTypeInvNumn.Add("Все");
foreach (object o in ForWorks.viewSource.View)
{
if (o is OS obj)
{
if (!FilterOtv.Contains(obj.Otvetstvenniy) && !string.IsNullOrWhiteSpace(obj.Otvetstvenniy))
{
FilterOtv.Add(obj.Otvetstvenniy);
}
if (!FilterNewOtv.Contains(obj.NewOtv) && !string.IsNullOrWhiteSpace(obj.NewOtv))
{
FilterNewOtv.Add(obj.NewOtv);
}
if (!FilterUser.Contains(obj.User) && !string.IsNullOrWhiteSpace(obj.User))
{
FilterUser.Add(obj.User);
}
if (!FilterLocation.Contains(obj.Location) && !string.IsNullOrWhiteSpace(obj.Location))
{
FilterLocation.Add(obj.Location);
}
if (!FilterPodrazdelenie.Contains(obj.Podrazdelenie) && !string.IsNullOrWhiteSpace(obj.Podrazdelenie))
{
FilterPodrazdelenie.Add(obj.Podrazdelenie);
}
if (!FilterTypeOs.Contains(obj.TypeOs) && !string.IsNullOrWhiteSpace(obj.TypeOs))
{
FilterTypeOs.Add(obj.TypeOs);
}
if (!FilterSostoyanie.Contains(obj.Sostoyanie) && !string.IsNullOrWhiteSpace(obj.Sostoyanie))
{
FilterSostoyanie.Add(obj.Sostoyanie);
}
if (!FilterDate.Contains(obj.DatePostanovki) && !string.IsNullOrWhiteSpace(obj.DatePostanovki))
{
FilterDate.Add(obj.DatePostanovki);
}
if (!FilterOtdel.Contains(obj.Otdel) && !string.IsNullOrWhiteSpace(obj.Otdel))
{
FilterOtdel.Add(obj.Otdel);
}
if (!FilterStatusRec.Contains(obj.StatusRec) && !string.IsNullOrWhiteSpace(obj.StatusRec))
{
FilterStatusRec.Add(obj.StatusRec);
}
if (obj.InvNum.StartsWith("29600") && !FilterTypeInvNumn.Contains("Деловые линии"))
{
FilterTypeInvNumn.Add("Деловые линии");
}
if (obj.InvNum.StartsWith("296CC") && !FilterTypeInvNumn.Contains("КЦ"))
{
FilterTypeInvNumn.Add("КЦ");
}
if (obj.InvNum.StartsWith("6000") && !FilterTypeInvNumn.Contains("ДЛ Транс"))
{
FilterTypeInvNumn.Add("ДЛ Транс");
}
if (obj.InvNum.StartsWith("11100") && !FilterTypeInvNumn.Contains("Гет Карго"))
{
FilterTypeInvNumn.Add("Гет Карго");
}
}
}
}
//Конструктор модели представления
public MainViewModel()
{
string executable = System.Reflection.Assembly.GetExecutingAssembly().Location;
string path = (System.IO.Path.GetDirectoryName(executable));
AppDomain.CurrentDomain.SetData("DataDirectory", path);
this.AddServiceLogCommand = new DelegateCommand(ExecuteAddServiceLog);
parameter = Expression.Parameter(typeof(ServiceLog), "s");
parameterSD = Expression.Parameter(typeof(ServiceDone), "sd");
parameterSU = Expression.Parameter(typeof(SpareUsed), "su");
filterDate = new FilterDate(parameter);
filterSearch = new FilterSearch(parameter);
filterStatus = new FilterId(parameter);
filterDept = new FilterId(parameter);
filterRepairer = new FilterId(parameter);
filterTypeModel = new FilterId(parameter);
filterModel = new FilterId(parameter);
filterSparesUsed = new FilterIdAnd(parameterSU);
filterServicesDone = new FilterIdAnd(parameterSD);
filters = new List <IFilter>();
filters.Add(filterDate);
filters.Add(filterSearch);
filters.Add(filterStatus);
filters.Add(filterRepairer);
filters.Add(filterDept);
filters.Add(filterTypeModel);
filters.Add(filterModel);
filterDate.FilterCreated += OnFilterChanged;
filterSearch.FilterCreated += OnFilterChanged;
FirstDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
SecondDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
Spares = new ObservableCollection <Spare>();
Services = new ObservableCollection <Service>();
Models = new ObservableCollection <Model>();
TypesModel = new ObservableCollection <TypeModel>();
Depts = new ObservableCollection <Dept>();
Repairers = new ObservableCollection <Repairer>();
Statuses = new ObservableCollection <Status>();
ServiceLogs = new ObservableCollection <ServiceLog>();
ParametersValues = new ObservableCollection <ParameterValue>();
ServicesDone = new ObservableCollection <ServiceDone>();
SparesUsed = new ObservableCollection <SpareUsed>();
SelectedStatuses = new ObservableCollection <Status>();
SelectedRepairers = new ObservableCollection <Repairer>();
SelectedDepts = new ObservableCollection <Dept>();
SelectedTypesModel = new ObservableCollection <TypeModel>();
SelectedModels = new ObservableCollection <Model>();
SelectedSpares = new ObservableCollection <Spare>();
SelectedServices = new ObservableCollection <Service>();
DbContext dbContext = new SQLiteContext();
if (dbContext is SQLiteContext)
{
SQLiteContext context = dbContext as SQLiteContext;
context.Status.Load();
Statuses = context.Status.Local.ToBindingList();
context.Repairer.Load();
Repairers = context.Repairer.Local.ToBindingList();
context.Dept.Load();
Depts = context.Dept.Local.ToBindingList();
context.TypeModel.Load();
TypesModel = context.TypeModel.Local.ToBindingList();
context.Model.Load();
Models = context.Model.Local.ToBindingList();
context.Service.Load();
Services = context.Service.Local.ToBindingList();
context.Spare.Load();
Spares = context.Spare.Local.ToBindingList();
}
}
public GameFilterByDate(FilterDate selectedDate)
{
_selectedDate = selectedDate;
}
public FakeFilter(FilterDate date)
{
this.date = date;
}
