/* public static XDocument DbToXelemet(ClassSync.ClassCloseTicketTmp.ChecksTicket check)
* {
*
* XDocument doc;
*
* doc = new XDocument(
* new XElement("check",
* new XAttribute("barcodeCheck", check.BarCode))
* )
* ;
* foreach (ClassSync.TypesPayDB type in ClassSync.TypesPayDB.t)
* {
*
* decimal m = 0.0m;
*
* switch (type.NameCourt)
* {
* case "BankChecks": m = check.PayBankChecks; break;
* case "BankCards": m = check.PayBankCards; break;
* case "Cash": m = check.PayCash; break;
* case "Resto": m = check.PayResto; break;
* case "1": m = check.Pay1; break;
* case "2": m = check.Pay2; break;
* case "3": m = check.Pay3; break;
* case "4": m = check.Pay4; break;
* case "5": m = check.Pay5; break;
* case "6": m = check.Pay6; break;
* case "7": m = check.Pay7; break;
* case "8": m = check.Pay8; break;
* case "9": m = check.Pay9; break;
* case "10": m = check.Pay10; break;
* case "11": m = check.Pay11; break;
* case "12": m = check.Pay12; break;
* case "13": m = check.Pay13; break;
* case "14": m = check.Pay14; break;
* case "15": m = check.Pay15; break;
* case "16": m = check.Pay16; break;
* case "17": m = check.Pay17; break;
* case "18": m = check.Pay18; break;
* case "19": m = check.Pay19; break;
* case "20": m = check.Pay20; break;
* default: break;
* }
*
* if (m != 0) doc.Element("check").Add(new XAttribute(type.NameCourt.TrimEnd(), m));
* }
* doc.Element("check").Add(new XAttribute("Rendu", check.Rendu));
* doc.Element("check").Add(new XAttribute("sum", check.TotalTTC));
* doc.Element("check").Add(new XAttribute("date", check.Date));
* doc.Element("check").Add(new XAttribute("DCBC", check.DCBC));
* doc.Element("check").Add(new XAttribute("DCBC_BiloPoints", check.DCBC_BiloPoints));
* doc.Element("check").Add(new XAttribute("DCBC_DobavilePoints", check.DCBC_DobavilePoints));
* doc.Element("check").Add(new XAttribute("DCBC_OtnayliPoints", check.DCBC_OtnayliPoints));
* doc.Element("check").Add(new XAttribute("DCBC_OstalosPoints", check.DCBC_OstalosPoints));
* doc.Element("check").Add(new XAttribute("DCBC_name", check.DCBC_name));
*
*
* check.PayProducts = ClassSync.ClassCloseTicketTmp.PayProducts.sel(check.CustumerId);
*
* foreach (var p in check.PayProducts)
* {
* ClassProducts.product ptemp = ClassProducts.listProducts.Find(la => la.CustumerId == p.ProductId);
*
*
* XElement el = (
* new XElement("product",
* new XElement("CustumerId", p.ProductId),
* new XElement("grp", ClassGroupProduct.getGrpId(ptemp == null ? 3 : ptemp.cusumerIdSubGroup).grp),
* new XElement("qty", p.QTY),
* new XElement("Name", p.Name),
* new XElement("CodeBare", p.Barcode),
* new XElement("price", p.PriceHT),
* new XElement("tva", ClassTVA.listTVA.Find(l => l.val == p.TVA).id),
* new XElement("total", p.Total),
* new XElement("Discount", p.Discount),
* new XElement("sumDiscount", p.sumDiscount)
* )
* );
* doc.Element("check").Add(el);
* }
*
* return doc;
* }
*/
public static XDocument DbToXelemet(ClassSync.ClassCloseTicket.ChecksTicket check)
{
XDocument doc;
doc = new XDocument(
new XElement("check",
new XAttribute("barcodeCheck", check.BarCode))
)
;
foreach (ClassSync.TypesPayDB type in ClassSync.TypesPayDB.t)
{
decimal m = 0.0m;
switch (type.NameCourt)
{
case "BankChecks": m = check.PayBankChecks; break;
case "BankCards": m = check.PayBankCards; break;
case "Cash": m = check.PayCash; break;
case "Resto": m = check.PayResto; break;
case "1": m = check.Pay1; break;
case "2": m = check.Pay2; break;
case "3": m = check.Pay3; break;
case "4": m = check.Pay4; break;
case "5": m = check.Pay5; break;
case "6": m = check.Pay6; break;
case "7": m = check.Pay7; break;
case "8": m = check.Pay8; break;
case "9": m = check.Pay9; break;
case "10": m = check.Pay10; break;
case "11": m = check.Pay11; break;
case "12": m = check.Pay12; break;
case "13": m = check.Pay13; break;
case "14": m = check.Pay14; break;
case "15": m = check.Pay15; break;
case "16": m = check.Pay16; break;
case "17": m = check.Pay17; break;
case "18": m = check.Pay18; break;
case "19": m = check.Pay19; break;
case "20": m = check.Pay20; break;
default: break;
}
if (m != 0)
{
doc.Element("check").Add(new XAttribute(type.NameCourt.TrimEnd(), m));
}
}
doc.Element("check").Add(new XAttribute("Rendu", check.Rendu));
doc.Element("check").Add(new XAttribute("sum", check.TotalTTC));
doc.Element("check").Add(new XAttribute("date", check.Date));
doc.Element("check").Add(new XAttribute("DCBC", check.CheckDiscount.DCBC ?? ""));
doc.Element("check").Add(new XAttribute("DCBC_BiloPoints", check.CheckDiscount.DCBC_BiloPoints ?? 0));
doc.Element("check").Add(new XAttribute("DCBC_DobavilePoints", check.CheckDiscount.DCBC_DobavilePoints ?? 0));
doc.Element("check").Add(new XAttribute("DCBC_OtnayliPoints", check.CheckDiscount.DCBC_OtnayliPoints ?? 0));
doc.Element("check").Add(new XAttribute("DCBC_OstalosPoints", check.CheckDiscount.DCBC_OstalosPoints ?? 0));
doc.Element("check").Add(new XAttribute("DCBC_name", check.CheckDiscount.DCBC_name ?? ""));
check.PayProducts = new ClassSync.ClassCloseTicket.PayProducts().get(check.CustumerId);
foreach (var p in check.PayProducts)
{
ClassProducts.product ptemp = ClassProducts.listProducts.Find(la => la.CustumerId == p.ProductId);
XElement el = (
new XElement("product",
new XElement("CustumerId", p.ProductId),
new XElement("grp", ClassGroupProduct.getGrpId(ptemp == null ? 3 : ptemp.cusumerIdSubGroup).grp),
new XElement("qty", p.QTY),
new XElement("Name", p.Name),
new XElement("CodeBare", p.Barcode),
new XElement("price", p.PriceHT),
new XElement("tva", ClassTVA.listTVA.Find(l => l.val == p.TVA).id),
new XElement("total", p.Total),
new XElement("Discount", p.Discount),
new XElement("sumDiscount", p.sumDiscount)
)
);
doc.Element("check").Add(el);
}
return(doc);
}
public static product DbToVar(ClassSync.ProductDB.Products e)
{
try
{
product p = new product();
p.CustumerId = e.CustumerId;
p.Name = e.Name.ToUpper();
p.Desc = e.Desc;
p.tva = int.Parse(e.TVA.Id);
ClassSync.ProductDB.StockReal sr = null;
ClassSync.ProductDB.StockReal sr2 = null;
if (e.StockReal_ != null)
{
sr = e.StockReal_.First(l => l.IdEstablishment == ClassGlobalVar.IdEstablishment);
sr2 = e.StockReal_.First(l => l.IdEstablishment == ClassGlobalVar.IdEstablishment_GROS);
}
if (sr == null)
{
sr = ClassSync.ProductDB.StockReal.addIsNull(p.CustumerId, ClassGlobalVar.IdEstablishment);
sr2 = ClassSync.ProductDB.StockReal.addIsNull(p.CustumerId, ClassGlobalVar.IdEstablishment_GROS);
}
p.price = sr.Price;
p.priceGros = sr2.Price;
p.qty = sr.QTY;
p.cusumerIdRealStock = sr.CustomerId;
p.uniteContenance = e.UniteContenance;
p.contenance = e.Contenance;
p.tare = e.Tare;
p.date = e.Date;
p.CodeBare = e.CodeBare;
p.balance = e.Balance;
p.cusumerIdSubGroup = e.SubGrpProduct.Id;
ClassGroupProduct.grp_subGrp gs = ClassGroupProduct.getGrpId(p.cusumerIdSubGroup);
p.grp = gs.grp;
p.sgrp = gs.subGrp;
p.ProductsWeb_CustomerId = e.ProductsWeb_CustomerId;
return(p);
}
catch (Exception ex)
{
new ClassLog("error 2012" + ex.Message + " " + e.Name + " " + e.CodeBare);
return(null);
}
}
