public AddCommand(RetailerBuyingCalendarViewModel buyingCalendar)
{
BuyingCalendar = buyingCalendar;
}
public UpdateAdapCommand(RetailerBuyingCalendarViewModel buyingCalendar)
{
BuyingCalendar = buyingCalendar;
}
public async Task <RetailerBuyingCalendarViewModel> Get(long id)
{
RetailerBuyingCalendarViewModel result = null;
string cmd = $@"SELECT * FROM `retailer_buying_calendar` o
LEFT JOIN `retailer` r ON o.retailer_id = r.id AND r.is_used = 1 AND r.is_deleted = 0
LEFT JOIN `retailer_buying_calendar_item` i ON i.retailer_buying_calendar_id = o.id
LEFT JOIN `product` p ON p.id = i.product_id AND p.is_used = 1 AND p.is_deleted = 0
LEFT JOIN `uom` u ON u.id = i.uom_id AND u.is_used = 1 AND u.is_deleted = 0
WHERE o.`id` = {id} AND o.is_deleted = 0";
if (DbConnection != null)
{
var rd = await DbConnection.QueryMultipleAsync(cmd, transaction : DbTransaction);
rd.Read <RetailerBuyingCalendar, Retailer, RetailerBuyingCalendarItem, Product, UoM, RetailerBuyingCalendarViewModel>(
(orderRs, rRs, itemRs, pRs, uRs) =>
{
if (result == null)
{
result = CommonHelper.Mapper <RetailerBuyingCalendar, RetailerBuyingCalendarViewModel>(orderRs);
}
if (result.Retailer == null)
{
result.Retailer = rRs;
}
var item = result.Items.FirstOrDefault(i => i.Id == itemRs.Id);
if (item == null)
{
item = CommonHelper.Mapper <RetailerBuyingCalendarItem, RetailerBuyingCalendarItemViewModel>(itemRs);
result.Items.Add(item);
}
item.Product = pRs;
item.UoM = uRs;
return(result);
}
);
return(result);
}
else
{
using (var conn = DALHelper.GetConnection())
{
var rd = await conn.QueryMultipleAsync(cmd);
rd.Read <RetailerBuyingCalendar, Retailer, RetailerBuyingCalendarItem, Product, UoM, RetailerBuyingCalendarViewModel>(
(orderRs, rRs, itemRs, pRs, uRs) =>
{
if (result == null)
{
result = CommonHelper.Mapper <RetailerBuyingCalendar, RetailerBuyingCalendarViewModel>(orderRs);
}
if (result.Retailer == null)
{
result.Retailer = rRs;
}
var item = result.Items.FirstOrDefault(i => i.Id == itemRs.Id);
if (item == null)
{
item = CommonHelper.Mapper <RetailerBuyingCalendarItem, RetailerBuyingCalendarItemViewModel>(itemRs);
result.Items.Add(item);
}
item.Product = pRs;
item.UoM = uRs;
return(result);
}
);
return(result);
}
}
}
