private void S_OITM_Load(object sender, EventArgs e) { try { UXUTIL.clsUtilities.setAllControlsThemes(this); this.WindowState = FormWindowState.Maximized; //this.CheckForIllegalCrossThreadCalls = false; oDtCompany = new DataTable(); oDtCompany.Columns.Add("Company", typeof(string)); oDtCompany.Columns.Add("Company Name", typeof(string)); string strMaiDB = System.Configuration.ConfigurationManager.AppSettings["MainDB"].ToString(); oCompany = (SAPbobsCOM.Company)TransLog.GetCompany(strMaiDB); SAPbobsCOM.Recordset oRecordSet; oRecordSet = oCompany.GetCompanyList(); DataRow oDr; while (!oRecordSet.EoF) { oDr = oDtCompany.NewRow(); oDr["Company"] = oRecordSet.Fields.Item(0).Value; oDr["Company Name"] = oRecordSet.Fields.Item(1).Value; oDtCompany.Rows.Add(oDr); oRecordSet.MoveNext(); } BindingSource bs = new BindingSource(); bs.DataSource = oDtCompany; comboBox1.DataSource = oDtCompany; comboBox1.DisplayMember = "Company Name"; comboBox1.ValueMember = "Company"; comboBox1.SelectedIndex = 0; System.Windows.Forms.Control.CheckForIllegalCrossThreadCalls = false; } catch (Exception ex) { TransLog.traceService(" Error : " + ex.Message); } }
void m_oWorker_DoWork(object sender, DoWorkEventArgs e) { try { string strInterface = System.Configuration.ConfigurationManager.AppSettings["InterDB"].ToString(); string strMainDB = System.Configuration.ConfigurationManager.AppSettings["MainDB"].ToString(); int intCount = 0; int intCompleted = dgv_S_OINV.RowCount; for (int i = 0; i < dgv_S_OINV.RowCount; i++) { intCount += 1; if (intCount == (intCompleted / 10)) { toolStripProgressBar1.PerformStep(); intCount = 0; } try { bool blnSync = false; Hashtable htCCDet = new Hashtable(); string[] strValues = new string[4]; sQuery = " Select T1.U_COMPANY,T0.U_WAREHOUSE,ISNULL(T0.U_COSTCEN,'') As U_COSTCEN From "; sQuery += " [@Z_INBOUNDMAPPINGC] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code "; sQuery += " Where T0.U_SHOPID = '" + dgv_S_OINV.Rows[i].Cells["ShopID"].Value.ToString().Trim() + "'"; oCompDT = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB); if (oCompDT != null) { if (oCompDT.Rows.Count > 0) { strCompany = oCompDT.Rows[0]["U_COMPANY"].ToString(); strWareHouse = oCompDT.Rows[0]["U_WAREHOUSE"].ToString(); strValues[0] = oCompDT.Rows[0]["U_COSTCEN"].ToString(); oGetCompany = TransLog.GetCompany(strCompany); sQuery = " Select T0.U_SCREDITCARD,T0.U_CREDITCARD,T0.U_CARDNUMBER,T0.U_CARDVALID,T0.U_PAYMENTMETHOD From "; sQuery += " [@Z_INBOUNDMAPPINGC1] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code "; sQuery += " Where T1.U_COMPANY = '" + strCompany + "'"; oCCDT = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB); if (oCCDT != null) { if (oCCDT.Rows.Count > 0) { foreach (DataRow dr1 in oCCDT.Rows) { htCCDet.Add(dr1["U_SCREDITCARD"], dr1); } } } } } TransLog.traceService(" Transaction Type : " + dgv_S_OINV.Rows[i].Cells["Scenario"].Value.ToString().Trim()); TransLog.traceService(" Transaction Key : " + dgv_S_OINV.Rows[i].Cells["Source_Key"].Value.ToString().Trim()); if (oGetCompany != null) { TransLog.traceService("Company DB : " + oGetCompany.CompanyDB); if (oGetCompany.Connected) { Singleton.obj_S_OINV.Sync((dgv_S_OINV.Rows[i].Cells["Source_Key"].Value.ToString().Trim()), TransType.A, oGetCompany, strInterface, strWareHouse, strValues, htCCDet); string strQuery = "Select Status,Remarks From dbo.Z_OTXN Where Scenario = '" + dgv_S_OINV.Rows[i].Cells["Scenario"].Value.ToString().Trim() + "' "; strQuery += " And S_DocNo = '" + dgv_S_OINV.Rows[i].Cells["Source_Key"].Value.ToString().Trim() + "' "; DataTable oStatus = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(strQuery, strInterface); if (oStatus != null && oStatus.Rows.Count > 0) { if (oStatus.Rows[0][0].ToString() == "1") { blnSync = true; dgv_S_OINV.Rows[i].Cells["Remarks"].Value = string.Empty; } else { blnSync = false; dgv_S_OINV.Rows[i].Cells["Remarks"].Value = oStatus.Rows[0][1].ToString(); } } else { blnSync = false; } } else { TransLog.traceService(" Error : Company Not Connected."); } } else { TransLog.traceService(" Error : Company Not Found."); } if (blnSync) { Image image = Armada_App.Properties.Resources.Yes1; dgv_S_OINV.Rows[i].Cells["Image"].Value = image; } else { Image image = Armada_App.Properties.Resources.Error1; dgv_S_OINV.Rows[i].Cells["Image"].Value = image; } } catch (Exception ex) { TransLog.traceService(ex.StackTrace.ToString()); TransLog.traceService(ex.Message.ToString()); } } m_oWorker.CancelAsync(); } catch (Exception ex) { TransLog.traceService(ex.StackTrace.ToString()); TransLog.traceService(ex.Message.ToString()); } finally { toolStripProgressBar1.Value = 0; } }
private void btnSync_Click(object sender, EventArgs e) { try { string strInterface = System.Configuration.ConfigurationManager.AppSettings["InterDB"].ToString(); string strMainDB = System.Configuration.ConfigurationManager.AppSettings["MainDB"].ToString(); oDtTransLog = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(TRANSACTIONLOG, strInterface); if (oDtTransLog != null && oDtTransLog.Rows.Count > 0) { foreach (DataRow dr in oDtTransLog.Rows) { try { Hashtable htCCDet = new Hashtable(); string[] strValues = new string[4]; sQuery = " Select T1.U_COMPANY,T0.U_WAREHOUSE From "; sQuery += " [@Z_INBOUNDMAPPINGC] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code "; sQuery += " Where T0.U_SHOPID = '" + dr["ShopID"].ToString() + "'"; oCompDT = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB); if (oCompDT != null) { if (oCompDT.Rows.Count > 0) { strCompany = oCompDT.Rows[0]["U_COMPANY"].ToString(); strWareHouse = oCompDT.Rows[0]["U_WAREHOUSE"].ToString(); oGetCompany = TransLog.GetCompany(strCompany); sQuery = " Select T0.U_SCREDITCARD,T0.U_CREDITCARD,T0.U_CARDNUMBER,T0.U_CARDVALID,T0.U_PAYMENTMETHOD From "; sQuery += " [@Z_INBOUNDMAPPINGC1] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code "; sQuery += " Where T1.U_COMPANY = '" + strCompany + "'"; oCCDT = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB); if (oCCDT != null) { if (oCCDT.Rows.Count > 0) { foreach (DataRow dr1 in oCCDT.Rows) { htCCDet.Add(dr1["U_SCREDITCARD"], dr1); } } } } } TransLog.traceService(" Transaction Type : " + dr["Scenario"].ToString()); TransLog.traceService(" Transaction Key : " + dr["Key"].ToString()); if (oGetCompany != null) { TransLog.traceService("Company DB : " + oGetCompany.CompanyDB); if (oGetCompany.Connected) { Singleton.obj_S_OINV.Sync((dr["Key"].ToString()), TransType.A, oGetCompany, strInterface, strWareHouse, strValues, htCCDet); } else { TransLog.traceService(" Error : Company Not Connected."); } } else { TransLog.traceService(" Error : Company Not Found."); } } catch (Exception ex) { TransLog.traceService(" Error : " + ex.Message); } } } MessageBox.Show("Manual Sync Completed..."); LoadAll(); } catch (Exception ex) { TransLog.traceService("Error Message : " + ex.Message); TransLog.traceService(" Error Source : " + ex.Source); MessageBox.Show(ex.Message.ToString()); } }
private void btnSync_Click(object sender, EventArgs e) { try { string strInterface = System.Configuration.ConfigurationManager.AppSettings["InterDB"].ToString(); string strMainDB = System.Configuration.ConfigurationManager.AppSettings["MainDB"].ToString(); oDtTransLog = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(TRANSACTIONLOG, strInterface); if (oDtTransLog != null && oDtTransLog.Rows.Count > 0) { foreach (DataRow dr in oDtTransLog.Rows) { try { string[] strValues = new string[4]; sQuery = " Select T1.U_COMPANY,T0.U_WAREHOUSE From "; sQuery += " [@Z_INBOUNDMAPPINGC] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code "; sQuery += " Where T0.U_SHOPID = '" + dr["ShopID"].ToString() + "'"; oCompDT = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB); if (oCompDT != null) { if (oCompDT.Rows.Count > 0) { strCompany = oCompDT.Rows[0][0].ToString(); strWareHouse = oCompDT.Rows[0][1].ToString(); oGetCompany = TransLog.GetCompany(strCompany); } } sQuery = " Select T1.U_COMPANY,T0.U_WAREHOUSE,T0.U_PRICELIST From "; sQuery += " [@Z_INBOUNDMAPPINGC] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code "; sQuery += " Where T0.U_SHOPID = '" + dr["ShopID_T"].ToString() + "'"; oCompDT = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB); if (oCompDT != null) { if (oCompDT.Rows.Count > 0) { strCompany_T = oCompDT.Rows[0][0].ToString(); strWareHouse_T = oCompDT.Rows[0][1].ToString(); oGetCompany_T = TransLog.GetCompany(strCompany_T); strValues[0] = oCompDT.Rows[0][2].ToString(); } } TransLog.traceService(" Transaction Type : " + dr["Scenario"].ToString()); TransLog.traceService(" Transaction Key : " + dr["Key"].ToString()); if (oGetCompany != null && oGetCompany_T != null) { TransLog.traceService("From Company DB : " + oGetCompany.CompanyDB); TransLog.traceService("To Company DB : " + oGetCompany_T.CompanyDB); if (oGetCompany.Connected && oGetCompany_T.Connected) { Singleton.obj_S_OWTR.Sync((dr["Key"].ToString()), TransType.A, oGetCompany, oGetCompany_T, strInterface, strWareHouse, strWareHouse_T, strValues); } else { TransLog.traceService(" Error : Either One of the Company Not Connected."); } } else { TransLog.traceService(" Error : Either One of the Company Not Found."); } } catch (Exception ex) { TransLog.traceService(" Error : " + ex.Message); } } } MessageBox.Show("Manual Sync Completed..."); LoadAll(); } catch (Exception ex) { TransLog.traceService("Error Message : " + ex.Message); TransLog.traceService(" Error Source : " + ex.Source); MessageBox.Show(ex.Message.ToString()); } }
public void import_Products() { try { System.Reflection.Assembly oItem_R = System.Reflection.Assembly.LoadFrom(Application.StartupPath + "\\Interop.SAPbobsCOM.dll"); string strMaiDB = strCompany_S.ToString();//System.Configuration.ConfigurationManager.AppSettings["MainDB"].ToString(); oCompany = (SAPbobsCOM.Company)TransLog.GetCompany(strMaiDB); SAPbobsCOM.Items oItem = (SAPbobsCOM.Items)oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oItems); foreach (DictionaryEntry entry in oHT_S) { DataRow row = (DataRow)entry.Value; try { bool blnItemExist = false; string strItemCode = row["ItemCode"].ToString(); TransLog.traceService(" Product : " + strItemCode); //Thread.Sleep(100); //oForm_S.label1.Text = "Creation Item No : " + " - :" + strItemCode; //Application.DoEvents(); //oForm_S.Invoke((MethodInvoker)delegate //{ // oForm_S.label1.Text = strItemCode; // runs on UI thread //}); //oForm_S.label1.Invoke(new Action(() => Control.text = "")); if (oItem.GetByKey(row["ItemCode"].ToString())) { blnItemExist = true; } foreach (DataColumn column in oDS_S.Tables[0].Columns) { string DESTF = column.ColumnName; if (!DESTF.StartsWith("U_")) { try { if (DESTF != "ItemsGroupCode") { oItem_R.GetType("SAPbobsCOM.IItems").GetProperty(DESTF).SetValue(oItem, row[DESTF].ToString(), null); } else { oItem_R.GetType("SAPbobsCOM.IItems").GetProperty(DESTF).SetValue(oItem, Convert.ToInt32(row[DESTF].ToString()), null); } } catch (Exception ex) { TransLog.traceService(" Error : " + ex.Message + "--> Field : " + DESTF); } } else { oItem.UserFields.Fields.Item(DESTF).Value = row[column.ColumnName.ToString()].ToString(); } } int intStatus = 0; if (!blnItemExist) { intStatus = oItem.Add(); if (intStatus != 0) { TransLog.traceService(" Error : " + oCompany.GetLastErrorDescription()); } else { TransLog.traceService(" Success "); } } else { intStatus = oItem.Update(); if (intStatus != 0) { TransLog.traceService(" Error : " + oCompany.GetLastErrorDescription()); } else { TransLog.traceService(" Success "); } } } catch (Exception ex) { TransLog.traceService(" Error : " + ex.Message); } } } catch (Exception ex) { TransLog.traceService(" Error : " + ex.Message); } }
void m_oWorker_DoWork(object sender, DoWorkEventArgs e) { try { string strInterface = System.Configuration.ConfigurationManager.AppSettings["InterDB"].ToString(); string strMainDB = System.Configuration.ConfigurationManager.AppSettings["MainDB"].ToString(); int intCount = 0; int intCompleted = dgv_S_OWTR.RowCount; for (int i = 0; i < dgv_S_OWTR.RowCount; i++) { intCount += 1; if (intCount == (intCompleted / 10)) { toolStripProgressBar1.PerformStep(); intCount = 0; } try { bool blnSync = false; string[] strValues = new string[4]; sQuery = " Select T1.U_COMPANY,T0.U_WAREHOUSE,T0.U_GIACCT From "; sQuery += " [@Z_INBOUNDMAPPINGC] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code "; sQuery += " Where T0.U_LOCATION = '" + dgv_S_OWTR.Rows[i].Cells["ShopID"].Value.ToString().Trim() + "'"; oCompDT = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB); if (oCompDT != null) { if (oCompDT.Rows.Count > 0) { strCompany = oCompDT.Rows[0][0].ToString(); strWareHouse = oCompDT.Rows[0][1].ToString(); strValues[1] = oCompDT.Rows[0]["U_GIACCT"].ToString(); oGetCompany = TransLog.GetCompany(strCompany); } } sQuery = " Select T1.U_COMPANY,T0.U_WAREHOUSE,T0.U_PRICELIST,T0.U_GRACCT From "; sQuery += " [@Z_INBOUNDMAPPINGC] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code "; sQuery += " Where T0.U_LOCATION = '" + dgv_S_OWTR.Rows[i].Cells["ToShop"].Value.ToString().Trim() + "'"; oCompDT = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB); if (oCompDT != null) { if (oCompDT.Rows.Count > 0) { strCompany_T = oCompDT.Rows[0][0].ToString(); strWareHouse_T = oCompDT.Rows[0][1].ToString(); oGetCompany_T = TransLog.GetCompany(strCompany_T); strValues[0] = oCompDT.Rows[0]["U_PRICELIST"].ToString(); strValues[2] = oCompDT.Rows[0]["U_GRACCT"].ToString(); } } TransLog.traceService(" Transaction Type : " + dgv_S_OWTR.Rows[i].Cells["Scenario"].Value.ToString().Trim()); TransLog.traceService(" Transaction Key : " + dgv_S_OWTR.Rows[i].Cells["Source_Key"].Value.ToString().Trim()); if (oGetCompany != null && oGetCompany_T != null) { TransLog.traceService("Source Company DB : " + oGetCompany.CompanyDB); TransLog.traceService("Destination Company DB : " + oGetCompany_T.CompanyDB); if (oGetCompany.Connected && oGetCompany_T.Connected) { if (oGetCompany.CompanyDB != oGetCompany_T.CompanyDB) { //Overriding the Good Issue Account if transaction happening from Main Company if (oGetCompany.CompanyDB == strMainDB) { sQuery = " Select T0.U_GIACCT From "; sQuery += " [@Z_INBOUNDMAPPINGC2] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code "; sQuery += " Where T1.U_COMPANY = '" + strMainDB + "'"; sQuery += " And T0.U_COMPANY = '" + oGetCompany_T.CompanyDB + "'"; DataTable oCompDT1 = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB); if (oCompDT1 != null) { if (oCompDT1.Rows.Count > 0) { strValues[1] = oCompDT1.Rows[0]["U_GIACCT"].ToString(); } } } //Overriding the Good Recipt Account if transaction happening from Main Company if (oGetCompany_T.CompanyDB == strMainDB) { sQuery = " Select T0.U_GRACCT From "; sQuery += " [@Z_INBOUNDMAPPINGC2] T0 JOIN [@Z_INBOUNDMAPPING] T1 On T0.Code = T1.Code "; sQuery += " Where T1.U_COMPANY = '" + strMainDB + "'"; sQuery += " And T0.U_COMPANY = '" + oGetCompany.CompanyDB + "'"; DataTable oCompDT1 = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(sQuery, strMainDB); if (oCompDT1 != null) { if (oCompDT1.Rows.Count > 0) { strValues[2] = oCompDT1.Rows[0]["U_GRACCT"].ToString(); } } } } Singleton.obj_S_OWTR.Sync((dgv_S_OWTR.Rows[i].Cells["Source_Key"].Value.ToString().Trim()), TransType.A, oGetCompany, oGetCompany_T, strInterface, strWareHouse, strWareHouse_T, strValues); string strQuery = "Select Status,Remarks From dbo.Z_OTXN Where Scenario = '" + dgv_S_OWTR.Rows[i].Cells["Scenario"].Value.ToString().Trim() + "' "; strQuery += " And S_DocNo = '" + dgv_S_OWTR.Rows[i].Cells["Source_Key"].Value.ToString().Trim() + "' "; DataTable oStatus = Armada_Sync.Singleton.objSqlDataAccess.ExecuteReader(strQuery, strInterface); if (oStatus != null && oStatus.Rows.Count > 0) { if (oStatus.Rows[0][0].ToString() == "1") { blnSync = true; dgv_S_OWTR.Rows[i].Cells["Remarks"].Value = string.Empty; } else { blnSync = false; dgv_S_OWTR.Rows[i].Cells["Remarks"].Value = oStatus.Rows[0][1].ToString(); } } else { blnSync = false; } } else { TransLog.traceService(" Error : Company Not Connected."); } } else { TransLog.traceService(" Error : Company Not Connected."); } if (blnSync) { Image image = Armada_App.Properties.Resources.Yes1; dgv_S_OWTR.Rows[i].Cells["Image"].Value = image; } else { Image image = Armada_App.Properties.Resources.Error1; dgv_S_OWTR.Rows[i].Cells["Image"].Value = image; } } catch (Exception ex) { TransLog.traceService(ex.StackTrace.ToString()); TransLog.traceService(ex.Message.ToString()); } } m_oWorker.CancelAsync(); } catch (Exception ex) { TransLog.traceService(ex.StackTrace.ToString()); TransLog.traceService(ex.Message.ToString()); } finally { toolStripProgressBar1.Value = 0; } }