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);
}
