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;
}
}
