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