public PrintProduct(Guid customerId, string categories, string barcode, string name, decimal qty, decimal total, decimal price, int tvaId, decimal procentDiscount,
decimal sumDiscount)
{
CustomerId = customerId;
Categories = categories;
Name = name;
TvaId = tvaId;
ProcentDiscount = procentDiscount;
SumDiscount = sumDiscount;
if (customerId != Guid.Empty)
{
Qty = qty;
Total = total;
Barcode = barcode;
Price = price;
Ht = Math.Round((total / qty) * (100 / (100 + RepositoryTva.GetById(tvaId))), 2) * qty;
TvaTotal = total - Ht;
}
else
{
Qty = 1;
Total = sumDiscount;
Barcode = string.Empty;
Price = 0;
Ht = decimal.Round(sumDiscount * (100 / (100 + RepositoryTva.GetById(tvaId))), 2);
TvaTotal = sumDiscount - Ht;
}
}
public static void XmlToDbSaveD(XDocument x)
{
var infoClientsCustomerId = ModePro ? Pro.CustomerId : new Guid("87da7ba2-5e52-4d31-8def-5a2dad508e94");
var di = new DevisIdType(-1, DateTime.Now, false, infoClientsCustomerId, 0);
var products = x.GetXElements("check", "product");
var p = new List <XElement>();
foreach (var product in products)
{
var pf = p.Find(l => (l.GetXElementValue("CustomerId") == product.GetXElementValue("CustomerId")));
if (pf == null || (pf.GetXElementValue("price") != product.GetXElementValue("price")))
{
p.Add(product);
}
else
{
var qty = pf.GetXElementValue("qty").ToDecimal();
var qty1 = product.GetXElementValue("qty").ToDecimal();
var total = pf.GetXElementValue("total").ToDecimal();
var total1 = product.GetXElementValue("total").ToDecimal();
pf.GetXElement("qty").SetValue(qty + qty1);
pf.GetXElement("total").SetValue(total + total1);
}
}
x.GetXElements("check", "product").Remove();
di.DivisWebs = new List <DevisWebType>();
foreach (var product in p)
{
x.GetXElement("check").Add(product);
var prixHt = Math.Round(product.GetXElementValue("price").ToDecimal(), 2);
var tva = RepositoryTva.GetById(product.GetXElementValue("tva").ToInt());
var tva1 = PrixTtcOnlyTva(product.GetXElementValue("price").ToDecimal(), tva);
var monPrixHt = product.GetXElementValue("contenance").ToDecimal();
var qty = product.GetXElementValue("qty").ToDecimal();
var prixHtValue = prixHt - tva1;
var dw = new DevisWebType(Guid.NewGuid(), -1, prixHtValue, monPrixHt == 0 ? 1 : monPrixHt, qty,
qty * prixHtValue, 0, true, product.GetXElementValue("CustomerId").ToGuid(), di.InfoClientsCustomerId ?? Guid.Empty);
var cusumerIdRealStock = Guid.Parse(product.GetXElementValue("cusumerIdRealStock").Replace('.', ','));
RepositoryStockReal.AddProductCount(-dw.Qty, cusumerIdRealStock);
RepositoryStockReal.UpdateProductCountByEstablishment(dw.Qty, Config.IdEstablishmentGros, dw.ProductsCustomerId);
di.DivisWebs.Add(dw);
}
di.Total = di.DivisWebs.Sum(l => l.TotalHt);
SyncService.InsDevis(di);
FileMove();
}
public static PayProductTmp FromCheckXElement(XElement element, Guid customerId, Guid checksTicketCustomerId)
{
return(new PayProductTmp(
customerId,
element.GetXElementValue("CustomerId").ToGuid(),
element.GetXElementValue("Name"),
element.GetXElementValue("CodeBare"),
element.GetXElementValue("qty").ToDecimal(),
RepositoryTva.GetById(element.GetXElementValue("tva").ToInt()),
element.GetXElementValue("price").ToDecimal(),
element.GetXElementValue("total").ToDecimal(),
checksTicketCustomerId,
0,
0));
}
private static PriceGrosType[] GetGros(Guid[] g)
{
var res = new PriceGrosType[g.Length];
for (var i = 0; i < res.Length; i++)
{
var x = RepositoryProduct.GetXElementByElementName("CustomerId", g[i].ToString());
var pg = x.GetXElementValue("priceGros").ToDecimal();
decimal procent = Pro.DiscountValue;
pg = pg + (pg * procent / 100);
var tva1 = RepositoryTva.GetById(x.GetXElementValue("tva").ToInt());
var tva = PrixOnlyTva(pg, tva1);
pg = pg + tva;
res[i] = new PriceGrosType(x.GetXElementValue("cusumerIdRealStock").ToGuid(), x.GetXElementValue("CustomerId").ToGuid(), pg);
}
return(res);
}
public WBallance(object arg)
{
InitializeComponent();
_product = arg as ProductType;
xCodebar.Content = _product.CodeBare.Trim() == "" ? "not" : _product.CodeBare;
xName.Content = _product.Name;
xDescription.Content = _product.Desc;
xPrix.Text = _product.Price.ToString();
xTVA.Content = RepositoryTva.GetById(_product.TvaId);
xBallance.Content = _product.Balance;
xContenance.Content = _product.Contenance;
xUniteContenance.Content = _product.UniteContenance;
xTare.Content = _product.Tare;
GetBallance();
Product = _product;
numPad.TextBox = xPrix;
numPad.BEnter = bOk;
numPad2.TextBox = xBallance_kg;
numPad2.BEnter = bOk;
}
public static void XmlToDbSave(XDocument x)
{
var tes = new Tes
{
CustomerId = Guid.NewGuid(),
ACodeFournisseur = 0,
AFrtva = Pro.Frtva ?? string.Empty,
AMail = Pro.Mail,
AName = Pro.Name ?? string.Empty,
ASex = Pro.SexToInt(Pro.Sex),
ASurname = Pro.Surname ?? string.Empty,
ANameCompany = Pro.NameCompany,
AOfficeAddress = Pro.OfficeAddress ?? string.Empty,
AOfficeCity = Pro.OfficeCity ?? string.Empty,
AOfficeZipCode = Pro.OfficeZipCode ?? string.Empty,
ASiret = Pro.Siret ?? string.Empty,
ATelephone = Pro.Telephone
};
tes.CustomerId = Guid.NewGuid();
tes.DateTime = DateTime.Now;
tes.Description = string.Empty;
tes.Id = RepositoryTes.MaxId(0) + 1;
tes.Livraison = false;
tes.Montant = x.GetXAttributeValue("check", "sum").ToDecimal();
tes.Nclient = Pro.Nclient.ToString();
tes.Payement = false;
tes.Type = 0;
tes.VAdresse = RepositoryEstablishment.Establishment.Adress;
tes.VCodeNaf = "0";
tes.VCp = RepositoryEstablishment.Establishment.Cp;
tes.VFax = RepositoryEstablishment.Establishment.Phone;
tes.VFrtva = "";
tes.VMail = RepositoryEstablishment.Establishment.Mail;
tes.VNameCompany = RepositoryEstablishment.Establishment.Name;
tes.VPhone = RepositoryEstablishment.Establishment.Phone;
tes.VSiret = "";
tes.VVille = RepositoryEstablishment.Establishment.Ville;
var products = x.GetXElements("check", "product");
var p = new List <XElement>();
foreach (var product in products)
{
var pf = p.Find(l => l.GetXElementValue("CustomerId") == product.GetXElementValue("CustomerId"));
if (pf == null || (pf.GetXElementValue("price") != product.GetXElementValue("price")))
{
p.Add(product);
}
else
{
var qty = pf.GetXElementValue("qty").ToDecimal();
var qty1 = product.GetXElementValue("qty").ToDecimal();
var total = pf.GetXElementValue("total").ToDecimal();
var total1 = product.GetXElementValue("total").ToDecimal();
pf.GetXElement("qty").SetValue(qty + qty1);
pf.GetXElement("total").SetValue(total + total1);
}
}
x.GetXElements("check", "product").Remove();
foreach (var product in p)
{
x.GetXElement("check").Add(product);
var prod = new TesProduct
{
Balance = product.GetXElementValue("balance").ToBool(),
CodeBar = ReplaceCodeBare(product.GetXElementValue("CodeBare")),
ConditionAchat = 1,
CustomerId = -1,
CustomerIdProduct = product.GetXElementValue("CustomerId").ToGuid(),
Date = DateTime.Now,
Description = Config.Name,
Group = RepositoryGroupProduct.GetGroupNameById(product.GetXElementValue("grp").ToInt()),
NameProduct = product.GetXElementValue("Name"),
PrixHt = Math.Round(product.GetXElementValue("price").ToDecimal(), 2),
ProductsWeb = product.GetXElementValue("ProductsWeb_CustomerId").ToGuid(),
Qty = product.GetXElementValue("qty").Replace('.', ',').ToDecimal(),
SubGroup = RepositoryGroupProduct.GetGroupNameById(product.GetXElementValue("grp").ToInt()),
TesCustomerId = tes.CustomerId,
Tva = RepositoryTva.GetById(product.GetXElementValue("tva").ToInt())
};
var tva = PrixTtcOnlyTva(product.GetXElementValue("price").ToDecimal(), prod.Tva);
prod.PrixHt = prod.PrixHt - tva;
prod.TotalHt = prod.Qty * prod.PrixHt;
prod.TypeId = 1;
tes.TesProducts.Add(prod);
var qty = prod.Qty;
var cusumerIdRealStock = product.GetXElementValue("cusumerIdRealStock").ToGuid();
RepositoryStockReal.AddProductCount(-qty, cusumerIdRealStock);
}
foreach (var type in RepositoryTypePay.TypePays)
{
var reglement = new TesReglament();
var r = RepositoryTypePay.TypePays.FirstOrDefault(l => l.NameCourt == type.NameCourt);
var elm = x.GetXAttribute("check", type.NameCourt);
if (elm != null && r != null)
{
reglement.Caisse = Config.NameTicket;
reglement.CustomerId = Guid.NewGuid();
reglement.DateTime = DateTime.Now;
if (r.Name == "En espèces")
{
var rendux = x.GetXAttribute("check", "Rendu");
if (rendux != null)
{
var rendu = rendux.Value.ToDecimal();
reglement.Montant = elm.Value.ToDecimal() + rendu;
}
else
{
reglement.Montant = elm.Value.ToDecimal();
}
}
else
{
reglement.Montant = elm.Value.ToDecimal();
}
reglement.TesCustomerId = tes.CustomerId;
reglement.TypePay = r.Name;
tes.TesReglaments.Add(reglement);
}
tes.Payement = (tes.TesReglaments.Sum(l => l.Montant) >= tes.Montant);
}
if (tes.TesReglaments.Count > 0)
{
var newTes = new Tes
{
CustomerId = Guid.NewGuid(),
ACodeFournisseur = (short)(Pro.Nclient),
AFrtva = Pro.Frtva ?? string.Empty,
AMail = Pro.Mail,
AName = Pro.Name ?? string.Empty,
ASex = Pro.SexToInt(Pro.Sex),
ASurname = Pro.Surname ?? string.Empty,
ANameCompany = Pro.NameCompany,
AOfficeAddress = Pro.OfficeAddress ?? string.Empty,
AOfficeCity = Pro.OfficeCity ?? string.Empty,
AOfficeZipCode = Pro.OfficeZipCode ?? string.Empty,
ASiret = Pro.Siret ?? string.Empty,
ATelephone = Pro.Telephone,
DateTime = DateTime.Now,
Description = "{" + tes.CustomerId + "}{" + tes.Id + "}{" + tes.Type + "}",
Id = RepositoryTes.MaxId(1) + 1,
Livraison = tes.Livraison,
Montant = decimal.Parse(x.Element("check").Attribute("sum").Value.Replace('.', ',')),
Nclient = Pro.Nclient.ToString(),
Payement = tes.Payement,
Type = 1,
VAdresse = tes.VAdresse,
VCodeNaf = tes.VCodeNaf,
VCp = tes.VCp,
VFax = tes.VFax,
VFrtva = tes.VFrtva,
VMail = tes.VMail,
VNameCompany = tes.VNameCompany,
VPhone = tes.VPhone,
VSiret = tes.VSiret,
VVille = tes.VVille
};
tes.Description = "{" + newTes.CustomerId + "}{" + newTes.Id + "}{" + newTes.Type + "}";
foreach (var t in tes.TesReglaments)
{
if (t.Montant > 0)
{
t.TesCustomerId = newTes.CustomerId;
newTes.TesReglaments.Add(t);
}
}
tes.TesReglaments.Clear();
RepositoryTes.AddToDb(newTes);
}
RepositoryTes.AddToDb(tes);
Nfact = tes.Id ?? -1;
FileMove();
}