public override void CreateForm(SAPbouiCOM.Application SboApp, string strXml, SAPbobsCOM.Company cmp, string frmId)
{
base.CreateForm(SboApp, strXml, cmp, frmId);
InitiallizeForm();
NopServices ns = new NopServices(Program.strConNOP, Program.strConSAP, Program.SboAPI);
DataTable dtConf = ns.getConfiguration();
if (dtConf.Rows.Count > 0)
{
txSDB.Value = dtConf.Rows[0][2].ToString();
txSUID.Value = dtConf.Rows[0][3].ToString();
txSPwd.Value = dtConf.Rows[0][4].ToString();
txSDBUid.Value = dtConf.Rows[0][5].ToString();
txSDBPwd.Value = dtConf.Rows[0][6].ToString();
txSSType.Value = dtConf.Rows[0][7].ToString();
txSServer.Value = dtConf.Rows[0][8].ToString();
txNPServer.Value = dtConf.Rows[0][9].ToString();
txNPDB.Value = dtConf.Rows[0][10].ToString();
txNPUID.Value = dtConf.Rows[0][11].ToString();
txNPPwd.Value = dtConf.Rows[0][12].ToString();
txStdPL.Value = dtConf.Rows[0][13].ToString();
txWhs.Value = dtConf.Rows[0][14].ToString();
txPrFldr.Value = dtConf.Rows[0][15].ToString();
txCatFldr.Value = dtConf.Rows[0][16].ToString();
txFI.Value = dtConf.Rows[0][17].ToString();
txSoSer.Value = dtConf.Rows[0][18].ToString();
txSalesEmp.Value = dtConf.Rows[0][19].ToString();
txOwn.Value = dtConf.Rows[0][20].ToString();
}
}
public override void etAfterClick(ref SAPbouiCOM.ItemEvent pVal, ref bool BubbleEvent)
{
try
{
base.etAfterClick(ref pVal, ref BubbleEvent);
if (pVal.ItemUID == "cmdClear")
{
NopServices ns = new NopServices(Program.strConNOP, Program.strConSAP, Program.SboAPI);
string result = ns.cleanData();
oApplication.SetStatusBarMessage("UDFs Created Successfully." + result, SAPbouiCOM.BoMessageTime.bmt_Medium, false);
}
if (pVal.ItemUID == "cmdUdfs")
{
try
{
oApplication.SetStatusBarMessage("Creating Udfs.", SAPbouiCOM.BoMessageTime.bmt_Medium, false);
NopServices ns = new NopServices(Program.strConNOP, Program.strConSAP, Program.SboAPI);
ns.addSboFields();
oApplication.SetStatusBarMessage("UDFs Created Successfully.", SAPbouiCOM.BoMessageTime.bmt_Medium, false);
}
catch (Exception ex)
{
}
}
if (pVal.ItemUID == "cmdRole")
{
try
{
NopServices ns = new NopServices(Program.strConNOP, Program.strConSAP, Program.SboAPI);
ns.SyncRole();
oApplication.SetStatusBarMessage("Role Created Successfully.", SAPbouiCOM.BoMessageTime.bmt_Medium, false);
}
catch (Exception ex)
{
}
}
if (pVal.ItemUID == "cmdCus")
{
try
{
NopServices ns = new NopServices(Program.strConNOP, Program.strConSAP, Program.SboAPI);
ns.SyncCustomer();
oApplication.SetStatusBarMessage("Customer Transfered Successfully.", SAPbouiCOM.BoMessageTime.bmt_Medium, false);
}
catch (Exception ex)
{
}
}
if (pVal.ItemUID == "cmdIG")
{
try
{
NopServices ns = new NopServices(Program.strConNOP, Program.strConSAP, Program.SboAPI);
ns.SyncItemGroup();
ns.syncCatImages(Program.categorImageFolder);
oApplication.SetStatusBarMessage("Item Group Transfered Successfully.", SAPbouiCOM.BoMessageTime.bmt_Medium, false);
}
catch (Exception ex)
{
}
}
if (pVal.ItemUID == "cmdItems")
{
try
{
NopServices ns = new NopServices(Program.strConNOP, Program.strConSAP, Program.SboAPI);
ns.SyncItems();
// ns.syncProductImages(Program.productImageFolder);
oApplication.SetStatusBarMessage("Items Transfered Successfully.", SAPbouiCOM.BoMessageTime.bmt_Medium, false);
}
catch (Exception ex)
{
}
}
if (pVal.ItemUID == "cmdPrice")
{
try
{
NopServices ns = new NopServices(Program.strConNOP, Program.strConSAP, Program.SboAPI);
ns.UpdateStandardPrice(Program.standardPricelist);
oApplication.SetStatusBarMessage("Items Price Updated Successfully.", SAPbouiCOM.BoMessageTime.bmt_Medium, false);
}
catch (Exception ex)
{
}
}
if (pVal.ItemUID == "cmdGPrice")
{
try
{
NopServices ns = new NopServices(Program.strConNOP, Program.strConSAP, Program.SboAPI);
ns.UpdateStandardPrice(Program.standardPricelist);
oApplication.SetStatusBarMessage("Group Price Updated Successfully.", SAPbouiCOM.BoMessageTime.bmt_Medium, false);
}
catch (Exception ex)
{
}
}
if (pVal.ItemUID == "1")
{
NopServices ns = new NopServices(Program.strConNOP, Program.strConSAP, Program.SboAPI);
string consaveResult = ns.updateConConfiguration(txSDB.Value, txSUID.Value, txSPwd.Value, txSDBUid.Value, txSDBPwd.Value, txSSType.Value, txSServer.Value, txNPServer.Value, txNPDB.Value, txNPUID.Value, txNPPwd.Value);
if (consaveResult == "Ok")
{
Program.companyDb = txSDB.Value;
Program.SboUID = txSUID.Value;
Program.SboPwd = txSPwd.Value;
Program.DbUserName = txSPwd.Value;
Program.DbPassword = txSDBPwd.Value;
Program.ServerType = txSSType.Value;
Program.SboServer = txSServer.Value;
Program.standardPricelist = txStdPL.Value;;
Program.whsCode = txWhs.Value;;
Program.productImageFolder = txPrFldr.Value;
Program.categorImageFolder = txPrFldr.Value;
Program.NopDbUserName = txNPUID.Value;
Program.NopDbPassword = txNPPwd.Value;
Program.NopDbName = txNPDB.Value;
Program.NopSServer = txNPServer.Value;
}
ns.updateConfiguration(txSDB.Value, txSUID.Value, txSPwd.Value, txSDBUid.Value, txSDBPwd.Value, txSSType.Value, txSServer.Value, txNPServer.Value, txNPDB.Value, txNPUID.Value, txNPPwd.Value, txStdPL.Value, txWhs.Value, txPrFldr.Value, txCatFldr.Value, txFI.Value, txSoSer.Value, txSalesEmp.Value, txOwn.Value);
Program.updateSetting();
}
}
catch (Exception ex)
{
oApplication.SetStatusBarMessage("Error occured " + ex.Message);
}
}
