public LabelImageViewModel(Dish _d, ItemLabelInfo _l, DateTime _dt, int logoType = 0)
{
d = _d;
l = _l;
dt = _dt;
LogoType = logoType;
}
public bool RemoveLabelInfo(ItemLabelInfo l)
{
var res = DBDataExtractor <ItemLabelInfo> .DeleteItem(DBProvider.Client.DeleteItemLabelInfo, l.Id);
if (res)
{
ItemLabelsInfo.Remove(l);
Dishes.SingleOrDefault(a => a.Id == l.ParenItemId).LabelsCount--;
return(true);
}
return(false);
}
public bool AddLabelInfo(long ParenDishId)
{
ItemLabelInfo l = new ItemLabelInfo()
{
ParenItemId = ParenDishId, SerialNumber = ItemLabelsInfo.Where(a => a.ParenItemId == ParenDishId).Count() + 1
};
var res = DBDataExtractor <ItemLabelInfo> .AddItem(DBProvider.Client.CreateItemLabelInfo, l);
if (res > 0)
{
l.Id = res;
ItemLabelsInfo.Add(l);
Dishes.SingleOrDefault(a => a.Id == ParenDishId).LabelsCount++;
return(true);
}
return(false);
}
static void ExportDishes()
{
var existsD = AlohaFly.DBProvider.Client.GetDishList().Result.Where(a => a.IsToGo);
var dItems = db.Menu.Where(a => a.Active);
//var clsList = new List<OrderCustomer>();
foreach (var d in dItems)
{
int code = Convert.ToInt32(d.Code);
long shId = db.RKeeperMenu.Where(a => a.Code.GetValueOrDefault() == code).First().Sifr.GetValueOrDefault();
StickCatalog stick = null;
if (db.StickCatalog.Any(a => a.Code == code.ToString()))
{
stick = db.StickCatalog.Where(a => a.Code == code.ToString()).FirstOrDefault();
}
Dish nd = new Dish()
{
Barcode = code,
IsTemporary = false,
IsToGo = true,
EnglishName = "",
IsAlcohol = false,
IsActive = true,
LabelRussianName = d.Name,
LabelEnglishName = "",
Name = d.Name,
LabelsCount = 1,
NeedPrintInMenu = true,
PriceForDelivery = d.Cost,
PriceForFlight = 0,
SHId = shId,
ToFlyLabelSeriesCount = 1,
ToGoLabelSeriesCount = 1,
};
if (stick != null)
{
nd.LabelEnglishName = stick.NameENG;
nd.LabelRussianName = stick.NameRU;
}
var res = AlohaFly.DBProvider.Client.CreateDish(nd);
if (!res.Success)
{
string s = res.ErrorMessage;
continue;
}
if (stick != null)
{
var id = res.CreatedObjectId;
foreach (var sd in db.StickContent.Where(a => a.StickID == stick.ID))
{
var lbl = new ItemLabelInfo()
{
ParenItemId = id,
NameEng = sd.PartNameENG,
NameRus = sd.PartNameRU,
Message = sd.WarmUp,
SerialNumber = sd.PartNumb
};
var res2 = AlohaFly.DBProvider.Client.CreateItemLabelInfo(lbl);
if (!res2.Success)
{
string s = res.ErrorMessage;
continue;
}
}
}
}
}
static void ExportDishes2()
{
try
{
_logger.Debug($"ExportDishes2 ");
var existsD = AlohaFly.DBProvider.Client.GetDishList().Result.Where(a => a.IsToGo);
var dItems = db.Menu.Where(a => a.Active);
_logger.Debug($"dItems count {dItems.Count()}");
//var clsList = new List<OrderCustomer>();
foreach (var d in dItems)
{
int code = Convert.ToInt32(d.Code);
// long shId = db.RKeeperMenu.Where(a => a.Code.GetValueOrDefault() == code).First().Sifr.GetValueOrDefault();
StickCatalog stick = null;
if (!existsD.Any(a => a.Barcode == code))
{
_logger.Debug($"ExportDishes2 not exist {code}");
}
else
{
var Oldd = existsD.FirstOrDefault(a => a.Barcode == code);
Oldd.PriceForDelivery = d.Cost;
Oldd.PriceForFlight = 0;
var res = AlohaFly.DBProvider.Client.UpdateDish(Oldd);
if (!res.Success)
{
_logger.Debug($"Error ExportDishes2 UpdateDish {res.ErrorMessage}");
continue;
}
if (db.StickCatalog.Any(a => a.Code == code.ToString()))
{
stick = db.StickCatalog.Where(a => a.Code == code.ToString()).FirstOrDefault();
Oldd.LabelRussianName = stick.NameRU;
Oldd.LabelEnglishName = stick.NameENG;
res = AlohaFly.DBProvider.Client.UpdateDish(Oldd);
if (!res.Success)
{
_logger.Debug($"Error ExportDishes2 UpdateDish {res.ErrorMessage}");
continue;
}
var id = Oldd.Id;
foreach (var sd in db.StickContent.Where(a => a.StickID == stick.ID))
{
var lbl = new ItemLabelInfo()
{
ParenItemId = id,
NameEng = sd.PartNameENG,
NameRus = sd.PartNameRU,
Message = sd.WarmUp,
SerialNumber = sd.PartNumb
};
var res2 = AlohaFly.DBProvider.Client.CreateItemLabelInfo(lbl);
if (!res2.Success)
{
_logger.Debug($"Error ExportDishes2 CreateItemLabelInfo {res2.ErrorMessage}");
continue;
}
}
}
}
}
}
catch (Exception e)
{
_logger.Debug($"ExportDishes2 error {e.Message}");
}
}
public bool UpdateLabelInfo(ItemLabelInfo l)
{
return(DBDataExtractor <ItemLabelInfo> .EditItem(DBProvider.Client.UpdateItemLabelInfo, l));
}
