// [Authorize(Roles = "QuoteItem:12, QuoteItem:13, QuoteItem:15, QuoteItem:16")]
public IActionResult Create([FromBody] QuoteItems quoteItem)
{
var res = _quoteItem.add(quoteItem);
if (res == true)
{
return(CreatedAtRoute("QuoteItemById", new { Controller = "QuoteItem", id = quoteItem.QuoteItemsId }, quoteItem));
}
return(StatusCode(500));
}
public IActionResult Update(int id, [FromBody] QuoteItems quoteItem)
{
var res = _quoteItem.updateQuoteItem(id, quoteItem);
if (res == true)
{
return(new NoContentResult());
}
return(StatusCode(500));
}
static Dictionary <long, List <DataEntryInfo> > CreateProductOppChartData()
{
return(QuoteItems.GroupBy(q => q.ProductId)
.Select(g => new {
K = g.Key.Value,
V = g.GroupBy(q => q.Quote.Date.Year)
.Select(yg => new { Year = yg.Key, Total = yg.Sum(i => i.Total) }).OrderBy(i => i.Year).ToList()
}).ToDictionary(i => i.K, i => i.V.Select(e => new DataEntryInfo()
{
Name = e.Year.ToString(), Value = e.Total
}).ToList()));
}
public bool add(QuoteItems quoteItem)
{
try
{
_context.QuoteItems.Add(quoteItem);
_context.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e.StackTrace);
return(false);
}
return(true);
}
public bool update(int id, QuoteItems quoteItem)
{
quoteItem.QuoteItemsId = id;
try
{
_context.QuoteItems.Update(quoteItem);
_context.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e.StackTrace);
return(false);
}
return(true);
}
public async Task <QuoteRequestEntity[]> GetQuoteRequestByIdsAsync(params string[] ids)
{
var result = await QuoteRequests.Where(x => ids.Contains(x.Id)).ToArrayAsync();
ids = result.Select(x => x.Id).ToArray();
if (!ids.IsNullOrEmpty())
{
await Addresses.Where(x => ids.Contains(x.QuoteRequestId)).LoadAsync();
await Attachments.Where(x => ids.Contains(x.QuoteRequestId)).LoadAsync();
await QuoteItems.Include(x => x.ProposalPrices)
.Where(x => ids.Contains(x.QuoteRequestId)).ToArrayAsync();
await DynamicPropertyObjectValues.Where(x => ids.Contains(x.ObjectId)).LoadAsync();
}
return(result);
}
// [Authorize(Roles = "QuoteItem:15, QuoteItem:16, QuoteItem:10, QuoteItem:11")]
public IActionResult Update(int id, [FromBody] QuoteItems quoteItem)
{
return(_quoteItem.update(id, quoteItem) ? new NoContentResult() : StatusCode(500));
}
public void CalculateTotalOrderPrice()
{
var sum = QuoteItems.Sum(s => s.ProductPrice * s.ProductQuantity);
TotalPrice = Convert.ToDouble(sum);
}
