public void UpdateCurrency(ValCurs Currency) { foreach (var item in Currency.ValType[1].Valute) { switch (item.Code) { case "USD": bo.SetCurrencyRate("USD", DateTime.Now, Convert.ToDouble(item.Value), true); break; case "DKK": bo.SetCurrencyRate("DKK", DateTime.Now, Convert.ToDouble(item.Value), true); break; case "EUR": bo.SetCurrencyRate("EUR", DateTime.Now, Convert.ToDouble(item.Value), true); break; case "GPB": bo.SetCurrencyRate("GPB", DateTime.Now, Convert.ToDouble(item.Value), true); break; case "SEK": bo.SetCurrencyRate("SEK", DateTime.Now, Convert.ToDouble(item.Value), true); break; } } }
public static string AddData(SAPbobsCOM.Company oCompany, EXR model) { RTNMANVAL rtn = new RTNMANVAL(); int errCode; string errMessage, strResult = ""; SAPbobsCOM.SBObob oSBob = null; SAPbobsCOM.Recordset rs = null; try { oCompany.StartTransaction(); oSBob = oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoBridge); rs = oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset); rs = oSBob.GetLocalCurrency(); rs = oSBob.GetSystemCurrency(); oSBob.SetCurrencyRate(model.Currency, model.DateRate, model.Rate, true); oCompany.EndTransaction(BoWfTransOpt.wf_Commit); strResult = "OK"; } catch (Exception e) { if (oCompany.InTransaction) { oCompany.EndTransaction(BoWfTransOpt.wf_RollBack); } ; throw; } return(strResult); }
private void UpdateSBOSAP(ref SAPbobsCOM.Company oCompany, DateTime FecActSBO, Double USDObs, ref SAPbobsCOM.SBObob oSBObob, string moneda) { try { //if (SBO_VID_Currency.Properties.Settings.Default.TipoCambio == 1) //{ // cambioIndirecto = true; // if (SBO_VID_Currency.Properties.Settings.Default.MonedaBaseIndirecta == "E") // MonedaBase = EU; // else // MonedaBase = USDObs; //} //string s; try { //s = SBO_VID_Currency.Properties.Settings.Default.Dolar; if ((moneda != "") && (moneda != null)) { oSBObob.SetCurrencyRate(moneda, FecActSBO, USDObs, false); oLog.LogMsg("Valor a cargar Moneda: " + moneda + " Fecha:" + FecActSBO + " Valor: " + USDObs, "A", "I"); } } catch (Exception e) { oLog.LogMsg("Tipo de cambio " + moneda + " ya se encuentra ingresado en la sociedad " + e.Message, "A", "D"); } } catch (Exception e) { oLog.LogMsg("Error al actualizar tasa de cambio en SBO - " + e.Message, "A", "E"); } }
private void UpdateSBO(ref SAPbobsCOM.Company oCompany, DateTime FecActSBO, Double USDObs, Double EU, Double Uefe, ref SAPbobsCOM.SBObob oSBObob) { Double MonedaBase = 0;; bool cambioIndirecto = false; try { if (SBO_VID_Currency.Properties.Settings.Default.TipoCambio == 1) { cambioIndirecto = true; if (SBO_VID_Currency.Properties.Settings.Default.MonedaBaseIndirecta == "E") { MonedaBase = EU; } else { MonedaBase = USDObs; } } string s; try { s = SBO_VID_Currency.Properties.Settings.Default.Dolar; if ((USDObs >= 0) && (s != "") && (s != null)) { oSBObob.SetCurrencyRate(s, FecActSBO, USDObs, false); } } catch { } try { s = SBO_VID_Currency.Properties.Settings.Default.Euro; if ((EU >= 0) && (s != "") && (s != null)) { oSBObob.SetCurrencyRate(s, FecActSBO, EU, false); } } catch { } try { s = SBO_VID_Currency.Properties.Settings.Default.UF; if ((Uefe >= 0) && (s != "") && (s != null)) { oSBObob.SetCurrencyRate(s, FecActSBO, Uefe, false); } } catch { } try { s = SBO_VID_Currency.Properties.Settings.Default.DolarI; if ((USDObs > 0) && (s != "") && (s != null) && (MonedaBase > 0) && (cambioIndirecto)) { oSBObob.SetCurrencyRate(s, FecActSBO, MonedaBase / USDObs, false); } } catch { } try { s = SBO_VID_Currency.Properties.Settings.Default.EuroI; if ((EU > 0) && (s != "") && (s != null) && (MonedaBase > 0) && (cambioIndirecto)) { oSBObob.SetCurrencyRate(s, FecActSBO, MonedaBase / EU, false); } } catch { } try { s = SBO_VID_Currency.Properties.Settings.Default.UFI; if ((Uefe > 0) && (s != "") && (s != null) && (MonedaBase > 0) && (cambioIndirecto)) { oSBObob.SetCurrencyRate(s, FecActSBO, MonedaBase / Uefe, false); } } catch { } } catch (Exception e) { oLog.LogMsg("Error al actualizar tasa de cambio en SBO - " + e.Message, "A", "E"); } }