static void r_xml_file_()
{
int i = 0;
string path = @"D:\Product.xml";
XDocument x = XDocument.Load(path);
IEnumerable <XElement> elms = x.Element("Product").Elements("rec");
int c = elms.Count();
foreach (XElement e in elms)
{
Guid pg = Products.getProdCustomerId(e.Element("CodeBare").Value.TrimEnd().TrimStart().Trim());
i++;
Console.WriteLine(i + " of " + c);
if (pg != Guid.Empty)
{
Products.StockReal s = new Products.StockReal();
s.CustomerId = Guid.NewGuid();
s.IdEstablishment = new Guid("42e89ba9-1012-4327-95f9-40712e232849");
s.IdProduct = pg;
s.MinQTY = 10;
s.QTY = 0;
s.Price = Convert.ToDecimal(e.Element("price").Value.Replace(".", ","));
s.ProductsCustumerId = pg;
Products.StockReal.ins(s);
}
}
}
static void r_xml_file()
{
string path = @"D:\Product.xml";
// string pat = @"D:\GroupProduct.xml";
XDocument x = XDocument.Load(path);
IEnumerable <XElement> elms = x.Element("Product").Elements("rec");
int i = 0;
new ClassDB(null).queryResonse("DELETE FROM StockReal");
new ClassDB(null).queryResonse("DELETE FROM Products");
foreach (XElement e in elms)
{
Products p = new Products();
p.CustumerId = Guid.NewGuid();
// e.Element("id").Value = p.CustumerId.ToString();
p.Name = e.Element("Name").Value;
p.TVACustumerId = e.Element("tva").Value == "1" ? Guid.Parse("7e73aa7e-a6a6-4ed5-8dad-3d47aa5cdbc0") : Guid.Parse("0eb6dd27-e9f8-4f50-8e7e-e7c81874ff56");
p.ProductsAwaitingDeliveryCustomerId = Guid.Empty;
p.ProductsWeb_CustomerId = Guid.NewGuid();
p.SubGrpProduct_Id = 3;//Convert.ToInt32(e.Element("chp_fam").Value);
p.CodeBare = e.Element("CodeBare").Value;
p.Balance = Convert.ToBoolean(e.Element("balance").Value);
p.Contenance = Convert.ToDecimal(e.Element("contenance").Value.Replace(".", ","));
p.UniteContenance = Convert.ToInt32(e.Element("uniteContenance").Value);
p.Tare = 0;
p.Desc = e.Element("Desc").Value;
p.Date = DateTime.Now;
Products.StockReal s = new Products.StockReal();
s.CustomerId = Guid.NewGuid();
s.IdEstablishment = new Guid("e27d5a4d-d6d3-4ee5-810b-f95b32e0bb93");
s.IdProduct = p.CustumerId;
s.MinQTY = 10;
s.QTY = 0;
s.Price = Convert.ToDecimal(e.Element("price").Value.Replace(".", ","));
s.ProductsCustumerId = p.CustumerId;
p.SR.Add(s);
Products.ins(p);
Console.WriteLine(i++);
}
x.Save(path);
}