public async Task <MsgRetriever> SaveCardReplacement(CardReplacement CardReplace)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[10];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(CardReplace.CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", CardReplace.CardNo);
Parameters[2] = new SqlParameter("@NewCardNo", SqlDbType.VarChar, 19);
Parameters[2].Direction = ParameterDirection.Output;
Parameters[3] = String.IsNullOrEmpty(CardReplace.ExpiryDate) ? new SqlParameter("@ExpiryDate", DBNull.Value) : new SqlParameter("@ExpiryDate", CardReplace.ExpiryDate);// new SqlParameter("@ExpiryDate", ConvertDatetimeDB(CardReplace.ExpiryDate));
Parameters[4] = String.IsNullOrEmpty(CardReplace.SelectedFeeCd) ? new SqlParameter("@FeeCd", DBNull.Value) : new SqlParameter("@FeeCd", CardReplace.SelectedFeeCd);
Parameters[5] = String.IsNullOrEmpty(CardReplace.SelectedReasonCode) ? new SqlParameter("@ReasonCd", DBNull.Value) : new SqlParameter("@ReasonCd", CardReplace.SelectedReasonCode);
Parameters[6] = String.IsNullOrEmpty(CardReplace.Remarks) ? new SqlParameter("@Remarks", DBNull.Value) : new SqlParameter("@Remarks", CardReplace.Remarks);
Parameters[7] = String.IsNullOrEmpty(this.GetUserId) ? new SqlParameter("@UserId", DBNull.Value) : new SqlParameter("@UserId", this.GetUserId);
Parameters[8] = String.IsNullOrEmpty(CardReplace.SelectedCardMediaType) ? new SqlParameter("@CardMedia", DBNull.Value) : new SqlParameter("@CardMedia", CardReplace.SelectedCardMediaType);
Parameters[9] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[9].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebCardReplacementMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
NewcardNo = Convert.ToString(Cmd.Parameters["@NewCardNo"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> SavePukalSedut(int accountNo, decimal txnAmt, string UserId)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[4];
Parameters[0] = new SqlParameter("@AcctNo", accountNo);
Parameters[1] = new SqlParameter("@TxnAmt", txnAmt);
Parameters[2] = String.IsNullOrEmpty(UserId)?new SqlParameter("@UserId", DBNull.Value): new SqlParameter("@UserId", UserId);
Parameters[3] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[3].Direction = ParameterDirection.ReturnValue;
var execResult = await objDataEngine.ExecuteWithReturnValueAsync("WebPukalSedutMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(execResult.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
catch (Exception ex)
{
return(new MsgRetriever {
desp = ex.Message, flag = 0
});
throw ex;
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> DeleteLocationAcceptance(string AcctNo, string BusnLocation, string CardNo)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[6];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo ", AcctNo);
Parameters[2] = String.IsNullOrEmpty(CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", CardNo);
Parameters[3] = String.IsNullOrEmpty(BusnLocation) ? new SqlParameter("@BusnLocation", DBNull.Value) : new SqlParameter("@BusnLocation", BusnLocation);
Parameters[4] = new SqlParameter("@UserId", this.GetUserId);
Parameters[5] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[5].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebLocationAcceptanceDelete", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
MsgRetriever Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> SaveMilestoneMerchant(Milestone _milestone)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
await objDataEngine.InitiateConnectionAsync();
SqlParameter[] Parameters = new SqlParameter[12];
Parameters[0] = new SqlParameter("@Id", ConvertLongToDb(_milestone.ID));
Parameters[1] = String.IsNullOrEmpty(_milestone.SelectedTaskNo) ? new SqlParameter("@TaskNo", DBNull.Value) : new SqlParameter("@TaskNo", _milestone.SelectedTaskNo);//new SqlParameter("@TaskNo", ConvertIntToDb(_milestone.SelectedTaskNo));
Parameters[2] = new SqlParameter("@RefKey", ConvertLongToDb(_milestone.aprId));
Parameters[3] = String.IsNullOrEmpty(_milestone.RefNo) ? new SqlParameter("@RefNo", DBNull.Value) : new SqlParameter("@RefNo", _milestone.RefNo);
Parameters[4] = String.IsNullOrEmpty(_milestone.selectedOwner) ? new SqlParameter("@Owner", DBNull.Value) : new SqlParameter("@Owner", _milestone.selectedOwner);
Parameters[5] = String.IsNullOrEmpty(_milestone.selectedPriority) ? new SqlParameter("@Priority", DBNull.Value) : new SqlParameter("@Priority", _milestone.selectedPriority); //new SqlParameter("@Priority", ConvertIntToDb(_milestone.selectedPriority));
Parameters[6] = String.IsNullOrEmpty(_milestone.Remarks) ? new SqlParameter("@Remarks", DBNull.Value) : new SqlParameter("@Remarks", _milestone.Remarks);
Parameters[7] = String.IsNullOrEmpty(_milestone.selectedReasonCd) ? new SqlParameter("@ReasonCd", DBNull.Value) : new SqlParameter("@ReasonCd", _milestone.selectedReasonCd);
Parameters[8] = new SqlParameter("@RecallDate", ConvertDatetimeDB(_milestone.RecallDate));
Parameters[9] = String.IsNullOrEmpty(_milestone.selectedStatus) ? new SqlParameter("@Sts", DBNull.Value) : new SqlParameter("@Sts", _milestone.selectedStatus);
Parameters[10] = String.IsNullOrEmpty(this.GetUserId) ? new SqlParameter("@UserId", DBNull.Value) : new SqlParameter("@UserId", this.GetUserId);
Parameters[11] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[11].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebMilestoneMerchAdjustmentApproval", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> WebPinChange(string CardNo)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[4];
SqlCommand cmd = new SqlCommand();
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", CardNo);
Parameters[2] = new SqlParameter("@UserId", this.GetUserId);
Parameters[3] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[3].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebPinChange", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> ResetInternalUserPassword(string Token, Login Login)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Web);
try
{
await objDataEngine.InitiateConnectionAsync();
SqlParameter[] Parameters = new SqlParameter[3];
SqlCommand cmd = new SqlCommand();
Parameters[0] = String.IsNullOrEmpty(Token) ? new SqlParameter("@Token", DBNull.Value) : new SqlParameter("@Token", Token);
Parameters[1] = String.IsNullOrEmpty(Login.Password) ? new SqlParameter("@NewPass", DBNull.Value) : new SqlParameter("@NewPass", Login.Password);
Parameters[2] = new SqlParameter("@RETURN_VALUE", SqlDbType.TinyInt);
Parameters[2].Direction = ParameterDirection.ReturnValue;
// Parameters[10] = new SqlParameter("@Flag", isUpdate ? "U" : "N");
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebInternalAdminPassValidate", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> UpdatePassword(Login _UserAccess)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Web);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[4];
SqlCommand cmd = new SqlCommand();
Parameters[0] = new SqlParameter("@UserId", _UserAccess.AppUid);
Parameters[1] = new SqlParameter("@OldPass", _UserAccess.OldPassword);
Parameters[2] = new SqlParameter("@NewPass", _UserAccess.Password);
Parameters[3] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[3].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebInternalChangesPassMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> DelTxnAdjustment(TxnAdjustment _TxnAdjustment)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
await objDataEngine.InitiateConnectionAsync();
SqlParameter[] Parameters = new SqlParameter[5];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(_TxnAdjustment.TxnId) ? new SqlParameter("@TxnId", DBNull.Value) : new SqlParameter("@TxnId", _TxnAdjustment.TxnId);
Parameters[2] = String.IsNullOrEmpty(_TxnAdjustment._CardnAccNo.AccNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", _TxnAdjustment._CardnAccNo.AccNo);
Parameters[3] = String.IsNullOrEmpty(_TxnAdjustment._CardnAccNo.CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", _TxnAdjustment._CardnAccNo.CardNo);
Parameters[4] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[4].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebTxnAdjustmentDelete", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> SaveLocationAccept(LocationAcceptListModel LocationAcceptance)
{
MsgRetriever Descp = new MsgRetriever();
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
if (LocationAcceptance.SelectedStates[0] != "")
{
foreach (var x in LocationAcceptance.SelectedStates)
{
objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[7];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(LocationAcceptance._CardnAccNo.AccNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", LocationAcceptance._CardnAccNo.AccNo);
Parameters[2] = String.IsNullOrEmpty(LocationAcceptance._CardnAccNo.CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", LocationAcceptance._CardnAccNo.CardNo);
Parameters[3] = new SqlParameter("@State", Convert.ToString(x));
Parameters[4] = new SqlParameter("@BusnLocation", DBNull.Value);
Parameters[5] = new SqlParameter("@UserId", GetUserId);
Parameters[6] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[6].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebLocationAcceptanceMaint", CommandType.StoredProcedure, Parameters);
var result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
Descp = await GetMessageCode(result);
objDataEngine.CloseConnection();
}
objDataEngine.CloseConnection();
return(Descp);
}
else
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[7];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(LocationAcceptance._CardnAccNo.AccNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", LocationAcceptance._CardnAccNo.AccNo);
Parameters[2] = String.IsNullOrEmpty(LocationAcceptance._CardnAccNo.CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", LocationAcceptance._CardnAccNo.CardNo);
Parameters[3] = new SqlParameter("@State", null);
Parameters[4] = String.IsNullOrEmpty(LocationAcceptance.BusnLoc) ? new SqlParameter("@BusnLocation", DBNull.Value) : new SqlParameter("@BusnLocation", LocationAcceptance.BusnLoc);
Parameters[5] = new SqlParameter("@UserId", GetUserId);
Parameters[6] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[6].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebLocationAcceptanceMaint", CommandType.StoredProcedure, Parameters);
var result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
Descp = await GetMessageCode(result);
}
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> WebRefMaint(LookupParameters _variable)
{ //@RefCd to save address is the selected address type
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
await objDataEngine.InitiateConnectionAsync();
SqlParameter[] Parameters = new SqlParameter[8];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(_variable.type) ? new SqlParameter("@RefType", DBNull.Value) : new SqlParameter("@RefType", _variable.type);
Parameters[2] = new SqlParameter("@Flag", _variable.flag);
Parameters[3] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[3].Direction = ParameterDirection.ReturnValue;
if (_variable.type == "State")
{
//@Html.CustomNgSelectListFor(model => model.Country, Model.Countries, new { required = true }, new { @Name = "Countries", @section = "con", ng_disabled = "isUpdate", on_select = "CountryChanged($item, $model);" })
//@Html.CustomNgTextBoxFor(model => model.StateCode, new { required = true }, new { @section = "con", @ng_disabled = "editMode" })
//@Html.CustomNgTextBoxFor(model => model.StateName, new { required = true }, new { @section = "con" })
Parameters[4] = String.IsNullOrEmpty(_variable.StateCode) ? new SqlParameter("@RefCd", DBNull.Value) : new SqlParameter("@RefCd", _variable.StateCode);
Parameters[5] = String.IsNullOrEmpty(_variable.Country) ? new SqlParameter("@RefNo", DBNull.Value) : new SqlParameter("@RefNo", _variable.Country);
Parameters[6] = String.IsNullOrEmpty(_variable.StateName) ? new SqlParameter("@Descp", DBNull.Value) : new SqlParameter("@Descp", _variable.StateName);
Parameters[7] = new SqlParameter("@RefId", DBNull.Value);
}
else if (_variable.type == "City")
{
Parameters[4] = String.IsNullOrEmpty(_variable.ParameterCode) ? new SqlParameter("@RefCd", DBNull.Value) : new SqlParameter("@RefCd", _variable.ParameterCode);
Parameters[5] = String.IsNullOrEmpty(_variable.Country) ? new SqlParameter("@RefNo", DBNull.Value) : new SqlParameter("@RefNo", _variable.Country);
Parameters[6] = String.IsNullOrEmpty(_variable.StateCode) ? new SqlParameter("@RefId", DBNull.Value) : new SqlParameter("@RefId", _variable.StateCode);
Parameters[7] = String.IsNullOrEmpty(_variable.CityName) ? new SqlParameter("@Descp", DBNull.Value) : new SqlParameter("@Descp", _variable.CityName);
//@Html.CustomNgSelectListFor(model => model.Country, Model.Countries, new { required = true }, new { @Name = "Countries", @section = "con", ng_disabled = "isUpdate", on_select = "CountryChanged($item, $model);" })
//@Html.CustomNgSelectListFor(model => model.StateCode, Model.States, new { required = true }, new { @Name = "States", @section = "con", ng_disabled = "isUpdate" })
//@Html.CustomNgTextBoxFor(model => model.ParameterCode, new { required = true }, new { @section = "con", @ng_disabled = "editMode" })
//@Html.CustomNgTextBoxFor(model => model.CityName, new { required = true }, new { @section = "con" })
}
else
{
Parameters[4] = String.IsNullOrEmpty(_variable.ParameterCode) ? new SqlParameter("@RefCd", DBNull.Value) : new SqlParameter("@RefCd", _variable.ParameterCode);
Parameters[5] = String.IsNullOrEmpty(_variable.ParameterDescp) ? new SqlParameter("@Descp", DBNull.Value) : new SqlParameter("@Descp", _variable.ParameterDescp);
Parameters[6] = new SqlParameter("@RefNo", DBNull.Value);
Parameters[7] = new SqlParameter("@RefId", DBNull.Value);
}
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebRefMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> PinMailerPrint(int batchID, List <long> cardList)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = new SqlParameter("@BatchId", batchID);
DataTable dt = new DataTable();
dt.Columns.Add("BatchId");
dt.Columns.Add("CardNo", typeof(long));
dt.Columns.Add("Sts");
for (int i = 0; i < cardList.Count; i++)
{
DataRow dr = dt.NewRow();
dr["BatchId"] = batchID;
dr["CardNo"] = cardList[i];
dr["Sts"] = DBNull.Value;
dt.Rows.Add(dr);
}
Parameters[1] = new SqlParameter("@PINMailer", dt);
Parameters[1].SqlDbType = SqlDbType.Structured;
Parameters[2] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[2].Direction = ParameterDirection.ReturnValue;
//try
//{
var execResult = await objDataEngine.ExecuteWithReturnValueAsync("WebPINMailerMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(execResult.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
//}
//catch (Exception ex)
//{
// objDataEngine.CloseConnection();
// return null;
//}
}
public async Task <MsgRetriever> SaveGeneralInfo(CardHolderInfoModel CardData)
{
var objDataEngine = new FleetDataEngine(AccessMode.Admin, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[27];
SqlCommand cmd = new SqlCommand();
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(CardData.CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", ConvertLongToDb(CardData.CardNo));
Parameters[2] = String.IsNullOrEmpty(CardData.EmbossName) ? new SqlParameter("@EmbName", DBNull.Value) : new SqlParameter("@EmbName", CardData.EmbossName);
Parameters[3] = String.IsNullOrEmpty(CardData.SelectedCurrentStatus) ? new SqlParameter("@Sts", DBNull.Value) : new SqlParameter("@Sts", CardData.SelectedCurrentStatus);
Parameters[4] = new SqlParameter("@TerminatedDate", ConvertDatetimeDB(CardData.TerminatedDate));
Parameters[5] = String.IsNullOrEmpty(CardData.vehRegNo) ? new SqlParameter("@VehRegsNo", DBNull.Value) : new SqlParameter("@VehRegsNo", CardData.vehRegNo);
Parameters[6] = String.IsNullOrEmpty(CardData.DriverCd) ? new SqlParameter("@DriverCd", DBNull.Value) : new SqlParameter("@DriverCd", CardData.DriverCd);
Parameters[7] = new SqlParameter("@SKDSInd", ConvertBoolDB(CardData.SelectedSKDSInd));
Parameters[8] = new SqlParameter("@SKDSQuota", ConvertDecimalToDb(CardData.SKDSQuota));
Parameters[9] = String.IsNullOrEmpty(CardData.SelectedSKDSNo) ? new SqlParameter("@SKDSNo", DBNull.Value) : new SqlParameter("@SKDSNo", CardData.SelectedSKDSNo);
Parameters[10] = String.IsNullOrEmpty(CardData.SelectedDialogueInd) ? new SqlParameter("@DialogueInd", DBNull.Value) : new SqlParameter("@DialogueInd", CardData.SelectedDialogueInd);
Parameters[11] = new SqlParameter("@PINInd", ConvertBoolDB(CardData.SelectedPINInd));
Parameters[12] = new SqlParameter("@OdometerInd", ConvertBoolDB(CardData.OdometerIndicator));
Parameters[13] = new SqlParameter("@AcctNo", ConvertLongToDb(CardData.AcctNo));//String.IsNullOrEmpty(CardData.AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) :
Parameters[14] = new SqlParameter("@PushAlertInd", ConvertBoolDB(CardData.SelectedPushAlertInd));
Parameters[15] = String.IsNullOrEmpty(CardData.SelectedAnnualFee) ? new SqlParameter("@AnnlFee", DBNull.Value) : new SqlParameter("@AnnlFee", CardData.SelectedAnnualFee);
Parameters[16] = String.IsNullOrEmpty(CardData.SelectedJonFee) ? new SqlParameter("@JoiningFee", DBNull.Value) : new SqlParameter("@JoiningFee", CardData.SelectedJonFee);
Parameters[17] = String.IsNullOrEmpty(CardData.SelectedRenewalInd) ? new SqlParameter("@RenewalInd", DBNull.Value) : new SqlParameter("@RenewalInd ", CardData.SelectedRenewalInd);
Parameters[18] = new SqlParameter("@UserId", this.GetUserId);
Parameters[19] = new SqlParameter("@PrimaryCard", ConvertBoolDB(CardData.PrimaryCard));
Parameters[20] = String.IsNullOrEmpty(CardData.SelectedProductUtilization) ? new SqlParameter("@ProductGroup", DBNull.Value) : new SqlParameter("@ProductGroup", CardData.SelectedProductUtilization);
Parameters[21] = String.IsNullOrEmpty(CardData.SelectedCostCentre) ? new SqlParameter("@CostCentre", DBNull.Value) : new SqlParameter("@CostCentre", CardData.SelectedCostCentre);
Parameters[22] = String.IsNullOrEmpty(CardData.SelectedVehicleModel) ? new SqlParameter("@VehModel", DBNull.Value) : new SqlParameter("@VehModel", CardData.SelectedVehicleModel);
Parameters[23] = String.IsNullOrEmpty(CardData.SelectedBranchCd) ? new SqlParameter("@BranchCd", DBNull.Value) : new SqlParameter("@BranchCd", CardData.SelectedBranchCd);
Parameters[24] = String.IsNullOrEmpty(CardData.SelectedDivisionCode) ? new SqlParameter("@DivisionCd", DBNull.Value) : new SqlParameter("@DivisionCd", CardData.SelectedDivisionCode);
Parameters[25] = String.IsNullOrEmpty(CardData.SelectedDeptCd) ? new SqlParameter("@DeptCd", DBNull.Value) : new SqlParameter("@DeptCd", CardData.SelectedDeptCd);
Parameters[26] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[26].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebCardGeneralInfoMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> SaveTxnAdjustment(TxnAdjustment _TxnAdjustment)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
await objDataEngine.InitiateConnectionAsync();
SqlParameter[] Parameters = new SqlParameter[19];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(_TxnAdjustment.TxnId) ? new SqlParameter("@TxnId", DBNull.Value) : new SqlParameter("@TxnId", _TxnAdjustment.TxnId);
Parameters[2] = String.IsNullOrEmpty(_TxnAdjustment._CardnAccNo.AccNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", _TxnAdjustment._CardnAccNo.AccNo);
Parameters[3] = String.IsNullOrEmpty(_TxnAdjustment._CardnAccNo.CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", _TxnAdjustment._CardnAccNo.CardNo);
Parameters[4] = String.IsNullOrEmpty(_TxnAdjustment.SelectedTxnCd) ? new SqlParameter("@TxnCd", DBNull.Value) : new SqlParameter("@TxnCd", _TxnAdjustment.SelectedTxnCd);
Parameters[5] = new SqlParameter("@TxnDate", ConvertDatetimeDB(_TxnAdjustment.TxnDate));
Parameters[6] = String.IsNullOrEmpty(_TxnAdjustment.DueDate) ? new SqlParameter("@DueDate", DBNull.Value) : new SqlParameter("@DueDate", ConvertDatetimeDB(_TxnAdjustment.DueDate));
Parameters[7] = new SqlParameter("@TxnAmt", ConvertDecimalToDb(_TxnAdjustment.TotAmnt));
Parameters[8] = new SqlParameter("@Pts", ConvertDecimalToDb(_TxnAdjustment.Totpts));
Parameters[9] = String.IsNullOrEmpty(_TxnAdjustment.Descp) ? new SqlParameter("@Descp", DBNull.Value) : new SqlParameter("@Descp", _TxnAdjustment.Descp);
Parameters[10] = String.IsNullOrEmpty(_TxnAdjustment.AppvCd) ? new SqlParameter("@AppvCd", DBNull.Value) : new SqlParameter("@AppvCd", _TxnAdjustment.AppvCd);
Parameters[11] = new SqlParameter("@CheqNo", ConvertLongToDb(_TxnAdjustment.ChequeNo));
Parameters[12] = String.IsNullOrEmpty(_TxnAdjustment.SelectedSts) ? new SqlParameter("@Sts", DBNull.Value) : new SqlParameter("@Sts", _TxnAdjustment.SelectedSts);
Parameters[13] = new SqlParameter("@RcptNo", SqlDbType.BigInt);
Parameters[13].Direction = ParameterDirection.Output;
Parameters[14] = new SqlParameter("@RetCd", SqlDbType.BigInt);
Parameters[14].Direction = ParameterDirection.Output;
Parameters[15] = String.IsNullOrEmpty(System.Web.HttpContext.Current.User.Identity.Name) ? new SqlParameter("@UserId", DBNull.Value) : new SqlParameter("@UserId", System.Web.HttpContext.Current.User.Identity.Name);
Parameters[16] = String.IsNullOrEmpty(_TxnAdjustment.SelectedOwner) ? new SqlParameter("@Owner", DBNull.Value) : new SqlParameter("@Owner", _TxnAdjustment.SelectedOwner);
Parameters[17] = String.IsNullOrEmpty(_TxnAdjustment.DeftBusnLocation) ? new SqlParameter("@Dealer", DBNull.Value) : new SqlParameter("@Dealer", _TxnAdjustment.DeftBusnLocation);
Parameters[18] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[18].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebTxnAdjustmentMaint", CommandType.StoredProcedure, Parameters);
var Result = ConvertInt(Cmd.Parameters["@RETURN_VALUE"].Value);
this.RcptNo = ConvertInt(Cmd.Parameters[13].Value);
this.RetCd = ConvertInt(Cmd.Parameters[14].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> SaveMerchManualBatch(ManualSlipEntry _ManualSlipEntry)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[16];
SqlCommand cmd = new SqlCommand();
Parameters[0] = new SqlParameter("@AcqNo", this.GetAcqNo);
Parameters[1] = String.IsNullOrEmpty(_ManualSlipEntry.SettleId) ? new SqlParameter("@SettleId", DBNull.Value) : new SqlParameter("@SettleId", _ManualSlipEntry.SettleId);
Parameters[2] = String.IsNullOrEmpty(_ManualSlipEntry.BusnLocation) ? new SqlParameter("@BusnLocation", DBNull.Value) : new SqlParameter("@BusnLocation", _ManualSlipEntry.BusnLocation);
Parameters[3] = String.IsNullOrEmpty(_ManualSlipEntry.SiteId) ? new SqlParameter("@SiteId", DBNull.Value) : new SqlParameter("@SiteId", _ManualSlipEntry.SiteId);
Parameters[4] = String.IsNullOrEmpty(_ManualSlipEntry.SelectedTermId) ? new SqlParameter("@TermId", DBNull.Value) : new SqlParameter("@TermId", _ManualSlipEntry.SelectedTermId);
Parameters[5] = new SqlParameter("@TxnCd", ConvertIntToDb(_ManualSlipEntry.SelectedTxnCd));
Parameters[6] = new SqlParameter("@InvoiceNo ", ConvertIntToDb(_ManualSlipEntry.InvoiceNo));
Parameters[7] = String.IsNullOrEmpty(_ManualSlipEntry.BatchId) ? new SqlParameter("@BatchId", DBNull.Value) : new SqlParameter("@BatchId", _ManualSlipEntry.BatchId);
Parameters[8] = new SqlParameter("@OrigBatchNo", ConvertLongToDb(_ManualSlipEntry.OrigBatchNo));
Parameters[9] = String.IsNullOrEmpty(_ManualSlipEntry.Descp) ? new SqlParameter("@Descp", DBNull.Value) : new SqlParameter("@Descp", _ManualSlipEntry.Descp);
Parameters[10] = String.IsNullOrEmpty(_ManualSlipEntry.SettleDate) ? new SqlParameter("@SettleDate", DBNull.Value) : new SqlParameter("@SettleDate", DateConverterDB(_ManualSlipEntry.SettleDate));
Parameters[11] = String.IsNullOrEmpty(_ManualSlipEntry.SelectedSts) ? new SqlParameter("@Sts", DBNull.Value) : new SqlParameter("@Sts", _ManualSlipEntry.SelectedSts);
Parameters[12] = String.IsNullOrEmpty(this.GetUserId) ? new SqlParameter("@UserId", DBNull.Value) : new SqlParameter("@UserId", this.GetUserId);
Parameters[13] = new SqlParameter("@oBatchId", SqlDbType.NVarChar, 20);
Parameters[13].Direction = ParameterDirection.Output;
Parameters[14] = new SqlParameter("@oSettleId", SqlDbType.NVarChar, 20);
Parameters[14].Direction = ParameterDirection.Output;
Parameters[15] = new SqlParameter("@RETURN_VALUE", SqlDbType.VarChar, 19);
Parameters[15].Direction = ParameterDirection.ReturnValue;
//Parameters[9] = String.IsNullOrEmpty(_ManualSlipEntry.SiteId) ? new SqlParameter("@SiteId", DBNull.Value) : new SqlParameter("@SiteId", DateConverterDB(_ManualSlipEntry.SiteId));
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebMerchManualBatchMaint", CommandType.StoredProcedure, Parameters);
var Result = ConvertInt(Cmd.Parameters["@RETURN_VALUE"].Value);
this.BatchId = Convert.ToString(Cmd.Parameters[13].Value);
this.SettleId = Convert.ToString(Cmd.Parameters[14].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> SaveUserAccess(UserAccess _UserAccess, bool isUpdate = false)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Web);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[15];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(_UserAccess.SelectedAccessInd) ? new SqlParameter("@AccessInd", DBNull.Value) : new SqlParameter("@AccessInd", _UserAccess.SelectedAccessInd);
Parameters[2] = String.IsNullOrEmpty(_UserAccess.selectedSts) ? new SqlParameter("@Sts", DBNull.Value) : new SqlParameter("@Sts ", _UserAccess.selectedSts);
Parameters[3] = String.IsNullOrEmpty(_UserAccess.UserId) ? new SqlParameter("@UserId", DBNull.Value) : new SqlParameter("@UserId ", _UserAccess.UserId);
Parameters[4] = String.IsNullOrEmpty(_UserAccess.Password) ? new SqlParameter("@Pw", DBNull.Value) : new SqlParameter("@Pw", _UserAccess.Password);
Parameters[5] = String.IsNullOrEmpty(_UserAccess.Name) ? new SqlParameter("@Name", DBNull.Value) : new SqlParameter("@Name ", _UserAccess.Name);
Parameters[6] = String.IsNullOrEmpty(_UserAccess.ContactNo) ? new SqlParameter("@ContactNo", DBNull.Value) : new SqlParameter("@ContactNo ", _UserAccess.ContactNo);
Parameters[7] = String.IsNullOrEmpty(_UserAccess.EmailAddr) ? new SqlParameter("@EmailAddr", DBNull.Value) : new SqlParameter("@EmailAddr ", _UserAccess.EmailAddr);
Parameters[8] = String.IsNullOrEmpty(_UserAccess.SeletedTitle) ? new SqlParameter("@Title", DBNull.Value) : new SqlParameter("@Title ", _UserAccess.SeletedTitle);
Parameters[9] = String.IsNullOrEmpty(_UserAccess.SelectedDeptId) ? new SqlParameter("@DeptId", DBNull.Value) : new SqlParameter("@DeptId ", _UserAccess.SelectedDeptId);
Parameters[10] = String.IsNullOrEmpty(_UserAccess.PrivilegeCd) ? new SqlParameter("@PrivilegeCd", DBNull.Value) : new SqlParameter("@PrivilegeCd ", _UserAccess.PrivilegeCd);
Parameters[11] = String.IsNullOrEmpty(_UserAccess.CreatedBy) ? new SqlParameter("@CreatedBy", DBNull.Value) : new SqlParameter("@CreatedBy ", _UserAccess.CreatedBy);
Parameters[12] = new SqlParameter("@ChangePassInd", BaseClass.ConvertBoolDB(_UserAccess.ChangePasswordInd));
Parameters[13] = new SqlParameter("@Flag", isUpdate ? "U" : "N");
Parameters[14] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[14].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebUserAccessMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
if (Descp.flag == 0)
{
//this.GenerateUserFolder(_UserAccess.UserId);
return(Descp);
}
else
{
return(Descp);
}
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> SavePersonInfo(PersonInfoModel PersonInfo, string entityID)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[16];
SqlCommand cmd = new SqlCommand();
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(entityID) ? new SqlParameter("@EntityId", DBNull.Value) : new SqlParameter("@EntityId", entityID);
Parameters[2] = String.IsNullOrEmpty(PersonInfo.SelectedTitle) ? new SqlParameter("@Title", DBNull.Value) : new SqlParameter("@Title", PersonInfo.SelectedTitle);
Parameters[3] = String.IsNullOrEmpty(PersonInfo.FirstName) ? new SqlParameter("@FirstName", DBNull.Value) : new SqlParameter("@FirstName", PersonInfo.FirstName);
Parameters[4] = String.IsNullOrEmpty(PersonInfo.LastName) ? new SqlParameter("@LastName", DBNull.Value) : new SqlParameter("@LastName", PersonInfo.LastName);
Parameters[5] = String.IsNullOrEmpty(PersonInfo.IdNo) ? new SqlParameter("@NewIc", DBNull.Value) : new SqlParameter("@NewIc", PersonInfo.IdNo);
Parameters[6] = String.IsNullOrEmpty(PersonInfo.SelectedIdType) ? new SqlParameter("@NewIcType", DBNull.Value) : new SqlParameter("@NewIcType", PersonInfo.SelectedIdType);
Parameters[7] = String.IsNullOrEmpty(PersonInfo.AltIdNo) ? new SqlParameter("@OldIc", DBNull.Value) : new SqlParameter("@OldIc", PersonInfo.AltIdNo);
Parameters[8] = String.IsNullOrEmpty(PersonInfo.SelectedAltIdType) ? new SqlParameter("@OldIcType", DBNull.Value) : new SqlParameter("@OldIcType", PersonInfo.SelectedAltIdType);
Parameters[9] = String.IsNullOrEmpty(PersonInfo.Selectedgender) ? new SqlParameter("@Gender", DBNull.Value) : new SqlParameter("@Gender", PersonInfo.Selectedgender);
Parameters[10] = new SqlParameter("@DOB", ConvertDatetimeDB(PersonInfo.DOB));
Parameters[11] = new SqlParameter("@Income", ConvertDecimalToDb(PersonInfo.AnnualIncome));
Parameters[12] = String.IsNullOrEmpty(PersonInfo.SelectedOccupation) ? new SqlParameter("@Occupation", DBNull.Value) : new SqlParameter("@Occupation", PersonInfo.SelectedOccupation);
Parameters[13] = String.IsNullOrEmpty(PersonInfo.SelectedDeptId) ? new SqlParameter("@DeptId", DBNull.Value) : new SqlParameter("@DeptId", PersonInfo.SelectedDeptId);
Parameters[14] = String.IsNullOrEmpty(PersonInfo.DrivingLicense) ? new SqlParameter("@DrivingLic", DBNull.Value) : new SqlParameter("@DrivingLic", PersonInfo.DrivingLicense);
Parameters[15] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[15].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebEntityMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> SaveFinancialInfo(CardFinancialInfoModel finInfo, string cardNo)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[15];
SqlCommand cmd = new SqlCommand();
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(cardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", cardNo);
Parameters[2] = new SqlParameter("@TxnLimit", ConvertDecimalToDb(finInfo.txnLimit));
Parameters[3] = new SqlParameter("@LitLimit", ConvertDecimalToDb(finInfo.litLimit));
Parameters[4] = new SqlParameter("@PinExceedCnt", ConvertIntToDb(finInfo.PinExceedCnt));
Parameters[5] = new SqlParameter("@PinAttempted", ConvertIntToDb(finInfo.PinAttempted));
Parameters[6] = String.IsNullOrEmpty(finInfo.PinTriedUpdDate) ? new SqlParameter("@PinTriedUpdDate", DBNull.Value) : new SqlParameter("@PinTriedUpdDate", ConvertDatetimeDB(finInfo.PinTriedUpdDate));
Parameters[7] = new SqlParameter("@PushAlertInd", ConvertIntToDb(finInfo.PushAlertInd));
Parameters[8] = new SqlParameter("@LocationInd", ConvertIntToDb(finInfo.LocationInd));
Parameters[9] = new SqlParameter("@LocationCheckFlag", ConvertIntToDb(finInfo.LocationCheckFlag));
Parameters[10] = new SqlParameter("@LocationMaxCnt", ConvertIntToDb(finInfo.LocationMaxCnt));
Parameters[11] = new SqlParameter("@LocationMaxAmt", ConvertDecimalToDb(finInfo.LocationMaxAmt));
Parameters[12] = new SqlParameter("@FuelCheckFlag", ConvertIntToDb(finInfo.FuelCheckFlag));
Parameters[13] = new SqlParameter("@FuelLitPerKM", ConvertDecimalToDb(finInfo.FuelLitPerKM));
Parameters[14] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[14].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebCardFinInfoMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> WebProdGroupRefMaint(LookupParameters _LookupParameters)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
await objDataEngine.InitiateConnectionAsync();
SqlParameter[] Parameters = new SqlParameter[6];
SqlCommand cmd = new SqlCommand();
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(_LookupParameters.SelectedProductGroup) ? new SqlParameter("@ProdGroup", DBNull.Value) : new SqlParameter("@ProdGroup", _LookupParameters.SelectedProductGroup);
Parameters[2] = String.IsNullOrEmpty(_LookupParameters.Descp) ? new SqlParameter("@ProdDescp", DBNull.Value) : new SqlParameter("@ProdDescp", _LookupParameters.Descp);
Parameters[3] = new SqlParameter("@UserId", GetUserId);
DataTable dt = new DataTable();
dt.Columns.Add("ProdCd");
foreach (var item in _LookupParameters.ProductItems)
{
DataRow dr = dt.NewRow();
dr["ProdCd"] = item.ProductCode;
dt.Rows.Add(dr);
}
Parameters[4] = new SqlParameter("@ProdDetail", dt);
Parameters[5] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[5].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("[WebProdGroupRefMaint]", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> SaveBalanceTxn(string inputSrc, List <UnbalanceTxnSearch> UnallocatedModel)
{
DataTable dataTableTxnUnallocate = new DataTable();
dataTableTxnUnallocate.Columns.Add("RecType");
dataTableTxnUnallocate.Columns.Add("SrcTxnId", typeof(Int64));
dataTableTxnUnallocate.Columns.Add("SrcTxnSeq", typeof(Int64));
dataTableTxnUnallocate.Columns.Add("TgtTxnId", typeof(Int64));
dataTableTxnUnallocate.Columns.Add("TxnDate");
dataTableTxnUnallocate.Columns.Add("BookingAmt");
//dataTableTxnUnallocate.Columns.Add("OrigAmt");
//dataTableTxnUnallocate.Columns.Add("Rc");
//dataTableTxnUnallocate.Columns.Add("Cnt");
//dataTableTxnUnallocate.Columns.Add("Err");
//dataTableTxnUnallocate.Columns.Add("PrcsId");
//dataTableTxnUnallocate.Columns.Add("PrcsDate");
//dataTableTxnUnallocate.Columns.Add("PrcsName");
DataRow dr = dataTableTxnUnallocate.NewRow();
if (UnallocatedModel != null)
{
for (int i = 0; i < UnallocatedModel.Count; i++)
{
// dr["ID"]= id;
dr["RecType"] = (object)UnallocatedModel[i].SelectedRecType ?? DBNull.Value;
dr["SrcTxnId"] = (object)UnallocatedModel[i].SrcTxnId ?? DBNull.Value;
dr["SrcTxnSeq"] = (object)UnallocatedModel[i].SrcTxnSequence ?? DBNull.Value;
dr["TgtTxnId"] = (object)UnallocatedModel[i].TgtTxnId ?? DBNull.Value;
dr["TxnDate"] = (object)ConvertDatetimeDB(UnallocatedModel[i].TxnDate) ?? DBNull.Value;
dr["BookingAmt"] = (object)UnallocatedModel[i].BookingAmt ?? DBNull.Value;
//dr["OrigAmt"] = (object)UnallocatedModel[i].OrigAmt ?? DBNull.Value;
//dr["Rc"] = (object)UnallocatedModel[i].re ?? DBNull.Value;
//dr["Cnt"] = (object)UnallocatedModel[i].Cnt ?? DBNull.Value;
//dr["Err"] = (object)UnallocatedModel[i].Err ?? DBNull.Value;
//dr["PrcsId"] = (object)UnallocatedModel[i].PrcsId ?? DBNull.Value;
//dr["PrcsDate"] = (object)UnallocatedModel[i].PrcsDate ?? DBNull.Value;
//dr["PrcsName"] = (object)UnallocatedModel[i].PrcsName ?? DBNull.Value;
dataTableTxnUnallocate.Rows.Add(dr);
dr = dataTableTxnUnallocate.NewRow();
// id = id + 1;
}
}
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[5];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(inputSrc) ? new SqlParameter("@InputSrc", DBNull.Value) : new SqlParameter("@InputSrc", inputSrc);
Parameters[2] = String.IsNullOrEmpty(this.GetUserId) ? new SqlParameter("@UserId", DBNull.Value) : new SqlParameter("@UserId", this.GetUserId);
Parameters[3] = new SqlParameter("@BalanceAllocation", dataTableTxnUnallocate);
Parameters[4] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[4].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebTxnUnallocateMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = GetMessageCode(Result);
return(await Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> SaveWebUserAccessLevel(List <WebModule> ModuleList, List <WebPage> PageList, List <WebControl> CtrlList, List <WebPageSection> SectionList, string UserId)
{
//DataSet dataset = new DataSet();
DataTable dataTable = new DataTable();
// dataTable.Columns.Add("ID");
dataTable.Columns.Add("ModuleID");
dataTable.Columns.Add("PageID");
dataTable.Columns.Add("SectionID");
dataTable.Columns.Add("ControlID");
dataTable.Columns.Add("Status");
DataRow dr = dataTable.NewRow();
if (ModuleList != null)
{
for (int i = 0; i < ModuleList.Count; i++)
{
// dr["ID"]= id;
dr["ModuleID"] = ModuleList[i].ModuleId;
dr["PageID"] = ModuleList[i].PageId; //DBNull.Value;
dr["ControlID"] = ModuleList[i].CtrlId; //DBNull.Value;
dr["Status"] = ModuleList[i].Sts;
dataTable.Rows.Add(dr);
dr = dataTable.NewRow();
// id = id + 1;
}
}
if (PageList != null)
{
for (int i = 0; i < PageList.Count; i++)
{
// dr["ID"] = id;
dr["ModuleID"] = PageList[i].ModuleId;
dr["PageID"] = PageList[i].PageId;
dr["ControlID"] = PageList[i].CtrlId;//DBNull.Value;
dr["Status"] = PageList[i].Sts;
dataTable.Rows.Add(dr);
dr = dataTable.NewRow();
// id = id + 1;
}
}
if (SectionList != null)
{
for (int i = 0; i < SectionList.Count; i++)
{
dr["ModuleID"] = SectionList[i].ModuleId; //DBNull.Value;
dr["PageID"] = SectionList[i].PageId; //DBNull.Value;
dr["ControlID"] = SectionList[i].CtrlId; //DBNull.Value;
dr["SectionID"] = SectionList[i].SectionId;
dr["Status"] = SectionList[i].SectionStatus;
dataTable.Rows.Add(dr);
dr = dataTable.NewRow();
}
}
if (CtrlList != null)
{
for (int i = 0; i < CtrlList.Count; i++)
{
//dr["ID"] = id;
dr["ModuleID"] = CtrlList[i].ModuleId;//DBNull.Value;
dr["PageID"] = CtrlList[i].PageId;
dr["ControlID"] = CtrlList[i].CtrlId;
dr["SectionID"] = CtrlList[i].SectionId;
dr["Status"] = CtrlList[i].Sts;
dataTable.Rows.Add(dr);
dr = dataTable.NewRow();
//id = id + 1;
}
}
var objDataEngine = new FleetDataEngine(AccessMode.Admin, DBType.Web);
try
{
await objDataEngine.InitiateConnectionAsync();
var _SecurityViewModel = new List <SecurityViewModel>();
SqlParameter[] Parameters = new SqlParameter[4];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = new SqlParameter("@UserId", UserId);
Parameters[2] = new SqlParameter("@Tbl", dataTable);
Parameters[3] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[3].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebUserAccessLevelMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> ftMultipleAdjMaint(TxnAdjustment _MultipleTxn)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
DataTable dt = new DataTable();
dt.Columns.Add("Acctno");
dt.Columns.Add("Cardno", typeof(string));//
dt.Columns.Add("TxnAmt");
dt.Columns.Add("Descp");
dt.Columns.Add("InvoiceNo");
dt.Columns.Add("AppvCd");
dt.Columns.Add("DeftBusnLocation");
dt.Columns.Add("DeftTermId");
dt.Columns.Add("Owner");
dt.Columns.Add("Sts");
dt.Columns.Add("TxnDate");
dt.Columns.Add("DueDate");
dt.Columns.Add("TxnCd");
dt.Columns.Add("TxnId");
//dt.Columns.Add("TxnId")
foreach (var item in _MultipleTxn.MultipleTxnRecord)
{
DataRow dr = dt.NewRow();
dr["Acctno"] = item.AcctNo;
dr["Cardno"] = item.CardNo;
if (!string.IsNullOrEmpty(item.TxnAmt))
{
dr["TxnAmt"] = ConvertDecimalToDb(item.TxnAmt);
}
else
{
dr["TxnAmt"] = DBNull.Value;
}
dr["Descp"] = item.TxnDescp;
dr["InvoiceNo"] = item.InvoiceNo;
dr["AppvCd"] = item.AppvCd;
dr["DeftBusnLocation"] = item.DeftBusnLocation;
dr["DeftTermId"] = item.DeftTermId;
dr["Owner"] = _MultipleTxn.SelectedOwner;
dr["Sts"] = item.SelectedSts;
dr["TxnDate"] = ConvertDatetimeDB(_MultipleTxn.TxnDate);
dr["DueDate"] = DBNull.Value;
dr["TxnCd"] = _MultipleTxn.SelectedAdjTxnCode;
dr["TxnId"] = item.TxnId;
//dr["RcptNo"] = DBNull.Value;
dt.Rows.Add(dr);
}
SqlParameter[] Parameters = new SqlParameter[11];
SqlCommand cmd = new SqlCommand();
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
//Parameters[1] = !string.IsNullOrEmpty(_MultipleTxn.CheqNo) ? new SqlParameter("@CheqNo", _MultipleTxn.CheqNo) : new SqlParameter("@CheqNo", DBNull.Value);
Parameters[1] = !string.IsNullOrEmpty(_MultipleTxn.ChequeAmt) ? new SqlParameter("@CheqAmt", ConvertDecimalToDb(_MultipleTxn.ChequeAmt)) : new SqlParameter("@CheqAmt", DBNull.Value);
Parameters[2] = new SqlParameter("@UserId", GetUserId);
Parameters[3] = new SqlParameter("@Adjustment", dt);
Parameters[4] = String.IsNullOrEmpty(_MultipleTxn.ChequeNo) ? new SqlParameter("@RcptNo", DBNull.Value) : new SqlParameter("@RcptNo", _MultipleTxn.ChequeNo);//
//Parameters[5] = new SqlParameter("@RcptNo", SqlDbType.VarChar, 19);
//Parameters[5].Direction = ParameterDirection.Output;
Parameters[5] = new SqlParameter("@Batch", SqlDbType.VarChar, 25);
Parameters[5].Direction = ParameterDirection.Output;
Parameters[6] = new SqlParameter("@RetCd", SqlDbType.Int);
Parameters[6].Direction = ParameterDirection.Output;
Parameters[7] = new SqlParameter("@RcptOut", SqlDbType.Int);
Parameters[7].Direction = ParameterDirection.Output;
Parameters[8] = string.IsNullOrEmpty(_MultipleTxn.BatchId) ? new SqlParameter("@BatchId", DBNull.Value) : new SqlParameter("@BatchId", _MultipleTxn.BatchId);
Parameters[9] = string.IsNullOrEmpty(_MultipleTxn.SelectedOwner) ? new SqlParameter("@Owner", DBNull.Value) : new SqlParameter("@Owner", _MultipleTxn.SelectedOwner);
Parameters[10] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[10].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebMultiTxnAdjustmentMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
this.BatchId = Convert.ToString(Cmd.Parameters["@Batch"].Value);
this.RetCd = ConvertInt(Cmd.Parameters["@RetCd"].Value);
this.ChequeNo = ConvertInt(Cmd.Parameters["@RcptOut"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> SavePukalAcctEdits(PukalAcctMaintInfo listInfo)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
var userid = ClaimsPrincipal.Current.Identities.First();
SqlParameter[] Parameters = new SqlParameter[16];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = new SqlParameter("@Func", listInfo.Func);
if (listInfo.BatchId == 0)
{
Parameters[2] = new SqlParameter("@BatchId", SqlDbType.BigInt);
Parameters[2].Direction = ParameterDirection.Output;
}
else
{
Parameters[2] = new SqlParameter("@BatchId", listInfo.BatchId);
Parameters[2].Direction = ParameterDirection.Input;
}
Parameters[3] = new SqlParameter("@RefCd", listInfo.RefCd);
Parameters[4] = new SqlParameter("@AcctOfficeCd", listInfo.AcctOfficeCd);
Parameters[5] = !string.IsNullOrEmpty(listInfo.SelectedTxnCd)? new SqlParameter("@TxnCd", listInfo.SelectedTxnCd): new SqlParameter("@TxnCd", DBNull.Value);
Parameters[6] = !string.IsNullOrEmpty(listInfo.SelectedSettlement) ? new SqlParameter("@GLSettlement", listInfo.SelectedSettlement) : new SqlParameter("@GLSettlement", DBNull.Value);
Parameters[7] = new SqlParameter("@CycStmtId", listInfo.CycStmtId);
Parameters[8] = new SqlParameter("@ChequeNo", listInfo.ChequeNo);
Parameters[9] = new SqlParameter("@ChequeAmt", Convert.ToDecimal(listInfo.ChequeAmt));
Parameters[10] = listInfo.Func == "Save" ? new SqlParameter("@Owner", DBNull.Value) : new SqlParameter("@Owner", listInfo.SelectedOwner);
Parameters[11] = !string.IsNullOrEmpty(userid.Name) ? new SqlParameter("@UserId", userid.Name) : new SqlParameter("@UserId", DBNull.Value);
DataTable dt = new DataTable();
dt.Columns.Add("AcctNo");
dt.Columns.Add("TxnDate");
dt.Columns.Add("DueDate");
dt.Columns.Add("Amt");
dt.Columns.Add("Descp");
if (listInfo.MultipleTxnRecord != null)
{
foreach (var item in listInfo.MultipleTxnRecord)
{
DataRow dr = dt.NewRow();
dr["AcctNo"] = item.AcctNo;
dr["TxnDate"] = ConvertDatetimeDB(listInfo.CreationDate);
dr["DueDate"] = ConvertDatetimeDB(listInfo.CreationDate);
dr["Amt"] = Convert.ToDecimal(item.PaymentAmt);
dr["Descp"] = DBNull.Value;
dt.Rows.Add(dr);
}
}
Parameters[12] = new SqlParameter("@PukalPayment", dt);
Parameters[13] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[13].Direction = ParameterDirection.ReturnValue;
Parameters[14] = !string.IsNullOrEmpty(listInfo.SlipNo) ? new SqlParameter("@SlipNo", listInfo.SlipNo) : new SqlParameter("@SlipNo", DBNull.Value);
Parameters[15] = !string.IsNullOrEmpty(listInfo.SelectedIssBank) ? new SqlParameter("@IssBank", listInfo.SelectedIssBank) : new SqlParameter("@IssBank", DBNull.Value);
var execResult = await objDataEngine.ExecuteWithReturnValueAsync("WebTxnPukalPaymentMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(execResult.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
if (listInfo.BatchId == 0)
{
Descp.Id = Convert.ToInt32(execResult.Parameters["@BatchId"].Value).ToString();
}
return(Descp);
}catch (Exception ex)
{
objDataEngine.CloseConnection();
throw ex;
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> WebProdRefMaint(LookupParameters _LookupParameters)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
await objDataEngine.InitiateConnectionAsync();
SqlParameter[] Parameters = new SqlParameter[12];
SqlCommand cmd = new SqlCommand();
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = new SqlParameter("@UserId", GetUserId);
Parameters[2] = String.IsNullOrEmpty(_LookupParameters.ProductCode) ? new SqlParameter("@ProdCd", DBNull.Value) : new SqlParameter("@ProdCd", _LookupParameters.ProductCode);
Parameters[3] = String.IsNullOrEmpty(_LookupParameters.ProdDescp) ? new SqlParameter("@ProdName", DBNull.Value) : new SqlParameter("@ProdName", _LookupParameters.ProdDescp);
Parameters[4] = String.IsNullOrEmpty(_LookupParameters.SelectedProductCategory) ? new SqlParameter("@ProdCat", DBNull.Value) : new SqlParameter("@ProdCat", _LookupParameters.SelectedProductCategory);
Parameters[5] = String.IsNullOrEmpty(_LookupParameters.SelectedProductType) ? new SqlParameter("@ProdType", DBNull.Value) : new SqlParameter("@ProdType", _LookupParameters.SelectedProductType);
Parameters[6] = String.IsNullOrEmpty(_LookupParameters.SelectedBillingPlan) ? new SqlParameter("@BillPlanId", DBNull.Value) : new SqlParameter("@BillPlanId", _LookupParameters.SelectedBillingPlan);
Parameters[7] = String.IsNullOrEmpty(_LookupParameters.Descp) ? new SqlParameter("@ShortDescp", DBNull.Value) : new SqlParameter("@ShortDescp", _LookupParameters.Descp);
Parameters[8] = String.IsNullOrEmpty(_LookupParameters.LastUpdated) ? new SqlParameter("@UpdatedOn", DBNull.Value) : new SqlParameter("@UpdatedOn", ConvertDatetimeDB(_LookupParameters.LastUpdated));
Parameters[9] = String.IsNullOrEmpty(_LookupParameters.flag) ? new SqlParameter("@flag", "U") : new SqlParameter("@flag", _LookupParameters.flag);
DataTable dt = new DataTable();
dt.Columns.Add("ProdId");
dt.Columns.Add("ProdCd");
dt.Columns.Add("ProdPrice", typeof(decimal));
dt.Columns.Add("EffDate");
dt.Columns.Add("ExpDate");
dt.Columns.Add("UserId");
dt.Columns.Add("LastUpdDate");
foreach (var item in _LookupParameters.ProductItems)
{
DataRow dr = dt.NewRow();
if (!string.IsNullOrEmpty(_LookupParameters.ProductCode))
{
dr["ProdCd"] = _LookupParameters.ProductCode;
}
else
{
dr["ProdCd"] = DBNull.Value;
}
if (!string.IsNullOrEmpty(item.ProdId))
{
dr["ProdId"] = item.ProdId;
}
else
{
dr["ProdId"] = DBNull.Value;
}
if (!string.IsNullOrEmpty(item.LastUpdated))
{
dr["LastUpdDate"] = ConvertDatetimeDB(item.LastUpdated);
}
else
{
dr["LastUpdDate"] = DBNull.Value;
}
if (!string.IsNullOrEmpty(item.EffectiveFrom))
{
dr["EffDate"] = ConvertDatetimeDB(item.EffectiveFrom);
}
else
{
dr["EffDate"] = DBNull.Value;
}
if (!string.IsNullOrEmpty(item.ExpiryDate))
{
dr["ExpDate"] = ConvertDatetimeDB(item.ExpiryDate);
}
else
{
dr["ExpDate"] = DBNull.Value;
}
if (!string.IsNullOrEmpty(item.UnitPrice))
{
dr["ProdPrice"] = item.UnitPrice;
}
else
{
dr["ProdPrice"] = DBNull.Value;
}
dr["UserId"] = GetUserId;
dt.Rows.Add(dr);
}
Parameters[10] = new SqlParameter("@ProdPriceTbl", dt);
Parameters[11] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[11].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebProdRefMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> WebRebatePlanMaint(LookupParameters _LookupParameters)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
await objDataEngine.InitiateConnectionAsync();
SqlParameter[] Parameters = new SqlParameter[10];
SqlCommand cmd = new SqlCommand();
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(_LookupParameters.PlanId) ? new SqlParameter("@PlanId", DBNull.Value) : new SqlParameter("@PlanId", _LookupParameters.PlanId);
Parameters[2] = String.IsNullOrEmpty(_LookupParameters.Descp) ? new SqlParameter("@Descp", DBNull.Value) : new SqlParameter("@Descp", _LookupParameters.Descp);
Parameters[3] = String.IsNullOrEmpty(_LookupParameters.SelectedType) ? new SqlParameter("@Type", DBNull.Value) : new SqlParameter("@Type", _LookupParameters.SelectedType);
Parameters[4] = String.IsNullOrEmpty(_LookupParameters.EffectiveFrom) ? new SqlParameter("@EffDate", DBNull.Value) : new SqlParameter("@EffDate", ConvertDatetimeDB(_LookupParameters.EffectiveFrom));
Parameters[5] = String.IsNullOrEmpty(_LookupParameters.ExpiryDate) ? new SqlParameter("@ExpDate", DBNull.Value) : new SqlParameter("@ExpDate", ConvertDatetimeDB(_LookupParameters.ExpiryDate));
Parameters[6] = new SqlParameter("@UserId", GetUserId);
DataTable dt = new DataTable();
dt.Columns.Add("PlanId");
dt.Columns.Add("TierValue", typeof(decimal));
dt.Columns.Add("BasisValue", typeof(decimal));
dt.Columns.Add("BilledValue", typeof(decimal));
dt.Columns.Add("UserId");
dt.Columns.Add("LastUpdDate");
foreach (var item in _LookupParameters.ProductItems)
{
DataRow dr = dt.NewRow();
dr["PlanId"] = _LookupParameters.PlanId;
if (!string.IsNullOrEmpty(item.MinPurchaseAmt))
{
dr["TierValue"] = item.MinPurchaseAmt;
}
else
{
dr["TierValue"] = DBNull.Value;
}
if (!string.IsNullOrEmpty(item.SubSeqPurchaseAmt))
{
dr["BasisValue"] = item.SubSeqPurchaseAmt;
}
else
{
dr["BasisValue"] = DBNull.Value;
}
if (!string.IsNullOrEmpty(item.SubSeqBillingAmt))
{
dr["BilledValue"] = item.SubSeqBillingAmt;
}
else
{
dr["BilledValue"] = DBNull.Value;
}
dr["UserId"] = GetUserId;
if (!string.IsNullOrEmpty(item.LastUpdated))
{
dr["LastUpdDate"] = ConvertDatetimeDB(item.LastUpdated);
}
else
{
dr["LastUpdDate"] = DBNull.Value;
}
dt.Rows.Add(dr);
}
Parameters[7] = new SqlParameter("@RebatePlanTbl", dt);
Parameters[8] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[8].Direction = ParameterDirection.ReturnValue;
Parameters[9] = String.IsNullOrEmpty(_LookupParameters.flag) ? new SqlParameter("@Flag", "I") : new SqlParameter("@Flag", _LookupParameters.flag);
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebRebatePlanMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> WebMerchantMultiTxnAdjustmentMaint(TxnAdjustment _MultiPayment)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
await objDataEngine.InitiateConnectionAsync();
DataTable dt = new DataTable();
dt.Columns.Add("Acctno", typeof(long));
dt.Columns.Add("Cardno");
dt.Columns.Add("TxnAmt", typeof(decimal));
dt.Columns.Add("Descp");
dt.Columns.Add("InvoiceNo");
dt.Columns.Add("AppvCd");
dt.Columns.Add("DeftBusnlocation");
dt.Columns.Add("DeftTermId");
dt.Columns.Add("Owner");
dt.Columns.Add("Sts");
dt.Columns.Add("TxnDate");
dt.Columns.Add("DueDate");
dt.Columns.Add("TxnCd");
dt.Columns.Add("TxnId");
foreach (var item in _MultiPayment.MultipleTxnRecord)
{
DataRow dr = dt.NewRow();
dr["DeftBusnlocation"] = item.MerchantAcctNo;
if (!string.IsNullOrEmpty(item.TxnAmt))
{
dr["TxnAmt"] = ConvertDecimalToDb(item.TxnAmt);
}
else
{
dr["TxnAmt"] = DBNull.Value;
}
if (String.IsNullOrEmpty(item.Descp))
{
dr["Descp"] = DBNull.Value;
}
else
{
dr["Descp"] = item.Descp;
}
//dr["ChequeNo"] = _MultiPayment.CheqNo;
//dr["Owner"] = _MultiPayment.SelectedOwner;
dr["TxnCd"] = _MultiPayment.SelectedTxnCd;
dr["TxnDate"] = ConvertDatetimeDB(_MultiPayment.TxnDate);
dr["DueDate"] = ConvertDatetimeDB(_MultiPayment.DueDate);
dr["Owner"] = _MultiPayment.SelectedOwner;
if (String.IsNullOrEmpty(_MultiPayment.InvoiceNo))
{
dr["InvoiceNo"] = DBNull.Value;
}
else
{
dr["InvoiceNo"] = _MultiPayment.InvoiceNo;
}
if (String.IsNullOrEmpty(item.TxnId))
{
dr["TxnId"] = DBNull.Value;
}
else
{
dr["TxnId"] = item.TxnId;
}
dt.Rows.Add(dr);
}
SqlParameter[] Parameters = new SqlParameter[10];
SqlCommand cmd = new SqlCommand();
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = new SqlParameter("@UserId", GetUserId);
Parameters[2] = new SqlParameter("@Adjustment", dt);
Parameters[3] = new SqlParameter("@CheqAmt", ConvertDecimalToDb(_MultiPayment.ChequeAmt));
Parameters[4] = String.IsNullOrEmpty(_MultiPayment.InvoiceNo) ? new SqlParameter("@RcptNo", DBNull.Value) : new SqlParameter("@RcptNo", _MultiPayment.InvoiceNo);
Parameters[5] = String.IsNullOrEmpty(_MultiPayment.BatchId) ? new SqlParameter("@BatchId", DBNull.Value) : new SqlParameter("@BatchId", _MultiPayment.BatchId);
Parameters[6] = new SqlParameter("@RetCd", SqlDbType.VarChar, 25);
Parameters[6].Direction = ParameterDirection.Output;
Parameters[7] = String.IsNullOrEmpty(_MultiPayment.SelectedOwner) ? new SqlParameter("@Owner", DBNull.Value) : new SqlParameter("@Owner", _MultiPayment.SelectedOwner);
Parameters[8] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[8].Direction = ParameterDirection.ReturnValue;
Parameters[9] = new SqlParameter("@BatchOut", SqlDbType.VarChar, 25);
Parameters[9].Direction = ParameterDirection.Output;
//// Parameters[2].SqlDbType = SqlDbType.Structured
//Parameters[5] = new SqlParameter("@RefKey", _MultiPayment.RefId);
//Parameters[6] = new SqlParameter("@ChequeNo", _MultiPayment.ChequeNo);
//Parameters[7] = new SqlParameter("@TxnCd", _MultiPayment.SelectedTxnCode);
//Parameters[8] = new SqlParameter("@TxnDate", DateConverterDB(_MultiPayment.TxnDate));
//Parameters[9] = new SqlParameter("@DueDate", DateConverterDB(_MultiPayment.DueDate));
//Parameters[10] = String.IsNullOrEmpty(_MultiPayment.SlipNo) ? new SqlParameter("@SlipNo", DBNull.Value) : new SqlParameter("@SlipNo", _MultiPayment.SlipNo);
//Parameters[11] = new SqlParameter("@IssueingBankCd", _MultiPayment.SelectedIssueingBank);
//Parameters[12] = new SqlParameter("@Owner", _MultiPayment.SelectedOwner);
//Parameters[13] = new SqlParameter("@Batch", SqlDbType.VarChar, 25);
//Parameters[13].Direction = ParameterDirection.Output;
//Parameters[14] = String.IsNullOrEmpty(_MultiPayment.SelectedGLSettlement) ? new SqlParameter("@SettleVal", DBNull.Value) : new SqlParameter("@SettleVal", _MultiPayment.SelectedGLSettlement);
//Parameters[15] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
//Parameters[15].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebMerchantMultiTxnAdjustmentMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
this.RetCd = Convert.ToString(Cmd.Parameters["@RetCd"].Value);
this.BatchId = Convert.ToString(Cmd.Parameters["@BatchOut"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> WebNtfyEvtConfMaint(LookupParameters _LookupParameters)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
await objDataEngine.InitiateConnectionAsync();
SqlParameter[] _Parameter = new SqlParameter[19];
SqlCommand cmd = new SqlCommand();
var dtNtfyEventTbl = new DataTable();
var dtNtfyEventRcptTbl = new DataTable();
dtNtfyEventTbl.Columns.Add("EvtNtfyDetailId");
dtNtfyEventTbl.Columns.Add("MinIntVal");
dtNtfyEventTbl.Columns.Add("MaxIntVal");
dtNtfyEventTbl.Columns.Add("MinMoneyVal");
dtNtfyEventTbl.Columns.Add("MaxMoneyVal");
dtNtfyEventTbl.Columns.Add("MinDateVal");
dtNtfyEventTbl.Columns.Add("MaxDateVal");
dtNtfyEventTbl.Columns.Add("MinTimeVal");
dtNtfyEventTbl.Columns.Add("MaxTimeVal");
dtNtfyEventTbl.Columns.Add("VarCharVal");
dtNtfyEventTbl.Columns.Add("PeriodType");
dtNtfyEventTbl.Columns.Add("PeriodInterval");
if (_LookupParameters.ProductItems != null)
{
foreach (var item in _LookupParameters.ProductItems)
{
DataRow dr = dtNtfyEventTbl.NewRow();
dr["EvtNtfyDetailId"] = item.EvtPlanDetailId;
dr["MinIntVal"] = ConvertLongToDb(item.MinIntVal);
dr["MaxIntVal"] = ConvertLongToDb(item.MaxIntVal);
dr["MinMoneyVal"] = ConvertDecimalToDb(item.MinMoneyVal);
dr["MaxMoneyVal"] = ConvertDecimalToDb(item.MaxMoneyVal);
dr["MinDateVal"] = ConvertDatetimeDB(item.MinDateVal);
dr["MaxDateVal"] = ConvertDatetimeDB(item.MaxDateVal);
dr["MinTimeVal"] = item.MinTimeVal;
dr["MaxTimeVal"] = item.MaxTimeVal;
dr["VarCharVal"] = item.VarCharVal;
dr["PeriodType"] = item.PeriodType;
dr["PeriodInterval"] = item.PeriodInterval;
dtNtfyEventTbl.Rows.Add(dr);
}
}
dtNtfyEventRcptTbl.Columns.Add("EventRecipientId");
dtNtfyEventRcptTbl.Columns.Add("EventScheduleId");
dtNtfyEventRcptTbl.Columns.Add("ContactName");
dtNtfyEventRcptTbl.Columns.Add("ContactNo");
dtNtfyEventRcptTbl.Columns.Add("ChannelInd");
dtNtfyEventRcptTbl.Columns.Add("LangInd");
if (_LookupParameters._EventRcptList != null)
{
foreach (var item in _LookupParameters._EventRcptList)
{
DataRow dr = dtNtfyEventRcptTbl.NewRow();
dr["EventRecipientId"] = string.IsNullOrEmpty(Convert.ToString(item.Id)) ? (object)DBNull.Value : item.Id;
dr["EventScheduleId"] = string.IsNullOrEmpty(_LookupParameters.EventScheduleId) ? (object)DBNull.Value : _LookupParameters.EventScheduleId;
dr["ContactName"] = string.IsNullOrEmpty(item.ContactName) ? (object)DBNull.Value : item.ContactName;
dr["ContactNo"] = string.IsNullOrEmpty(item.ContactNo) ? (object)DBNull.Value : item.ContactNo;
dr["ChannelInd"] = item.ChannelInd;
dr["LangInd"] = string.IsNullOrEmpty(item.LangInd) ? (object)DBNull.Value : item.LangInd;
dtNtfyEventRcptTbl.Rows.Add(dr);
}
}
_Parameter[0] = new SqlParameter("@IssNo", GetIssNo);
_Parameter[1] = new SqlParameter("@EventSchId", string.IsNullOrEmpty(_LookupParameters.EventScheduleId) ? (object)DBNull.Value : _LookupParameters.EventScheduleId);
_Parameter[2] = new SqlParameter("@EventTypeID", string.IsNullOrEmpty(_LookupParameters.EventTypeId) ? (object)DBNull.Value : _LookupParameters.EventTypeId);
_Parameter[3] = new SqlParameter("@EventPlanId", string.IsNullOrEmpty(_LookupParameters.EventPlanId) ? (object)DBNull.Value : _LookupParameters.EventPlanId);
_Parameter[4] = new SqlParameter("@ShortDescp", string.IsNullOrEmpty(_LookupParameters.ShortDescp) ? (object)DBNull.Value : _LookupParameters.ShortDescp);
_Parameter[5] = new SqlParameter("@Scope", string.IsNullOrEmpty(_LookupParameters.SelectedOwner) ? (object)DBNull.Value : _LookupParameters.SelectedOwner);
_Parameter[6] = new SqlParameter("@Sts", string.IsNullOrEmpty(_LookupParameters.SelectedStatus) ? (object)DBNull.Value : _LookupParameters.SelectedStatus);
_Parameter[7] = new SqlParameter("@ParamInd", "");
_Parameter[8] = new SqlParameter("@RefTo", string.IsNullOrEmpty(_LookupParameters.SelectedRefTo) ? (object)DBNull.Value : _LookupParameters.SelectedRefTo);
_Parameter[9] = new SqlParameter("@RefKey", string.IsNullOrEmpty(_LookupParameters.RefKey) ? (object)DBNull.Value : _LookupParameters.RefKey);
_Parameter[10] = new SqlParameter("@CntEvtOccur", string.IsNullOrEmpty(_LookupParameters.MaxOccur) ? (object)DBNull.Value : _LookupParameters.MaxOccur);
_Parameter[11] = new SqlParameter("@EvtOccurType", string.IsNullOrEmpty(_LookupParameters.SelectedFrequency) ? (object)DBNull.Value : _LookupParameters.SelectedFrequency);
_Parameter[12] = new SqlParameter("@UserId", GetUserId);
_Parameter[13] = new SqlParameter("@ChannelInd", ConvertIntToDb(_LookupParameters.NotifyInd));
_Parameter[14] = new SqlParameter("@DefaultInd", ConvertBoolDB(_LookupParameters.DefaultInd));
_Parameter[15] = new SqlParameter("@NtfyEventTbl", dtNtfyEventTbl);
_Parameter[16] = new SqlParameter("@NtfyEventRcptTbl", dtNtfyEventRcptTbl);
_Parameter[17] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
_Parameter[17].Direction = ParameterDirection.ReturnValue;
_Parameter[18] = new SqlParameter("@NewEventSchId", SqlDbType.BigInt, 19);
_Parameter[18].Direction = ParameterDirection.Output;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebNtfyEvtConfMaint", CommandType.StoredProcedure, _Parameter);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
this.ScheduleId = String.IsNullOrEmpty(_LookupParameters.EventScheduleId) ? Convert.ToString(Cmd.Parameters["@NewEventSchId"].Value) : _LookupParameters.EventScheduleId;
Descp.Id = this.ScheduleId;
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> WebEventTypeMaint(LookupParameters _LookupParameters)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
await objDataEngine.InitiateConnectionAsync();
SqlParameter[] _Parameter = new SqlParameter[15];
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
dt.Columns.Add("EvtNtfyDetailId");
dt.Columns.Add("MinIntVal");
dt.Columns.Add("MaxIntVal");
dt.Columns.Add("MinMoneyVal");
dt.Columns.Add("MaxMoneyVal");
dt.Columns.Add("MinDateVal");
dt.Columns.Add("MaxDateVal");
dt.Columns.Add("MinTimeVal");
dt.Columns.Add("MaxTimeVal");
dt.Columns.Add("VarCharVal");
dt.Columns.Add("PeriodType");
dt.Columns.Add("PeriodInterval");
foreach (var item in _LookupParameters.ProductItems)
{
DataRow dr = dt.NewRow();
dr["EvtNtfyDetailId"] = string.IsNullOrEmpty(item.EvtPlanDetailId) ? (object)DBNull.Value : item.EvtPlanDetailId;
dr["MinIntVal"] = ConvertLongToDb(item.MinIntVal);
dr["MaxIntVal"] = ConvertLongToDb(item.MaxIntVal);
dr["MinMoneyVal"] = ConvertDecimalToDb(item.MinMoneyVal);
dr["MaxMoneyVal"] = ConvertDecimalToDb(item.MaxMoneyVal);
dr["MinDateVal"] = ConvertDatetimeDB(item.MinDateVal);
dr["MaxDateVal"] = ConvertDatetimeDB(item.MaxDateVal);
dr["MinTimeVal"] = string.IsNullOrEmpty(item.MinTimeVal) ? (object)DBNull.Value : item.MinTimeVal;
dr["MaxTimeVal"] = string.IsNullOrEmpty(item.MaxTimeVal) ? (object)DBNull.Value : item.MaxTimeVal;
dr["VarCharVal"] = string.IsNullOrEmpty(item.VarCharVal) ? (object)DBNull.Value : item.VarCharVal;
dr["PeriodType"] = string.IsNullOrEmpty(item.PeriodType) ? (object)DBNull.Value : item.PeriodType;
dr["PeriodInterval"] = string.IsNullOrEmpty(item.PeriodInterval) ? (object)DBNull.Value : item.PeriodInterval;
dt.Rows.Add(dr);
}
_Parameter[0] = new SqlParameter("@EventTypeID", string.IsNullOrEmpty(_LookupParameters.EventTypeId) ? (object)DBNull.Value : _LookupParameters.EventTypeId);
_Parameter[1] = new SqlParameter("@EventPlanId", string.IsNullOrEmpty(_LookupParameters.EventPlanId) ? (object)DBNull.Value : _LookupParameters.EventPlanId);
_Parameter[2] = new SqlParameter("@ShortDescp", string.IsNullOrEmpty(_LookupParameters.ShortDescp) ? (object)DBNull.Value : _LookupParameters.ShortDescp);
_Parameter[3] = new SqlParameter("@Type", string.IsNullOrEmpty(_LookupParameters.SelectedEventType) ? (object)DBNull.Value : _LookupParameters.SelectedEventType);
_Parameter[4] = new SqlParameter("@Severity", string.IsNullOrEmpty(_LookupParameters.SelectedPriority) ? (object)DBNull.Value : _LookupParameters.SelectedPriority);
_Parameter[5] = new SqlParameter("@Scope", string.IsNullOrEmpty(_LookupParameters.SelectedOwner) ? (object)DBNull.Value : _LookupParameters.SelectedOwner);
_Parameter[6] = new SqlParameter("@Sts", string.IsNullOrEmpty(_LookupParameters.SelectedStatus) ? (object)DBNull.Value : _LookupParameters.SelectedStatus);
_Parameter[7] = new SqlParameter("@Descp", string.IsNullOrEmpty(_LookupParameters.DetailedDescp) ? (object)DBNull.Value : _LookupParameters.DetailedDescp);
_Parameter[8] = new SqlParameter("@CntEvtOccur", string.IsNullOrEmpty(_LookupParameters.MaxOccur) ? (object)DBNull.Value : _LookupParameters.MaxOccur);
_Parameter[9] = new SqlParameter("@EvtOccurType", string.IsNullOrEmpty(_LookupParameters.SelectedFrequency) ? (object)DBNull.Value : _LookupParameters.SelectedFrequency);
_Parameter[10] = new SqlParameter("@UserId", GetUserId);
_Parameter[11] = new SqlParameter("@ChannelInd", ConvertIntToDb(_LookupParameters.NotifyInd));
_Parameter[12] = new SqlParameter("@ApplyAllInd", ConvertBoolDB(_LookupParameters.ApplyAllInd));
_Parameter[13] = new SqlParameter("@NtfyEventTbl", dt);
_Parameter[14] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
_Parameter[14].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebEventTypeMaint", CommandType.StoredProcedure, _Parameter);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
