public async Task <SAP_GeneralInfo> SAPGetGeneralInfo(string SapNo) { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[1]; Parameters[0] = String.IsNullOrEmpty(SapNo) ? new SqlParameter("@sapNo", DBNull.Value) : new SqlParameter("@sapNo", SapNo); var execResult = objDataEngine.ExecuteCommand("WebSAPGeneralInfoSelect", CommandType.StoredProcedure, Parameters); var _SAP = new SAP_GeneralInfo(); while (execResult.Read()) { _SAP.CompanyCd = Convert.ToString(execResult["CmpyCd"]); _SAP.ReconAccountNo = Convert.ToString(execResult["ReconAcctNo"]); _SAP.selectedDistributionChannel = Convert.ToString(execResult["DistChannel"]); _SAP.DistributionChannel = await BaseClass.WebGetRefLib("City"); _SAP.SelectedDivision = Convert.ToString(execResult["Division"]); _SAP.Division = await BaseClass.WebGetRefLib("City"); _SAP.selectedSalesOrganisation = Convert.ToString(execResult["SalesOrganization"]); _SAP.SalesOrganization = await BaseClass.WebGetRefLib("City"); _SAP.selectedCustomerClass = Convert.ToString(execResult["CustomerClass"]); _SAP.CustoemrClass = await BaseClass.WebGetRefLib("City"); _SAP.AuthCd = Convert.ToString(execResult["Authorization"]); _SAP.SearchName = Convert.ToString(execResult["SearchTerm1"]); _SAP.SortKey = Convert.ToString(execResult["SortKey"]); _SAP.Location = Convert.ToString(execResult["Location"]); _SAP.SelectedCountryCd = Convert.ToString(execResult["CountryCd"]); _SAP.CountryCd = await BaseClass.WebGetRefLib("City"); _SAP.CurrencyCd = await BaseClass.WebGetRefLib("City"); _SAP.SelectedCurrencyCd = Convert.ToString(execResult["CurrencyCd"]); _SAP.SelectedCashManagementGroup = Convert.ToString(execResult["CashMgmtGroup"]); _SAP.CashManagementGroup = await BaseClass.WebGetRefLib("City"); } objDataEngine.CloseConnection(); return(_SAP); }
public async Task <MsgRetriever> WebSAPGeneralInfoMaint(SAP_GeneralInfo _SAP, string SapNo) { var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint); objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[15]; SqlCommand cmd = new SqlCommand(); Parameters[0] = String.IsNullOrEmpty(SapNo) ? new SqlParameter("@SapNo", DBNull.Value) : new SqlParameter("@SapNo", SapNo); Parameters[1] = String.IsNullOrEmpty(_SAP.ReconAccountNo) ? new SqlParameter("@ReconAcctNo", DBNull.Value) : new SqlParameter("@ReconAcctNo", _SAP.ReconAccountNo); Parameters[2] = String.IsNullOrEmpty(_SAP.selectedDistributionChannel) ? new SqlParameter("@DistChannel", DBNull.Value) : new SqlParameter("@DistChannel", _SAP.selectedDistributionChannel); Parameters[3] = String.IsNullOrEmpty(_SAP.CompanyCd) ? new SqlParameter("@CmpyCd", DBNull.Value) : new SqlParameter("@CmpyCd", _SAP.CompanyCd); Parameters[4] = String.IsNullOrEmpty(_SAP.SelectedDivision) ? new SqlParameter("@Division", DBNull.Value) : new SqlParameter("@Division", _SAP.SelectedDivision); Parameters[5] = String.IsNullOrEmpty(_SAP.selectedSalesOrganisation) ? new SqlParameter("@SaleOrg", DBNull.Value) : new SqlParameter("@SaleOrg", _SAP.selectedSalesOrganisation); Parameters[6] = String.IsNullOrEmpty(_SAP.selectedCustomerClass) ? new SqlParameter("@CustClass", DBNull.Value) : new SqlParameter("@CustClass", _SAP.selectedCustomerClass); Parameters[7] = String.IsNullOrEmpty(_SAP.AuthCd) ? new SqlParameter("@Autho", DBNull.Value) : new SqlParameter("@Autho", _SAP.AuthCd); Parameters[8] = String.IsNullOrEmpty(_SAP.SearchName) ? new SqlParameter("@SearchTerm1", DBNull.Value) : new SqlParameter("@SearchTerm1", _SAP.SearchName); Parameters[9] = String.IsNullOrEmpty(_SAP.SortKey) ? new SqlParameter("@SortKey", DBNull.Value) : new SqlParameter("@SortKey", _SAP.SortKey); Parameters[10] = String.IsNullOrEmpty(_SAP.Location) ? new SqlParameter("@Location", DBNull.Value) : new SqlParameter("@Location", _SAP.Location); Parameters[11] = String.IsNullOrEmpty(_SAP.SelectedCountryCd) ? new SqlParameter("@CtryCd", DBNull.Value) : new SqlParameter("@CtryCd", _SAP.SelectedCountryCd); Parameters[12] = String.IsNullOrEmpty(_SAP.SelectedCurrencyCd) ? new SqlParameter("@CurrCd", DBNull.Value) : new SqlParameter("@CurrCd", _SAP.SelectedCurrencyCd); Parameters[13] = String.IsNullOrEmpty(_SAP.SelectedCashManagementGroup) ? new SqlParameter("@CashMgmtGroup", DBNull.Value) : new SqlParameter("@CashMgmtGroup", _SAP.SelectedCashManagementGroup); Parameters[14] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt); Parameters[14].Direction = ParameterDirection.ReturnValue; var Cmd = objDataEngine.ExecuteWithReturnValue("[WebSAPGeneralInfoMaint]", CommandType.StoredProcedure, Parameters); var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value); var Descp = GetMessageCode(Result); objDataEngine.CloseConnection(); return(await Descp); }