public ActionResult GetPriceType2(ModelRequest request, Guid id)
{
var items = db.PricesViews.Where(o => o.PriceProjectId == id && o.Type == 2 && o.MtPartsId != null).ToList();
var count = items.Count();
var sumItem = new PricesView
{
PartsName = "ВСЕГО",
ManufacturerPrice = items.Sum(x => x.ManufacturerPrice),
CipPrice = items.Sum(x => x.CipPrice),
RefPrice = items.Sum(x => x.RefPrice),
UnitPrice = items.Sum(x => x.UnitPrice),
RefPriceTypeName = "",
Id = Guid.Parse("11111111-1111-1111-1111-111111111111")
};
items.Add(sumItem);
var data = new
{
draw = request.Draw,
recordsFiltered = count,
recordsTotal = count,
Data = items.ToList()
};
return(Json(data, JsonRequestBehavior.AllowGet));
}
private void SendWelcomeSms(user user, PricesView network)
{
_log.Info("Sending welcome sms to " + user.phonenumber);
var template = "FLEXINETS: Welcome to {{country}}\nYour subscription is now connected to {{network}}.\nTraffic price: {{price}}\nwww.flexinets.se";
template = template.Replace("{{country}}", network.CommonName);
template = template.Replace("{{network}}", network.providername);
if (network.StepPrice != null)
{
template = template.Replace("{{price}}", network.StepPrice.Value.ToString("f2", CultureInfo.InvariantCulture) + "EUR / " + network.StepSize + "MB");
}
else
{
template = template.Replace("{{price}}", network.Price.ToString("f2", CultureInfo.InvariantCulture) + "EUR / MB");
}
var smsid = _smsGateway.SendSmsAsync(template, user.phonenumber).Result;
_log.Info($"Sent sms with id: {smsid} to {user.phonenumber}");
}
private void Fill()
{
WarePricesLogic prices = new WarePricesLogic(manager);
var pricesList = prices.GetAll(wareId).Select(a => new
{
a.ID,
a.WareID,
a.WarePriceGroupID,
a.DocumentID,
a.AllowDiscount,
a.PurchasePriceForUnit,
a.SalePriceForUnit,
a.Active,
a.Ware.Name,
UnitID = a.Ware.UnitID,
UnitName = a.Ware.WareUnit == null ? "" : a.Ware.WareUnit.Name,
CategoryID = a.Ware.CategoryID,
CategoryName = a.Ware.WareCategory == null ? "" : a.Ware.WareCategory.Name,
WarePriceGroupName = a.WarePriceGroup == null ? "" : a.WarePriceGroup.Name,
ManufacturerName = a.Ware.WareManufacturer == null ? "" : a.Ware.WareManufacturer.Name,
ManufacturerID = a.Ware.ManufacturerID
});
view = new SortableBindingList <PricesView>();
//var waresList = wares.GetAll(name, categoryId, manufacturerId, unitId).Select(a => new
//{
// a.ID,
// Name = a.Name,
// UnitName = a.WareUnit != null ? a.WareUnit.Name : "",
// ManufacturerName = a.WareManufacturer != null ? a.WareManufacturer.Name : "",
// CategoryName = a.WareCategory != null ? a.WareCategory.Name : ""
//});//.OrderBy(a => a.CategoryName).ThenBy(a=> a.Name).ToList();
foreach (var a in pricesList)
{
PricesView pv = new PricesView();
pv.ID = a.ID;
pv.WareName = a.Name;
pv.CategoryID = a.CategoryID;
pv.CategoryName = a.CategoryName;
pv.ManufacturerName = a.ManufacturerName;
pv.UnitName = a.UnitName;
pv.DocumentID = a.DocumentID;
pv.ManufacturerID = a.ManufacturerID;
pv.PurshasePriceForUnit = a.PurchasePriceForUnit;
pv.SalePriceForUnit = a.SalePriceForUnit;
pv.UnitID = a.UnitID;
pv.UnitName = a.UnitName;
pv.WareID = a.WareID;
pv.WarePriceGroupID = a.WarePriceGroupID;
pv.WarePriceGroupName = a.WarePriceGroupName;
pv.AllowDiscount = a.AllowDiscount;
pv.Active = a.Active;
view.Add(pv);
}
//BindingListView<WareView> view = new BindingListView<WareView>(viewList);
//bs.DataSource = view;
//bs.Sort = columnName;
//SortableBindingList<PricesView> viewList = new SortableBindingList<PricesView>(view);
DataGV.DataSource = view;
DataGV.Update();
}
private void Fill()
{
WarePricesLogic prices = new WarePricesLogic(manager);
var pricesList = prices.GetAll(wareId).Select(a => new
{
a.ID,
a.WareID,
a.WarePriceGroupID,
a.DocumentID,
a.AllowDiscount,
a.PurchasePriceForUnit,
a.SalePriceForUnit,
a.Active,
a.Ware.Name,
UnitID = a.Ware.UnitID,
UnitName = a.Ware.WareUnit == null ? "" : a.Ware.WareUnit.Name,
CategoryID = a.Ware.CategoryID,
CategoryName = a.Ware.WareCategory == null ? "" : a.Ware.WareCategory.Name,
WarePriceGroupName = a.WarePriceGroup == null ? "" : a.WarePriceGroup.Name,
ManufacturerName = a.Ware.WareManufacturer == null ? "" : a.Ware.WareManufacturer.Name,
ManufacturerID = a.Ware.ManufacturerID
});
view = new SortableBindingList<PricesView>();
//var waresList = wares.GetAll(name, categoryId, manufacturerId, unitId).Select(a => new
//{
// a.ID,
// Name = a.Name,
// UnitName = a.WareUnit != null ? a.WareUnit.Name : "",
// ManufacturerName = a.WareManufacturer != null ? a.WareManufacturer.Name : "",
// CategoryName = a.WareCategory != null ? a.WareCategory.Name : ""
//});//.OrderBy(a => a.CategoryName).ThenBy(a=> a.Name).ToList();
foreach (var a in pricesList)
{
PricesView pv = new PricesView();
pv.ID = a.ID;
pv.WareName = a.Name;
pv.CategoryID = a.CategoryID;
pv.CategoryName = a.CategoryName;
pv.ManufacturerName = a.ManufacturerName;
pv.UnitName = a.UnitName;
pv.DocumentID = a.DocumentID;
pv.ManufacturerID = a.ManufacturerID;
pv.PurshasePriceForUnit = a.PurchasePriceForUnit;
pv.SalePriceForUnit = a.SalePriceForUnit;
pv.UnitID = a.UnitID;
pv.UnitName = a.UnitName;
pv.WareID = a.WareID;
pv.WarePriceGroupID = a.WarePriceGroupID;
pv.WarePriceGroupName = a.WarePriceGroupName;
pv.AllowDiscount = a.AllowDiscount;
pv.Active = a.Active;
view.Add(pv);
}
//BindingListView<WareView> view = new BindingListView<WareView>(viewList);
//bs.DataSource = view;
//bs.Sort = columnName;
//SortableBindingList<PricesView> viewList = new SortableBindingList<PricesView>(view);
DataGV.DataSource = view;
DataGV.Update();
}
