public async Task <MsgRetriever> WebSAPSalesTerritoryMaint(SAP_SalesTerritory _SAP, string SapNo) { var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint); objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[11]; SqlCommand cmd = new SqlCommand(); Parameters[0] = String.IsNullOrEmpty(SapNo) ? new SqlParameter("@SapNo", DBNull.Value) : new SqlParameter("@SapNo", SapNo); Parameters[1] = String.IsNullOrEmpty(_SAP.SelectedSalesTerritoryCd) ? new SqlParameter("@SalesTerritoryCd", DBNull.Value) : new SqlParameter("@SalesTerritoryCd", _SAP.SelectedSalesTerritoryCd); Parameters[2] = String.IsNullOrEmpty(_SAP.CustomerPricingProc) ? new SqlParameter("@CustPricingProc", DBNull.Value) : new SqlParameter("@CustPricingProc", _SAP.CustomerPricingProc); Parameters[3] = String.IsNullOrEmpty(_SAP.SelectedCustoemrStatsGroup) ? new SqlParameter("@CustStatisticGroup", DBNull.Value) : new SqlParameter("@CustStatisticGroup", _SAP.SelectedCustoemrStatsGroup); Parameters[4] = String.IsNullOrEmpty(_SAP.SelectedSalesDistrict) ? new SqlParameter("@SalesDistrict", DBNull.Value) : new SqlParameter("@SalesDistrict", _SAP.SelectedSalesDistrict); Parameters[5] = String.IsNullOrEmpty(_SAP.SalesOfficer) ? new SqlParameter("@SalesOffice", DBNull.Value) : new SqlParameter("@SalesOffice", _SAP.SalesOfficer); Parameters[6] = String.IsNullOrEmpty(_SAP.ShippingConditions) ? new SqlParameter("@ShippingCondition", DBNull.Value) : new SqlParameter("@ShippingCondition", _SAP.ShippingConditions); Parameters[7] = String.IsNullOrEmpty(_SAP.MaxPartialDelivery) ? new SqlParameter("@MaxPartialDelivery", DBNull.Value) : new SqlParameter("@MaxPartialDelivery", _SAP.MaxPartialDelivery); Parameters[8] = String.IsNullOrEmpty(_SAP.OrderCombiation) ? new SqlParameter("@OrderCombination", DBNull.Value) : new SqlParameter("@OrderCombination", _SAP.OrderCombiation); Parameters[9] = String.IsNullOrEmpty(_SAP.SelectedTaxClass) ? new SqlParameter("@TaxClass", DBNull.Value) : new SqlParameter("@TaxClass", _SAP.SelectedTaxClass); Parameters[10] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt); Parameters[10].Direction = ParameterDirection.ReturnValue; var Cmd = objDataEngine.ExecuteWithReturnValue("[WebSAPSalesTerritoryMaint]", CommandType.StoredProcedure, Parameters); var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value); var Descp = GetMessageCode(Result); objDataEngine.CloseConnection(); return(await Descp); }
public async Task <SAP_SalesTerritory> SAPSalesTerritory(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("WebSAPSalesTerritorySelect", CommandType.StoredProcedure, Parameters); var _SAP = new SAP_SalesTerritory(); while (execResult.Read()) { _SAP.SelectedSalesTerritoryCd = Convert.ToString(execResult["SalesTerritoryCd"]); _SAP.SalesTerritoryCd = await BaseClass.WebGetRefLib("City"); _SAP.CustomerPricingProc = Convert.ToString(execResult["CustPricingProc"]); _SAP.SelectedCustoemrStatsGroup = Convert.ToString(execResult["CustStatisticGroup"]); _SAP.CustomerStatsGroup = await BaseClass.WebGetRefLib("City"); _SAP.SelectedSalesDistrict = Convert.ToString(execResult["CustStatisticGroup"]); _SAP.SalesDistrict = await BaseClass.WebGetRefLib("City"); _SAP.SalesOfficer = Convert.ToString(execResult["SalesOfficer"]); _SAP.SelectedSalesGroup = Convert.ToString(execResult["SalesGroup"]); _SAP.SalesGroup = await BaseClass.WebGetRefLib("City"); _SAP.ShippingConditions = Convert.ToString(execResult["ShippingCondition"]); _SAP.MaxPartialDelivery = Convert.ToString(execResult["MaxPartialDelivery"]); _SAP.SelectedTaxClass = Convert.ToString(execResult["TaxClass"]); _SAP.TaxClass = await BaseClass.WebGetRefLib("City"); _SAP.OrderCombiation = Convert.ToString(execResult["OrderCombination"]); } return(_SAP); }