private Guid UserGuid(Models.User sp) { Guid res = Guid.Empty; SqlCommand cmd = new SqlCommand("SELECT [UserId] FROM [User] WHERE [Username]=@Username", new SqlConnection(this.StringConnection)); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Username", sp.Code); try { if (cmd.Connection.State != ConnectionState.Open) { cmd.Connection.Open(); } res = ((Guid)cmd.ExecuteScalar()); } catch (Exception ex) { IEvent e = new ErrorEvent("", "", "UserExist::" + ex.Message); e.Publish(); } finally { if (cmd.Connection.State == ConnectionState.Open) { cmd.Connection.Close(); } } return(res); }
private bool ItemExist(string item) { bool res = false; SqlCommand cmd = new SqlCommand("SELECT COUNT([No]) FROM [Item] WHERE [No]=@No", new SqlConnection(this.StringConnection)); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@No", item); try { if (cmd.Connection.State != ConnectionState.Open) { cmd.Connection.Open(); } res = ((int)cmd.ExecuteScalar()) > 0; } catch (Exception ex) { //MessageBox.Show("TransactionAddInventoryMovement::" + ex.Message); IEvent e = new ErrorEvent("", "", "TransactionAddInventoryMovement::" + ex.Message); e.Publish(); } finally { if (cmd.Connection.State == ConnectionState.Open) { cmd.Connection.Close(); } } return(res); }
private DataTable getTransactionInfo(string DocumentNumber) { SqlCommand command = new SqlCommand(); SqlDataAdapter adapter = new SqlDataAdapter(); DataTable data = new DataTable("GL_ADJUSTMENTS"); command.Connection = new SqlConnection(this.mStringConnection); command.Parameters.AddWithValue("@DOCUMENT", DocumentNumber); command.CommandType = CommandType.Text; command.CommandText = "SELECT IV.DOCNUMBR " + ",ISNULL(GL.USWHPSTD,'UNKNOWN') AS USERID " + ", CASE DOCTYPE " + " WHEN 1 THEN 'AJUSTE' ELSE 'DESCONOCIDO' " + " END AS DOCTYPE " + ",IV.DOCDATE " + ",CONVERT(time, ISNULL(GL.DEX_ROW_TS,0)) AS [TIME] " + ",IV.ITEMNMBR " + ",IV.UOFM " + ",'UNKNOWN' AS FAMILY " + ",CASE WHEN TRXQTY>0 THEN '1' ELSE '2' END AS PROCESS " + ",IV.TRXLOCTN " + ",ISNULL((SELECT USERNAME FROM DYNAMICS..SY01400 WHERE USERID= GL.USWHPSTD),'UNKNOWN') AS USERNAME " + ",'UBICACION' AS LOCATION " + ",ISNULL(CASE IVM.PRICMTHD " + " WHEN 1 THEN ROUND(UOMPRICE,IVM.DECPLCUR) " + " WHEN 2 THEN ROUND(CUR.LISTPRCE*(UOMPRICE/100),IV.DECPLCUR-1) " + " WHEN 3 THEN ROUND(IVM.CURRCOST + (IVM.CURRCOST * (UOMPRICE/100)),IVM.DECPLCUR-1) " + " WHEN 4 THEN ROUND(IVM.STNDCOST + (IVM.STNDCOST * (UOMPRICE/100)),IVM.DECPLCUR-1) " + " WHEN 5 THEN ROUND(IVM.CURRCOST + ((IVM.CURRCOST * (UOMPRICE/100))/((100-UOMPRICE)/100)),IVM.DECPLCUR-1) " + " WHEN 6 THEN ROUND(IVM.STNDCOST + ((IVM.STNDCOST * (UOMPRICE/100))/((100-UOMPRICE)/100)),IVM.DECPLCUR-1) " + "END,0) AS PRICE " + ",IVM.CURRCOST AS COST " + ",TRXQTY AS QTY " + "FROM IV30300 AS IV " + "LEFT JOIN GL10000 AS GL ON IV.TRXSORCE = GL.ORTRXSRC AND GL.DTAControlNum=IV.DOCNUMBR " + "INNER JOIN IV00101 AS IVM ON IV.ITEMNMBR = IVM.ITEMNMBR " + "INNER JOIN IV00108 AS PRCLST ON IV.ITEMNMBR=PRCLST.ITEMNMBR AND IVM.PRCLEVEL=PRCLST.PRCLEVEL AND IVM.PRCHSUOM=PRCLST.UOFM " + "INNER JOIN IV00105 AS CUR ON CUR.ITEMNMBR = IV.ITEMNMBR AND PRCLST.CURNCYID = CUR.CURNCYID " + "WHERE DOCTYPE=1 AND IV.DOCNUMBR=@DOCUMENT ORDER BY IV.DEX_ROW_ID ASC"; try { adapter.SelectCommand = command; adapter.Fill(data); } catch (Exception ex) { IEvent e = new ErrorEvent("", "", ex.Message); e.Publish(); } finally { //nothing } return(data); }
private DataTable getSalespersons() { SqlCommand command = new SqlCommand(); SqlDataAdapter adapter = new SqlDataAdapter(); DataTable data = new DataTable("SALESPERSON"); command.Connection = new SqlConnection(this.mStringConnection); // command.Parameters.AddWithValue("@P", "0"); command.CommandType = CommandType.Text; command.CommandText = "SELECT * FROM RM00301 WHERE INACTIVE=0"; try { adapter.SelectCommand = command; adapter.Fill(data); } catch (Exception ex) { IEvent e = new ErrorEvent("", "", ex.Message); e.Publish(); } finally { //nothing } return(data); }
private bool SalespersonExist(Models.Salesperson sp) { bool res = false; SqlCommand cmd = new SqlCommand("SELECT COUNT([Code]) FROM [Employees] WHERE [Code]=@Code", new SqlConnection(this.StringConnection)); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Code", sp.Code); try { if (cmd.Connection.State != ConnectionState.Open) { cmd.Connection.Open(); } res = ((int)cmd.ExecuteScalar()) > 0; } catch (Exception ex) { IEvent e = new ErrorEvent("", "", "TransactionAddSalesPerson::" + ex.Message); e.Publish(); } finally { if (cmd.Connection.State == ConnectionState.Open) { cmd.Connection.Close(); } } return(res); }
private DataTable getAllLocation() { SqlCommand command = new SqlCommand(); SqlDataAdapter adapter = new SqlDataAdapter(); DataTable data = new DataTable("LOCATIONS"); command.Connection = new SqlConnection(this.mStringConnection); // command.Parameters.AddWithValue("@P", "0"); command.CommandType = CommandType.Text; command.CommandText = "SELECT * FROM IV40700"; try { adapter.SelectCommand = command; adapter.Fill(data); } catch (Exception ex) { IEvent e = new ErrorEvent("", "", ex.Message); e.Publish(); } finally { //nothing } return(data); }
private DataTable getAllCustomers() { SqlCommand command = new SqlCommand(); SqlDataAdapter adapter = new SqlDataAdapter(); DataTable data = new DataTable("CUSTOMER"); command.Connection = new SqlConnection(this.mStringConnection); // command.Parameters.AddWithValue("@P", "0"); command.CommandType = CommandType.Text; command.CommandText = "SELECT * FROM RM00101 WHERE CUSTNMBR LIKE 'CL9000%'"; try { adapter.SelectCommand = command; adapter.Fill(data); } catch (Exception ex) { IEvent e = new ErrorEvent("", "", ex.Message); e.Publish(); } finally { //nothing } return(data); }
private bool CustomerExist(string code) { bool res = false; SqlCommand cmd = new SqlCommand("SELECT COUNT([No]) FROM [Customer] WHERE [No]=@No", new SqlConnection(this.StringConnection)); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@No", code); try { if (cmd.Connection.State != ConnectionState.Open) { cmd.Connection.Open(); } res = ((int)cmd.ExecuteScalar()) > 0; } catch (Exception ex) { IEvent ev = new ErrorEvent("", "", "TransactionAddCustomer::" + ex.Message); ev.Publish(); } finally { if (cmd.Connection.State == ConnectionState.Open) { cmd.Connection.Close(); } } return(res); }
private DataTable getAllWarehouseData() { SqlCommand command = new SqlCommand(); SqlDataAdapter adapter = new SqlDataAdapter(); DataTable data = new DataTable("WAREHOUSE"); command.Connection = new SqlConnection(this.mStringConnection); // command.Parameters.AddWithValue("@P", "0"); command.CommandType = CommandType.Text; command.CommandText = "SELECT LOCNCODE, LOCNDSCR FROM IV40700 WHERE LTRIM(RTRIM(UPPER(ADDRESS3)))='TIENDA GALAPAGO'"; try { adapter.SelectCommand = command; adapter.Fill(data); } catch (Exception ex) { IEvent e = new ErrorEvent("", "", ex.Message); e.Publish(); } finally { //nothing } return(data); }
private DataTable getItemsData(string ITEMNMBR) { SqlCommand command = new SqlCommand(); SqlDataAdapter adapter = new SqlDataAdapter(); DataTable data = new DataTable("ITEMMSTR"); command.Connection = new SqlConnection(this.mStringConnection); command.Parameters.AddWithValue("@ITMBS", this.mItmbs); command.Parameters.AddWithValue("@ITEMNMBR", ITEMNMBR); command.CommandType = CommandType.Text; command.CommandText = "SELECT IV.ITEMNMBR " + ",IV.ITEMDESC,IV.ITEMTYPE,IV.SELNGUOM " + ",ITMCLSCD " + ",CURRCOST " + ",CASE IV.PRICMTHD " + "WHEN 1 THEN ROUND(UOMPRICE,IV.DECPLCUR) " + "WHEN 2 THEN ROUND(CUR.LISTPRCE*(UOMPRICE/100),IV.DECPLCUR-1) " + "WHEN 3 THEN ROUND(IV.CURRCOST + (IV.CURRCOST * (UOMPRICE/100)),IV.DECPLCUR-1) " + "WHEN 4 THEN ROUND(IV.STNDCOST + (IV.STNDCOST * (UOMPRICE/100)),IV.DECPLCUR-1) " + "WHEN 5 THEN ROUND(IV.CURRCOST + ((IV.CURRCOST * (UOMPRICE/100))/((100-UOMPRICE)/100)),IV.DECPLCUR-1) " + "WHEN 6 THEN ROUND(IV.STNDCOST + ((IV.STNDCOST * (UOMPRICE/100))/((100-UOMPRICE)/100)),IV.DECPLCUR-1) " + "END AS PRICE " + ",CASE IV.PRICMTHD " + "WHEN 1 THEN ISNULL(UOMPRICE+(UOMPRICE*((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS)/100)),ROUND(UOMPRICE,IV.DECPLCUR)) " + "WHEN 2 THEN ISNULL(CUR.LISTPRCE*(UOMPRICE/100) /**/ + ((CUR.LISTPRCE*(UOMPRICE/100))*((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS)/100)),ROUND(CUR.LISTPRCE*(UOMPRICE/100),IV.DECPLCUR-1) ) " + "WHEN 3 THEN ISNULL(IV.CURRCOST + (IV.CURRCOST * (UOMPRICE/100)) /**/ + ((IV.CURRCOST + (IV.CURRCOST * (UOMPRICE/100)))*((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS)/100)),ROUND(IV.CURRCOST + (IV.CURRCOST * (UOMPRICE/100)),IV.DECPLCUR-1)) " + "WHEN 4 THEN ISNULL(IV.STNDCOST + (IV.STNDCOST * (UOMPRICE/100)) /**/ + (IV.STNDCOST + (IV.STNDCOST * (UOMPRICE/100))*((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS)/100)),ROUND(IV.STNDCOST + (IV.STNDCOST * (UOMPRICE/100)),IV.DECPLCUR-1)) " + "WHEN 5 THEN ISNULL(IV.CURRCOST + ((IV.CURRCOST * (UOMPRICE/100))/((100-UOMPRICE)/100)) /**/ + ((IV.CURRCOST + ((IV.CURRCOST * (UOMPRICE/100))/((100-UOMPRICE)/100)))*((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS)/100)),ROUND(IV.CURRCOST + ((IV.CURRCOST * (UOMPRICE/100))/((100-UOMPRICE)/100)),IV.DECPLCUR-1)) " + "WHEN 6 THEN ISNULL(IV.STNDCOST + ((IV.STNDCOST * (UOMPRICE/100))/((100-UOMPRICE)/100)) /**/+ ((IV.STNDCOST + ((IV.STNDCOST * (UOMPRICE/100))/((100-UOMPRICE)/100)))*((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS)/100)),ROUND(IV.STNDCOST + ((IV.STNDCOST * (UOMPRICE/100))/((100-UOMPRICE)/100)),IV.DECPLCUR-1)) " + "END AS PRICEWITMBS " + ",ISNULL((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS),0) AS ITMBSPCT " + "FROM IV00101 AS IV " + "INNER JOIN IV00108 AS PRCLST ON IV.ITEMNMBR=PRCLST.ITEMNMBR AND IV.PRCLEVEL=PRCLST.PRCLEVEL AND IV.PRCHSUOM=PRCLST.UOFM " + "INNER JOIN IV00105 AS CUR ON CUR.ITEMNMBR = IV.ITEMNMBR AND PRCLST.CURNCYID = CUR.CURNCYID WHERE IV.ITEMNMBR=@ITEMNMBR"; try { adapter.SelectCommand = command; adapter.Fill(data); } catch (Exception ex) { IEvent e = new ErrorEvent("", "", ex.Message); e.Publish(); } finally { //nothing } return(data); }
// Carga un cliente desde un XML public static Customer LoadFrom(string filename) { Customer tCustomer = null; try { var serializer = new XmlSerializer(typeof(Customer)); FileStream fs = new FileStream(filename, FileMode.Open); StreamReader stream = new StreamReader(fs, Encoding.Unicode); tCustomer = (Customer)serializer.Deserialize(stream); fs.Close(); }catch (Exception ex) { IEvent e = new ErrorEvent("", "", "Customer::" + ex.Message); e.Publish(); } return(tCustomer); }
void thread() { DataTable warehouseData = getAllWarehouseData(); int total = warehouseData.Rows.Count; // esrcibo en el nowin porque van para premiumsoft foreach (DataRow row in warehouseData.Rows) { string FileName = "GP_TDEPO_{0}.xml"; string LOCNCODE = row["LOCNCODE"].ToString().Trim(); string LOCNDSCR = row["LOCNDSCR"].ToString().Trim(); IEvent e = new InfoEvent("", "", "Iniciando la creación del archivo XML '" + String.Format(FileName, LOCNCODE) + "'."); e.Publish(); // xml // XmlDocument doc = new XmlDocument(); /* Lines */ XmlElement Raiz = doc.CreateElement(string.Empty, "raiz", string.Empty); /* Lines */ try { Models.Warehouse ware = new Models.Warehouse(); //XmlDeclaration xmlDeclaration = doc.CreateXmlDeclaration("1.0", "UTF-8", null); //XmlElement root = doc.DocumentElement; //doc.InsertBefore(xmlDeclaration, root); //doc.AppendChild(Raiz); //XmlElement element2 = doc.CreateElement(string.Empty, "warehouse", string.Empty); //Raiz.AppendChild(element2); //XmlElement element3 = doc.CreateElement(string.Empty, "codigo", string.Empty); ware.Codigo = LOCNCODE.Trim(); // XmlText text1 = doc.CreateTextNode(LOCNCODE.Trim()); //element3.AppendChild(text1); //element2.AppendChild(element3); //XmlElement element4 = doc.CreateElement(string.Empty, "descripcion", string.Empty); ware.Descripcion = LOCNDSCR.Trim(); //XmlText text2 = doc.CreateTextNode(LOCNDSCR.Trim()); //element4.AppendChild(text2); //element2.AppendChild(element4); if (this.NowPathIn.ToCharArray().Last() == '/' || this.NowPathIn.ToCharArray().Last() == '\\') { if (!System.IO.File.Exists(this.mNowPathOut + string.Format(FileName, LOCNCODE))) { Models.Warehouse.SaveAs(this.mNowPathOut + string.Format(FileName, LOCNCODE), ware); //doc.Save(this.mNowPathOut + string.Format(FileName, LOCNCODE)); } } else { if (!System.IO.File.Exists(this.mNowPathOut + "/" + string.Format(FileName, LOCNCODE))) { Models.Warehouse.SaveAs(this.mNowPathOut + "/" + string.Format(FileName, LOCNCODE), ware); //doc.Save(this.mNowPathOut + "/" + string.Format(FileName, LOCNCODE)); } } total--; ObserverManager.Instance.addSubject(new ProgressSubject(total, warehouseData.Rows.Count - total)); IEvent e2 = new InfoEvent("", "", "El archivo '" + String.Format(FileName, LOCNCODE) + "'. fue creado correctamente"); e2.Publish(); } catch (Exception ex) { IEvent err = new ErrorEvent("", "", "No pudo crear el archivo xml correctamente. Mensaje: " + ex.Message); err.Publish(); } } ObserverManager.Instance.addSubject(new ProgressSubject(0, 0)); }
private DataTable getInventorySnapshot(String LOCATION, string itbms) { SqlCommand command = new SqlCommand(); SqlDataAdapter adapter = new SqlDataAdapter(); DataTable data = new DataTable("ITEMS"); command.Connection = new SqlConnection(this.mStringConnection); command.Parameters.AddWithValue("@ITMBS", itbms); command.Parameters.AddWithValue("@LOCATION", LOCATION); command.CommandType = CommandType.Text; string query = ""; query += "SELECT "; query += "IV.LOCNCODE "; query += ",IV.ITEMNMBR "; query += ",(IV.QTYONHND-IV.ATYALLOC) AS DISP "; query += ",ITEM.UOFM "; query += ",ITEM.ITEMDESC "; query += ",ITEM.ITEMTYPE "; query += ",ITEM.ITMCLSCD "; query += ",ITEM.CURRCOST "; query += ",ITEM.QTYBSUOM "; query += ",ITEM.PRICE "; query += ",ITEM.PRICEWITMBS "; query += ",ITEM.ITMBSPCT "; query += ",ITEM.PRCLEVEL "; query += "FROM IV00102 AS IV "; query += "INNER JOIN (SELECT DISTINCT IV.ITEMNMBR "; query += ",IV.ITEMDESC,IV.ITEMTYPE,PRCLST.UOFM,ITMCLSCD,CURRCOST,MAX(UOFM.QTYBSUOM) AS QTYBSUOM "; query += ",CASE IV.PRICMTHD "; query += "WHEN 1 THEN ROUND(MAX(PRCLST.UOMPRICE) * MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1) "; query += "WHEN 2 THEN ROUND((MAX(CUR.LISTPRCE)*(MAX(PRCLST.UOMPRICE)/100)) * MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1) "; query += "WHEN 3 THEN ROUND((MAX(IV.CURRCOST) + (MAX(IV.CURRCOST) * (MAX(PRCLST.UOMPRICE)/100))) * MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1) "; query += "WHEN 4 THEN ROUND((MAX(IV.STNDCOST) + (MAX(IV.STNDCOST) * (MAX(PRCLST.UOMPRICE)/100))) * MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1) "; query += "WHEN 5 THEN ROUND((MAX(IV.CURRCOST) + ((MAX(IV.CURRCOST) * (MAX(PRCLST.UOMPRICE)/100))/((100-MAX(PRCLST.UOMPRICE))/100))) * MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1) "; query += "WHEN 6 THEN ROUND((MAX(IV.STNDCOST) + ((MAX(IV.STNDCOST) * (MAX(PRCLST.UOMPRICE)/100))/((100-MAX(PRCLST.UOMPRICE))/100))) * MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1) "; query += "END AS PRICE "; query += ",CASE IV.PRICMTHD "; query += "WHEN 1 THEN ISNULL((MAX(PRCLST.UOMPRICE)+(MAX(PRCLST.UOMPRICE)*((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS)/100))) * MAX(UOFM.QTYBSUOM),ROUND(MAX(PRCLST.UOMPRICE) * MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1)) "; query += "WHEN 2 THEN ISNULL((MAX(CUR.LISTPRCE)*(MAX(PRCLST.UOMPRICE)/100) /**/ + ((MAX(CUR.LISTPRCE)*(MAX(PRCLST.UOMPRICE)/100))*((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS)/100))) * MAX(UOFM.QTYBSUOM),ROUND((MAX(CUR.LISTPRCE)*(MAX(PRCLST.UOMPRICE)/100))* MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1) ) "; query += "WHEN 3 THEN ISNULL((MAX(IV.CURRCOST) + (MAX(IV.CURRCOST) * (MAX(PRCLST.UOMPRICE)/100)) /**/ + ((MAX(IV.CURRCOST) + (MAX(IV.CURRCOST) * (MAX(PRCLST.UOMPRICE)/100)))*((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS)/100)))* MAX(UOFM.QTYBSUOM),ROUND((MAX(IV.CURRCOST) + (MAX(IV.CURRCOST) * (MAX(PRCLST.UOMPRICE)/100)))* MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1)) "; query += "WHEN 4 THEN ISNULL((MAX(IV.STNDCOST) + (MAX(IV.STNDCOST) * (MAX(PRCLST.UOMPRICE)/100)) /**/ + (MAX(IV.STNDCOST) + (MAX(IV.STNDCOST) * (MAX(PRCLST.UOMPRICE)/100))*((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS)/100)))* MAX(UOFM.QTYBSUOM),ROUND((MAX(IV.STNDCOST) + (MAX(IV.STNDCOST) * (MAX(PRCLST.UOMPRICE)/100)))* MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1)) "; query += "WHEN 5 THEN ISNULL((MAX(IV.CURRCOST) + ((MAX(IV.CURRCOST) * (MAX(PRCLST.UOMPRICE)/100))/((100-MAX(PRCLST.UOMPRICE))/100)) /**/ + ((MAX(IV.CURRCOST) + ((MAX(IV.CURRCOST) * (MAX(PRCLST.UOMPRICE)/100))/((100-MAX(PRCLST.UOMPRICE))/100)))*((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS)/100)))* MAX(UOFM.QTYBSUOM),ROUND((MAX(IV.CURRCOST) + ((MAX(IV.CURRCOST) * (MAX(PRCLST.UOMPRICE)/100))/((100-MAX(PRCLST.UOMPRICE))/100)))* MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1)) "; query += "WHEN 6 THEN ISNULL((MAX(IV.STNDCOST) + ((MAX(IV.STNDCOST) * (MAX(PRCLST.UOMPRICE)/100))/((100-MAX(PRCLST.UOMPRICE))/100)) /**/+ ((MAX(IV.STNDCOST) + ((MAX(IV.STNDCOST) * (MAX(PRCLST.UOMPRICE)/100))/((100-MAX(PRCLST.UOMPRICE))/100)))*((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS)/100)))* MAX(UOFM.QTYBSUOM),ROUND((MAX(IV.STNDCOST) + ((MAX(IV.STNDCOST) * (MAX(PRCLST.UOMPRICE)/100))/((100-MAX(PRCLST.UOMPRICE))/100)))* MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1)) "; query += "END AS PRICEWITMBS "; query += ",ISNULL((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS),0) AS ITMBSPCT "; query += ",PRCLST.PRCLEVEL "; query += "FROM IV00107 AS PRCLVL "; query += "INNER JOIN IV00101 AS IV ON IV.ITEMNMBR=PRCLVL.ITEMNMBR "; query += "INNER JOIN IV00108 AS PRCLST ON PRCLVL.ITEMNMBR=PRCLST.ITEMNMBR AND PRCLVL.PRCLEVEL=PRCLST.PRCLEVEL AND PRCLVL.UOFM=PRCLST.UOFM "; query += "INNER JOIN IV00105 AS CUR ON CUR.ITEMNMBR = IV.ITEMNMBR AND PRCLST.CURNCYID = CUR.CURNCYID "; query += "INNER JOIN IV00106 AS UOFM ON IV.ITEMNMBR=UOFM.ITEMNMBR AND PRCLST.UOFM=UOFM.UOFM "; query += "WHERE PRCLST.PRCLEVEL='GALAPAGO' "; query += "GROUP BY IV.ITEMNMBR "; query += ",IV.ITEMDESC,IV.ITEMTYPE "; query += ",PRCLST.UOFM "; query += ",ITMCLSCD "; query += ",CURRCOST "; query += ",IV.PRICMTHD "; query += ",PRCLST.PRCLEVEL) AS ITEM ON ITEM.ITEMNMBR=IV.ITEMNMBR "; query += "WHERE IV.LOCNCODE <> '' AND IV.LOCNCODE = @LOCATION "; command.CommandText = query; try { adapter.SelectCommand = command; adapter.Fill(data); } catch (Exception ex) { IEvent e = new ErrorEvent("", "", ex.Message); e.Publish(); } finally { //nothing } return(data); }
private DataTable getAllItemsData() { SqlCommand command = new SqlCommand(); SqlDataAdapter adapter = new SqlDataAdapter(); DataTable data = new DataTable("ITEMMSTR"); command.Connection = new SqlConnection(this.mStringConnection); command.Parameters.AddWithValue("@ITMBS", this.mItmbs); command.CommandType = CommandType.Text; command.CommandText = "SELECT DISTINCT IV.ITEMNMBR " + ",IV.ITEMDESC,IV.ITEMTYPE,PRCLST.UOFM,ITMCLSCD,CURRCOST,MAX(UOFM.QTYBSUOM) AS QTYBSUOM " + ",CASE IV.PRICMTHD " + "WHEN 1 THEN ROUND(MAX(PRCLST.UOMPRICE) * MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1) " + "WHEN 2 THEN ROUND((MAX(CUR.LISTPRCE)*(MAX(PRCLST.UOMPRICE)/100)) * MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1) " + "WHEN 3 THEN ROUND((MAX(IV.CURRCOST) + (MAX(IV.CURRCOST) * (MAX(PRCLST.UOMPRICE)/100))) * MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1) " + "WHEN 4 THEN ROUND((MAX(IV.STNDCOST) + (MAX(IV.STNDCOST) * (MAX(PRCLST.UOMPRICE)/100))) * MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1) " + "WHEN 5 THEN ROUND((MAX(IV.CURRCOST) + ((MAX(IV.CURRCOST) * (MAX(PRCLST.UOMPRICE)/100))/((100-MAX(PRCLST.UOMPRICE))/100))) * MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1) " + "WHEN 6 THEN ROUND((MAX(IV.STNDCOST) + ((MAX(IV.STNDCOST) * (MAX(PRCLST.UOMPRICE)/100))/((100-MAX(PRCLST.UOMPRICE))/100))) * MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1) " + "END AS PRICE " + ",CASE IV.PRICMTHD " + "WHEN 1 THEN ISNULL((MAX(PRCLST.UOMPRICE)+(MAX(PRCLST.UOMPRICE)*((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS)/100))) * MAX(UOFM.QTYBSUOM),ROUND(MAX(PRCLST.UOMPRICE) * MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1)) " + "WHEN 2 THEN ISNULL((MAX(CUR.LISTPRCE)*(MAX(PRCLST.UOMPRICE)/100) /**/ + ((MAX(CUR.LISTPRCE)*(MAX(PRCLST.UOMPRICE)/100))*((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS)/100))) * MAX(UOFM.QTYBSUOM),ROUND((MAX(CUR.LISTPRCE)*(MAX(PRCLST.UOMPRICE)/100))* MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1) ) " + "WHEN 3 THEN ISNULL((MAX(IV.CURRCOST) + (MAX(IV.CURRCOST) * (MAX(PRCLST.UOMPRICE)/100)) /**/ + ((MAX(IV.CURRCOST) + (MAX(IV.CURRCOST) * (MAX(PRCLST.UOMPRICE)/100)))*((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS)/100)))* MAX(UOFM.QTYBSUOM),ROUND((MAX(IV.CURRCOST) + (MAX(IV.CURRCOST) * (MAX(PRCLST.UOMPRICE)/100)))* MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1)) " + "WHEN 4 THEN ISNULL((MAX(IV.STNDCOST) + (MAX(IV.STNDCOST) * (MAX(PRCLST.UOMPRICE)/100)) /**/ + (MAX(IV.STNDCOST) + (MAX(IV.STNDCOST) * (MAX(PRCLST.UOMPRICE)/100))*((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS)/100)))* MAX(UOFM.QTYBSUOM),ROUND((MAX(IV.STNDCOST) + (MAX(IV.STNDCOST) * (MAX(PRCLST.UOMPRICE)/100)))* MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1)) " + "WHEN 5 THEN ISNULL((MAX(IV.CURRCOST) + ((MAX(IV.CURRCOST) * (MAX(PRCLST.UOMPRICE)/100))/((100-MAX(PRCLST.UOMPRICE))/100)) /**/ + ((MAX(IV.CURRCOST) + ((MAX(IV.CURRCOST) * (MAX(PRCLST.UOMPRICE)/100))/((100-MAX(PRCLST.UOMPRICE))/100)))*((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS)/100)))* MAX(UOFM.QTYBSUOM),ROUND((MAX(IV.CURRCOST) + ((MAX(IV.CURRCOST) * (MAX(PRCLST.UOMPRICE)/100))/((100-MAX(PRCLST.UOMPRICE))/100)))* MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1)) " + "WHEN 6 THEN ISNULL((MAX(IV.STNDCOST) + ((MAX(IV.STNDCOST) * (MAX(PRCLST.UOMPRICE)/100))/((100-MAX(PRCLST.UOMPRICE))/100)) /**/+ ((MAX(IV.STNDCOST) + ((MAX(IV.STNDCOST) * (MAX(PRCLST.UOMPRICE)/100))/((100-MAX(PRCLST.UOMPRICE))/100)))*((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS)/100)))* MAX(UOFM.QTYBSUOM),ROUND((MAX(IV.STNDCOST) + ((MAX(IV.STNDCOST) * (MAX(PRCLST.UOMPRICE)/100))/((100-MAX(PRCLST.UOMPRICE))/100)))* MAX(UOFM.QTYBSUOM),AVG(IV.DECPLCUR)-1)) " + "END AS PRICEWITMBS " + ",ISNULL((SELECT TXDTLPCT FROM TX00201 WHERE TAXDTLID=@ITMBS),0) AS ITMBSPCT " + ",PRCLST.PRCLEVEL " + "FROM IV00107 AS PRCLVL " + "INNER JOIN IV00101 AS IV ON IV.ITEMNMBR=PRCLVL.ITEMNMBR AND PRCLVL.PRCLEVEL='GALAPAGO' " + "INNER JOIN IV00108 AS PRCLST ON PRCLVL.ITEMNMBR=PRCLST.ITEMNMBR AND PRCLVL.PRCLEVEL=PRCLST.PRCLEVEL AND PRCLVL.UOFM=PRCLST.UOFM " + "INNER JOIN IV00105 AS CUR ON CUR.ITEMNMBR = IV.ITEMNMBR AND PRCLST.CURNCYID = CUR.CURNCYID " + "INNER JOIN IV00106 AS UOFM ON IV.ITEMNMBR=UOFM.ITEMNMBR AND PRCLST.UOFM=UOFM.UOFM " + "GROUP BY IV.ITEMNMBR " + ",IV.ITEMDESC,IV.ITEMTYPE " + ",PRCLST.UOFM " + ",ITMCLSCD " + ",CURRCOST " + ",IV.PRICMTHD " + ",PRCLST.PRCLEVEL "; try { adapter.SelectCommand = command; adapter.Fill(data); } catch (Exception ex) { IEvent e = new ErrorEvent("", "", ex.Message); e.Publish(); } finally { //nothing } return(data); }
void thread() { DataTable itemsData = getAllItemsData(); int total = itemsData.Rows.Count; // esrcibo en el nowin porque van para premiumsoft foreach (DataRow row in itemsData.Rows) { string FileName = "GP_TINV_{0}.xml"; string ITEMNMBR = row["ITEMNMBR"].ToString().Trim(); string ITEMDESC = row["ITEMDESC"].ToString().Trim(); string ITMCLSCD = row["ITMCLSCD"].ToString().Trim(); string CURRCOST = row["CURRCOST"].ToString().Trim(); string PRICE = row["PRICE"].ToString().Trim(); string PRICEWITMBS = row["PRICEWITMBS"].ToString().Trim(); string ITMBSPCT = row["ITMBSPCT"].ToString().Trim(); int ITEMTYPE = Int16.Parse(row["ITEMTYPE"].ToString()); string UOFM = row["UOFM"].ToString().Trim(); IEvent e = new InfoEvent("", "", "Iniciando la creación del archivo XML '" + String.Format(FileName, ITEMNMBR) + "'."); e.Publish(); // xml // XmlDocument doc = new XmlDocument(); /* Lines */ XmlElement Raiz = doc.CreateElement(string.Empty, "raiz", string.Empty); /* Lines */ Models.Item item = new Models.Item(); try { //XmlDeclaration xmlDeclaration = doc.CreateXmlDeclaration("1.0", "UTF-8", null); //XmlElement root = doc.DocumentElement; //doc.InsertBefore(xmlDeclaration, root); //doc.AppendChild(Raiz); //XmlElement element2 = doc.CreateElement(string.Empty, "item", string.Empty); //Raiz.AppendChild(element2); //XmlElement element3 = doc.CreateElement(string.Empty, "codigo", string.Empty); item.No = ITEMNMBR;//XmlText text1 = doc.CreateTextNode(ITEMNMBR); //element3.AppendChild(text1); //element2.AppendChild(element3); //XmlElement element4 = doc.CreateElement(string.Empty, "nombre", string.Empty); item.Description = ITEMDESC; //XmlText text2 = doc.CreateTextNode(ITEMDESC); //element4.AppendChild(text2); //element2.AppendChild(element4); //XmlElement element5 = doc.CreateElement(string.Empty, "codigogrupo", string.Empty); //XmlText text3 = doc.CreateTextNode(ITMCLSCD); //element5.AppendChild(text3); //element2.AppendChild(element5); //XmlElement element6 = doc.CreateElement(string.Empty, "costo", string.Empty); //XmlText text4 = doc.CreateTextNode(CURRCOST.ToString().Replace(",",".")); //element6.AppendChild(text4); //element2.AppendChild(element6); //XmlElement element7 = doc.CreateElement(string.Empty, "precio_neto", string.Empty); item.PricewithoutVAT = (decimal)Convert.ToDecimal(PRICE); //XmlText text5 = doc.CreateTextNode(PRICE.ToString().Replace(",", ".")); //element7.AppendChild(text5); //element2.AppendChild(element7); //XmlElement element8 = doc.CreateElement(string.Empty, "precio_con_itbms", string.Empty); item.PriceincludingVAT = (decimal)Convert.ToDecimal(PRICEWITMBS); //XmlText text6 = doc.CreateTextNode(PRICEWITMBS.ToString().Replace(",", ".")); //element8.AppendChild(text6); //element2.AppendChild(element8); //XmlElement element9 = doc.CreateElement(string.Empty, "porcentaje_itbms", string.Empty); item.VAT = (decimal)Convert.ToDecimal(ITMBSPCT.ToString());//XmlText text7 = doc.CreateTextNode(ITMBSPCT.ToString().Replace(",", ".")); //element9.AppendChild(text7); //element2.AppendChild(element9); //XmlElement element10 = doc.CreateElement(string.Empty, "tipo", string.Empty); //XmlText text8 = doc.CreateTextNode(ITEMTYPE.ToString()); //element10.AppendChild(text8); //element2.AppendChild(element10); //XmlElement element11 = doc.CreateElement(string.Empty, "unidad_de_medida", string.Empty); //XmlText text9 = doc.CreateTextNode(UOFM); //element11.AppendChild(text9); //element2.AppendChild(element11); if (this.NowPathIn.ToCharArray().Last() == '/' || this.NowPathIn.ToCharArray().Last() == '\\') { if (!System.IO.File.Exists(this.mNowPathOut + string.Format(FileName, ITEMNMBR))) { Models.Item.SaveAs(this.mNowPathOut + string.Format(FileName, ITEMNMBR), item); // doc.Save(this.mNowPathOut + string.Format(FileName, ITEMNMBR)); } } else { if (!System.IO.File.Exists(this.mNowPathOut + "/" + string.Format(FileName, ITEMNMBR))) { Models.Item.SaveAs(this.mNowPathOut + "/" + string.Format(FileName, ITEMNMBR), item); // doc.Save(this.mNowPathOut + "/" + string.Format(FileName, ITEMNMBR)); } } total--; ObserverManager.Instance.addSubject(new ProgressSubject(total, itemsData.Rows.Count - total)); IEvent e2 = new InfoEvent("", "", "El archivo '" + String.Format(FileName, ITEMNMBR) + "'. fue creado correctamente"); e2.Publish(); } catch (Exception ex) { IEvent err = new ErrorEvent("", "", "No pudo crear el archivo xml correctamente. Mensaje: " + ex.Message); err.Publish(); } } ObserverManager.Instance.addSubject(new ProgressSubject(0, 0)); }
private bool InsertItem(Models.Item item) { bool res = false; SqlCommand command; command = new SqlCommand("dbo.spUpdateItem", new SqlConnection(this.StringConnection)); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@No", item.No); command.Parameters.AddWithValue("@Description", item.Description); command.Parameters.AddWithValue("@Descripcion2", item.Descripcion2); command.Parameters.AddWithValue("@Qty_Inventory", item.Qty_Inventory); command.Parameters.AddWithValue("@Is_Use", 1); command.Parameters.AddWithValue("@Billed_Units", 0); command.Parameters.AddWithValue("@Qty_Purshase", 0); command.Parameters.AddWithValue("@Qty_Sales", 0); command.Parameters.AddWithValue("@Amount_Purchases", 0); command.Parameters.AddWithValue("@Amount_Sales", 0); command.Parameters.AddWithValue("@Qty_Positive_adjustment", 0); command.Parameters.AddWithValue("@Qty_Negative_adjustment", 0); command.Parameters.AddWithValue("@Amount_Positive_adjustment", 0); command.Parameters.AddWithValue("@Amount_Negative_adjustment", 0); command.Parameters.AddWithValue("@Qty_in_Order", 0); command.Parameters.AddWithValue("@Qty_transfer", 0); command.Parameters.AddWithValue("@Transfer_amount", 0); command.Parameters.AddWithValue("@Price_without_VAT", item.PricewithoutVAT); command.Parameters.AddWithValue("@Price_including_VAT", item.PriceincludingVAT); command.Parameters.AddWithValue("@VAT", item.VAT); command.Parameters.AddWithValue("@Qty_in_Transit", 0); command.Parameters.AddWithValue("@Qty_Sale_Returns", 0); command.Parameters.AddWithValue("@Qty_Purchase_Returns", 0); command.Parameters.AddWithValue("@Allow_Negative_Inventory", 0); command.Parameters.AddWithValue("@Qty_Negative", 0); command.Parameters.AddWithValue("@Auto_Code", ""); command.Parameters.AddWithValue("@Variant", ""); command.Parameters.AddWithValue("@Weight", 0); command.Parameters.AddWithValue("@Base_Unit_of_Measure_Purched", ""); command.Parameters.AddWithValue("@Base_Unit_of_Measure_Sales", ""); command.Parameters.AddWithValue("@Barcode", ""); command.Parameters.AddWithValue("@Allow_Discount", 1); command.Parameters.AddWithValue("@Cost_Unity", 0); command.Parameters.AddWithValue("@Cost_Standard", "0"); command.Parameters.AddWithValue("@Last_cost", 0); command.Parameters.AddWithValue("@date_last_cost", DateTime.Now); command.Parameters.AddWithValue("@Cost_indirect", 0); command.Parameters.AddWithValue("@Cost_Ajust", 0); command.Parameters.AddWithValue("@Profit", 0); command.Parameters.AddWithValue("@Profit_percentage", 0); command.Parameters.AddWithValue("@Special_Groups", ""); command.Parameters.AddWithValue("@Sustitute", ""); command.Parameters.AddWithValue("@Cross_References", ""); command.Parameters.AddWithValue("@Additional_text", ""); command.Parameters.AddWithValue("@Imagen", DBNull.Value).SqlDbType = SqlDbType.Image; command.Parameters.AddWithValue("@Translations", ""); command.Parameters.AddWithValue("@Block", 0); command.Parameters.AddWithValue("@No_Vendor", ""); command.Parameters.AddWithValue("@Reorder_point", 0); command.Parameters.AddWithValue("@Qty_Reorder_point", 0); command.Parameters.AddWithValue("@Inventory_Security", 0); command.Parameters.AddWithValue("@Reserve", 0); command.Parameters.AddWithValue("@Lot_size", 0); command.Parameters.AddWithValue("@No_Serial", ""); command.Parameters.AddWithValue("@No_Lot", ""); command.Parameters.AddWithValue("@Calculation_Due", ""); command.Parameters.AddWithValue("@Due_Date", DateTime.Now); command.Parameters.AddWithValue("@Creation_date", DateTime.Now); command.Parameters.AddWithValue("@Created_by_User", ""); command.Parameters.AddWithValue("@Last_modified_date", DateTime.Now); command.Parameters.AddWithValue("@Last_modified_by_the_user", ""); command.Parameters.AddWithValue("@Warning_shortages", 0); command.Parameters.AddWithValue("@Location", ""); command.Parameters.AddWithValue("@Start_Date_counting", DateTime.Now); command.Parameters.AddWithValue("@End_Date_counting", DateTime.Now); command.Parameters.AddWithValue("@VAT_Prod_Posting_Group", "01"); command.Parameters.AddWithValue("@VAT_Bus_Posting_Group", "01"); command.Parameters.AddWithValue("@Item_Category_Code", "01"); command.Parameters.AddWithValue("@Product_Group_Code", "01"); try { if (command.Connection.State != ConnectionState.Open) { command.Connection.Open(); } res = (command.ExecuteNonQuery() >= 0); } catch (Exception ex) { res = false; IEvent e = new ErrorEvent("", "", "TransactionAddInventoryMovement::" + ex.Message); e.Publish(); } finally { if (command.Connection.State != ConnectionState.Closed) { command.Connection.Close(); } } return(res); }
void thread() { DataTable Transactions = getAllLocation(); string prevDoc = ""; int total = Transactions.Rows.Count; // esrcibo en el nowin porque van para premiumsoft foreach (DataRow row in Transactions.Rows) { if (prevDoc != row["LOCNCODE"].ToString().Trim()) { DataTable TransactionDetail = getInventorySnapshot(row["LOCNCODE"].ToString().Trim(), mItmbs); string ADJUST = row["LOCNCODE"].ToString().Trim(); string FileName = "GP_INI_{0}.xml"; IEvent e = new InfoEvent("", "", "Iniciando la creación del archivo XML '" + String.Format(FileName, ADJUST) + "'."); e.Publish(); // xml // XmlDocument doc = new XmlDocument(); XmlDeclaration xmlDeclaration = doc.CreateXmlDeclaration("1.0", "UTF-8", null); XmlElement root = doc.DocumentElement; doc.InsertBefore(xmlDeclaration, root); /* Lines */ XmlElement Lines = doc.CreateElement(string.Empty, "lines", string.Empty); /* Lines */ ///////// Models.InventoryAdjustment ia = new Models.InventoryAdjustment(); foreach (DataRow det in TransactionDetail.Rows) { string DOCNUMBR = det["LOCNCODE"].ToString().Trim(); string USERID = "UNKNOWN"; string DOCDATE = DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day + " 00:00"; string TIME = DateTime.Now.Hour + ":" + DateTime.Now.Minute + ":00"; string ITEMNMBR = det["ITEMNMBR"].ToString().Trim(); Models.ItemAvailability iav = new Models.ItemAvailability(); try { if (det["PRCLEVEL"].ToString().Trim() == "GALAPAGO") { XmlElement Item = doc.CreateElement(string.Empty, "articulo", string.Empty); ///* document */ //XmlElement document = doc.CreateElement(string.Empty, "documento", string.Empty); iav.Codigoalmacen = det["LOCNCODE"].ToString().Trim();//XmlText document_text = doc.CreateTextNode(det["LOCNCODE"].ToString().Trim()); //document.AppendChild(document_text); //Item.AppendChild(document); ///* document */ ///* realizador */ //XmlElement realizador = doc.CreateElement(string.Empty, "realizador", string.Empty); iav.Realizador = USERID;//XmlText realizador_text = doc.CreateTextNode("UNKNOWN"); //realizador.AppendChild(realizador_text); //Item.AppendChild(realizador); ///* realizador */ ///* motivo */ //XmlElement motivo = doc.CreateElement(string.Empty, "motivo", string.Empty); iav.Motivo = "ESTATUS ACTUAL DE INVENTARIO";//XmlText motivo_text = doc.CreateTextNode("ESTATUS ACTUAL DE INVENTARIO"); //motivo.AppendChild(motivo_text); //Item.AppendChild(motivo); ///* motivo */ ///* fecha */ //XmlElement fecha = doc.CreateElement(string.Empty, "fecha", string.Empty); iav.Fecha = DOCDATE;//XmlText fecha_text = doc.CreateTextNode(DOCDATE); //fecha.AppendChild(fecha_text); //Item.AppendChild(fecha); ///* fecha */ ///* hora */ //XmlElement hora = doc.CreateElement(string.Empty, "hora", string.Empty); iav.Hora = TIME;//XmlText hora_text = doc.CreateTextNode(TIME); //hora.AppendChild(hora_text); //Item.AppendChild(hora); ///* hora */ ///* codigo */ //XmlElement codigo = doc.CreateElement(string.Empty, "codigo", string.Empty); iav.Codigo = ITEMNMBR;//XmlText codigo_text = doc.CreateTextNode(ITEMNMBR); //codigo.AppendChild(codigo_text); //Item.AppendChild(codigo); ///* codigo */ ///* nombre */ //XmlElement nombre = doc.CreateElement(string.Empty, "nombre", string.Empty); iav.Nombre = det["ITEMDESC"].ToString().Trim();//XmlText nombre_text = doc.CreateTextNode(det["ITEMDESC"].ToString().Trim()); //nombre.AppendChild(nombre_text); //Item.AppendChild(nombre); ///* nombre */ ///* grupo */ //XmlElement grupo = doc.CreateElement(string.Empty, "grupo", string.Empty); iav.Grupo = det["ITMCLSCD"].ToString().Trim();//XmlText grupo_text = doc.CreateTextNode(det["ITMCLSCD"].ToString().Trim()); //grupo.AppendChild(grupo_text); //Item.AppendChild(grupo); ///* grupo */ ///* tipoproceso */ //XmlElement tipoproceso = doc.CreateElement(string.Empty, "tipoproceso", string.Empty); iav.Tipoproceso = 1;//XmlText tipoproceso_text = doc.CreateTextNode("1"); //tipoproceso.AppendChild(tipoproceso_text); //Item.AppendChild(tipoproceso); ///* tipoproceso */ ///* codigoalmacen */ //XmlElement codigoalmacen = doc.CreateElement(string.Empty, "codigoalmacen", string.Empty); iav.Codigoalmacen = det["LOCNCODE"].ToString().Trim();//XmlText codigoalmacen_text = doc.CreateTextNode(det["LOCNCODE"].ToString().Trim()); //codigoalmacen.AppendChild(codigoalmacen_text); //Item.AppendChild(codigoalmacen); ///* codigoalmacen */ ///* usuario */ //XmlElement usuario = doc.CreateElement(string.Empty, "descripcion", string.Empty); iav.Descripcion = row["LOCNDSCR"].ToString().Trim();//XmlText usuario_text = doc.CreateTextNode(row["LOCNDSCR"].ToString().Trim()); //usuario.AppendChild(usuario_text); //Item.AppendChild(usuario); ///* usuario */ ///* ubicacion */ //XmlElement ubicacion = doc.CreateElement(string.Empty, "usuario", string.Empty); iav.Usuario = "UNKNOWN"; //XmlText ubicacion_text = doc.CreateTextNode("UNKNOWN"); //ubicacion.AppendChild(ubicacion_text); //Item.AppendChild(ubicacion); ///* ubicacion */ ///* descripción */ //XmlElement descripcion = doc.CreateElement(string.Empty, "ubicacion", string.Empty); iav.Ubicacion = row["ADDRESS1"].ToString().Trim();//XmlText descripcion_text = doc.CreateTextNode(row["ADDRESS1"].ToString().Trim()); //descripcion.AppendChild(descripcion_text); //Item.AppendChild(descripcion); ///* descripción */ ///* precio */ //XmlElement precio = doc.CreateElement(string.Empty, "precio_neto", string.Empty); iav.Precio_neto = (decimal)Convert.ToDecimal(det["PRICE"].ToString().Trim().Replace(",", "."));//XmlText precio_text = doc.CreateTextNode(det["PRICE"].ToString().Trim().Replace(",", ".")); //precio.AppendChild(precio_text); //Item.AppendChild(precio); ///* precio */ ///* cost */ //XmlElement cost = doc.CreateElement(string.Empty, "precio_con_itbms", string.Empty); iav.Precio_con_itbms = (decimal)Convert.ToDecimal(det["PRICEWITMBS"].ToString().Trim().Replace(",", ".")); //XmlText cost_text = doc.CreateTextNode(det["PRICEWITMBS"].ToString().Trim().Replace(",", ".")); //cost.AppendChild(cost_text); //Item.AppendChild(cost); ///* costo */ ///* costo */ //#region "COSTO NODE" //XmlElement costo = doc.CreateElement(string.Empty, "costo", string.Empty); iav.Costo = (decimal)Convert.ToDecimal(det["CURRCOST"].ToString().Trim().Replace(",", "."));//XmlText costo_text = doc.CreateTextNode(det["CURRCOST"].ToString().Trim().Replace(",", ".")); //costo.AppendChild(costo_text); //Item.AppendChild(costo); //#endregion ///* costo */ //XmlElement element7 = doc.CreateElement(string.Empty, "porcentaje_itbms", string.Empty); iav.Porcentaje_itbms = (decimal)Convert.ToDecimal(det["ITMBSPCT"].ToString().Trim().Replace(",", ".")); //XmlText text5 = doc.CreateTextNode(det["ITMBSPCT"].ToString().Trim().Replace(",", ".")); //element7.AppendChild(text5); //Item.AppendChild(element7); //XmlElement element8 = doc.CreateElement(string.Empty, "tipo", string.Empty); iav.Tipo = (int)Convert.ToInt32(det["ITEMTYPE"].ToString().Trim());//XmlText text6 = doc.CreateTextNode(det["ITEMTYPE"].ToString().Trim()); //element8.AppendChild(text6); //Item.AppendChild(element8); //XmlElement element9 = doc.CreateElement(string.Empty, "cantidad", string.Empty); iav.Cantidad = (decimal)Convert.ToDecimal(det["DISP"].ToString().Trim().Replace(",", "."));//XmlText text7 = doc.CreateTextNode(det["DISP"].ToString().Trim().Replace(",", ".")); //element9.AppendChild(text7); //Item.AppendChild(element9); //XmlElement element10 = doc.CreateElement(string.Empty, "unidad_de_medida", string.Empty); iav.Unidad_de_medida = det["UOFM"].ToString().Trim();//XmlText text8 = doc.CreateTextNode(det["UOFM"].ToString().Trim()); //element10.AppendChild(text8); //Item.AppendChild(element10); ia.Add(iav);//Lines.AppendChild(Item); } } catch (Exception ex) { IEvent err = new ErrorEvent("", "", "No pudo crear el archivo xml correctamente. Mensaje: " + ex.Message); err.Publish(); } } doc.AppendChild(Lines); if (this.NowPathIn.ToCharArray().Last() == '/' || this.NowPathIn.ToCharArray().Last() == '\\') { if (!System.IO.File.Exists(this.mNowPathOut + string.Format(FileName, ADJUST))) { Models.InventoryAdjustment.SaveAs(this.mNowPathOut + string.Format(FileName, ADJUST), ia);// doc.Save(this.mNowPathOut + string.Format(FileName, ADJUST)); } } else { if (!System.IO.File.Exists(this.mNowPathOut + "/" + string.Format(FileName, ADJUST))) { Models.InventoryAdjustment.SaveAs(this.mNowPathOut + "/" + string.Format(FileName, ADJUST), ia);// doc.Save(this.mNowPathOut + "/" + string.Format(FileName, ADJUST)); } } total--; ObserverManager.Instance.addSubject(new ProgressSubject(total, Transactions.Rows.Count - total)); IEvent e2 = new InfoEvent("", "", "El archivo '" + String.Format(FileName, ADJUST) + "'. fue creado correctamente"); e2.Publish(); } prevDoc = row["LOCNCODE"].ToString().Trim(); } ObserverManager.Instance.addSubject(new ProgressSubject(0, 0)); }
void thread() { DataTable Salesperson = getSalespersons(); int total = Salesperson.Rows.Count; //// // esrcibo en el nowin porque van para premiumsoft foreach (DataRow row in Salesperson.Rows) { string FileName = "GP_US_{0}.xml"; string SLPRSNID = row["SLPRSNID"].ToString().Trim(); string SLPRSNFN = row["SLPRSNFN"].ToString().Trim(); string SPRSNSMN = row["SPRSNSMN"].ToString().Trim(); string SPRSNSLN = row["SPRSNSLN"].ToString().Trim(); string ADDRESS1 = row["ADDRESS1"].ToString().Trim(); string ADDRESS2 = row["ADDRESS2"].ToString().Trim(); string ADDRESS3 = row["ADDRESS3"].ToString().Trim(); string CITY = row["CITY"].ToString().Trim(); string STATE = row["STATE"].ToString().Trim(); string ZIP = row["ZIP"].ToString().Trim(); string COUNTRY = row["COUNTRY"].ToString().Trim(); string PHONE1 = row["PHONE1"].ToString().Trim(); string PHONE2 = row["PHONE2"].ToString().Trim(); string PHONE3 = row["PHONE3"].ToString().Trim(); string FAX = row["FAX"].ToString().Trim(); Models.Salesperson salesperson = new Models.Salesperson(); IEvent e = new InfoEvent("", "", "Iniciando la creación del archivo XML '" + String.Format(FileName, SLPRSNID) + "'."); e.Publish(); // xml // XmlDocument doc = new XmlDocument(); /* Lines */ XmlElement Raiz = doc.CreateElement(string.Empty, "raiz", string.Empty); /* Lines */ try { //XmlDeclaration xmlDeclaration = doc.CreateXmlDeclaration("1.0", "UTF-8", null); //XmlElement root = doc.DocumentElement; //doc.InsertBefore(xmlDeclaration, root); //doc.AppendChild(Raiz); //XmlElement element2 = doc.CreateElement(string.Empty, "vendedor", string.Empty); //Raiz.AppendChild(element2); //XmlElement element3 = doc.CreateElement(string.Empty, "codigo", string.Empty); salesperson.Code = SLPRSNID; //XmlText text1 = doc.CreateTextNode(SLPRSNID); //element3.AppendChild(text1); //element2.AppendChild(element3); //XmlElement element4 = doc.CreateElement(string.Empty, "nombres", string.Empty); salesperson.Firts_Name = SLPRSNFN; //XmlText text2 = doc.CreateTextNode(SLPRSNFN); //element4.AppendChild(text2); //element2.AppendChild(element4); //XmlElement element5 = doc.CreateElement(string.Empty, "apellidos", string.Empty); salesperson.Last_Name = SPRSNSMN + " " + SPRSNSLN; //XmlText text3 = doc.CreateTextNode(SPRSNSMN + " " + SPRSNSLN); //element5.AppendChild(text3); //element2.AppendChild(element5); //XmlElement element6 = doc.CreateElement(string.Empty, "ruc", string.Empty); salesperson.RUC = ""; //XmlText text4 = doc.CreateTextNode(""); //element6.AppendChild(text4); //element2.AppendChild(element6); //XmlElement element7 = doc.CreateElement(string.Empty, "address", string.Empty); salesperson.Address = (ADDRESS1 + " " + ADDRESS2 + " " + ADDRESS3).Trim(); //XmlText text5 = doc.CreateTextNode(ADDRESS1 + " " + ADDRESS2 + " " + ADDRESS3); //element7.AppendChild(text5); //element2.AppendChild(element7); //XmlElement element8 = doc.CreateElement(string.Empty, "porcentaje_comision", string.Empty); salesperson.ComisionPCT = 0; //XmlText text6 = doc.CreateTextNode("0.00000"); //element8.AppendChild(text6); //element2.AppendChild(element8); //XmlElement element9 = doc.CreateElement(string.Empty, "email", string.Empty); salesperson.EMail = ""; //XmlText text7 = doc.CreateTextNode(""); //element9.AppendChild(text7); //element2.AppendChild(element9); //XmlElement element10 = doc.CreateElement(string.Empty, "phone", string.Empty); salesperson.Phone = PHONE1; //XmlText text8 = doc.CreateTextNode(PHONE1); //element10.AppendChild(text8); //element2.AppendChild(element10); if (this.NowPathIn.ToCharArray().Last() == '/' || this.NowPathIn.ToCharArray().Last() == '\\') { if (!System.IO.File.Exists(this.mNowPathOut + string.Format(FileName, SLPRSNID))) { Models.Salesperson.SaveAs(this.mNowPathOut + string.Format(FileName, SLPRSNID), salesperson); //doc.Save(this.mNowPathOut + string.Format(FileName, SLPRSNID)); } } else { if (!System.IO.File.Exists(this.mNowPathOut + "/" + string.Format(FileName, SLPRSNID))) { Models.Salesperson.SaveAs(this.mNowPathOut + "/" + string.Format(FileName, SLPRSNID), salesperson); //doc.Save(this.mNowPathOut + "/" + string.Format(FileName, SLPRSNID)); } } total--; ObserverManager.Instance.addSubject(new ProgressSubject(total, Salesperson.Rows.Count - total)); IEvent e2 = new InfoEvent("", "", "El archivo '" + String.Format(FileName, SLPRSNID) + "'. fue creado correctamente"); e2.Publish(); } catch (Exception ex) { IEvent err = new ErrorEvent("", "", "No pudo crear el archivo xml correctamente. Mensaje: " + ex.Message); err.Publish(); } } ObserverManager.Instance.addSubject(new ProgressSubject(0, 0)); }
void thread() { DataTable customerData = getAllCustomers(); int total = customerData.Rows.Count; // esrcibo en el nowin porque van para premiumsoft foreach (DataRow row in customerData.Rows) { string FileName = "GP_CUST_{0}.xml"; string CUSTNMBR = row["CUSTNMBR"].ToString().Trim(); IEvent e = new InfoEvent("", "", "Iniciando la creación del archivo XML '" + String.Format(FileName, CUSTNMBR) + "'."); e.Publish(); // xml // XmlDocument doc = new XmlDocument(); /* Lines */ XmlElement Raiz = doc.CreateElement(string.Empty, "raiz", string.Empty); /* Lines */ try { Models.Customer customer = new Models.Customer(); customer.No = row["CUSTNMBR"].ToString().Trim(); customer.Name = row["CUSTNAME"].ToString().Trim(); customer.VAT_Registration_No = row["TXRGNNUM"].ToString().Trim(); customer.Phone = row["PHONE1"].ToString().Trim(); customer.EMail = ""; customer.VAT = 7; customer.VAT_Bus_Posting_Group = "01"; customer.Creation_date = "1900-01-01 00:00:00.00"; customer.Last_modified_date = "1991-03-15 00:00:00"; customer.Address1 = row["ADDRESS1"].ToString().Trim(); if (this.NowPathIn.ToCharArray().Last() == '/' || this.NowPathIn.ToCharArray().Last() == '\\') { if (!System.IO.File.Exists(this.mNowPathOut + string.Format(FileName, CUSTNMBR))) { Models.Customer.SaveAs(this.mNowPathOut + string.Format(FileName, CUSTNMBR), customer); //doc.Save(this.mNowPathOut + string.Format(FileName, LOCNCODE)); } } else { if (!System.IO.File.Exists(this.mNowPathOut + "/" + string.Format(FileName, CUSTNMBR))) { Models.Customer.SaveAs(this.mNowPathOut + "/" + string.Format(FileName, CUSTNMBR), customer); //doc.Save(this.mNowPathOut + "/" + string.Format(FileName, LOCNCODE)); } } total--; ObserverManager.Instance.addSubject(new ProgressSubject(total, customerData.Rows.Count - total)); IEvent e2 = new InfoEvent("", "", "El archivo '" + String.Format(FileName, CUSTNMBR) + "'. fue creado correctamente"); e2.Publish(); } catch (Exception ex) { IEvent err = new ErrorEvent("", "", "No pudo crear el archivo xml correctamente. Mensaje: " + ex.Message); err.Publish(); } } ObserverManager.Instance.addSubject(new ProgressSubject(0, 0)); }
private bool CreateCustomer(string code, string name, string name2, string ruc, string nfc, string phone, string email, string address1, string address2) { bool res = false; SqlCommand command; if (!CustomerExist(code)) { command = new SqlCommand("spInsertCustomer", new SqlConnection(this.StringConnection)); } else { command = new SqlCommand("spUpdateCustomer", new SqlConnection(this.StringConnection)); } command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@No", code); command.Parameters.AddWithValue("@Name", name); command.Parameters.AddWithValue("@Name2", name2); command.Parameters.AddWithValue("@CodeAddress", ""); command.Parameters.AddWithValue("@VAT_Registration_No", ruc); command.Parameters.AddWithValue("@NCF", nfc); command.Parameters.AddWithValue("@Alias", ""); command.Parameters.AddWithValue("@Phone", phone); command.Parameters.AddWithValue("@EMail", email); command.Parameters.AddWithValue("@Credit_limit", 0.00); command.Parameters.AddWithValue("@Customer_Invoice_No", ""); command.Parameters.AddWithValue("@Price_Group", "01"); command.Parameters.AddWithValue("@Currency", "01"); command.Parameters.AddWithValue("@Language", "01"); command.Parameters.AddWithValue("@Price_including_VAT", 0.00); command.Parameters.AddWithValue("@Price_without_VAT", 0.00); command.Parameters.AddWithValue("@VAT", 0.00); command.Parameters.AddWithValue("@Salesperson", ""); command.Parameters.AddWithValue("@Discounts_Invoice", 0.00); command.Parameters.AddWithValue("@Line_Discounts", 0.00); command.Parameters.AddWithValue("@Reserve", 0); command.Parameters.AddWithValue("@Payment_terms", ""); command.Parameters.AddWithValue("@Allow_discount", 1); command.Parameters.AddWithValue("@Block", 0); command.Parameters.AddWithValue("@VAT_Bus_Posting_Group", "01"); command.Parameters.AddWithValue("@Creation_date", DateTime.Now); command.Parameters.AddWithValue("@Created_by_user", ""); command.Parameters.AddWithValue("@Last_modified_date", DateTime.Now); command.Parameters.AddWithValue("@Last_modified_by_the_user", ""); command.Parameters.AddWithValue("@Address1", address1); command.Parameters.AddWithValue("@Address2", address2); try { if (command.Connection.State != ConnectionState.Open) { command.Connection.Open(); } int r = command.ExecuteNonQuery(); res = (r >= 0); }catch (Exception ex) { res = false; IEvent ev = new ErrorEvent("", "", "TransactionAddSalesPerson::" + ex.Message); ev.Publish(); //MessageBox.Show("TransactionAddSalesPerson::" + ex.Message); } finally { if (command.Connection.State != ConnectionState.Closed) { command.Connection.Close(); } } return(res); }
void thread() { DataTable Transactions = getAllPricesLevels(); string prevDoc = ""; int total = Transactions.Rows.Count; // esrcibo en el nowin porque van para premiumsoft foreach (DataRow row in Transactions.Rows) { if (prevDoc != row["PRCLEVEL"].ToString().Trim()) { DataTable TransactionDetail = getPriceLeveData(row["PRCLEVEL"].ToString().Trim()); string ADJUST = row["PRCLEVEL"].ToString().Trim(); string FileName = "GP_OFER_{0}.xml"; IEvent e = new InfoEvent("", "", "Iniciando la creación del archivo XML '" + String.Format(FileName, ADJUST) + "'."); e.Publish(); // xml // XmlDocument doc = new XmlDocument(); XmlDeclaration xmlDeclaration = doc.CreateXmlDeclaration("1.0", "UTF-8", null); XmlElement root = doc.DocumentElement; doc.InsertBefore(xmlDeclaration, root); /* Lines */ XmlElement Lines = doc.CreateElement(string.Empty, "raiz", string.Empty); /* Lines */ Models.Oferts offerts = new Models.Oferts(); foreach (DataRow det in TransactionDetail.Rows) { Models.PriceList pl = new Models.PriceList(); string DOCNUMBR = det["PRCLEVEL"].ToString().Trim(); //string USERID = "UNKNOWN"; string DOCDATE = DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day; string TIME = DateTime.Now.Hour + ":" + DateTime.Now.Minute + ":00"; string ITEMNMBR = det["ITEMNMBR"].ToString().Trim(); try { XmlElement Item = doc.CreateElement(string.Empty, "lista_de_precio", string.Empty); /* document */ //XmlElement document = doc.CreateElement(string.Empty, "codigoalmacen", string.Empty); pl.Almacen = det["PRCLEVEL"].ToString().Trim(); // XmlText document_text = doc.CreateTextNode(det["PRCLEVEL"].ToString().Trim()); //document.AppendChild(document_text); //Item.AppendChild(document); /* document */ /* realizador */ //XmlElement realizador = doc.CreateElement(string.Empty, "codigo", string.Empty); pl.Codigo = det["ITEMNMBR"].ToString().Trim(); //XmlText realizador_text = doc.CreateTextNode(det["ITEMNMBR"].ToString().Trim()); //realizador.AppendChild(realizador_text); //Item.AppendChild(realizador); /* realizador */ /* motivo */ //XmlElement motivo = doc.CreateElement(string.Empty, "nombre", string.Empty); pl.Descripcion = det["ITEMDESC"].ToString().Trim();//XmlText motivo_text = doc.CreateTextNode(det["ITEMDESC"].ToString().Trim()); //motivo.AppendChild(motivo_text); //Item.AppendChild(motivo); /* motivo */ /* fecha */ //XmlElement fecha = doc.CreateElement(string.Empty, "nombrelista", string.Empty); pl.NombreLista = det["PRCLEVEL"].ToString().Trim();// XmlText fecha_text = doc.CreateTextNode(det["PRCLEVEL"].ToString().Trim()); //fecha.AppendChild(fecha_text); //Item.AppendChild(fecha); /* fecha */ //XmlElement element10 = doc.CreateElement(string.Empty, "unidad", string.Empty); pl.UofM = det["UOFM"].ToString().Trim();// XmlText text8 = doc.CreateTextNode(det["UOFM"].ToString().Trim()); //element10.AppendChild(text8); //Item.AppendChild(element10); //XmlElement element9 = doc.CreateElement(string.Empty, "cantidad", string.Empty); pl.Cantidad = det["QTYBSUOM"].ToString().Trim().Replace(",", "."); // XmlText text7 = doc.CreateTextNode(det["QTYBSUOM"].ToString().Trim().Replace(",", ".")); // element9.AppendChild(text7); //Item.AppendChild(element9); /* precio */ //XmlElement precio = doc.CreateElement(string.Empty, "precio_neto", string.Empty); pl.PrecioNeto = (decimal)det["PRICE"]; // XmlText precio_text = doc.CreateTextNode(det["PRICE"].ToString().Trim().Replace(",", ".")); //precio.AppendChild(precio_text); //Item.AppendChild(precio); /* precio */ /* cost */ //XmlElement cost = doc.CreateElement(string.Empty, "precio_con_itbms", string.Empty); pl.PrecioConITBMS = (decimal)det["PRICEWITMBS"];// XmlText cost_text = doc.CreateTextNode(det["PRICEWITMBS"].ToString().Trim().Replace(",", ".")); //cost.AppendChild(cost_text); //Item.AppendChild(cost); /* costo */ /* cost */ //XmlElement cost2 = doc.CreateElement(string.Empty, "costo", string.Empty); pl.Costo = (decimal)det["CURRCOST"]; // XmlText cost_text2 = doc.CreateTextNode(det["CURRCOST"].ToString().Trim().Replace(",", ".")); //cost2.AppendChild(cost_text2); //Item.AppendChild(cost2); /* costo */ //XmlElement element7 = doc.CreateElement(string.Empty, "porcentaje_itbms", string.Empty); pl.PrecioITBMS = (decimal)det["ITMBSPCT"];// XmlText text5 = doc.CreateTextNode(det["ITMBSPCT"].ToString().Trim().Replace(",", ".")); //element7.AppendChild(text5); //Item.AppendChild(element7); //XmlElement element8 = doc.CreateElement(string.Empty, "tipo", string.Empty); pl.Tipo = (int)Convert.ToInt32(det["ITEMTYPE"]);// XmlText text6 = doc.CreateTextNode(det["ITEMTYPE"].ToString().Trim()); //element8.AppendChild(text6); //Item.AppendChild(element8); offerts.Add(pl); //Lines.AppendChild(Item); } catch (Exception ex) { IEvent err = new ErrorEvent("", "", "No pudo crear el archivo xml correctamente. Mensaje: " + ex.Message); err.Publish(); } } doc.AppendChild(Lines); if (this.NowPathIn.ToCharArray().Last() == '/' || this.NowPathIn.ToCharArray().Last() == '\\') { if (!System.IO.File.Exists(this.mNowPathOut + string.Format(FileName, ADJUST))) { Models.Oferts.SaveAs(this.mNowPathOut + string.Format(FileName, ADJUST), offerts);// doc.Save(this.mNowPathOut + string.Format(FileName, ADJUST)); } } else { if (!System.IO.File.Exists(this.mNowPathOut + "/" + string.Format(FileName, ADJUST))) { Models.Oferts.SaveAs(this.mNowPathOut + "/" + string.Format(FileName, ADJUST), offerts);//doc.Save(this.mNowPathOut + "/" + string.Format(FileName, ADJUST)); } } total--; ObserverManager.Instance.addSubject(new ProgressSubject(total, Transactions.Rows.Count - total)); IEvent e2 = new InfoEvent("", "", "El archivo '" + String.Format(FileName, ADJUST) + "'. fue creado correctamente"); e2.Publish(); } prevDoc = row["PRCLEVEL"].ToString().Trim(); } ObserverManager.Instance.addSubject(new ProgressSubject(0, 0)); }