public static CustomerGeneralInfo CustomerIDGetByUsername(string userName, int portalID, int storeID) { try { CustomerGeneralInfo sageCustInfo = CustomerGeneralInfoSQLProvider.CustomerIDGetByUsername(userName, portalID, storeID); return(sageCustInfo); } catch (Exception e) { throw e; } }
public static CustomerGeneralInfo CustomerIDGetByUsername(string userName, int portalID, int storeID) { try { List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >(); ParaMeterCollection.Add(new KeyValuePair <string, object>("UserName", userName)); ParaMeterCollection.Add(new KeyValuePair <string, object>("PortalID", portalID)); ParaMeterCollection.Add(new KeyValuePair <string, object>("StoreID", storeID)); OracleHandler sqlH = new OracleHandler(); CustomerGeneralInfo sageCustInfo = sqlH.ExecuteAsObject <CustomerGeneralInfo>("usp_Aspx_CustomerIDGetByUserna", ParaMeterCollection); return(sageCustInfo); } catch (Exception e) { throw e; } }