public ActionResult GetWeather(FCViewModel model)
{
var wModel = new WeatherModel();
var eventList = model.name == "month" ? wModel.DailyForecast().ToArray() : wModel.HourlyForecast().ToArray();
return(Json(eventList, JsonRequestBehavior.AllowGet));
}
public async Task <IEnumerable <FCViewModel> > GetOrderFromCollectionByFcId(string id)
{
List <FCViewModel> result = new List <FCViewModel>();
string cmd = $@"SELECT fuco.*, co.*,fu.*, fucoi.*, p.*, u.*
FROM `fulfillment_collection` fuco
LEFT JOIN `collection` co ON co.id = fuco.collection_id AND co.is_used = 1 AND co.is_deleted = 0
LEFT JOIN `fulfillment` fu ON fu.id = fuco.fulfillment_id AND fu.is_used = 1 AND fu.is_deleted = 0
LEFT JOIN `fulfillment_collection_item` fucoi ON fuco.id = fucoi.fulfillment_collection_id
LEFT JOIN `product` p ON p.id = fucoi.product_id AND p.is_used = 1 AND p.is_deleted = 0
LEFT JOIN `uom` u ON u.id = fucoi.uom_id AND u.is_used = 1 AND u.is_deleted = 0
WHERE fuco.fulfillment_id = '{id}'
";
DbConnection = DbConnection ?? DALHelper.GetConnection();
var rd = await DbConnection.QueryMultipleAsync(cmd, transaction : DbTransaction);
rd.Read <FulfillmentCollection, Collection, Fulfillment, CFShippingItem, Product, UoM, FCViewModel>(
(fc, col, fu, fci, pro, Uom) =>
{
FCViewModel vm = result.FirstOrDefault(x => x.ID == fc.ID);
if (vm == null)
{
vm = CommonHelper.Mapper <FulfillmentCollection, FCViewModel>(fc);
result.Add(vm);
}
if (vm.Collection == null)
{
vm.Collection = col;
}
if (vm.Fulfillment == null)
{
vm.Fulfillment = fu;
}
var item = vm.Items.FirstOrDefault(i => i.Id == fci.Id);
if (item == null && fci != null)
{
item = CommonHelper.Mapper <CFShippingItem, FCItemViewModel>(fci);
vm.Items.Add(item);
}
if (item != null)
{
item.Product = pro;
item.UoM = Uom;
}
return(vm);
}
);
return(result);
}
public ActionResult GetTasks(FCViewModel view)
{
return(Json(todoModel.GetTasks(view), JsonRequestBehavior.AllowGet));
}
