Пример #1
0
        // GET: api/Sales
        public IEnumerable <Sales> Get()
        {
            DatabaseTaskEntities context = new DatabaseTaskEntities();
            var result = context.Sales.OrderBy(i => i.Date);

            return(result);
        }
Пример #2
0
        // DELETE: api/Sales/5
        public void Delete(Guid?id)
        {
            DatabaseTaskEntities context = new DatabaseTaskEntities();
            var result = context.Sales.Where(i => i.Id == id).FirstOrDefault();

            context.Sales.Remove(result);
            context.SaveChanges();
        }
Пример #3
0
        // POST: api/Sales
        public Sales Post([FromBody] Sales obj)
        {
            DatabaseTaskEntities context = new DatabaseTaskEntities();

            context.Sales.Add(new Sales {
                Id = Guid.NewGuid(), Date = obj.Date, Price = obj.Price
            });
            context.SaveChanges();
            return(obj);
        }
Пример #4
0
        // GET: api/SalesPerDays
        public IQueryable <StructDays> Get(DateTime StartDate, DateTime EndDate)
        {
            DatabaseTaskEntities context = new DatabaseTaskEntities();
            var result = context.Sales.GroupBy(i => i.Date)
                         .Select(grp => new StructDays()
            {
                Date = grp.Key, Price = grp.Sum(p => p.Price), CountPrice = grp.Count()
            })
                         .Where(p => p.Date >= StartDate && p.Date <= EndDate);

            return(result);
        }
Пример #5
0
        // GET: api/SalesPerYears
        public IQueryable <StructYears> Get(DateTime StartDate, DateTime EndDate)
        {
            int StartYear = StartDate.Year;
            int EndYear   = EndDate.Year;
            DatabaseTaskEntities context = new DatabaseTaskEntities();
            var result = context.Sales.GroupBy(i => SqlFunctions.DatePart("year", i.Date))
                         .Select(grp => new StructYears()
            {
                NumberYear = grp.Key.Value, CountPrice = grp.Count(), Price = grp.Sum(q => q.Price)
            })
                         .Where(q => q.NumberYear >= StartYear && q.NumberYear <= EndYear);

            return(result);
        }
Пример #6
0
        // PUT: api/Sales/5
        public void Put(Guid?id, [FromBody] Sales obj)
        {
            DatabaseTaskEntities context = new DatabaseTaskEntities();
            var result = context.Sales.Where(i => i.Id == id).FirstOrDefault();

            if (obj.Price != null)
            {
                result.Price = obj.Price;
            }
            if (obj.Date != null)
            {
                result.Date = obj.Date;
            }
            context.SaveChanges();
        }
Пример #7
0
        // GET: api/SalesPerQuarters
        public IQueryable <StructQuarters> Get(DateTime StartDate, DateTime EndDate)
        {
            int startYear = StartDate.Year;
            int endYear   = EndDate.Year;
            DatabaseTaskEntities context = new DatabaseTaskEntities();
            var result = context.Sales.Select(i => new Sale()
            {
                Id = i.Id, Price = i.Price, Date = i.Date
            })
                         .Where(i => i.Date >= StartDate && i.Date <= EndDate);
            var fimleResult = result.GroupBy(i => new { QuarterNumber = SqlFunctions.DatePart("quarter", i.Date), YearNumber = SqlFunctions.DatePart("year", i.Date) })
                              .Select(grp => new StructQuarters()
            {
                NumberQuarter = grp.Key.QuarterNumber, NumberYear = grp.Key.YearNumber, Price = grp.Sum(i => i.Price), CountPrice = grp.Count()
            });

            return(fimleResult);
        }
Пример #8
0
        // GET: api/SalesPerWeeks
        public IQueryable <StructWeeks> Get(DateTime StartDate, DateTime EndDate)
        {
            int startMonth = StartDate.Month;
            int endMonth   = EndDate.Month;
            int startYear  = StartDate.Year;
            int endYear    = EndDate.Year;
            DatabaseTaskEntities context = new DatabaseTaskEntities();
            var result = context.Sales.Select(i => new Sale()
            {
                Id = i.Id, Date = i.Date, Price = i.Price
            })
                         .Where(q => q.Date >= StartDate && q.Date <= EndDate).OrderBy(i => i.Date);
            var finleResult = result.GroupBy(i => new { WeekNumber = SqlFunctions.DatePart("week", i.Date), MonthNumber = SqlFunctions.DatePart("month", i.Date), YearNumber = SqlFunctions.DatePart("year", i.Date) })
                              .Select(grp => new StructWeeks()
            {
                NumberWeek = grp.Key.WeekNumber, NumberYear = grp.Key.YearNumber, NumberMonth = grp.Key.MonthNumber, CountPrice = grp.Count(), Price = grp.Sum(i => i.Price)
            });

            return(finleResult);
        }