public ResponseMessageResult Analogues(int kagId, string number, string brand)
{
var ctx = new valmiEntities();
NomenclatureElement[] result = null;
var r = ctx.vsspGetWare(null, kagId, null, null, number, brand, true, null).FirstOrDefault();
if (r != null)
{
var foundRows = new ObjectParameter("RowCnt", 1);
var analogue = ctx.vsspGetWareChange(r.WareId, kagId, null, null, true, null, foundRows, true, false);
// vsspGetWareReplacements(null, r.WareId, kagId, null, false, out var rowCnt);
result = analogue.Select(i => new NomenclatureElement
{
Brand = i.ProducerName,
WareName = i.WareName,
WareId = i.WareId,
UnitName = i.UnitShName,
WareNum = i.WareNum,
Price = i.PriceOut ?? 0,
WareNameRom = i.WareName,
UnitCode = 5
}).ToArray();
}
/*
* var ctx = new CatalogRepository();
*
* NomenclatureElement[] result = null;
*
* var r = ctx.GetWare(null, brand, number, kagId, null);
* if (r != null)
* {
* var analogue = ctx.GetWareReplacements(null, r.Id, kagId, null, false, out var rowCnt);
* result = analogue.Select(i => new NomenclatureElement
* {
* Brand = i.ProducerName,
* WareName = i.Name,
* WareId = i.Id,
* UnitName = i.MeasureUnit,
* WareNum = i.WareNum,
* Price = i.ClientPrice ?? 0,
* WareNameRom = i.Name,
* UnitCode = 5
* }).ToArray();
*
* }
*/
return(XmlResponseMessage(result));
}
public ResponseMessageResult CreateOrder(int orderId, int kagId)
{
var user = GetUser(kagId);
if (user == null)
{
return(ForbiddenResponseMessage);
}
var ctx = new valmiEntities();
var result = ctx.vsspCreateOrder(kagId, null, user.Id, null).FirstOrDefault();
return(XmlResponseMessage(result));
}
public ResponseMessageResult Orders(string startDate, string endDate, int kagId)
{
var user = GetUser(kagId);
if (user == null)
{
return(ForbiddenResponseMessage);
}
var ctx = new valmiEntities();
var result = ctx.vsspGetOrderList(kagId, null,
DateTime.TryParseExact(startDate, "ddMMyyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out var dateBeg) ? (DateTime?)dateBeg : null,
DateTime.TryParseExact(endDate, "ddMMyyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out var dateEnd) ? (DateTime?)dateEnd : null, null, null, null).ToArray();
return(XmlResponseMessage(result));
}
public ResponseMessageResult Order(int orderId, int kagId)
{
var user = GetUser(kagId);
if (user == null)
{
return(ForbiddenResponseMessage);
}
var ctx = new valmiEntities();
var result = new Order
{
OrderData = ctx.vsspGetOrderData(kagId, null, null).FirstOrDefault(),
OrderPositions = ctx.vsspGetOrderPositions(orderId, kagId, null).ToArray()
};
return(XmlResponseMessage(result));
}