private List <SellDto> DoGetDrinkSells(BeerControlEntities context, int idMarket, int idDrink, DateTimeOffset startTs, DateTimeOffset endTs)
{
var list = new List <SellDto>();
var dbSells = context.Sell.Where(s => s.idMarket == idMarket && s.idDrink == idDrink && s.Ts >= startTs && s.Ts <= endTs).OrderBy(s => s.Ts).ToArray();
var priceIds = dbSells.Select(s => s.idPrice).Distinct();
var dbPrices = context.Price.Where(p => priceIds.Contains(p.id)).Select(p => new { p.id, p.Val });
var priceDic = new Dictionary <int, int>();
foreach (var dbPrice in dbPrices)
{
priceDic.Add(dbPrice.id, dbPrice.Val);
}
foreach (var dbSell in dbSells)
{
int price;
if (dbSell.idPrice == 0 || !priceDic.ContainsKey(dbSell.idPrice))
{
price = 0;
}
else
{
price = priceDic[dbSell.idPrice];
}
list.Add(DtoFactory.Create(dbSell, price));
}
return(list);
}
[ProducesResponseType(typeof(DtoError), 500)] //Define the extra HttpStatusCode for Swagger
public IQueryable <DtoCustomer> GetAll()
{
var rtn = new List <DtoCustomer>();
try
{
//throw new Exception("Test");
using (var custService = new CustomerService(DbContextFactory.Create()))
{
var custDaos = custService.GetAll().ToList();
foreach (var custDao in custDaos)
{
rtn.Add(DtoFactory.Create <Angular2.Mvc.DAL.Models.DAO.Customer, Angular2.Mvc.Core.Models.DTO.DtoCustomer>(custDao));
}
}
return(rtn.AsQueryable());
}
catch (Exception ex)
{
var err = new DtoError
{
StatusCode = 500,
ServerError = ex.Message,
ClientMsg = "Please try again..."
};
var errJson = JsonConvert.SerializeObject(err);
byte[] data = System.Text.Encoding.UTF8.GetBytes(errJson);
Response.ContentType = "application/json";
Response.StatusCode = (int)HttpStatusCode.InternalServerError;
Response.Body.WriteAsync(data, 0, data.Length);
throw;
}
}
private DrinkDto LoadDrink(BeerControlEntities context, int?idDrink)
{
if (!idDrink.HasValue)
{
return(null);
}
var dbDrink = context.Drink.Find(idDrink);
return(DtoFactory.Create(dbDrink));
}
public DtoCustomer Get(int id)
{
Angular2.Mvc.Core.Models.DTO.DtoCustomer rtn = null;
using (var custService = new CustomerService(DbContextFactory.Create()))
{
var cust = custService.Get(x => x.Id.Equals(id)).FirstOrDefault();
if (cust != null)
{
return(DtoFactory.Create <Angular2.Mvc.DAL.Models.DAO.Customer, Angular2.Mvc.Core.Models.DTO.DtoCustomer>(cust));
}
else
{
throw new Exception($"The customers with Id:{id.ToString()} is not exist!");
}
}
}
public void TestCustomerMapping()
{
var cust = new Angular2.Mvc.DAL.Models.DAO.Customer()
{
Id = 10,
Age = 35,
Description = "Hello!!",
Name = "JB",
Phone = "0933XXXXXXX"
};
var actual = DtoFactory.Create <Angular2.Mvc.DAL.Models.DAO.Customer, Angular2.Mvc.Core.Models.DTO.DtoCustomer>(cust);
Assert.True(cust.Id.Equals(actual.Id), $"Expected:{cust.Id}, Actual:{actual.Id}");
Assert.True(cust.Name.Equals(actual.Name), $"Expected:{cust.Name}, Actual:{actual.Name}");
Assert.True(cust.Phone.Equals(actual.Phone), $"Expected:{cust.Phone}, Actual:{actual.Phone}");
Assert.True(cust.Age.Equals(actual.Age), $"Expected:{cust.Age}, Actual:{actual.Age}");
Assert.True(cust.Description.Equals(actual.Description), $"Expected:{cust.Description}, Actual:{actual.Description}");
}
public void SampleDtoFromDataRow()
{
var gameId = Guid.NewGuid();
var gameYear = 2010;
var gameMonth = 7;
var gameDay = 3;
var sampleTable = GenerateSampleDataTable();
sampleTable.Rows.Add(gameId, gameYear, gameMonth, gameDay);
var sut = new DtoFactory();
var result = sut.Create<GetGameCountByDateDto>(sampleTable.Rows[0]);
Assert.IsNotNull(result);
Assert.AreEqual(gameId, result.GameId);
Assert.AreEqual(gameYear, result.GameYear);
Assert.AreEqual(gameMonth, result.GameMonth);
Assert.AreEqual(gameDay, result.GameDay);
}
public void SampleDtoFromDataRow()
{
var gameId = Guid.NewGuid();
var gameYear = 2010;
var gameMonth = 7;
var gameDay = 3;
var sampleTable = GenerateSampleDataTable();
sampleTable.Rows.Add(gameId, gameYear, gameMonth, gameDay);
var sut = new DtoFactory();
var result = sut.Create <GetGameCountByDateDto>(sampleTable.Rows[0]);
Assert.IsNotNull(result);
Assert.AreEqual(gameId, result.GameId);
Assert.AreEqual(gameYear, result.GameYear);
Assert.AreEqual(gameMonth, result.GameMonth);
Assert.AreEqual(gameDay, result.GameDay);
}
public HttpResponseMessage Get()
{
try
{
var clusters = DataService.Clusters.ToList();
return(Request.CreateResponse(HttpStatusCode.OK, new
{
Result = clusters.Select(c => DtoFactory.Create(c)),
Succeeded = true
}));
}
catch (Exception)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, new
{
Succeeded = true,
Error = "There was an error when retrieving clusters."
}));
}
}
public List <ProducerDto> GetProducers(UserPass user)
{
if (!_security.Check(user))
{
throw new AuthenticationException();
}
var idUser = _security.GetUserId(user);
var list = new List <ProducerDto>();
using (var context = new BeerControlEntities())
{
var dbProducers = context.Producer.Where(p => p.idUser == idUser);
foreach (var pr in dbProducers)
{
list.Add(DtoFactory.Create(pr));
}
}
return(list);
}
public Dictionary <DrinkDto, List <SellDto> > GetMarketSells(UserPass user, int idMarket, DateTimeOffset startTs, DateTimeOffset endTs)
{
if (!_security.Check(user))
{
throw new AuthenticationException();
}
var items = new Dictionary <DrinkDto, List <SellDto> >();
using (var context = new BeerControlEntities())
{
var drinkIds = context.MarketDrink.Where(m => m.idMarket == idMarket).Select(d => d.idDrink).ToArray();
var dbDrinks = context.Drink.Where(d => drinkIds.Contains(d.id));
foreach (var dbDrink in dbDrinks)
{
items.Add(DtoFactory.Create(dbDrink), DoGetDrinkSells(context, idMarket, dbDrink.id, startTs, endTs));
}
}
return(items);
}
public Dictionary <MarketDto, SellSummaryDto> GetSellSummary(UserPass user, DateTimeOffset startTs, DateTimeOffset endTs)
{
if (!_security.Check(user))
{
throw new AuthenticationException();
}
var idUser = _security.GetUserId(user);
var items = new Dictionary <MarketDto, SellSummaryDto>();
using (var context = new BeerControlEntities())
{
var dbMarkets = context.Market.Where(m => m.idUser == idUser).ToArray();
foreach (var dbMarket in dbMarkets)
{
items.Add(DtoFactory.Create(dbMarket), DoGetMarketSellSummary(context, dbMarket.id, startTs, endTs));
}
}
return(items);
}
public List <DrinkDto> GetDrinks(UserPass user)
{
if (!_security.Check(user))
{
throw new AuthenticationException();
}
var idUser = _security.GetUserId(user);
var list = new List <DrinkDto>();
using (var context = new BeerControlEntities())
{
var dbDrinks = context.Drink.Where(d => d.idUser == idUser);
foreach (var dbDrink in dbDrinks)
{
list.Add(DtoFactory.Create(dbDrink));
}
}
return(list);
}
public List <MarketDto> GetMarkets(UserPass user)
{
if (!_security.Check(user))
{
throw new AuthenticationException();
}
var idUser = _security.GetUserId(user);
var list = new List <MarketDto>();
using (var context = new BeerControlEntities())
{
var dbMarkets = context.Market.Where(m => m.idUser == idUser);
foreach (var dbMarket in dbMarkets)
{
list.Add(DtoFactory.Create(dbMarket));
}
}
return(list);
}
public List <DrinkConfigDto> GetDrinksConfig(UserPass user)
{
if (!_security.Check(user))
{
throw new AuthenticationException();
}
var idUser = _security.GetUserId(user);
var drinks = new List <DrinkConfigDto>();
using (var context = new BeerControlEntities())
{
var producerNames = GetProducerNames(idUser, context);
var dbDrinks = context.Drink.Where(d => d.idUser == idUser);
foreach (var drink in dbDrinks)
{
drinks.Add(DtoFactory.Create(drink, producerNames));
}
}
return(drinks);
}
public void NullDataRow()
{
var sut = new DtoFactory();
sut.Create <GetGameCountByDateDto>(null);
}
public void NullDataRow()
{
var sut = new DtoFactory();
sut.Create<GetGameCountByDateDto>(null);
}
