protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
//APERTURA CONECCION
string destinationconfigname = "QA";
Application["destinationconfigname"] = destinationconfigname;
IDestinationConfiguration destinationConfiguration = null;
bool destinationisInialised = false;
if (!destinationisInialised)
{
destinationConfiguration = new ECCDestinationConfig();
destinationConfiguration.GetParameters(destinationconfigname);
if (RfcDestinationManager.TryGetDestination(destinationconfigname) == null)
{
RfcDestinationManager.RegisterDestinationConfiguration(destinationConfiguration);
destinationisInialised = true;
bool resultado = false;
resultado = testconnection(destinationconfigname);
Application["resultado"] = Convert.ToString(resultado);
}
}
//FIN APERTURA CONECCION
}
public void InitializeConnection()
{
destinationConfig = new SAPDestinationConfig(this.saplogonlanguage);
//destinationConfig.GetParameters(destinationConfigName);
if (RfcDestinationManager.TryGetDestination(destinationConfigName) == null)
{
RfcDestinationManager.RegisterDestinationConfiguration(destinationConfig);
destinationIsInialised = true;
}
}
public void KomisyonBedeliniGetir(string musteriNumarasi, DateTime?baslangicTarihi, DateTime?bitisTarihi
, out DataTable dtITAB, out DataTable dtZRETURN)
{
SAPDestinationConfiguration sapDestinationConfiguration = new SAPDestinationConfiguration();
IRfcFunction rfcFunction = null;
try
{
// ishak.kulekci 24.06.2013
// Destination configuration already initialized hatasını engelleme, bunun için önce TryGetDestination kullanılır
RfcDestination rfcDestination = RfcDestinationManager.TryGetDestination("SAPSYSTEM");
if (rfcDestination == null)
{
try
{
RfcDestinationManager.RegisterDestinationConfiguration(sapDestinationConfiguration);
}
catch (Exception ex)
{
}
rfcDestination = RfcDestinationManager.GetDestination("SAPSYSTEM");
}
//RfcDestination rfcDestination = RfcDestinationManager.GetDestination("SAPSYSTEM");
rfcFunction = rfcDestination.Repository.CreateFunction("Z_RFC_YK_BEKPRIM_TO_INTERNET");
//rfcFunction.SetValue("KUNNR", "100092"); // aygaz
rfcFunction.SetValue("KUNNR", musteriNumarasi);
//rfcFunction.SetValue("DATAB", "20130601");
rfcFunction.SetValue("DATAB", baslangicTarihi.Value.ToString("yyyyMMdd", CultureInfo.GetCultureInfo("tr-tr")));
//rfcFunction.SetValue("DATBI", "20130605");
rfcFunction.SetValue("DATBI", bitisTarihi.Value.ToString("yyyyMMdd", CultureInfo.GetCultureInfo("tr-tr")));
rfcFunction.Invoke(rfcDestination);
}
catch (Exception exception)
{
throw exception;
}
finally
{
try
{
RfcDestinationManager.UnregisterDestinationConfiguration(sapDestinationConfiguration);
}
catch (Exception ex)
{
}
}
dtITAB = RFCHelper.RfcTableToDataTable(rfcFunction.GetTable("ITAB"), "ITAB");
dtZRETURN = RFCHelper.RfcTableToDataTable(rfcFunction.GetTable("ZRETURN"), "ZRETURN");
}
public bool TestConnection()
{
bool result = false;
SAPDestinationConfiguration sapDestinationConfiguration = new SAPDestinationConfiguration();
try
{
// ishak.kulekci 24.06.2013
// Destination configuration already initialized hatasını engelleme, bunun için önce TryGetDestination kullanılır
RfcDestination rfcDestination = RfcDestinationManager.TryGetDestination("SAPSYSTEM");
if (rfcDestination == null)
{
try
{
RfcDestinationManager.RegisterDestinationConfiguration(sapDestinationConfiguration);
}
catch (Exception ex)
{
}
rfcDestination = RfcDestinationManager.GetDestination("SAPSYSTEM");
}
if (rfcDestination != null)
{
rfcDestination.Ping();
result = true;
}
}
catch (Exception exception)
{
//throw exception;
result = false;
//throw new Exception("Connection failure error. Message:"+exception.Message);
}
finally
{
try
{
RfcDestinationManager.UnregisterDestinationConfiguration(sapDestinationConfiguration);
}
catch (Exception ex)
{
}
}
return(result);
}
void Application_Start(object sender, EventArgs e)
{
string destinationConfigurationName = "QA";
IDestinationConfiguration destinationConfig = null;
bool IsDestinationInia = false;
if (!IsDestinationInia)
{
destinationConfig = new SAPDestinationConfig();
destinationConfig.GetParameters(destinationConfigurationName);
if (RfcDestinationManager.TryGetDestination(destinationConfigurationName) == null)
{
RfcDestinationManager.RegisterDestinationConfiguration(destinationConfig);
IsDestinationInia = true;
}
}
// Code that runs on application startup
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
}
public InvoiceValueModel GetInvoiceValue()
{
//SAPCommonService objSAPCommonService = new SAPCommonService();
SAPCommon objSAPCommon = new SAPCommon();
//RfcDestination rfcDest = null;
RfcDestination rfcDest = RfcDestinationManager.TryGetDestination("accelyides");
if (rfcDest == null)
{
RfcDestinationManager.RegisterDestinationConfiguration(objSAPCommon);
rfcDest = RfcDestinationManager.GetDestination("accelyides");
}
//RfcDestinationManager.UnregisterDestinationConfiguration(objSAPCommon);
//RfcDestinationManager.RegisterDestinationConfiguration(objSAPCommon);
//RfcDestination rfcDest = null;
//rfcDest = RfcDestinationManager.GetDestination("accelyides");
InvoiceValueModel invoiceValueModel = GetInvoiceValue(rfcDest);
return(invoiceValueModel);
}
private void frmCreateNotif_Load(object sender, EventArgs e)
{
IDestinationConfiguration destinationConfig;
string destinationConfigName = "SE37";
destinationConfig = null;
bool destinationIsInitialised = false;
if (!destinationIsInitialised)
{
destinationConfig = new rfc_Connector();
destinationConfig.GetParameters(destinationConfigName);
if (RfcDestinationManager.TryGetDestination(destinationConfigName) == null)
{
RfcDestinationManager.RegisterDestinationConfiguration(destinationConfig);
destinationIsInitialised = true;
}
GlobalData.rfcDestination = RfcDestinationManager.GetDestination("SE37");
GlobalData.rfcRepository = GlobalData.rfcDestination.Repository;
}
}
public VendorDetModel GetVendorsList()
{
//SAPCommonService objSAPCommonService = new SAPCommonService();
SAPCommonService objSAPCommon = new SAPCommonService();
//RfcDestination rfcDest = null;
RfcDestination rfcDest = RfcDestinationManager.TryGetDestination("accelyides");
if (rfcDest == null)
{
RfcDestinationManager.RegisterDestinationConfiguration(objSAPCommon);
rfcDest = RfcDestinationManager.GetDestination("accelyides");
}
//RfcDestinationManager.UnregisterDestinationConfiguration(objSAPCommon);
//RfcDestinationManager.RegisterDestinationConfiguration(objSAPCommon);
//RfcDestination rfcDest = null;
//rfcDest = RfcDestinationManager.GetDestination("accelyides");
VendorDetModel vendorDetModel = GetVendorDetails(rfcDest);
return(vendorDetModel);
}
protected void Application_Start()
{
var _Ip = WebApi.Common.Function.GetIpAddresses();
//string destinationConfigName = "QAS";
if (_Ip.Count() > 0)
{
if (_Ip[_Ip.Count() - 1].ToString() == ConfigurationManager.AppSettings["ServerIp"])
{
destinationConfigName = ConfigurationManager.AppSettings["SapMode"];
// destinationConfigName = "PRD";
}
else
{
destinationConfigName = ConfigurationManager.AppSettings["SapModeTest"];
// destinationConfigName = "QAS";
}
}
IDestinationConfiguration destinationConfig = null;
bool destinationIsInialised = false;
if (!destinationIsInialised)
{
destinationConfig = new SapDestinationConfig();
destinationConfig.GetParameters(destinationConfigName);
if (RfcDestinationManager.TryGetDestination(destinationConfigName) == null)
{
RfcDestinationManager.RegisterDestinationConfiguration(destinationConfig);
destinationIsInialised = true;
}
}
GlobalConfiguration.Configure(WebApiConfig.Register);
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
//強迫只回傳json格式
GlobalConfiguration.Configuration.Formatters.XmlFormatter.SupportedMediaTypes.Clear();
}
void Application_Start(object sender, EventArgs e)
{
// Code that runs on application startup
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
Convertir convert = new Convertir();
string destinationConfigName = "SapQA";
//string destinationConfigName = "MAP";
IDestinationConfiguration destinationConfig = null;
bool destinationIsInialised = false;
if (!destinationIsInialised)
{
destinationConfig = new SAPDestinationConfig();
destinationConfig.GetParameters(destinationConfigName);
if (RfcDestinationManager.TryGetDestination(destinationConfigName) == null)
{
RfcDestinationManager.RegisterDestinationConfiguration(destinationConfig);
destinationIsInialised = true;
}
}
}
/// <summary>
/// Getting single vendor from SAP
/// Date: 20 June 2019
/// Developer: Shreyans Khandelwal(0538)
/// </summary>
/// <returns></returns>
public VendorDetail GetVendor()
{
VendorDetail vendorDetModel = new VendorDetail();
try
{
SAPCommonService objSAPCommon = new SAPCommonService();
RfcDestination rfcDest = RfcDestinationManager.TryGetDestination("accelyides");
if (rfcDest == null)
{
RfcDestinationManager.RegisterDestinationConfiguration(objSAPCommon);
rfcDest = RfcDestinationManager.GetDestination("accelyides");
}
vendorDetModel = GetVendorDetail(rfcDest);
return(vendorDetModel);
}
catch (Exception ex)
{
logger.WriteLog(ex);
throw ex;
}
}
private void btnRFCTest_Click(object sender, EventArgs e)
{
try
{
FileHelper.SaveRFCName(txtRFCName.Text);
string rfcName = txtRFCName.Text;
SAPDestinationConfiguration sapDestinationConfiguration = new SAPDestinationConfiguration();
IRfcFunction rfcFunction = null;
try
{
// ishak.kulekci 24.06.2013
// Destination configuration already initialized hatasını engelleme, bunun için önce TryGetDestination kullanılır
RfcDestination rfcDestination = RfcDestinationManager.TryGetDestination("SAPSYSTEM");
if (rfcDestination == null)
{
try
{
RfcDestinationManager.RegisterDestinationConfiguration(sapDestinationConfiguration);
}
catch (Exception ex)
{
}
rfcDestination = RfcDestinationManager.GetDestination("SAPSYSTEM");
}
//RfcDestination rfcDestination = RfcDestinationManager.GetDestination("SAPSYSTEM");
//rfcFunction = rfcDestination.Repository.CreateFunction("Z_RFC_YK_BEKPRIM_TO_INTERNET");
////rfcFunction.SetValue("KUNNR", "100092"); // aygaz
//rfcFunction.SetValue("KUNNR", musteriNumarasi);
////rfcFunction.SetValue("DATAB", "20130601");
//rfcFunction.SetValue("DATAB", baslangicTarihi.Value.ToString("yyyyMMdd", CultureInfo.GetCultureInfo("tr-tr")));
////rfcFunction.SetValue("DATBI", "20130605");
//rfcFunction.SetValue("DATBI", bitisTarihi.Value.ToString("yyyyMMdd", CultureInfo.GetCultureInfo("tr-tr")));
//rfcFunction.Invoke(rfcDestination);
rfcFunction = rfcDestination.Repository.CreateFunction(rfcName);
//rfcFunction.Metadata
//RfcParameterMetadata describing an importing/exporting/tables parameter of a function module
List <RfcParameterMetadata_ForUI> listRfcParameterMetadataWhichDirectionImport = new List <RfcParameterMetadata_ForUI>();
//List<RfcParameterMetadata_ForUI> listRfcParameterMetadataWhichDirectionTables = new List<RfcParameterMetadata_ForUI>();
//List<DataTable> listDataTableToImport = new List<DataTable>();
List <RFCTableWhichHasDataTableAndFieldInfo> listRFCTable = new List <RFCTableWhichHasDataTableAndFieldInfo>();
int parameterCount = rfcFunction.Metadata.ParameterCount;
for (int i = 0; i < parameterCount; i++)
{
RfcParameterMetadata rfcParameterMetadata = rfcFunction.Metadata[i];
//rfcParameterMetadata.DefaultValue
//rfcParameterMetadata.Direction
//RfcDirection.CHANGING
//RfcDirection.EXPORT
//RfcDirection.IMPORT
//RfcDirection.TABLES
//rfcParameterMetadata.Optional
//rfcParameterMetadata.Name
if (rfcParameterMetadata.Direction == RfcDirection.IMPORT)
{
listRfcParameterMetadataWhichDirectionImport.Add(Convert_To_RfcParameterMetadata_ForUI(rfcParameterMetadata));
}
else if (rfcParameterMetadata.Direction == RfcDirection.TABLES)
{
RfcTableMetadata rfcTableMetadata = rfcParameterMetadata.ValueMetadataAsTableMetadata;
int fieldCount = rfcTableMetadata.LineType.FieldCount;
// field adeti kadar Datatable nesnesi oluşturup kolon eklemesi yapılacak
DataTable dt = new DataTable(rfcTableMetadata.Name);
List <RfcFieldMetadata_ForUI> listRfcFieldMetadata = new List <RfcFieldMetadata_ForUI>();
for (int j = 0; j < fieldCount; j++)
{
RfcFieldMetadata rfcFieldMetadata = rfcTableMetadata[j];
DataColumn dc = new DataColumn(rfcFieldMetadata.Name);
dt.Columns.Add(dc);
listRfcFieldMetadata.Add(Convert_To_RfcFieldMetadata_ForUI(rfcFieldMetadata));
}
//listDataTableToImport.Add(dt);
//listRfcParameterMetadataWhichDirectionTables.Add(Convert_To_RfcParameterMetadata_ForUI(rfcParameterMetadata));
RFCTableWhichHasDataTableAndFieldInfo rfcTable = new RFCTableWhichHasDataTableAndFieldInfo();
rfcTable.TableParameterMetadata = Convert_To_RfcParameterMetadata_ForUI(rfcParameterMetadata);
rfcTable.DataTableForItems = dt;
rfcTable.ListForFieldMetadata = listRfcFieldMetadata;
listRFCTable.Add(rfcTable);
}
}
gvImportParams.AutoGenerateColumns = false;
gvImportParams.DataSource = listRfcParameterMetadataWhichDirectionImport;
// tablolar elde edilip, tabcontrol içine tabpage olarak eklenir
// her tabpage içinde datagridview eklenir, kolon değerlerini alma sağlanır
foreach (RFCTableWhichHasDataTableAndFieldInfo itemTable in listRFCTable)
{
TabPage page = new TabPage();
page.Text = itemTable.TableParameterMetadata.Name;
page.Name = "tp" + itemTable.TableParameterMetadata.Name;
page.Width = 550;
page.Height = 300;
DataGridView gv = new DataGridView();
gv.Name = "gv" + itemTable.TableParameterMetadata.Name;
// grid kaynağı bağlanmalı
gv.DataSource = itemTable.DataTableForItems;
gv.Anchor = AnchorStyles.Left | AnchorStyles.Right;
gv.Location = new Point(5, 35);
gv.Margin = new Padding(3);
gv.Width = 540;
gv.Height = 200;
page.Controls.Add(gv);
tcTablesToImport.TabPages.Add(page);
}
}
catch (Exception exception)
{
throw exception;
}
finally
{
try
{
RfcDestinationManager.UnregisterDestinationConfiguration(sapDestinationConfiguration);
}
catch (Exception ex)
{
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void registerSAPServerDetails(string _sapUserName, string _sapPassword, string _sapClient = null,
string _sapLanguage = null, string _sapSystemNumber = null, string _sapHost = null,
string _sapSystemID = null, bool _replaceExistingInCache = false)
{
m_rfcDestination = null;
DataCache.GetObject().ClearCache();
try
{
if (String.IsNullOrEmpty(DataCache.GetObject().SapClient) || _replaceExistingInCache)
{
DataCache.GetObject().SapClient = (!String.IsNullOrEmpty(_sapClient)) ? _sapClient : string.Empty;
}
else if (String.IsNullOrEmpty(DataCache.GetObject().SapClient))
{
throw new Exception("Please provide valid client number");
}
if (String.IsNullOrEmpty(DataCache.GetObject().SapLanguage) || _replaceExistingInCache)
{
DataCache.GetObject().SapLanguage = (!String.IsNullOrEmpty(_sapLanguage)) ? _sapLanguage : String.Empty;
}
else if (String.IsNullOrEmpty(DataCache.GetObject().SapLanguage))
{
throw new Exception("Please provide valid SAP Language");
}
if (String.IsNullOrEmpty(DataCache.GetObject().SapSystemNumber) || _replaceExistingInCache)
{
DataCache.GetObject().SapSystemNumber = (!String.IsNullOrEmpty(_sapSystemNumber)) ? _sapSystemNumber : String.Empty;
}
else if (String.IsNullOrEmpty(DataCache.GetObject().SapSystemNumber))
{
throw new Exception("Please provide valid SAP System Number");
}
if (String.IsNullOrEmpty(DataCache.GetObject().SapHost) || _replaceExistingInCache)
{
DataCache.GetObject().SapHost = (!String.IsNullOrEmpty(_sapHost)) ? _sapHost : String.Empty;
}
else if (String.IsNullOrEmpty(DataCache.GetObject().SapHost))
{
throw new Exception("Please provide valid SAP Host");
}
if (String.IsNullOrEmpty(DataCache.GetObject().SapSystemID) || _replaceExistingInCache)
{
DataCache.GetObject().SapSystemID = (!String.IsNullOrEmpty(_sapSystemID)) ? _sapSystemID : String.Empty;
}
else if (String.IsNullOrEmpty(DataCache.GetObject().SapSystemID))
{
throw new Exception("Please provide valid SAP ID");
}
if (String.IsNullOrEmpty(DataCache.GetObject().SapUserName) || _replaceExistingInCache)
{
DataCache.GetObject().SapUserName = (!String.IsNullOrEmpty(_sapUserName)) ? _sapUserName : String.Empty;
}
else if (String.IsNullOrEmpty(DataCache.GetObject().SapUserName))
{
throw new Exception("Please provide valid SAP User Name");
}
if (String.IsNullOrEmpty(DataCache.GetObject().SapLogonPassword) || _replaceExistingInCache)
{
DataCache.GetObject().SapLogonPassword = (!String.IsNullOrEmpty(_sapPassword)) ? _sapPassword : String.Empty;
}
else if (String.IsNullOrEmpty(DataCache.GetObject().SapLogonPassword))
{
throw new Exception("Please provide valid SAP User Password");
}
if (m_rfcDestination == null)
{
m_provider = new MatManLib.SapLogonConfig();
if (RfcDestinationManager.TryGetDestination(DataCache.GetObject().SapDestinationName) == null)
{
RfcDestinationManager.RegisterDestinationConfiguration(m_provider);
}
}
}
catch (Exception exp)
{
throw exp;
}
}
