public Guid ins(object o) { ClassProducts.product p = (ClassProducts.product)o; string cmdProductWeb = "INSERT INTO ProductsWeb (CustomerId,[Visible],[Images],[ContenancePallet],[Weight],[Frozen]) VALUES ('" + p.ProductsWeb_CustomerId + "', 0, '', 0,0,0 )"; new ClassDB(null).queryNonResonse(cmdProductWeb); string cmdInsProduct = "INSERT INTO Products (CustumerId,Name,CodeBare,[Desc],Chp_cat,Balance,Contenance,UniteContenance,Tare,[Date],TVACustumerId," // +"ProductsAwaitingDeliveryCustomerId," + "ProductsWeb_CustomerId,SubGrpProduct_Id)" + "VALUES ('{CustumerId}','{Name}','{CodeBare}','{Desc}','{Chp_cat}','{Balance}','{Contenance}','{UniteContenance}','{Tare}', CAST('{Date}' AS DateTime),'{TVACustumerId}'," // +"'{ProductsAwaitingDeliveryCustomerId}'," + "'{ProductsWeb_CustomerId}','{SubGrpProduct_Id}')"; string c = cmdInsProduct .Replace("{CustumerId}", p.CustumerId.ToString()) .Replace("{Name}", p.Name.Replace("'", "''")) .Replace("{CodeBare}", p.CodeBare) .Replace("{Desc}", p.Desc.Replace("'", "''")) .Replace("{Chp_cat}", "0") .Replace("{Balance}", p.balance.ToString()) .Replace("{Contenance}", p.contenance.ToString().Replace(",", ".")) .Replace("{UniteContenance}", p.uniteContenance.ToString()) .Replace("{Tare}", p.tare.ToString()) .Replace("{Date}", DateTime.Now.ToString()) .Replace("{TVACustumerId}", ClassTVA.listTVA.Find(l => l.id == p.tva).CustumerId.ToString()) // .Replace("{ProductsAwaitingDeliveryCustomerId}", Guid.Empty.ToString()) .Replace("{ProductsWeb_CustomerId}", p.ProductsWeb_CustomerId.ToString()) .Replace("{SubGrpProduct_Id}", p.cusumerIdSubGroup.ToString() ); new ClassDB(null).queryNonResonse(c); string cmdInsStockReal = "INSERT INTO StockReal (CustomerId,QTY,MinQTY,Price,ProductsCustumerId,Establishment_CustomerId)" + "VALUES ('{CustomerId}','{QTY}','{MinQTY}','{Price}','{ProductsCustumerId}','{Establishment_CustomerId}')"; c = cmdInsStockReal .Replace("{CustomerId}", p.cusumerIdRealStock.ToString()) .Replace("{QTY}", p.qty.ToString().Replace("'", "''")) .Replace("{MinQTY}", "10") .Replace("{Price}", p.price.ToString().Replace(",", ".")) .Replace("{ProductsCustumerId}", p.CustumerId.ToString()) .Replace("{Establishment_CustomerId}", ClassGlobalVar.IdEstablishment.ToString() ); new ClassDB(null).queryNonResonse(c); new LastUpdDB().mod(ClassGlobalVar.nameTicket, DateTime.Now, ClassGlobalVar.user, ClassGlobalVar.CustumerId, true); return(p.CustumerId); }
public void del(object o) { string cmd = "DELETE FROM StockReal WHERE ProductsCustumerId = '{CustumerId}'"; ClassProducts.product p = (ClassProducts.product)o; string c = cmd.Replace("{CustumerId}", p.CustumerId.ToString()); int i = new ClassDB(null).queryNonResonse(c); cmd = "DELETE FROM Products WHERE CustumerId= '{CustumerId}'"; c = cmd.Replace("{CustumerId}", p.CustumerId.ToString()); i = new ClassDB(null).queryNonResonse(c); cmd = "DELETE FROM ProductsWeb WHERE CustomerId= '{CustomerId}'"; c = cmd.Replace("{CustomerId}", p.ProductsWeb_CustomerId.ToString()); i = new ClassDB(null).queryNonResonse(c); new LastUpdDB().mod(ClassGlobalVar.nameTicket, DateTime.Now, ClassGlobalVar.user, ClassGlobalVar.CustumerId, true); }
public void mod(object o) { ClassProducts.product p = (ClassProducts.product)o; string cmdUpd = "UPDATE Products SET [Name]='{Name}', [CodeBare]='{CodeBare}',[Desc]='{Desc}',[TVACustumerId]='{TVACustumerId}'," + "[SubGrpProduct_Id]='{SubGrpProduct_Id}',[Balance]='{Balance}',[Contenance]={Contenance},[UniteContenance]={UniteContenance}," + "[Tare]={Tare},[Date]=CAST('{Date}' AS DateTime) WHERE CustumerId= '{CustumerId}'"; string c = cmdUpd .Replace("{CustumerId}", p.CustumerId.ToString()) .Replace("{Name}", p.Name.Replace("'", "''")) .Replace("{CodeBare}", p.CodeBare) .Replace("{Desc}", p.Desc.Replace("'", "''")) .Replace("{TVACustumerId}", ClassTVA.listTVA.Find(l => l.id == p.tva).CustumerId.ToString()) .Replace("{SubGrpProduct_Id}", p.sgrp.ToString()) .Replace("{Balance}", p.balance.ToString()) .Replace("{Contenance}", p.contenance.ToString().Replace(",", ".")) .Replace("{UniteContenance}", p.uniteContenance.ToString().Replace(",", ".")) .Replace("{Tare}", p.tare.ToString().Replace(",", ".")) .Replace("{Date}", DateTime.Now.ToString()); new ClassDB(null).queryNonResonse(c); cmdUpd = "UPDATE StockReal SET QTY='{QTY}',MinQTY='{MinQTY}',Price='{Price}'," + "ProductsCustumerId='{ProductsCustumerId}',Establishment_CustomerId='{Establishment_CustomerId}'" + " WHERE CustomerId= '{CustomerId}'"; c = cmdUpd .Replace("{QTY}", p.qty.ToString().Replace(",", ".")) .Replace("{MinQTY}", "0") .Replace("{Price}", p.price.ToString().Replace(",", ".")) .Replace("{ProductsCustumerId}", p.CustumerId.ToString()) .Replace("{Establishment_CustomerId}", ClassGlobalVar.IdEstablishment.ToString()) .Replace("{CustomerId}", p.cusumerIdRealStock.ToString() ); new ClassDB(null).queryNonResonse(c); new LastUpdDB().mod(ClassGlobalVar.nameTicket, DateTime.Now, ClassGlobalVar.user, ClassGlobalVar.CustumerId, true); }