Пример #1
0
        /*************************************
        *  Created by:   dandy boy
        *  Created on:   March 24, 2017
        *  Function:     GetAccountTransactionSearch
        *  Purpose:      GetAccountTransactionSearch
        *  Inputs:
        *  Returns:      TransactionSearchResponse
        *************************************/
        public async Task <TransactionSearchResponse> GetAccountTransactionSearch(Int64?accountNo, Int64?cardNo, string transacionCategory, int txtCd, string fromDate, string toDate, string statementDate)
        {
            Logger.Info("Invoking GetAccountTransactionSearch function");
            var response = new TransactionSearchResponse()
            {
                Status = ResponseStatus.Failure,
            };

            try
            {
                using (var scope = Container.BeginLifetimeScope())
                {
                    var    transacionSearchDAO = scope.Resolve <ITransactionSearchDAO>();
                    string frDate  = (string)NumberExtensions.ConvertDatetimeDB(fromDate);
                    string tDate   = (string)NumberExtensions.ConvertDatetimeDB(toDate);
                    var    results = await transacionSearchDAO.GetAccountTxnSearch(accountNo, cardNo, transacionCategory, txtCd, frDate, tDate, statementDate);

                    if (results.Count() > 0)
                    {
                        response.transactionSearches = Mapper.Map <IList <TransactionSearchDTO>, IList <AcctPostedTxnSearch> >(results);
                    }
                }
                response.Status = ResponseStatus.Success;
            }catch (Exception ex)
            {
                string msg = string.Format("Error in GetAccountTransactionSearch: detail:{0}", ex.Message);
                Logger.Error(msg, ex);
                response.Status  = ResponseStatus.Exception;
                response.Message = msg;
            }
            return(response);
        }
Пример #2
0
        /*************************************
        *  Created by:   dandy boy
        *  Created on:   March 24, 2017
        *  Function:     GetMerchTransactionSearch
        *  Purpose:      GetMerchTransactionSearch
        *  Inputs:
        *  Returns:      TransactionSearchResponse
        *************************************/
        public async Task <TransactionSearchResponse> GetMerchTransactionSearch(string bussinessLocation, string merchAcctNo, string txnCd, string fromtxnDate, string toTxnDate, string txnCat)
        {
            Logger.Info("Invoking GetAccountTransactionSearch function");
            var response = new TransactionSearchResponse()
            {
                Status = ResponseStatus.Failure,
            };

            try
            {
                using (var scope = Container.BeginLifetimeScope())
                {
                    var    transacionSearchDAO = scope.Resolve <ITransactionSearchDAO>();
                    string frTransactionDate   = (string)NumberExtensions.ConvertDatetimeDB(fromtxnDate);
                    string toTransactionDate   = (string)NumberExtensions.ConvertDatetimeDB(toTxnDate);
                    var    results             = await transacionSearchDAO.GetMerchTxnSearch(bussinessLocation, merchAcctNo, txnCd, frTransactionDate, toTransactionDate, txnCat);

                    if (results.Count() > 0)
                    {
                        response.merchPostedTxnSearches = Mapper.Map <IList <TransactionSearchDTO>, IList <MerchPostedTxnSearch> >(results);
                    }
                }
                response.Status = ResponseStatus.Success;
            }catch (Exception ex)
            {
                string msg = string.Format("Error in GetMerchTransactionSearch: detail:{0}", ex.Message);
                Logger.Error(msg, ex);
                response.Status  = ResponseStatus.Exception;
                response.Message = msg;
            }
            return(response);
        }
Пример #3
0
        public async Task <IssMessageDTO> SaveCardReplacement(CardReplacementDTO cardReplacement, string userId)
        {
            using (var cardtrendentities = new pdb_ccmsContext(_connectionString))
            {
                IssMessageDTO issMessage = new IssMessageDTO();
                var           parameters = new[] {
                    new SqlParameter("@IssNo", SqlDbType.SmallInt)
                    {
                        SqlValue = Common.Helpers.Common.GetIssueNo()
                    },
                    new SqlParameter("@CardNo", SqlDbType.VarChar)
                    {
                        SqlValue = (object)cardReplacement.PrevCardNo ?? DBNull.Value
                    },
                    new SqlParameter("@NewCardNo", SqlDbType.VarChar, 19)
                    {
                        Direction = ParameterDirection.Output
                    },
                    new SqlParameter("@ExpiryDate", SqlDbType.VarChar)
                    {
                        SqlValue = (object)NumberExtensions.ConvertDatetimeDB(cardReplacement.CardExpiry.ToString()) ?? DBNull.Value
                    },
                    new SqlParameter("@FeeCd", SqlDbType.VarChar)
                    {
                        SqlValue = (object)cardReplacement.FeeCd ?? DBNull.Value
                    },

                    new SqlParameter("@ReasonCd", SqlDbType.VarChar)
                    {
                        SqlValue = (object)cardReplacement.RsCode ?? DBNull.Value
                    },
                    new SqlParameter("@Remarks", SqlDbType.VarChar)
                    {
                        SqlValue = (object)cardReplacement.Remarks ?? DBNull.Value
                    },
                    new SqlParameter("@UserId", SqlDbType.VarChar)
                    {
                        SqlValue = userId
                    },
                    new SqlParameter("@CardMedia", SqlDbType.Int)
                    {
                        SqlValue = (object)cardReplacement.CardMedia ?? DBNull.Value
                    },
                    new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt)
                    {
                        Direction = ParameterDirection.Output
                    }
                };

                await cardtrendentities.Database.ExecuteSqlCommandAsync("exec @RETURN_VALUE = WebCardReplacementMaint @IssNo,@CardNo,@NewCardNo OUT,@ExpiryDate,@FeeCd," +
                                                                        "@ReasonCd,@Remarks,@UserId,@CardMedia", parameters);

                var resultCode = parameters.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value;
                var newCardNo  = parameters.Where(x => x.ParameterName == "@NewCardNo").FirstOrDefault().Value;
                issMessage.Flag = Convert.ToInt32(resultCode);
                issMessage.paraOut.NewcardNo = Convert.ToString(newCardNo);
                return(issMessage);
            }
        }
Пример #4
0
        public DataTable GetTableReport(ReportViewerDTO rpt)
        {
            SqlParameter[] Parameters = new SqlParameter[3];
            Parameters[0] = new SqlParameter("@RptType", rpt.SelectedRptType);
            Parameters[1] = new SqlParameter("@RefKey", rpt.RefKey);
            Parameters[2] = new SqlParameter("@RptDate", NumberExtensions.ConvertDatetimeDB(rpt.Date));
            var Collector = FillDataTable("WebRptViewer", CommandType.StoredProcedure, Parameters);

            return(Collector);
        }
Пример #5
0
        public object GetReport(ReportViewerDTO rpt)
        {
            SqlParameter[] Parameters = new SqlParameter[3];
            Parameters[0] = string.IsNullOrEmpty(rpt.SelectedRptType) ? new SqlParameter("@RptType", DBNull.Value) : new SqlParameter("@RptType", rpt.SelectedRptType);
            Parameters[1] = string.IsNullOrEmpty(rpt.RefKey) ? new SqlParameter("@RefKey", DBNull.Value) : new SqlParameter("@RefKey", rpt.RefKey);
            Parameters[2] = new SqlParameter("@RptDate", NumberExtensions.ConvertDatetimeDB(rpt.Date));
            var Collector   = FillDataSet("WebRptViewer", CommandType.StoredProcedure, Parameters);
            var objDataInfo = GetInfo(Collector.Tables[0]);

            return(objDataInfo);
        }
Пример #6
0
        public List <object> GetRowReport(ReportViewerDTO rpt)
        {
            SqlParameter[] Parameters = new SqlParameter[3];
            Parameters[0] = string.IsNullOrEmpty(rpt.SelectedRptType) ? new SqlParameter("@RptType", DBNull.Value) : new SqlParameter("@RptType", rpt.SelectedRptType);
            Parameters[1] = string.IsNullOrEmpty(rpt.RefKey) ? new SqlParameter("@RefKey", DBNull.Value) : new SqlParameter("@RefKey", rpt.RefKey);
            Parameters[2] = new SqlParameter("@RptDate", NumberExtensions.ConvertDatetimeDB(rpt.Date));
            var           Collector = FillDataSet("WebRptViewer", CommandType.StoredProcedure, Parameters);
            var           dataRow   = Collector.Tables[0].AsEnumerable().ToList();
            List <object> rows      = new List <object>();

            foreach (var x in dataRow)
            {
                rows.Add(x.ItemArray);
            }
            return(rows);
        }
Пример #7
0
        public async Task <int> SaveMerchChgOwnershipMaint(MerchChangeOwnershipDTO model, string userId)
        {
            using (var cardtrendentities = new pdb_ccmsContext(_connectionString))
            {
                var parameters = new object[] { Common.Helpers.Common.GetIssueNo(), model.CurrentBusnNo, model.CurrentSiteId, model.NewSiteId, NumberExtensions.ConvertDatetimeDB(model.CutOffDate), model.CutOffTime, model.FloatAcctInd
                                                , model.BusnName, model.TaxId, model.DBAName, model.DBAState, model.CoRegNo, model.CoRegName, model.DealerName, model.DealerContact, model.PayeeName, model.BankName, model.BankAcctType,
                                                model.BankBranchCd, model.BankAcctNo, model.SapNo, userId };
                var paramNameList = new[]
                {
                    "@IssNo",
                    "@CurrentBusnNo",
                    "@CurrentSiteId",
                    "@NewSiteId",
                    "@CutOffDate",
                    "@CutOffTime",
                    "@FloatAcctInd",
                    "@BusnName",
                    "@TaxId",
                    "@DBA",
                    "@DBAState",
                    "@CmpyRegNo",
                    "@CmpyRegName",
                    "@DealerName",
                    "@DealerContact",
                    "@PayeeName",
                    "@BankName",
                    "@BankAcctType",
                    "@BankBranchCd",
                    "@BankAcctNo",
                    "@SapNo",
                    "@UserId"
                };
                var paramCollection = BuildParameterListWithRrn(parameters, paramNameList);
                var result          = await cardtrendentities.Database.ExecuteSqlCommandAsync(BuildSqlCommandWithRrn("WebMerchChgOwnershipMaint", paramCollection), paramCollection.ToArray());

                var resultCode = paramCollection.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value;
                return(Convert.ToInt32(resultCode));
            }
        }
        protected override void Configure()
        {
            this.CreateMap <ManualSlipEntryDTO, ManualSlipEntry>()
            .ForMember(d => d.BusnLocation, m => m.MapFrom(src => src.Dealer))
            .ForMember(d => d.SelectedTermId, m => m.MapFrom(src => src.TerminalId))
            .ForMember(d => d.SiteId, m => m.MapFrom(src => src.SiteId))
            .ForMember(d => d.InvoiceNo, m => m.MapFrom(src => src.InvoiceNo))
            .ForMember(d => d.SettleDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.SettleDate)))
            .ForMember(d => d.TotalCnt, m => m.MapFrom(src => src.TotalCount))
            .ForMember(d => d.DisplayTotalAmt, m => m.MapFrom(src => NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TotalAmount))))
            .ForMember(d => d.Descp, m => m.MapFrom(src => src.Description))
            .ForMember(d => d.SelectedSts, m => m.MapFrom(src => src.Status))
            .ForMember(d => d.TxnDescp, m => m.MapFrom(src => src.TxnDescription))
            .ForMember(d => d._CreationDatenUserId, m => m.ResolveUsing(model => new CreationDatenUserId()
            {
                UserId = model.UserId, CreationDate = CardTrend.Common.Extensions.NumberExtensions.DateConverter(model.CreationDate)
            }))
            ;
            this.CreateMap <MerchManualTxnDTO, ManualSlipEntry>()
            .ForMember(d => d.TxnCd, m => m.Ignore())
            .ForMember(d => d.VATCd, m => m.Ignore())
            .ForMember(d => d.TermId, m => m.Ignore())
            .ForMember(d => d.Sts, m => m.Ignore())
            .ForMember(d => d.ProdCd, m => m.Ignore())
            .ForMember(d => d.SelectedProdCd, m => m.MapFrom(src => src.ProdCd))
            .ForMember(d => d.Quantity, m => m.MapFrom(src => src.Quantity.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.000}", src.Quantity.Value)) : "0.000"))
            .ForMember(d => d.ProdAmt, m => m.MapFrom(src => src.ProdAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.ProdAmt.Value)) : "0.00"))
            .ForMember(d => d.UnitPrice, m => m.MapFrom(src => src.UnitPrice.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.UnitPrice.Value)) : "0.00"))
            .ForMember(d => d.VATRate, m => m.MapFrom(src => src.VATRate.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.VATRate.Value)) : "0.00"))
            .ForMember(d => d.SelectedVATCd, m => m.MapFrom(src => src.VATCd))
            .ForMember(d => d.SelectedSts, m => m.MapFrom(src => src.Sts))
            .ForMember(d => d.SelectedTermId, m => m.MapFrom(src => src.TerminalId))
            .ForMember(d => d.SelectedTxnCd, m => m.MapFrom(src => src.TxnCd))
            .ForMember(d => d.RcptNo, m => m.MapFrom(src => src.ReceiptNo))
            .ForMember(d => d.BusnLocation, m => m.MapFrom(src => src.Dealer))
            .ForMember(d => d.AppvCd, m => m.MapFrom(src => src.AuthNo))
            .ForMember(d => d.TxnDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.TransactionDate)))
            .ForMember(d => d.AuthCardNo, m => m.MapFrom(src => src.DriverCard))
            .ForMember(d => d.DisplayTxnAmt, m => m.MapFrom(src => NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TxnAmount))))
            .ForMember(d => d.VATAmt, m => m.MapFrom(src => src.VATAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.VATAmt.Value)) : "0.00"))
            .ForMember(d => d.Descp, m => m.MapFrom(src => src.Description))
            .ForMember(d => d.ProdDesc, m => m.MapFrom(src => src.Description))
            .ForMember(d => d.TotalAmt, m => m.MapFrom(src => NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TxnAmount))))
            .ForMember(d => d.DisplayTotalAmt, m => m.MapFrom(src => NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TxnAmount))))
            .ForMember(d => d.AuthNo, m => m.MapFrom(src => src.AuthNo))
            .ForMember(d => d.Odometer, m => m.MapFrom(src => src.OdometerReading))
            .ForMember(d => d.ArrayCnt, m => m.MapFrom(src => src.ArrayCount))
            .ForMember(d => d.Stans, m => m.MapFrom(src => src.Stan))
            .ForMember(d => d.Rrn, m => m.MapFrom(src => Convert.ToString(src.Rrn)))
            .ForMember(d => d._CreationDatenUserId, m => m.ResolveUsing(model => new CreationDatenUserId()
            {
                UserId = model.UserId, CreationDate = NumberExtensions.DateConverter(model.CreationDate)
            }))
            ;

            this.CreateMap <ManualSlipEntry, MerchManualTxnDTO>()
            .ForMember(d => d.TxnCd, m => m.MapFrom(src => src.SelectedTxnCd))
            .ForMember(d => d.Dealer, m => m.MapFrom(src => src.BusnLocation))
            .ForMember(d => d.TerminalId, m => m.MapFrom(src => src.SelectedTermId))
            .ForMember(d => d.ReceiptNo, m => m.MapFrom(src => src.RcptNo))
            .ForMember(d => d.VATCd, m => m.MapFrom(src => src.SelectedVATCd))
            .ForMember(d => d.ProdAmt, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.ProdAmt)))
            .ForMember(d => d.ProdCd, m => m.MapFrom(src => src.SelectedProdCd))
            .ForMember(d => d.InvoiceNo, m => m.MapFrom(src => Convert.ToInt32(src.InvoiceNo)))
            .ForMember(d => d.Stan, m => m.MapFrom(src => Convert.ToInt32(src.Stans)))
            .ForMember(d => d.Rrn, m => m.MapFrom(src => Convert.ToInt64(src.Rrn)))
            .ForMember(d => d.CardExpiry, m => m.MapFrom(src => src.CardExpire))
            .ForMember(d => d.DriverCard, m => m.MapFrom(src => src.AuthCardNo))
            .ForMember(d => d.VATAmt, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.VATAmt)))
            .ForMember(d => d.TxnDate, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.TxnDate)))
            .ForMember(d => d.ArrayCount, m => m.MapFrom(src => Convert.ToInt32(src.ArrayCnt)))
            .ForMember(d => d.Quantity, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.Quantity)))
            .ForMember(d => d.TotalAmt, m => m.MapFrom(src => src.DisplayTotalAmt))
            .ForMember(d => d.Description, m => m.MapFrom(src => src.Descp))
            .ForMember(d => d.OdometerReading, m => m.MapFrom(src => src.Odometer))
            .ForMember(d => d.Sts, m => m.MapFrom(src => src.SelectedSts))
            ;

            this.CreateMap <ManualSlipEntryBatchDetailDTO, ManualSlipEntry>()
            .ForMember(d => d.BusnLocation, m => m.MapFrom(src => src.Dealer))
            .ForMember(d => d.TermId, m => m.Ignore())
            .ForMember(d => d.Sts, m => m.Ignore())
            .ForMember(d => d.SelectedTermId, m => m.MapFrom(src => src.TermId))
            .ForMember(d => d.BatchId, m => m.MapFrom(src => src.BatchId))
            .ForMember(d => d.TxnCd, m => m.Ignore())
            .ForMember(d => d.SelectedTxnCd, m => m.MapFrom(src => src.TxnCd))
            .ForMember(d => d.InvoiceNo, m => m.MapFrom(src => src.InvoiceNo))
            .ForMember(d => d.SettleDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.SettleDate)))
            .ForMember(d => d.TotalCnt, m => m.MapFrom(src => src.Cnt))
            .ForMember(d => d.DisplayTotalAmt, m => m.MapFrom(src => NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.Amt))))
            .ForMember(d => d.OrigBatchNo, m => m.MapFrom(src => Convert.ToInt32(src.OrigBatchNo)))
            .ForMember(d => d.SelectedSts, m => m.MapFrom(src => src.Sts))
            .ForMember(d => d.Sts, m => m.MapFrom(s => CustomMapperExtensions.MapIEnumerableToList(s.StsList)))
            ;

            this.CreateMap <ManualSlipEntry, ManualSlipEntryBatchDetailDTO>()
            .ForMember(d => d.Dealer, m => m.MapFrom(src => src.BusnLocation))
            .ForMember(d => d.TermId, m => m.Ignore())
            .ForMember(d => d.Sts, m => m.Ignore())
            .ForMember(d => d.TxnCd, m => m.Ignore())
            .ForMember(d => d.TermId, m => m.MapFrom(src => src.SelectedTermId))
            .ForMember(d => d.TxnCd, m => m.MapFrom(src => src.SelectedTxnCd))
            .ForMember(d => d.InvoiceNo, m => m.MapFrom(src => Convert.ToString(src.InvoiceNo)))
            .ForMember(d => d.BatchId, m => m.MapFrom(src => src.BatchId.ToString()))
            .ForMember(d => d.OrigBatchNo, m => m.MapFrom(src => src.OrigBatchNo))
            .ForMember(d => d.SettleDate, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.SettleDate)))
            .ForMember(d => d.Sts, m => m.MapFrom(src => src.SelectedSts))
            ;
            this.CreateMap <ManualTxnDTO, ManualSlipEntry>()
            .ForMember(d => d.TxnCd, m => m.Ignore())
            .ForMember(d => d.BusnLocation, m => m.MapFrom(src => src.Dealer))
            .ForMember(d => d.SelectedTermId, m => m.MapFrom(src => src.Termid))
            .ForMember(d => d.SelectedTxnCd, m => m.MapFrom(src => src.TxnCd))
            .ForMember(d => d.InvoiceNo, m => m.MapFrom(src => src.InvoiceNo))
            ;
            this.CreateMap <ManualTxnProductDTO, ManualTxnProduct>()
            .ForMember(d => d.BatchId, m => m.MapFrom(src => Convert.ToString(src.BatchId)))
            .ForMember(d => d.SelectedProdCd, m => m.MapFrom(src => src.Prod))
            .ForMember(d => d.Quantity, m => m.MapFrom(src => src.Quantity.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.000}", src.Quantity.Value)) : "0.000"))
            .ForMember(d => d.ProdAmt, m => m.MapFrom(src => src.ProdAmount.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.ProdAmount.Value)) : "0.00"))
            .ForMember(d => d.ProdDesc, m => m.MapFrom(src => src.ProdDescription))
            .ForMember(d => d.LastUpdDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.LastUpdateDate)))
            .ForMember(d => d.VATAmt, m => m.MapFrom(src => src.VATAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.VATAmt.Value)) : "0.00"))
            .ForMember(d => d.VATRate, m => m.MapFrom(src => src.VATRate.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.VATRate.Value)) : "0.00"))
            .ForMember(d => d.SelectedVATCd, m => m.MapFrom(src => src.VATCd))
            .ForMember(d => d._CreationDatenUserId, m => m.ResolveUsing(model => new CreationDatenUserId()
            {
                UserId = model.UserId, CreationDate = CardTrend.Common.Extensions.NumberExtensions.DateConverter(model.CreationDate)
            }))
            ;
        }
Пример #9
0
        public async Task <List <FraudTxnDisputeDTO> > GetFraudTxnSearch(Int64 eventID, int searchType, int?txnCategory, int?txnCode, string acctNo, string cardNo, string fromDate, string toDate)
        {
            using (var cardtrendentities = new pdb_ccmsContext(_connectionString))
            {
                var parameters    = new object[] { Common.Helpers.Common.GetIssueNo(), eventID, searchType, txnCategory, txnCode, acctNo, cardNo, NumberExtensions.ConvertDatetimeDB(fromDate), NumberExtensions.ConvertDatetimeDB(toDate) };
                var paramNameList = new[]
                {
                    "@IssNo",
                    "@EventID",
                    "@SearchType",
                    "@TxnCategory",
                    "@TxnCode",
                    "@AcctNo",
                    "@CardNo",
                    "@FromDate",
                    "@ToDate"
                };
                var paramCollection = BuildParameterList(parameters, paramNameList);
                var fraudDisputeTxn = await cardtrendentities.Database.SqlQuery <FraudTxnDisputeDTO>(BuildSqlCommand("WebFraudDisputeTxnList", paramCollection), paramCollection.ToArray()).ToListAsync();

                return(fraudDisputeTxn);
            }
        }
Пример #10
0
        public async Task <int> WebRebatePlanMaint(RebatePlanDTO _LookupParameters, string userId)
        {
            using (var cardtrendentities = new pdb_ccmsContext(_connectionString))
            {
                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"] = userId;

                    if (!string.IsNullOrEmpty(item.LastUpdated))
                    {
                        dr["LastUpdDate"] = NumberExtensions.ConvertDatetimeDB(item.LastUpdated);
                    }
                    else
                    {
                        dr["LastUpdDate"] = DBNull.Value;
                    }
                    dt.Rows.Add(dr);
                }

                var parameters = new[] {
                    new SqlParameter("@IssNo", SqlDbType.BigInt)
                    {
                        SqlValue = Common.Helpers.Common.GetIssueNo()
                    },
                    new SqlParameter("@PlanId", SqlDbType.Int)
                    {
                        SqlValue = (object)_LookupParameters.PlanId ?? DBNull.Value
                    },
                    new SqlParameter("@Descp", SqlDbType.VarChar)
                    {
                        SqlValue = (object)_LookupParameters.Descp ?? DBNull.Value
                    },
                    new SqlParameter("@Type", SqlDbType.VarChar)
                    {
                        SqlValue = (object)_LookupParameters.Type ?? DBNull.Value
                    },
                    new SqlParameter("@EffDate", SqlDbType.DateTime)
                    {
                        SqlValue = (object)_LookupParameters.EffectiveDate ?? DBNull.Value
                    },

                    new SqlParameter("@ExpDate", SqlDbType.DateTime)
                    {
                        SqlValue = (object)_LookupParameters.ExpiredDate ?? DBNull.Value
                    },
                    new SqlParameter("@UserId", SqlDbType.NVarChar)
                    {
                        SqlValue = userId
                    },
                    new SqlParameter("@RebatePlanTbl", SqlDbType.Structured)
                    {
                        SqlValue = dt, TypeName = "RebatePlan"
                    },
                    new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt)
                    {
                        Direction = ParameterDirection.Output
                    }
                };

                await cardtrendentities.Database.ExecuteSqlCommandAsync("exec @RETURN_VALUE = WebRebatePlanMaint @IssNo,@PlanId,@Descp,@Type,@EffDate,@ExpDate,@UserId,@RebatePlanTbl", parameters);

                var resultCode = parameters.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value;
                return(Convert.ToInt32(resultCode));
            }
        }
Пример #11
0
        public async Task <int> WebEventTypeMaint(EventTypeDTO _LookupParameters, string userId)
        {
            using (var cardtrendentities = new pdb_ccmsContext(_connectionString))
            {
                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"]       = NumberExtensions.ConvertLongToDb(item.MinIntVal);
                    dr["MaxIntVal"]       = NumberExtensions.ConvertLongToDb(item.MaxIntVal);
                    dr["MinMoneyVal"]     = NumberExtensions.ConvertDecimalToDb(item.MinMoneyVal);
                    dr["MaxMoneyVal"]     = NumberExtensions.ConvertDecimalToDb(item.MaxMoneyVal);
                    dr["MinDateVal"]      = NumberExtensions.ConvertDatetimeDB(item.MinDateVal);
                    dr["MaxDateVal"]      = NumberExtensions.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);
                }

                var parameters = new[] {
                    new SqlParameter("@EventTypeID", SqlDbType.BigInt)
                    {
                        SqlValue = (object)_LookupParameters.EvtTypeID ?? DBNull.Value
                    },
                    new SqlParameter("@EventPlanId", SqlDbType.BigInt)
                    {
                        SqlValue = (object)_LookupParameters.EvtPlanId ?? DBNull.Value
                    },
                    new SqlParameter("@ShortDescp", SqlDbType.VarChar)
                    {
                        SqlValue = (object)_LookupParameters.ShortDescription ?? DBNull.Value
                    },
                    new SqlParameter("@Type", SqlDbType.VarChar)
                    {
                        SqlValue = (object)_LookupParameters.Type ?? DBNull.Value
                    },
                    new SqlParameter("@Severity", SqlDbType.VarChar)
                    {
                        SqlValue = (object)_LookupParameters.Severity ?? DBNull.Value
                    },
                    new SqlParameter("@Scope", SqlDbType.VarChar)
                    {
                        SqlValue = (object)_LookupParameters.Scope ?? DBNull.Value
                    },
                    new SqlParameter("@Sts", SqlDbType.NVarChar)
                    {
                        SqlValue = (object)_LookupParameters.Status ?? DBNull.Value
                    },
                    new SqlParameter("@Descp", SqlDbType.NVarChar)
                    {
                        SqlValue = (object)_LookupParameters.FullDescription ?? DBNull.Value
                    },
                    new SqlParameter("@CntEvtOccur", SqlDbType.Int)
                    {
                        SqlValue = (object)_LookupParameters.TotalOccurs ?? DBNull.Value
                    },
                    new SqlParameter("@EvtOccurType", SqlDbType.NVarChar)
                    {
                        SqlValue = (object)_LookupParameters.SetFrequencyType ?? DBNull.Value
                    },
                    new SqlParameter("@UserId", SqlDbType.NVarChar)
                    {
                        SqlValue = userId
                    },
                    new SqlParameter("@ChannelInd", SqlDbType.BigInt)
                    {
                        SqlValue = (object)_LookupParameters.NtfyInd ?? DBNull.Value
                    },
                    new SqlParameter("@ApplyAllInd", SqlDbType.VarChar)
                    {
                        SqlValue = (object)_LookupParameters.ApplyAllInd
                    },
                    new SqlParameter("@NtfyEventTbl", SqlDbType.Structured)
                    {
                        SqlValue = dt, TypeName = "NtfyEventTbl"
                    },
                    new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt)
                    {
                        Direction = ParameterDirection.Output
                    }
                };
                await cardtrendentities.Database.ExecuteSqlCommandAsync("exec @RETURN_VALUE = WebEventTypeMaint @EventTypeID,@EventPlanId,@ShortDescp,@Type,@Severity,@Scope,@Sts,@Descp,@CntEvtOccur,@EvtOccurType,@UserId,@ChannelInd,@ApplyAllInd,@NtfyEventTbl", parameters);

                var resultCode = parameters.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value;
                return(Convert.ToInt32(resultCode));
            }
        }
Пример #12
0
        public async Task <int> WebProdRefMaint(ProdRefDTO _LookupParameters, string userId)
        {
            using (var cardtrendentities = new pdb_ccmsContext(_connectionString))
            {
                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.ProdCd))
                    {
                        dr["ProdCd"] = _LookupParameters.ProdCd;
                    }
                    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"] = NumberExtensions.ConvertDatetimeDB(item.LastUpdated);
                    }
                    else
                    {
                        dr["LastUpdDate"] = DBNull.Value;
                    }
                    if (!string.IsNullOrEmpty(item.EffectiveFrom))
                    {
                        dr["EffDate"] = NumberExtensions.ConvertDatetimeDB(item.EffectiveFrom);
                    }
                    else
                    {
                        dr["EffDate"] = DBNull.Value;
                    }
                    if (!string.IsNullOrEmpty(item.ExpiryDate))
                    {
                        dr["ExpDate"] = NumberExtensions.ConvertDatetimeDB(item.ExpiryDate);
                    }
                    else
                    {
                        dr["ExpDate"] = DBNull.Value;
                    }
                    if (!string.IsNullOrEmpty(item.UnitPrice))
                    {
                        dr["ProdPrice"] = item.UnitPrice;
                    }
                    else
                    {
                        dr["ProdPrice"] = DBNull.Value;
                    }
                    dr["UserId"] = userId;
                    dt.Rows.Add(dr);
                }

                var parameters = new[] {
                    new SqlParameter("@IssNo", SqlDbType.SmallInt)
                    {
                        SqlValue = Common.Helpers.Common.GetIssueNo()
                    },
                    new SqlParameter("@ProdCd", SqlDbType.VarChar)
                    {
                        SqlValue = (object)_LookupParameters.ProdCd ?? DBNull.Value
                    },
                    new SqlParameter("@ProdName", SqlDbType.VarChar)
                    {
                        SqlValue = (object)_LookupParameters.ProdDescp ?? DBNull.Value
                    },
                    new SqlParameter("@ProdCat", SqlDbType.VarChar)
                    {
                        SqlValue = (object)_LookupParameters.ProductCategory ?? DBNull.Value
                    },
                    new SqlParameter("@ProdType", SqlDbType.VarChar)
                    {
                        SqlValue = (object)_LookupParameters.ProductType ?? DBNull.Value
                    },
                    new SqlParameter("@BillPlanId", SqlDbType.Int)
                    {
                        SqlValue = (object)_LookupParameters.BillingPlan ?? DBNull.Value
                    },
                    new SqlParameter("@ShortDescp", SqlDbType.NVarChar)
                    {
                        SqlValue = (object)_LookupParameters.ShortDescription ?? DBNull.Value
                    },
                    new SqlParameter("@UserId", SqlDbType.NVarChar)
                    {
                        SqlValue = userId
                    },
                    new SqlParameter("@UpdatedOn", SqlDbType.DateTime)
                    {
                        SqlValue = (object)NumberExtensions.ConvertDatetimeDB(_LookupParameters.UpdatedOn) ?? DBNull.Value
                    },
                    new SqlParameter("@Flag", SqlDbType.Char)
                    {
                        SqlValue = (object)_LookupParameters.Flag ?? "U"
                    },
                    new SqlParameter("@ProdPriceTbl", SqlDbType.Structured)
                    {
                        SqlValue = dt, TypeName = "ProdPriceData"
                    },
                    new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt)
                    {
                        Direction = ParameterDirection.Output
                    }
                };

                await cardtrendentities.Database.ExecuteSqlCommandAsync("exec @RETURN_VALUE = WebProdRefMaint @IssNo,@ProdCd,@ProdName,@ProdCat,@ProdType,@BillPlanId,@ShortDescp,@UserId,@UpdatedOn,@Flag,@ProdPriceTbl", parameters);

                var resultCode = parameters.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value;
                return(Convert.ToInt32(resultCode));
            }
        }
Пример #13
0
        protected override void Configure()
        {
            this.CreateMap <ProdRefDTO, LookupParameters>()
            .ForMember(d => d.ProductCategory, m => m.Ignore())
            .ForMember(d => d.ProductType, m => m.Ignore())
            .ForMember(d => d.BillingPlan, m => m.Ignore())
            .ForMember(d => d.Descp, m => m.MapFrom(src => src.ShortDescription))
            .ForMember(d => d.ProductCode, m => m.MapFrom(src => src.ProdCd))
            .ForMember(d => d.SelectedProductCategory, m => m.MapFrom(src => src.ProductCategory))
            .ForMember(d => d.SelectedProductType, m => m.MapFrom(src => src.ProductType))
            .ForMember(d => d.UnitPrice, m => m.MapFrom(src => src.UnitPrice.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.UnitPrice)) : "0.00"))
            .ForMember(d => d.SelectedBillingPlan, m => m.MapFrom(src => Convert.ToString(src.BillingPlan)))
            .ForMember(d => d.EffectiveFrom, m => m.MapFrom(src => src.EffDate))
            .ForMember(d => d.ExpiryDate, m => m.MapFrom(src => src.EffEndDate))
            .ForMember(d => d.LastUpdated, m => m.MapFrom(src => src.UpdateDate))
            ;

            this.CreateMap <LookupParameters, ProdRefDTO>()
            .ForMember(d => d.ProductCategory, m => m.Ignore())
            .ForMember(d => d.ProductType, m => m.Ignore())
            .ForMember(d => d.BillingPlan, m => m.Ignore())
            .ForMember(d => d.ShortDescription, m => m.MapFrom(src => src.Descp))
            .ForMember(d => d.ProdCd, m => m.MapFrom(src => src.ProductCode))
            .ForMember(d => d.ProductCategory, m => m.MapFrom(src => src.SelectedProductCategory))
            .ForMember(d => d.ProductType, m => m.MapFrom(src => src.SelectedProductType))
            .ForMember(d => d.UnitPrice, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.UnitPrice)))
            .ForMember(d => d.BillingPlan, m => m.MapFrom(src => Convert.ToInt32(src.SelectedBillingPlan)))
            .ForMember(d => d.EffDate, m => m.MapFrom(src => src.EffectiveFrom))
            .ForMember(d => d.EffEndDate, m => m.MapFrom(src => src.ExpiryDate))
            .ForMember(d => d.UpdateDate, m => m.MapFrom(src => src.LastUpdated))
            .ForMember(d => d.ProductItems, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.ProductItems)))
            ;

            this.CreateMap <ProdGroupRefDTO, LookupParameters>()
            .ForMember(d => d.ProductGroup, m => m.Ignore())
            .ForMember(d => d.ProductCategory, m => m.Ignore())
            .ForMember(d => d.ProductType, m => m.Ignore())
            .ForMember(d => d.Descp, m => m.MapFrom(src => src.Description))
            .ForMember(d => d.SelectedProductGroup, m => m.MapFrom(src => src.ProductGroup))
            .ForMember(d => d.LastUpdated, m => m.MapFrom(src => Convert.ToString(src.UpdateDate)))
            .ForMember(d => d.UserId, m => m.MapFrom(src => src.UserId))
            .ForMember(d => d.ProductCode, m => m.MapFrom(src => Convert.ToString(src.ProductCode)))
            .ForMember(d => d.SelectedProductCategory, m => m.MapFrom(src => src.ProductCategory))
            .ForMember(d => d.SelectedProductType, m => m.MapFrom(src => src.ProductType))
            ;
            this.CreateMap <TmplDisplayDTO, TmplDisplayer>()
            .ForMember(d => d.ContentTmplt, m => m.MapFrom(src => src.TemplateDisplayer))
            .ForMember(d => d.LangInd, m => m.MapFrom(src => src.TemplateLanguageIndicator))
            ;
            this.CreateMap <LookupParameterDTO, LookupParameters>()
            .ForMember(d => d.ProductCode, m => m.MapFrom(src => src.ProdCd))
            .ForMember(d => d.ProductName, m => m.MapFrom(src => src.ProdName))
            .ForMember(d => d.Descp, m => m.MapFrom(src => src.ProdDescp))
            .ForMember(d => d.SelectedProductCategory, m => m.MapFrom(src => src.ProdCategory))
            .ForMember(d => d.SelectedProductType, m => m.MapFrom(src => src.ProdType))
            .ForMember(d => d.UnitPrice, m => m.MapFrom(src => src.ProdUnitPrice.HasValue ? (Convert.ToString(src.ProdUnitPrice)) : ""))
            .ForMember(d => d.ParameterCode, m => m.MapFrom(src => src.ParamCd))
            .ForMember(d => d.CityCode, m => m.MapFrom(src => src.ParamCd))
            .ForMember(d => d.StateName, m => m.MapFrom(src => src.StateName))
            .ForMember(d => d.StateCode, m => m.MapFrom(src => src.StateCd))
            .ForMember(d => d.CityName, m => m.MapFrom(src => src.City))
            .ForMember(d => d.ParameterDescp, m => m.MapFrom(src => src.Descp))
            .ForMember(d => d.SelectedProductGroup, m => m.MapFrom(src => src.ProductGroup))
            .ForMember(d => d.LastUpdated, m => m.MapFrom(src => src.UpdatedOn))
            .ForMember(d => d.UserId, m => m.MapFrom(src => src.UpdatedBy))
            .ForMember(d => d.ProductItems, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.ProductItems)))
            ;
            this.CreateMap <LookupParameters, LookupParameterDTO>()
            .ForMember(d => d.Type, m => m.MapFrom(src => src.type))
            .ForMember(d => d.StateCd, m => m.MapFrom(src => src.StateCode))
            .ForMember(d => d.ParamCd, m => m.MapFrom(src => src.type.ToLower() == "city" ?src.CityCode: src.ParameterCode))
            .ForMember(d => d.City, m => m.MapFrom(src => src.CityName))
            .ForMember(d => d.Descp, m => m.MapFrom(src => src.Descp))
            .ForMember(d => d.ProductGroup, m => m.MapFrom(src => src.SelectedProductGroup))
            .ForMember(d => d.ProductItems, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.ProductItems)))
            ;
            this.CreateMap <EventTypeDTO, LookupParameters>()
            .ForMember(d => d.Scope, m => m.Ignore())
            .ForMember(d => d.EventTypeId, m => m.MapFrom(src => Convert.ToString(src.EvtTypeID)))
            .ForMember(d => d.EventPlanId, m => m.MapFrom(src => Convert.ToString(src.EvtPlanId)))
            .ForMember(d => d.ShortDescp, m => m.MapFrom(src => src.ShortDescription))
            .ForMember(d => d.TypeDesc, m => m.MapFrom(src => src.ShortDescription))
            .ForMember(d => d.SelectedEventType, m => m.MapFrom(src => src.Type))
            .ForMember(d => d.SelectedPriority, m => m.MapFrom(src => src.Severity))
            .ForMember(d => d.SelectedOwner, m => m.MapFrom(src => src.Scope))
            .ForMember(d => d.SelectedStatus, m => m.MapFrom(src => src.Status))
            .ForMember(d => d.ApplyAllInd, m => m.MapFrom(src => src.ApplyAllInd == "Y" ? true : false))
            .ForMember(d => d.DetailedDescp, m => m.MapFrom(src => src.FullDescription))
            .ForMember(d => d.BitmapAmt, m => m.MapFrom(src => Convert.ToString(src.BitmapAmt)))
            .ForMember(d => d.MaxOccur, m => m.MapFrom(src => Convert.ToString(src.TotalOccurs)))
            .ForMember(d => d.SelectedFrequency, m => m.MapFrom(src => src.SetFrequencyType))
            .ForMember(d => d.MinIntVal, m => m.MapFrom(src => src.MinIntVal.HasValue ? Convert.ToString(src.MinIntVal) : ""))
            .ForMember(d => d.MaxIntVal, m => m.MapFrom(src => src.MaxIntVal.HasValue ? Convert.ToString(src.MaxIntVal) : ""))
            .ForMember(d => d.EvtPlanDetailId, m => m.MapFrom(src => Convert.ToString(src.EvtPlanDetailId)))
            .ForMember(d => d.MinMoneyVal, m => m.MapFrom(src => src.MinMoneyVal.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.MinMoneyVal)) : ""))
            .ForMember(d => d.MaxMoneyVal, m => m.MapFrom(src => src.MaxMoneyVal.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.MaxMoneyVal)) : ""))

            .ForMember(d => d.MinDateVal, m => m.MapFrom(src => src.MinDateVal.HasValue ? NumberExtensions.DateConverter(src.MinDateVal) : ""))
            .ForMember(d => d.MaxDateVal, m => m.MapFrom(src => src.MaxDateVal.HasValue ? NumberExtensions.DateConverter(src.MaxDateVal) : ""))
            .ForMember(d => d.MinTimeVal, m => m.MapFrom(src => src.MinTimeVal.HasValue ? Convert.ToString(src.MinTimeVal) : ""))
            .ForMember(d => d.MaxTimeVal, m => m.MapFrom(src => src.MaxTimeVal.HasValue ? Convert.ToString(src.MaxTimeVal) : ""))

            .ForMember(d => d.PeriodInterval, m => m.MapFrom(src => Convert.ToString(src.PeriodInterval)))
            .ForMember(d => d.NotifyInd, m => m.MapFrom(src => Convert.ToInt32(src.NtfyInd)))
            .ForMember(d => d.LastUpdated, m => m.MapFrom(src => NumberExtensions.DateConverter(src.UpdateOn)))
            .ForMember(d => d.UpdatedBy, m => m.MapFrom(src => src.Updateby))
            .ForMember(d => d.DefaultInd, m => m.MapFrom(src => src.DefaultInd == "Y" ? true : false))
            .ForMember(d => d.ProductItems, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.ProductItems)))
            ;
            this.CreateMap <LookupParameters, EventTypeDTO>()
            .ForMember(d => d.Scope, m => m.Ignore())
            .ForMember(d => d.EvtTypeID, m => m.MapFrom(src => NumberExtensions.ConvertLongToDb(src.EventTypeId)))
            .ForMember(d => d.EvtPlanId, m => m.MapFrom(src => NumberExtensions.ConvertLongToDb(src.EventPlanId)))
            .ForMember(d => d.ShortDescription, m => m.MapFrom(src => src.ShortDescp))
            .ForMember(d => d.ShortDescription, m => m.MapFrom(src => src.TypeDesc))
            .ForMember(d => d.Type, m => m.MapFrom(src => src.SelectedEventType))
            .ForMember(d => d.Severity, m => m.MapFrom(src => src.SelectedPriority))
            .ForMember(d => d.Scope, m => m.MapFrom(src => src.SelectedOwner))
            .ForMember(d => d.Status, m => m.MapFrom(src => src.SelectedStatus))
            .ForMember(d => d.ApplyAllInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.ApplyAllInd)))
            .ForMember(d => d.FullDescription, m => m.MapFrom(src => src.DetailedDescp))
            .ForMember(d => d.BitmapAmt, m => m.MapFrom(src => NumberExtensions.ConvertLongToDb(src.BitmapAmt)))
            .ForMember(d => d.TotalOccurs, m => m.MapFrom(src => Convert.ToInt32(src.MaxOccur)))
            .ForMember(d => d.SetFrequencyType, m => m.MapFrom(src => src.SelectedFrequency))
            .ForMember(d => d.MinIntVal, m => m.MapFrom(src => Convert.ToInt32(src.MinIntVal)))
            .ForMember(d => d.MaxIntVal, m => m.MapFrom(src => Convert.ToInt32(src.MaxIntVal)))
            .ForMember(d => d.EvtPlanDetailId, m => m.MapFrom(src => NumberExtensions.ConvertLongToDb(src.EvtPlanDetailId)))
            .ForMember(d => d.MinMoneyVal, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.MinMoneyVal)))
            .ForMember(d => d.MaxMoneyVal, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.MaxMoneyVal)))
            .ForMember(d => d.MinDateVal, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.MinDateVal)))
            .ForMember(d => d.MaxDateVal, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.MaxDateVal)))
            .ForMember(d => d.MinTimeVal, m => m.Ignore())
            .ForMember(d => d.MaxTimeVal, m => m.Ignore())
            .ForMember(d => d.PeriodInterval, m => m.MapFrom(src => Convert.ToInt32(src.PeriodInterval)))
            .ForMember(d => d.NtfyInd, m => m.MapFrom(src => NumberExtensions.ConvertLongToDb(src.NotifyInd)))
            .ForMember(d => d.UpdateOn, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.LastUpdated)))
            .ForMember(d => d.Updateby, m => m.MapFrom(src => src.UpdatedBy))
            .ForMember(d => d.DefaultInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.DefaultInd)))
            .ForMember(d => d.ProductItems, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.ProductItems)))
            ;
            this.CreateMap <RebatePlanDTO, LookupParameters>()
            .ForMember(d => d.PlanId, m => m.MapFrom(src => Convert.ToString(src.PlanId)))
            .ForMember(d => d.EffectiveFrom, m => m.MapFrom(src => NumberExtensions.DateConverter(src.EffectiveDate)))
            .ForMember(d => d.ExpiryDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.ExpiredDate)))
            .ForMember(d => d.SelectedType, m => m.MapFrom(src => Convert.ToString(src.Type)))
            .ForMember(d => d.LastUpdated, m => m.MapFrom(src => NumberExtensions.DateConverter(src.Plan_UpdateDate)))
            .ForMember(d => d.MinPurchaseAmt, m => m.MapFrom(src => NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TierValue))))
            .ForMember(d => d.SubSeqPurchaseAmt, m => m.MapFrom(src => NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.BasisValue))))
            .ForMember(d => d.BillingPlanLastUpdate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.PlanDetail_UpdateDate)))
            .ForMember(d => d.UserId, m => m.MapFrom(src => src.UserId))
            ;
            this.CreateMap <LookupParameters, RebatePlanDTO>()
            .ForMember(d => d.PlanId, m => m.MapFrom(src => Convert.ToInt32(src.PlanId)))
            .ForMember(d => d.EffectiveDate, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.EffectiveFrom)))
            .ForMember(d => d.ExpiredDate, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.ExpiryDate)))
            .ForMember(d => d.Type, m => m.MapFrom(src => NumberExtensions.ConvertLongToDb(src.SelectedType)))
            .ForMember(d => d.Plan_UpdateDate, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.LastUpdated)))
            .ForMember(d => d.TierValue, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.MinPurchaseAmt)))
            .ForMember(d => d.BasisValue, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.SubSeqPurchaseAmt)))
            .ForMember(d => d.PlanDetail_UpdateDate, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.BillingPlanLastUpdate)))
            .ForMember(d => d.UserId, m => m.MapFrom(src => src.UserId))
            ;
            this.CreateMap <RebatePlanDetailDTO, LookupParameters>()
            .ForMember(d => d.PlanId, m => m.MapFrom(src => Convert.ToString(src.PlanId)))
            .ForMember(d => d.type, m => m.MapFrom(src => Convert.ToString(src.Type)))
            .ForMember(d => d.EffectiveFrom, m => m.MapFrom(src => NumberExtensions.DateConverter(src.EffectiveDate)))
            .ForMember(d => d.ExpiryDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.ExpiredDate)))
            .ForMember(d => d.LastUpdated, m => m.MapFrom(src => Convert.ToString(src.PlansUpdateDate)))
            .ForMember(d => d.MinPurchaseAmt, m => m.MapFrom(src => NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.MinPurchAmt))))
            .ForMember(d => d.SubSeqPurchaseAmt, m => m.MapFrom(src => NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.SubseqPurchAmt))))
            .ForMember(d => d.SubSeqBillingAmt, m => m.MapFrom(src => NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.SubseqBillingAmt))))
            .ForMember(d => d.BillingPlanUserId, m => m.MapFrom(src => src.BillingPlanUserId))
            .ForMember(d => d.BillingPlanLastUpdate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.BillingPlanLastUpdate)))
            ;
        }
Пример #14
0
        protected override void Configure()
        {
            this.CreateMap <CardHolderInfoDTO, CardHolderInfoModel>()
            .ForMember(d => d.CardType, m => m.Ignore())
            .ForMember(d => d.ReasonCd, m => m.Ignore())
            .ForMember(d => d.PINInd, m => m.Ignore())
            .ForMember(d => d.DialogueInd, m => m.Ignore())
            .ForMember(d => d.RenewalInd, m => m.Ignore())
            .ForMember(d => d.SKDSNo, m => m.Ignore())
            .ForMember(d => d.CostCentre, m => m.Ignore())
            .ForMember(d => d.BranchCd, m => m.Ignore())
            .ForMember(d => d.DeptCd, m => m.Ignore())
            .ForMember(d => d.CardMedia, m => m.Ignore())
            .ForMember(d => d.FullName, m => m.MapFrom(src => src.DriverName))
            .ForMember(d => d.SelectedCostCentre, m => m.MapFrom(src => src.CostCentre))
            .ForMember(d => d.AcctNo, m => m.MapFrom(src => Convert.ToString(src.AcctNo)))
            .ForMember(d => d.EmbossName, m => m.MapFrom(src => src.EmbName))
            .ForMember(d => d.SelectedCardType, m => m.MapFrom(src => src.CardType))
            .ForMember(d => d.SelectedCurrentStatus, m => m.MapFrom(src => src.Sts))
            .ForMember(d => d.SelectedReasonCode, m => m.MapFrom(src => src.ReasonCd))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => src.CreationDate.HasValue ? NumberExtensions.DateConverter(src.CreationDate) : null))
            .ForMember(d => d.MemberSince, m => m.MapFrom(src => src.MemSince))
            .ForMember(d => d.SelectedSKDSNo, m => m.MapFrom(src => src.SKDSNo))
            .ForMember(d => d.oldCardNo, m => m.MapFrom(src => Convert.ToString(src.XPreCardNo.HasValue)))
            .ForMember(d => d.XRefCardNo, m => m.MapFrom(src => Convert.ToString(src.XRefCardNo)))
            .ForMember(d => d.SelectedCardType, m => m.MapFrom(src => src.CardType))
            .ForMember(d => d.SelectedVehicleModel, m => m.MapFrom(src => src.Model))
            .ForMember(d => d.SelectedPINInd, m => m.MapFrom(src => src.PINInd))
            .ForMember(d => d.vehRegNo, m => m.MapFrom(src => src.VehRegsNo))
            .ForMember(d => d.SelectedSKDSInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.SKDSInd)))
            .ForMember(d => d.SKDSQuota, m => m.MapFrom(src => NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.SKDSQuota))))
            .ForMember(d => d.DriverName, m => m.MapFrom(src => src.DriverName))
            .ForMember(d => d.BlockedDate, m => m.MapFrom(src => src.BlockedDate.HasValue ? NumberExtensions.DateConverter(src.BlockedDate) : null))
            .ForMember(d => d.TerminatedDate, m => m.MapFrom(src => src.TerminatedDate.HasValue ? NumberExtensions.DateConverter(src.TerminatedDate) : null))
            .ForMember(d => d.PVV, m => m.MapFrom(src => src.PVV))
            .ForMember(d => d.SelectedDialogueInd, m => m.MapFrom(src => src.DialogueInd))
            .ForMember(d => d.SelectedRenewalInd, m => m.MapFrom(src => src.RenewalInd))
            .ForMember(d => d.SelectedPushAlertInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.PushAlertInd)))
            .ForMember(d => d.LocInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.LocationInd)))
            .ForMember(d => d.SelectedLocCheckFlag, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.LocationCheckFlag)))
            .ForMember(d => d.MaxCountLimit, m => m.MapFrom(src => src.LocationMaxCnt))
            .ForMember(d => d.AmtLimit, m => m.MapFrom(src => NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.LocationMaxAmt))))
            .ForMember(d => d.SelectedFuelCheckFlag, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.FuelCheckFlag)))
            .ForMember(d => d.FuelLitre, m => m.MapFrom(src => NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.FuelLitPerKM))))
            .ForMember(d => d.PINExceedCnt, m => m.MapFrom(src => src.PINExceedCnt.HasValue ? NumberExtensions.ConvertInt(src.PINExceedCnt) : 0))
            .ForMember(d => d.SelectedAnnualFee, m => m.MapFrom(src => src.AnnlFeeCd))
            .ForMember(d => d.SelectedJonFee, m => m.MapFrom(src => src.JoiningFeeCd))
            .ForMember(d => d.SelectedProductUtilization, m => m.MapFrom(src => src.ProdGroup))
            .ForMember(d => d.OdometerIndicator, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.OdometerInd)))
            .ForMember(d => d.PrimaryCard, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.PrimaryCard)))
            .ForMember(d => d.SelectedBranchCd, m => m.MapFrom(src => src.BranchCd))
            .ForMember(d => d.SelectedDivisionCode, m => m.MapFrom(src => src.DivisionCd))
            .ForMember(d => d.SelectedDeptCd, m => m.MapFrom(src => src.DeptCd))
            .ForMember(d => d.SelectedCardMedia, m => m.MapFrom(src => src.CardMedia))
            ;

            this.CreateMap <CardHolderInfoModel, CardHolderInfoDTO>()
            .ForMember(d => d.CardType, m => m.Ignore())
            .ForMember(d => d.ReasonCd, m => m.Ignore())
            .ForMember(d => d.PINInd, m => m.Ignore())
            .ForMember(d => d.DialogueInd, m => m.Ignore())
            .ForMember(d => d.RenewalInd, m => m.Ignore())
            .ForMember(d => d.SKDSNo, m => m.Ignore())
            .ForMember(d => d.BranchCd, m => m.Ignore())
            .ForMember(d => d.DeptCd, m => m.Ignore())
            .ForMember(d => d.CardMedia, m => m.Ignore())
            .ForMember(d => d.EmbName, m => m.MapFrom(src => src.EmbossName))
            .ForMember(d => d.AcctNo, m => m.MapFrom(src => Convert.ToInt64(src.AcctNo)))
            .ForMember(d => d.Sts, m => m.MapFrom(src => src.SelectedCurrentStatus))
            .ForMember(d => d.TerminatedDate, m => m.MapFrom(src => !string.IsNullOrEmpty(src.TerminatedDate) ? NumberExtensions.ConvertDatetimeDB(src.TerminatedDate) : DateTime.MinValue))
            .ForMember(d => d.VehRegsNo, m => m.MapFrom(src => src.vehRegNo))
            .ForMember(d => d.SKDSInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.SelectedSKDSInd)))
            .ForMember(d => d.SKDSQuota, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.SKDSQuota)))
            .ForMember(d => d.SKDSNo, m => m.MapFrom(src => src.SelectedSKDSNo))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.CreationDate)))
            .ForMember(d => d.DialogueInd, m => m.MapFrom(src => src.SelectedDialogueInd))
            .ForMember(d => d.PINInd, m => m.MapFrom(src => src.SelectedPINInd))
            .ForMember(d => d.OdometerInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.OdometerIndicator)))
            .ForMember(d => d.PushAlertInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.SelectedPushAlertInd)))
            .ForMember(d => d.AnnlFeeCd, m => m.MapFrom(src => src.SelectedAnnualFee))
            .ForMember(d => d.JoiningFeeCd, m => m.MapFrom(src => src.SelectedJonFee))
            .ForMember(d => d.RenewalInd, m => m.MapFrom(src => src.SelectedRenewalInd))
            .ForMember(d => d.PrimaryCard, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.PrimaryCard)))
            .ForMember(d => d.ProdGroup, m => m.MapFrom(src => src.SelectedProductUtilization))
            .ForMember(d => d.CostCentre, m => m.MapFrom(src => src.SelectedCostCentre))
            .ForMember(d => d.Model, m => m.MapFrom(src => src.SelectedVehicleModel))
            .ForMember(d => d.BranchCd, m => m.MapFrom(src => src.SelectedBranchCd))
            .ForMember(d => d.DivisionCd, m => m.MapFrom(src => src.SelectedDivisionCode))
            .ForMember(d => d.DeptCd, m => m.MapFrom(src => src.SelectedDeptCd))
            .ForMember(d => d.BlockedDate, m => m.MapFrom(src => !string.IsNullOrEmpty(src.BlockedDate) ? NumberExtensions.ConvertDatetimeDB(src.BlockedDate) : DateTime.MinValue))
            ;

            this.CreateMap <CardHolderInfoDTO, CardFinancialInfoModel>()
            .ForMember(d => d.txnLimit, m => m.MapFrom(src => NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TxnLimit))))
            .ForMember(d => d.litLimit, m => m.MapFrom(src => NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.LitLimit))))
            .ForMember(d => d.PinExceedCnt, m => m.MapFrom(src => NumberExtensions.ConvertInt(src.PINExceedCnt)))
            .ForMember(d => d.PinAttempted, m => m.MapFrom(src => src.PINAttempted))
            .ForMember(d => d.PinTriedUpdDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.PinTriedUpdDate)))
            .ForMember(d => d.PushAlertInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.PushAlertInd)))
            .ForMember(d => d.LocationInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.LocationInd)))
            .ForMember(d => d.LocationCheckFlag, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.LocationCheckFlag)))
            .ForMember(d => d.LocationMaxAmt, m => m.MapFrom(src => NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.LocationMaxAmt))))
            .ForMember(d => d.FuelCheckFlag, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.FuelCheckFlag)))
            .ForMember(d => d.FuelLitPerKM, m => m.MapFrom(src => NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.FuelLitPerKM))))
            ;

            this.CreateMap <CardFinancialInfoModel, CardHolderInfoDTO>()
            .ForMember(d => d.TxnLimit, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.txnLimit)))
            .ForMember(d => d.LitLimit, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.litLimit)))
            .ForMember(d => d.PINExceedCnt, m => m.MapFrom(src => src.PinExceedCnt))
            .ForMember(d => d.PINAttempted, m => m.MapFrom(src => src.PinAttempted))
            .ForMember(d => d.PinTriedUpdDate, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.PinTriedUpdDate)))
            .ForMember(d => d.PushAlertInd, m => m.MapFrom(src => src.PushAlertInd == true ? "Y" : "N"))
            .ForMember(d => d.LocationInd, m => m.MapFrom(src => src.LocationInd == true ? "Y" : "N"))
            .ForMember(d => d.LocationCheckFlag, m => m.MapFrom(src => src.LocationCheckFlag == true ? "Y" : "N"))
            .ForMember(d => d.LocationMaxAmt, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.LocationMaxAmt)))
            .ForMember(d => d.FuelCheckFlag, m => m.MapFrom(src => src.FuelCheckFlag == true ? "Y" : "N"))
            .ForMember(d => d.FuelLitPerKM, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.FuelLitPerKM)))
            ;
            this.CreateMap <PersonalInfoDTO, PersonInfoModel>()
            .ForMember(d => d.SelectedTitle, m => m.MapFrom(src => src.Title))
            .ForMember(d => d.IdNo, m => m.MapFrom(src => src.NewIc))
            .ForMember(d => d.SelectedIdType, m => m.MapFrom(src => src.NewIcType))
            .ForMember(d => d.AltIdNo, m => m.MapFrom(src => src.AlternateIc))
            .ForMember(d => d.SelectedAltIdType, m => m.MapFrom(src => src.AlternateIcType))
            .ForMember(d => d.Selectedgender, m => m.MapFrom(src => src.Gender))
            .ForMember(d => d.DOB, m => m.MapFrom(src => NumberExtensions.DateConverter(src.DOB)))
            .ForMember(d => d.AnnualIncome, m => m.MapFrom(src => NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.Income))))
            .ForMember(d => d.SelectedOccupation, m => m.MapFrom(src => src.Occupation))
            .ForMember(d => d.SelectedDeptId, m => m.MapFrom(src => src.DeptId))
            .ForMember(d => d.DrivingLicense, m => m.MapFrom(src => src.DrivingLic))
            ;
            this.CreateMap <PersonInfoModel, PersonalInfoDTO>()
            .ForMember(d => d.Title, m => m.Ignore())
            .ForMember(d => d.Gender, m => m.Ignore())
            .ForMember(d => d.Occupation, m => m.Ignore())
            .ForMember(d => d.DeptId, m => m.Ignore())
            .ForMember(d => d.Title, m => m.MapFrom(src => src.SelectedTitle))
            .ForMember(d => d.NewIc, m => m.MapFrom(src => src.IdNo))
            .ForMember(d => d.NewIcType, m => m.MapFrom(src => src.SelectedIdType))
            .ForMember(d => d.OldIc, m => m.MapFrom(src => src.AltIdNo))
            .ForMember(d => d.OldIcType, m => m.MapFrom(src => src.SelectedAltIdType))
            .ForMember(d => d.Gender, m => m.MapFrom(src => src.Selectedgender))
            .ForMember(d => d.DOB, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.DOB)))
            .ForMember(d => d.IncomeBK, m => m.MapFrom(src => src.AnnualIncome))
            .ForMember(d => d.Occupation, m => m.MapFrom(src => src.SelectedOccupation))
            .ForMember(d => d.DeptId, m => m.MapFrom(src => src.SelectedDeptId))
            .ForMember(d => d.DrivingLic, m => m.MapFrom(src => src.DrivingLicense))
            ;
            this.CreateMap <ChangeStatusDTO, ChangeStatus>()
            .ForMember(d => d.SelectedCurrentStatus, m => m.MapFrom(src => src.Sts))
            .ForMember(d => d.SelectedRefType, m => m.MapFrom(src => src.EventType))
            .ForMember(d => d.SelectedReasonCode, m => m.MapFrom(src => src.ReasonCd))
            .ForMember(d => d.CurrentStatus, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.CurrentStatus)))
            .ForMember(d => d.RefType, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.RefType)))
            .ForMember(d => d.ReasonCode, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.ReasonCode)))
            .ForMember(d => d.ChangeStatusTo, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.ChangeStatusTo)))
            ;
            this.CreateMap <ChangeStatus, ChangeStatusDTO>()
            .ForMember(d => d.Sts, m => m.MapFrom(src => src.SelectedChangeStatusTo))
            .ForMember(d => d.EventType, m => m.MapFrom(src => src.SelectedRefType))
            .ForMember(d => d.ReasonCd, m => m.MapFrom(src => src.SelectedReasonCode))
            .ForMember(d => d.CardNo, m => m.MapFrom(src => src._CardnAccNo.CardNo))
            .ForMember(d => d.MerchAcctNo, m => m.MapFrom(src => src.MerchAcctNo))
            .ForMember(d => d.BusnLocation, m => m.MapFrom(src => src.BusnLocation))
            .ForMember(d => d.AcctNo, m => m.MapFrom(src => src._CardnAccNo.AccNo))
            .ForMember(d => d.CurrentStatus, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.CurrentStatus)))
            .ForMember(d => d.RefType, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.RefType)))
            .ForMember(d => d.ReasonCode, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.ReasonCode)))
            .ForMember(d => d.ChangeStatusTo, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.ChangeStatusTo)))
            ;
            this.CreateMap <CardReplacementDTO, CardReplacement>()
            .ForMember(d => d.ReasonCd, m => m.Ignore())
            .ForMember(d => d.FeeCd, m => m.Ignore())
            .ForMember(d => d.CardMedia, m => m.Ignore())
            .ForMember(d => d.NewCardNo, m => m.MapFrom(src => src.NewCardNo.HasValue ? Convert.ToString(src.NewCardNo) : ""))
            .ForMember(d => d.XReferenceNo, m => m.MapFrom(src => Convert.ToString(src.PrevCardNo)))
            .ForMember(d => d.ExpiryDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.CardExpiry)))
            .ForMember(d => d.TerminatedDate, m => m.MapFrom(src => src.TerminatedDate.HasValue ? NumberExtensions.DateConverter(src.TerminatedDate) : ""))
            .ForMember(d => d.SelectedCurrentStatus, m => m.MapFrom(src => src.Sts))
            .ForMember(d => d.SelectedFeeCd, m => m.MapFrom(src => src.FeeCd))
            .ForMember(d => d.SelectedReasonCode, m => m.MapFrom(src => src.ReasonCd))
            .ForMember(d => d.SelectedCardMediaType, m => m.MapFrom(src => src.CardMedia.HasValue ? Convert.ToString(src.CardMedia) : ""))
            ;
            this.CreateMap <CardReplacement, CardReplacementDTO>()
            .ForMember(d => d.ReasonCd, m => m.Ignore())
            .ForMember(d => d.FeeCd, m => m.Ignore())
            .ForMember(d => d.CardMedia, m => m.Ignore())
            .ForMember(d => d.PrevCardNo, m => m.MapFrom(src => Convert.ToInt64(src.CardNo)))
            .ForMember(d => d.CardExpiry, m => m.MapFrom(src => !string.IsNullOrEmpty(src.ExpiryDate) ? NumberExtensions.ConvertDatetimeDB(src.ExpiryDate) : DateTime.MinValue))
            .ForMember(d => d.TerminatedDate, m => m.MapFrom(src => string.IsNullOrEmpty(src.TerminatedDate) ? NumberExtensions.ConvertDatetimeDB(src.TerminatedDate) : DateTime.MinValue))
            .ForMember(d => d.CardMedia, m => m.MapFrom(src => src.SelectedCardMediaType))
            .ForMember(d => d.FeeCd, m => m.MapFrom(src => Convert.ToInt32(src.SelectedFeeCd)))
            .ForMember(d => d.RsCode, m => m.MapFrom(src => src.SelectedReasonCode))
            ;
            this.CreateMap <LocationAcceptDTO, LocationAcceptListModel>()
            .ForMember(d => d.SelectedStates, m => m.Ignore())
            .ForMember(d => d._CardnAccNo, m => m.Ignore())
            .ForMember(d => d.DBAName, m => m.MapFrom(src => src.DBA_Name))
            .ForMember(d => d.s_state, m => m.MapFrom(src => src.DBA_City))
            .ForMember(d => d.UserId, m => m.MapFrom(src => src.UserId))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => src.CreationDate))
            .ForMember(d => d.SiteId, m => m.MapFrom(src => src.SiteId))
            .ForMember(d => d.BusnLoc, m => m.MapFrom(src => src.MerchantId))
            .ForMember(d => d.SelectedStates, m => m.MapFrom(s => CustomMapperExtensions.MapIEnumerableToList(s.SelectedStates)))
            .ForMember(d => d.SelectedBusnLocations, m => m.MapFrom(s => CustomMapperExtensions.MapIEnumerableToList(s.SelectedBusnLocations)))
            ;
            this.CreateMap <LocationAcceptListModel, LocationAcceptDTO>()
            .ForMember(d => d.SelectedStates, m => m.Ignore())
            .ForMember(d => d.DBA_Name, m => m.MapFrom(src => src.DBAName))
            .ForMember(d => d.DBA_City, m => m.MapFrom(src => src.s_state))
            .ForMember(d => d.UserId, m => m.MapFrom(src => src.UserId))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => src.CreationDate))
            .ForMember(d => d.SiteId, m => m.MapFrom(src => src.SiteId))
            .ForMember(d => d.MerchantId, m => m.MapFrom(src => src.BusnLoc))
            .ForMember(d => d.SelectedStates, m => m.MapFrom(s => CustomMapperExtensions.MapIEnumerableToList(s.SelectedStates)))
            .ForMember(d => d.SelectedBusnLocations, m => m.MapFrom(s => CustomMapperExtensions.MapIEnumerableToList(s.SelectedBusnLocations)))
            ;
            this.CreateMap <CardListDTO, CardHolderInfoModel>()
            .ForMember(d => d.CardType, m => m.Ignore())
            .ForMember(d => d.ReasonCd, m => m.Ignore())
            .ForMember(d => d.PINInd, m => m.Ignore())
            .ForMember(d => d.DialogueInd, m => m.Ignore())
            .ForMember(d => d.RenewalInd, m => m.Ignore())
            .ForMember(d => d.SKDSNo, m => m.Ignore())
            .ForMember(d => d.CostCentre, m => m.Ignore())
            .ForMember(d => d.BranchCd, m => m.Ignore())
            .ForMember(d => d.DeptCd, m => m.Ignore())
            .ForMember(d => d.CardMedia, m => m.Ignore())
            .ForMember(d => d.EmbossName, m => m.MapFrom(src => src.EmbName))
            .ForMember(d => d.SelectedCurrentStatus, m => m.MapFrom(src => src.Sts))
            .ForMember(d => d.XRefCardNo, m => m.MapFrom(src => Convert.ToInt64(src.XrefCardNo)))
            .ForMember(d => d.SelectedCardType, m => m.MapFrom(src => src.CardType))
            .ForMember(d => d.SelectedPINInd, m => m.MapFrom(src => src.PINInd))
            .ForMember(d => d.vehRegNo, m => m.MapFrom(src => src.VehRegsNo))
            .ForMember(d => d.SKDSQuota, m => m.MapFrom(src => src.SKDSQuota))
            .ForMember(d => d.SelectedSKDSNo, m => m.MapFrom(src => src.SKDSNo))
            .ForMember(d => d.BlockedDate, m => m.MapFrom(src => NumberExtensions.DateTimeConverter(src.BlockedDate)))
            .ForMember(d => d.DriverCd, m => m.MapFrom(src => src.DriverName))
            .ForMember(d => d.TerminatedDate, m => m.MapFrom(src => src.TerminatedDate.HasValue ? NumberExtensions.DateTimeConverter(src.TerminatedDate):""))
            .ForMember(d => d.SelectedCostCentre, m => m.MapFrom(src => src.CostCenter))
            ;
        }
Пример #15
0
        protected override void Configure()
        {
            this.CreateMap <UserAccessDTO, UserAccess>()
            .ForMember(d => d.Title, m => m.Ignore())
            .ForMember(d => d.DeptId, m => m.Ignore())
            .ForMember(d => d.Sts, m => m.Ignore())
            .ForMember(d => d.AccessInd, m => m.Ignore())
            .ForMember(d => d.SelectedMapUserId, m => m.MapFrom(src => src.AccessTmpl))
            .ForMember(d => d.selectedSts, m => m.MapFrom(src => src.Sts))
            .ForMember(d => d.EmailAddr, m => m.MapFrom(src => src.EmailAddr))
            .ForMember(d => d.SeletedTitle, m => m.MapFrom(src => src.Title))
            .ForMember(d => d.SelectedDeptId, m => m.MapFrom(src => src.DeptId))
            .ForMember(d => d.PrivilegeCd, m => m.MapFrom(src => src.PrivilegeCd))
            .ForMember(d => d.ChangePasswordInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.ChangePassInd)))
            .ForMember(d => d.LastLogin, m => m.MapFrom(src => NumberExtensions.DateTimeConverter(src.LastLogin)))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.CreationDate)))
            .ForMember(d => d.SelectedAccessInd, m => m.MapFrom(src => src.AccessInd))
            ;
            this.CreateMap <UserAccess, UserAccessDTO>()
            .ForMember(d => d.Title, m => m.Ignore())
            .ForMember(d => d.DeptId, m => m.Ignore())
            .ForMember(d => d.Sts, m => m.Ignore())
            .ForMember(d => d.AccessInd, m => m.Ignore())
            .ForMember(d => d.UserId, m => m.MapFrom(src => src.UserId))
            .ForMember(d => d.AccessTmpl, m => m.MapFrom(src => src.SelectedMapUserId))
            .ForMember(d => d.AccessInd, m => m.MapFrom(src => src.SelectedAccessInd))
            .ForMember(d => d.Sts, m => m.MapFrom(src => src.selectedSts))
            .ForMember(d => d.Title, m => m.MapFrom(src => src.SeletedTitle))
            .ForMember(d => d.DeptId, m => m.MapFrom(src => (src.SelectedDeptId)))
            .ForMember(d => d.CreateBy, m => m.MapFrom(src => src.CreatedBy))
            .ForMember(d => d.ChangePassInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.ChangePasswordInd)))
            .ForMember(d => d.MapUserId, m => m.MapFrom(src => src.SelectedMapUserId))
            .ForMember(d => d.LastLogin, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.LastLogin)))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.CreationDate)))
            ;

            this.CreateMap <UserAccessListDTO, UserAccess>()
            .ForMember(d => d.Title, m => m.Ignore())
            .ForMember(d => d.DeptId, m => m.Ignore())
            .ForMember(d => d.Sts, m => m.Ignore())
            .ForMember(d => d.AccessInd, m => m.Ignore())
            .ForMember(d => d.UserId, m => m.MapFrom(src => src.UserId))
            .ForMember(d => d.Name, m => m.MapFrom(src => src.UserName))
            .ForMember(d => d.SeletedTitle, m => m.MapFrom(src => src.Title))
            .ForMember(d => d.selectedSts, m => m.MapFrom(src => src.Status))
            .ForMember(d => d.EmailAddr, m => m.MapFrom(src => !string.IsNullOrEmpty(src.EmailAddress) ?src.EmailAddress : string.Empty))
            .ForMember(d => d.SelectedMapUserId, m => m.MapFrom(src => !string.IsNullOrEmpty(src.AccessTmpl) ? src.AccessTmpl : string.Empty))
            .ForMember(d => d.SelectedDeptId, m => m.MapFrom(src => !String.IsNullOrEmpty(src.DeptId) ? src.DeptId : string.Empty))
            .ForMember(d => d.SelectedAccessInd, m => m.MapFrom(src => src.AccessInd))
            ;
            this.CreateMap <UserAccessLevelDTO, WebModule>()
            .ForMember(d => d.Level, m => m.MapFrom(src => Convert.ToInt32(src.Lvl)))
            .ForMember(d => d.ModuleId, m => m.MapFrom(src => src.ModuleId))
            .ForMember(d => d.ShortDescp, m => m.MapFrom(src => src.ShortDescp))
            .ForMember(d => d.Descp, m => m.MapFrom(src => src.Descp))
            .ForMember(d => d.Sts, m => m.MapFrom(src => src.Sts))
            ;
            this.CreateMap <UserAccessLevelDetailDTO, WebPage>()
            .ForMember(d => d.Descp, m => m.Ignore())
            .ForMember(d => d.PageId, m => m.MapFrom(src => Convert.ToString(src.PageId)))
            .ForMember(d => d.Descp, m => m.MapFrom(src => src.PageDescription))
            .ForMember(d => d.ModuleId, m => m.MapFrom(src => Convert.ToString(src.ModuleId)))
            .ForMember(d => d.Sts, m => m.MapFrom(src => Convert.ToInt32(src.Sts)))
            .ForMember(d => d.URL, m => m.MapFrom(src => src.Url))
            .ForMember(d => d.Level, m => m.MapFrom(src => Convert.ToInt32(src.Lvl)))
            ;
            this.CreateMap <UserAccessLevelDetailDTO, WebPageSection>()
            .ForMember(d => d.Descp, m => m.Ignore())
            .ForMember(d => d.PageId, m => m.MapFrom(src => Convert.ToString(src.PageId)))
            .ForMember(d => d.CtrlId, m => m.MapFrom(src => Convert.ToString(src.ControlId)))
            .ForMember(d => d.ModuleId, m => m.MapFrom(src => Convert.ToString(src.ModuleId)))
            .ForMember(d => d.Descp, m => m.MapFrom(src => src.ControlDescription))
            .ForMember(d => d.Sts, m => m.MapFrom(src => Convert.ToInt32(src.CtrlSts)))
            .ForMember(d => d.Level, m => m.MapFrom(src => Convert.ToInt32(src.Lvl)))
            .ForMember(d => d.Section, m => m.MapFrom(src => src.SectionName))
            .ForMember(d => d.SectionId, m => m.MapFrom(src => Convert.ToString(src.SectionId)))
            .ForMember(d => d.SectionStatus, m => m.MapFrom(src => Convert.ToInt32(src.SectionStatus)))
            .ForMember(d => d.URL, m => m.MapFrom(src => src.Url))
            ;
            this.CreateMap <WebModule, WebModuleDTO>();
            this.CreateMap <WebPage, WebPageDTO>();
            this.CreateMap <WebControl, WebControlDTO>();
            this.CreateMap <WebPageSection, WebPageSectionDTO>();
        }
Пример #16
0
        protected override void Configure()
        {
            this.CreateMap <MerchGeneralInfoDTO, MA_GeneralInfo>()
            .ForMember(d => d.BankName, m => m.Ignore())
            .ForMember(d => d.BankBranchCd, m => m.Ignore())
            .ForMember(d => d.AutoDebitInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.AutoDebitInd)))
            .ForMember(d => d.AgrmntNo, m => m.MapFrom(src => src.AgreementNo))
            .ForMember(d => d.AgrmntDt, m => m.MapFrom(src => NumberExtensions.DateConverter(src.AgreementDate)))
            .ForMember(d => d.SelectedAffiliatedWithCorpCode, m => m.MapFrom(src => src.AffiliateWith))
            .ForMember(d => d.Msf, m => m.MapFrom(src => src.MSF.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.MSF)) : null))
            .ForMember(d => d.PIC, m => m.MapFrom(src => src.PersonInCharge))
            .ForMember(d => d.SelectedOwnership, m => m.MapFrom(src => src.Ownership))
            .ForMember(d => d.SelectedBusnSize, m => m.MapFrom(src => src.Establishment))
            .ForMember(d => d.CoRegDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.CoRegDate)))
            .ForMember(d => d.BankDirectDebitInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.AutoDebitInd)))
            .ForMember(d => d.SelectedBankName, m => m.MapFrom(src => src.BankName))
            .ForMember(d => d.selectedBankAccountType, m => m.MapFrom(src => src.BankAcctType))
            .ForMember(d => d.SelectedBankBranchCd, m => m.MapFrom(src => src.BankBranchCd))
            .ForMember(d => d.SelectedCurrentStatus, m => m.MapFrom(src => src.Sts))
            .ForMember(d => d.EnttId, m => m.MapFrom(src => src.EntityId))
            .ForMember(d => d.WithholdingTaxRate, m => m.MapFrom(src => src.WithholdingTaxRate.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.WithholdingTaxRate)) : null))
            .ForMember(d => d.SelectedCycleNo, m => m.MapFrom(src => Convert.ToString(src.CycNo)))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.CreationDate)))
            .ForMember(d => d.SelectedReasonCode, m => m.MapFrom(src => src.ReasonCd))
            .ForMember(d => d.SelectedBusnModel, m => m.MapFrom(src => src.Moso))
            .ForMember(d => d.AcctNo, m => m.MapFrom(src => src.AcctNo.HasValue ? Convert.ToString(src.AcctNo) : ""))
            ;
            this.CreateMap <MerchGeneralInfoDTO, MerchantDetails>()
            .ForMember(d => d.CurrentStatus, m => m.Ignore())
            .ForMember(d => d.TxnCode, m => m.Ignore())
            .ForMember(d => d.Ownership, m => m.Ignore())
            .ForMember(d => d.MCC, m => m.Ignore())
            .ForMember(d => d.SIC, m => m.Ignore())
            .ForMember(d => d.DBACity, m => m.Ignore())
            .ForMember(d => d.DBARegion, m => m.Ignore())
            .ForMember(d => d.DBAState, m => m.Ignore())
            .ForMember(d => d.BankAcctName, m => m.Ignore())
            .ForMember(d => d.BankAcctType, m => m.Ignore())
            .ForMember(d => d.BankBranchCode, m => m.Ignore())
            .ForMember(d => d.cycNo, m => m.Ignore())
            .ForMember(d => d.ReasonCd, m => m.Ignore())
            .ForMember(d => d.PaymtMode, m => m.Ignore())
            .ForMember(d => d.BusinessName, m => m.MapFrom(src => src.BusnName))
            .ForMember(d => d.AgreementDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.AgreementDate)))
            .ForMember(d => d.AutoDebitInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.AutoDebitInd)))
            .ForMember(d => d.PersonInCharge, m => m.MapFrom(src => src.PersonInCharge))
            .ForMember(d => d.selectedOwnershsip, m => m.MapFrom(src => src.Ownership))
            .ForMember(d => d.BusnSize, m => m.MapFrom(src => src.Establishment))
            .ForMember(d => d.SelectedSIC, m => m.MapFrom(src => src.Sic))
            .ForMember(d => d.SelectedMCC, m => m.MapFrom(src => src.Mcc))
            .ForMember(d => d.SelectedAreaCode, m => m.MapFrom(src => src.AreaCd))
            .ForMember(d => d.CoRegDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.CoRegDate)))
            .ForMember(d => d.OwnershipTrsfDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.OwnershipTrsfDate)))
            .ForMember(d => d.SelectDBARegion, m => m.MapFrom(src => src.DBARegion))
            .ForMember(d => d.SelectDBACity, m => m.MapFrom(src => src.DBACity))
            .ForMember(d => d.SelectDBAState, m => m.MapFrom(src => src.DBAState))
            .ForMember(d => d.AutoDebitInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.AutoDebitInd)))
            .ForMember(d => d.SelectedBankAcctName, m => m.MapFrom(src => src.BankName))
            .ForMember(d => d.selectedBankAcctType, m => m.MapFrom(src => src.BankAcctType))
            .ForMember(d => d.BankAccountNo, m => m.MapFrom(src => src.BankAcctNo))
            .ForMember(d => d.SelectedBankBranchCode, m => m.MapFrom(src => src.BankBranchCd))
            .ForMember(d => d.selectedCurrentStatus, m => m.MapFrom(src => src.Sts))
            .ForMember(d => d.WithholdingTaxInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.WithholdingTaxInd)))
            .ForMember(d => d.WithholdingTaxRate, m => m.MapFrom(src => src.WithholdingTaxRate.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.WithholdingTaxRate)) : ""))
            .ForMember(d => d.SelectedcycNo, m => m.MapFrom(src => Convert.ToString(src.CycNo)))
            .ForMember(d => d.UserID, m => m.MapFrom(src => src.UserId))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.CreationDate)))
            .ForMember(d => d.SelectedReasonCode, m => m.MapFrom(src => src.ReasonCd))
            .ForMember(d => d.StmtPrintInd, m => m.MapFrom(src => NumberExtensions.BoolConverter((src.StmtPrint))))
            .ForMember(d => d.SiteId, m => m.MapFrom(src => src.ReconAcct))
            .ForMember(d => d.BusnLoc, m => m.MapFrom(src => src.BusnLocation))
            .ForMember(d => d.TopupAmt, m => m.MapFrom(src => src.TopUpAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TopUpAmt)) : ""))
            .ForMember(d => d.TopupLimit, m => m.MapFrom(src => src.TopUpLimit.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TopUpLimit)) : ""))
            ;
            this.CreateMap <MerchantDetails, MerchGeneralInfoDTO>()
            .ForMember(d => d.Ownership, m => m.Ignore())
            .ForMember(d => d.DBACity, m => m.Ignore())
            .ForMember(d => d.DBARegion, m => m.Ignore())
            .ForMember(d => d.DBAState, m => m.Ignore())
            .ForMember(d => d.BankAcctType, m => m.Ignore())
            .ForMember(d => d.ReasonCd, m => m.Ignore())
            .ForMember(d => d.BusnName, m => m.MapFrom(src => src.BusinessName))
            .ForMember(d => d.AgreementDate, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.AgreementDate)))
            .ForMember(d => d.AutoDebitInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.AutoDebitInd)))
            .ForMember(d => d.PersonInCharge, m => m.MapFrom(src => src.PersonInCharge))
            .ForMember(d => d.Ownership, m => m.MapFrom(src => src.selectedOwnershsip))
            .ForMember(d => d.Establishment, m => m.MapFrom(src => src.BusnSize))
            .ForMember(d => d.Sic, m => m.MapFrom(src => src.SelectedSIC))
            .ForMember(d => d.AreaCd, m => m.MapFrom(src => src.SelectedAreaCode))
            .ForMember(d => d.Mcc, m => m.MapFrom(src => src.SelectedMCC))
            .ForMember(d => d.CoRegDate, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.CoRegDate)))
            .ForMember(d => d.OwnershipTrsfDate, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.OwnershipTrsfDate)))
            .ForMember(d => d.DBARegion, m => m.MapFrom(src => src.SelectDBARegion))
            .ForMember(d => d.DBACity, m => m.MapFrom(src => src.SelectDBACity))
            .ForMember(d => d.DBAState, m => m.MapFrom(src => src.SelectDBAState))
            .ForMember(d => d.AutoDebitInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.AutoDebitInd)))
            .ForMember(d => d.BankName, m => m.MapFrom(src => src.SelectedBankAcctName))
            .ForMember(d => d.BankAcctType, m => m.MapFrom(src => src.selectedBankAcctType))
            .ForMember(d => d.BankAcctNo, m => m.MapFrom(src => src.BankAccountNo))
            .ForMember(d => d.BankBranchCd, m => m.MapFrom(src => src.SelectedBankBranchCode))
            .ForMember(d => d.Sts, m => m.MapFrom(src => src.selectedCurrentStatus))
            .ForMember(d => d.WithholdingTaxInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.WithholdingTaxInd)))
            .ForMember(d => d.WithholdingTaxRate, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.WithholdingTaxRate)))
            .ForMember(d => d.CycNo, m => m.MapFrom(src => Convert.ToByte(src.SelectedcycNo)))
            .ForMember(d => d.UserId, m => m.MapFrom(src => src.UserID))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.CreationDate)))
            .ForMember(d => d.ReasonCd, m => m.MapFrom(src => src.SelectedReasonCode))
            .ForMember(d => d.StmtPrint, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB((src.StmtPrintInd))))
            .ForMember(d => d.ReconAcct, m => m.MapFrom(src => src.SiteId))
            .ForMember(d => d.BusnLocation, m => m.MapFrom(src => src.BusnLoc))
            .ForMember(d => d.TopUpAmt, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.TopupAmt)))
            .ForMember(d => d.TopUpLimit, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.TopupLimit)))
            ;
            this.CreateMap <EServiceDTO, eService>()
            .ForMember(d => d.Siteid, m => m.MapFrom(src => src.SiteId))
            .ForMember(d => d.bankName, m => m.MapFrom(src => src.BankName))
            .ForMember(d => d.PostingDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.PrcsDate)))
            .ForMember(d => d.TxnDate, m => m.MapFrom(src => src.LocalDate))
            .ForMember(d => d.TxnTime, m => m.MapFrom(src => src.LocalTime))
            .ForMember(d => d.CardNo, m => m.MapFrom(src => Convert.ToString(src.CardNo)))
            .ForMember(d => d.RRN, m => m.MapFrom(src => Convert.ToString(src.Rrn)))
            .ForMember(d => d.Quantity, m => m.MapFrom(src => Convert.ToInt32(src.Qty)))
            .ForMember(d => d.Amount, m => m.MapFrom(src => src.BillingAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.BillingAmt)) : ""))
            .ForMember(d => d.MDR, m => m.MapFrom(src => src.BillingAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.BillingAmt)) : ""))
            .ForMember(d => d.VatAmount, m => m.MapFrom(src => src.VATAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.VATAmt)) : ""))
            .ForMember(d => d.NetAmount, m => m.MapFrom(src => src.NetAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.NetAmt)) : ""))
            ;
            this.CreateMap <BusnLocTerminalDTO, BusnLocTerminal>()
            .ForMember(d => d.ProdType, m => m.Ignore())
            .ForMember(d => d.ReasonCd, m => m.Ignore())
            .ForMember(d => d.TermType, m => m.Ignore())
            .ForMember(d => d.SelectedTermType, m => m.MapFrom(src => src.TermType))
            .ForMember(d => d.SelectedStatus, m => m.MapFrom(src => src.Status))
            .ForMember(d => d.RawStatus, m => m.MapFrom(src => src.Sts))
            .ForMember(d => d.DeployDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.DeployDate)))
            .ForMember(d => d.Replacement, m => m.MapFrom(src => src.ReplacedByTermId))
            .ForMember(d => d.ReplacedDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.ReplacedDate)))
            .ForMember(d => d.SelectedReasonCode, m => m.MapFrom(src => src.ReasonCd))
            .ForMember(d => d.IPEK, m => m.MapFrom(src => Convert.ToString(src.IPEK)))
            .ForMember(d => d.SettlementStart, m => m.MapFrom(src => NumberExtensions.DateConverter(src.SettleFromTime)))
            .ForMember(d => d.SettlementEnd, m => m.MapFrom(src => NumberExtensions.DateConverter(src.SettleToTime)))
            .ForMember(d => d.LastBatchId, m => m.MapFrom(src => Convert.ToInt32(src.LastBatchId)))
            .ForMember(d => d.SettleTxnId, m => m.MapFrom(src => Convert.ToInt32(src.SettleTxnId)))
            .ForMember(d => d.SelectedProdType, m => m.MapFrom(src => src.DeviceModel))
            .ForMember(d => d.SerialNo, m => m.MapFrom(src => src.SerialNo))
            .ForMember(d => d.Descp, m => m.MapFrom(src => src.Reason))
            .ForMember(d => d.Remarks, m => m.MapFrom(src => src.Remarks))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.CreationDate)))
            .ForMember(d => d.LastUpdDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.LastUpdDate)))
            ;
            this.CreateMap <BusnLocTerminal, BusnLocTerminalDTO>()
            .ForMember(d => d.ReasonCd, m => m.Ignore())
            .ForMember(d => d.TermType, m => m.Ignore())
            .ForMember(d => d.TermType, m => m.MapFrom(src => src.SelectedTermType))
            .ForMember(d => d.Status, m => m.MapFrom(src => src.SelectedStatus))
            .ForMember(d => d.Sts, m => m.MapFrom(src => src.RawStatus))
            .ForMember(d => d.DeployDate, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.DeployDate)))
            .ForMember(d => d.ReplacedByTermId, m => m.MapFrom(src => src.Replacement))
            .ForMember(d => d.ReplacedDate, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.ReplacedDate)))
            .ForMember(d => d.ReasonCd, m => m.MapFrom(src => src.SelectedReasonCode))
            .ForMember(d => d.IPEK, m => m.MapFrom(src => src.IPEK))
            .ForMember(d => d.SettleFromTime, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.SettlementStart)))
            .ForMember(d => d.SettleToTime, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.SettlementEnd)))
            .ForMember(d => d.LastBatchId, m => m.MapFrom(src => src.LastBatchId))
            .ForMember(d => d.SettleTxnId, m => m.MapFrom(src => Convert.ToInt64(src.SettleTxnId)))
            .ForMember(d => d.DeviceModel, m => m.MapFrom(src => src.SelectedProdType))
            .ForMember(d => d.SerialNo, m => m.MapFrom(src => src.SerialNo))
            .ForMember(d => d.Reason, m => m.MapFrom(src => src.Descp))
            .ForMember(d => d.Remarks, m => m.MapFrom(src => src.Remarks))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.CreationDate)))
            .ForMember(d => d.LastUpdDate, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.LastUpdDate)))
            ;
            this.CreateMap <MerchChangeOwnershipDTO, MerchChangeOwnership>()
            .ForMember(d => d.DBAState, m => m.Ignore())
            .ForMember(d => d.BankName, m => m.Ignore())
            .ForMember(d => d.BankAcctType, m => m.Ignore())
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => src.CreationDate))
            .ForMember(d => d.CutoffDate, m => m.MapFrom(src => src.CutOffDate))
            .ForMember(d => d.NewSiteId, m => m.MapFrom(src => src.NewSiteId))
            .ForMember(d => d.SelectedDBAState, m => m.MapFrom(src => src.DBAState))
            .ForMember(d => d.SelectedBankName, m => m.MapFrom(src => src.BankName))
            .ForMember(d => d.SelectedBankAcctType, m => m.MapFrom(src => src.BankAcctType))
            .ForMember(d => d.ToMerchantId, m => m.MapFrom(src => src.ToMerchantID))
            .ForMember(d => d.FromMerchantId, m => m.MapFrom(src => src.FromMerchantId))
            .ForMember(d => d.SAPNo, m => m.MapFrom(src => src.SapNo))
            .ForMember(d => d.CutoffDate, m => m.MapFrom(src => src.CutOffDate))
            .ForMember(d => d.MaskedFlag, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.MaskedFlag)))
            .ForMember(d => d.FloatAcctInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.FloatAcctInd)))
            ;
            this.CreateMap <MerchChangeOwnership, MerchChangeOwnershipDTO>()
            .ForMember(d => d.DBAState, m => m.Ignore())
            .ForMember(d => d.BankName, m => m.Ignore())
            .ForMember(d => d.BankAcctType, m => m.Ignore())
            .ForMember(d => d.ToMerchantID, m => m.MapFrom(src => src.ToMerchantId))
            .ForMember(d => d.CurrentBusnNo, m => m.MapFrom(src => src.FromMerchantId))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.CreationDate)))
            .ForMember(d => d.CurrentBusnNo, m => m.MapFrom(src => src.FromMerchantId))
            .ForMember(d => d.CurrentSiteId, m => m.MapFrom(src => src.CurrentSiteId))
            .ForMember(d => d.CutOffDate, m => m.MapFrom(src => src.CutoffDate))
            .ForMember(d => d.FloatAcctInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.FloatAcctInd)))
            .ForMember(d => d.DBAState, m => m.MapFrom(src => src.SelectedDBAState))
            .ForMember(d => d.BankName, m => m.MapFrom(src => src.SelectedBankName))
            .ForMember(d => d.FloatAcctInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.FloatAcctInd)))
            .ForMember(d => d.BankAcctType, m => m.MapFrom(src => src.SelectedBankAcctType))
            .ForMember(d => d.SapNo, m => m.MapFrom(src => src.SAPNo))
            ;
            this.CreateMap <MerchProductPrizeDTO, MerchProductPrize>()
            .ForMember(d => d.ProdCd, m => m.Ignore())
            .ForMember(d => d.EffDateFrom, m => m.MapFrom(src => NumberExtensions.DateConverter(src.StartDate)))
            .ForMember(d => d.EffDateTo, m => m.MapFrom(src => NumberExtensions.DateConverter(src.EndDate)))
            .ForMember(d => d.Descp, m => m.MapFrom(src => src.Product))
            .ForMember(d => d.Price, m => m.MapFrom(src => src.Price.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.Price)) : ""))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.CreationDate)))
            ;
            this.CreateMap <MerchProductPrize, MerchProductPrizeDTO>()
            .ForMember(d => d.StartDate, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.EffDateFrom)))
            .ForMember(d => d.EndDate, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.EffDateTo)))
            .ForMember(d => d.Product, m => m.MapFrom(src => src.Descp))
            .ForMember(d => d.ProdCd, m => m.MapFrom(src => src.SelectedProdCd))
            .ForMember(d => d.Price, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.Price)))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.CreationDate)))
            ;

            this.CreateMap <MerchAgreementGeneralInfoDTO, MA_GeneralInfo>()
            .ForMember(d => d.AcctNo, m => m.MapFrom(src => src.MerchantAccount))
            .ForMember(d => d.PIC, m => m.MapFrom(src => src.PersonInCharge))
            .ForMember(d => d.SAPNo, m => m.MapFrom(src => src.SAPNo))
            .ForMember(d => d.BusnName, m => m.MapFrom(src => src.BusinessName))
            .ForMember(d => d.SelectedAffiliatedWithCorpCode, m => m.MapFrom(src => src.AffiliatedWith))
            .ForMember(d => d.WithholdingTaxInd, m => m.MapFrom(src => src.WithholdingTaxInd))
            .ForMember(d => d.WithholdingTaxRate, m => m.MapFrom(src => NumberExtensions.ConverterDecimal(src.WithholdingTaxRate.ToString())))
            .ForMember(d => d.TaxId, m => m.MapFrom(src => src.TaxId))
            .ForMember(d => d.SelectedCurrentStatus, m => m.MapFrom(src => src.Status))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.CreationDate)))
            ;
            this.CreateMap <MA_GeneralInfo, MerchAgreementGeneralInfoDTO>()
            .ForMember(d => d.AcctNo, m => m.MapFrom(src => src.AcctNo))
            .ForMember(d => d.BusinessName, m => m.MapFrom(src => src.BusnName))
            .ForMember(d => d.AgreeNo, m => m.MapFrom(src => src.AgrmntNo))
            .ForMember(d => d.AgreeDate, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.AgrmntDt)))
            .ForMember(d => d.AffiliatedWith, m => m.MapFrom(src => src.SelectedAffiliatedWithCorpCode))
            .ForMember(d => d.SAPNo, m => m.MapFrom(src => src.SAPNo))
            .ForMember(d => d.Msf, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.Msf)))
            .ForMember(d => d.PersonInCharge, m => m.MapFrom(src => src.PIC))
            .ForMember(d => d.ReasonCd, m => m.MapFrom(src => (src.SelectedReasonCode)))
            .ForMember(d => d.Ownership, m => m.MapFrom(src => src.SelectedOwnership))
            .ForMember(d => d.Establishment, m => m.MapFrom(src => src.SelectedBusnSize))
            .ForMember(d => d.CoRegsNo, m => m.MapFrom(src => src.CoRegNo))
            .ForMember(d => d.CoRegsName, m => m.MapFrom(src => src.CoRegName))
            .ForMember(d => d.CoRegsDate, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.CoRegDate)))
            .ForMember(d => d.Moso, m => m.MapFrom(src => src.SelectedBusnModel))
            .ForMember(d => d.PayeeName, m => m.MapFrom(src => src.PayeeName))
            .ForMember(d => d.AutoDebit, m => m.MapFrom(src => src.BankDirectDebitInd))
            .ForMember(d => d.BankName, m => m.MapFrom(src => src.SelectedBankName))
            .ForMember(d => d.BankAcctType, m => m.MapFrom(src => src.selectedBankAccountType))
            .ForMember(d => d.BankAcctNo, m => m.MapFrom(src => src.BankAcctNo))
            .ForMember(d => d.BankBranchCd, m => m.MapFrom(src => src.SelectedBankBranchCd))
            .ForMember(d => d.Status, m => m.MapFrom(src => src.SelectedCurrentStatus))
            .ForMember(d => d.EntityId, m => m.MapFrom(src => src.EnttId))
            .ForMember(d => d.TaxId, m => m.MapFrom(src => src.TaxId))
            .ForMember(d => d.WithholdInd, m => m.MapFrom(src => src.WithholdingTaxInd))
            .ForMember(d => d.WithholdingTaxRate, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.WithholdingTaxRate)))
            .ForMember(d => d.CycNo, m => m.MapFrom(src => src.SelectedCycleNo))
            .ForMember(d => d.UserId, m => m.MapFrom(src => src.UserId))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.DateConverterDB(CardTrend.Common.Extensions.NumberExtensions.DateConverter(DateTime.Now))))
            ;
        }
Пример #17
0
        public async Task <IssMessageDTO> SaveMerchantMultiTxnAdjustmentMaint(TxnAdjustmentDTO adjustmentDetail, string userId)
        {
            using (var cardtrendentities = new pdb_ccmsContext(_connectionString))
            {
                IssMessageDTO issMessage = new IssMessageDTO();
                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 adjustmentDetail.multipleTxnRecord)
                {
                    DataRow dr = dt.NewRow();
                    dr["DeftBusnlocation"] = item.MerchantAcctNo;
                    dr["TxnAmt"]           = (object)NumberExtensions.ConvertDecimalToDb(item.TxnAmt) ?? DBNull.Value;
                    dr["Descp"]            = (object)item.Descp ?? DBNull.Value;
                    dr["TxnCd"]            = adjustmentDetail.TxnCd;
                    dr["TxnDate"]          = adjustmentDetail.TxnDate.ToShortDateString();
                    dr["DueDate"]          = adjustmentDetail.DueDate == DateTime.MinValue ? DBNull.Value : NumberExtensions.ConvertDatetimeDB(adjustmentDetail.DueDate.ToShortDateString());
                    dr["Owner"]            = adjustmentDetail.Owner;
                    dr["InvoiceNo"]        = (object)adjustmentDetail.InvoiceNo ?? DBNull.Value;
                    dr["TxnId"]            = (object)adjustmentDetail.TxnId ?? DBNull.Value;
                    dt.Rows.Add(dr);
                }

                var parameters = new[] {
                    new SqlParameter("@IssNo", SqlDbType.SmallInt)
                    {
                        SqlValue = Common.Helpers.Common.GetIssueNo()
                    },
                    new SqlParameter("@CheqAmt", SqlDbType.Money)
                    {
                        SqlValue = NumberExtensions.ConvertDecimalToDb(adjustmentDetail.ChequeAmt)
                    },
                    new SqlParameter("@UserId", SqlDbType.VarChar)
                    {
                        SqlValue = (object)userId ?? DBNull.Value
                    },
                    new SqlParameter("@Adjustment", SqlDbType.Structured)
                    {
                        SqlValue = dt, TypeName = "Adjustment"
                    },
                    new SqlParameter("@RetCd", SqlDbType.Int)
                    {
                        Direction = ParameterDirection.Output
                    },
                    new SqlParameter("@RcptNo", SqlDbType.VarChar)
                    {
                        SqlValue = (object)adjustmentDetail.InvoiceNo ?? DBNull.Value
                    },
                    new SqlParameter("@BatchId", SqlDbType.Int)
                    {
                        SqlValue = (object)adjustmentDetail.BatchId ?? DBNull.Value
                    },
                    new SqlParameter("@BatchOut", SqlDbType.VarChar, 25)
                    {
                        Direction = ParameterDirection.Output
                    },
                    new SqlParameter("@Owner", SqlDbType.VarChar)
                    {
                        SqlValue = (object)adjustmentDetail.Owner ?? DBNull.Value
                    },
                    new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt)
                    {
                        Direction = ParameterDirection.Output
                    }
                };

                await cardtrendentities.Database.ExecuteSqlCommandAsync("exec @RETURN_VALUE = WebMerchantMultiTxnAdjustmentMaint @IssNo,@CheqAmt,@UserId,@Adjustment,@RetCd OUT," +
                                                                        "@RcptNo,@BatchId,@BatchOut OUT,@Owner", parameters);

                var             resultCode = parameters.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value;
                ResourceManager myManager  = new ResourceManager(typeof(CardTrend.Common.Resources.IssMessages));
                issMessage.paraOut.BatchId = parameters.Where(x => x.ParameterName == "@BatchOut").FirstOrDefault().Value.ToString();
                issMessage.paraOut.RetCd   = parameters.Where(x => x.ParameterName == "@RetCd").FirstOrDefault().Value.ToString();
                issMessage.Descp           = myManager.GetString("Msg" + resultCode);
                issMessage.Flag            = Convert.ToInt32(resultCode);
                return(issMessage);
            }
        }
Пример #18
0
        public async Task <IssMessageDTO> SaveWebNtfyEvtConfMaint(NtfyEventConfDTO lookUpParameters)
        {
            using (var cardtrendentities = new pdb_ccmsContext(_connectionString))
            {
                IssMessageDTO issMessage         = new IssMessageDTO();
                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"]       = NumberExtensions.ConvertLongToDb(item.MinIntVal);
                        dr["MaxIntVal"]       = NumberExtensions.ConvertLongToDb(item.MaxIntVal);
                        dr["MinMoneyVal"]     = NumberExtensions.ConvertDecimalToDb(item.MinMoneyVal);
                        dr["MaxMoneyVal"]     = NumberExtensions.ConvertDecimalToDb(item.MaxMoneyVal);
                        dr["MinDateVal"]      = NumberExtensions.ConvertDatetimeDB(item.MinDateVal);
                        dr["MaxDateVal"]      = NumberExtensions.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.eventRcpts != null)
                {
                    foreach (var item in lookUpParameters.eventRcpts)
                    {
                        DataRow dr = dtNtfyEventRcptTbl.NewRow();
                        dr["EventRecipientId"] = string.IsNullOrEmpty(item.Id.ToString()) ? (object)DBNull.Value : item.Id;
                        dr["EventScheduleId"]  = string.IsNullOrEmpty(lookUpParameters.EventScheduleId.ToString()) ? (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);
                    }
                }

                var parameters = new[] {
                    new SqlParameter("@IssNo", SqlDbType.SmallInt)
                    {
                        SqlValue = Common.Helpers.Common.GetIssueNo()
                    },
                    new SqlParameter("@EventSchId", SqlDbType.BigInt)
                    {
                        SqlValue = (object)lookUpParameters.EventScheduleId ?? DBNull.Value
                    },
                    new SqlParameter("@NewEventSchId", SqlDbType.BigInt)
                    {
                        Direction = ParameterDirection.Output
                    },
                    new SqlParameter("@EventTypeID", SqlDbType.BigInt)
                    {
                        SqlValue = (object)lookUpParameters.EventTypeId ?? DBNull.Value
                    },
                    new SqlParameter("@EventPlanId", SqlDbType.BigInt)
                    {
                        SqlValue = (object)lookUpParameters.EventPlanId ?? DBNull.Value
                    },
                    new SqlParameter("@ShortDescp", SqlDbType.NVarChar)
                    {
                        SqlValue = (object)lookUpParameters.ShortDescp ?? DBNull.Value
                    },
                    new SqlParameter("@Scope", SqlDbType.VarChar)
                    {
                        SqlValue = (object)lookUpParameters.OwnerType ?? DBNull.Value
                    },
                    new SqlParameter("@Sts", SqlDbType.VarChar)
                    {
                        SqlValue = (object)lookUpParameters.Sts ?? DBNull.Value
                    },
                    new SqlParameter("@ParamInd", SqlDbType.BigInt)
                    {
                        SqlValue = 0
                    },
                    new SqlParameter("@RefTo", SqlDbType.VarChar)
                    {
                        SqlValue = (object)lookUpParameters.Refto ?? DBNull.Value
                    },
                    new SqlParameter("@RefKey", SqlDbType.VarChar)
                    {
                        SqlValue = (object)lookUpParameters.Refkey ?? DBNull.Value
                    },

                    new SqlParameter("@CntEvtOccur", SqlDbType.Int)
                    {
                        SqlValue = (object)lookUpParameters.MaxOccur ?? DBNull.Value
                    },
                    new SqlParameter("@EvtOccurType", SqlDbType.VarChar)
                    {
                        SqlValue = (object)lookUpParameters.Frequency ?? DBNull.Value
                    },
                    new SqlParameter("@UserId", SqlDbType.VarChar)
                    {
                        SqlValue = (object)lookUpParameters.UserId ?? DBNull.Value
                    },
                    new SqlParameter("@ChannelInd", SqlDbType.BigInt)
                    {
                        SqlValue = (object)lookUpParameters.EvtTypeChannelInd ?? DBNull.Value
                    },
                    new SqlParameter("@DefaultInd", SqlDbType.Char)
                    {
                        SqlValue = (object)lookUpParameters.DefaultInd ?? DBNull.Value
                    },
                    new SqlParameter("@NtfyEventTbl", SqlDbType.Structured)
                    {
                        SqlValue = dtNtfyEventTbl, TypeName = "NtfyEventTbl"
                    },
                    new SqlParameter("@NtfyEventRcptTbl", SqlDbType.Structured)
                    {
                        SqlValue = dtNtfyEventRcptTbl, TypeName = "NtfyEventRcptTbl"
                    },
                    new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt)
                    {
                        Direction = ParameterDirection.Output
                    }
                };

                await cardtrendentities.Database.ExecuteSqlCommandAsync("exec @RETURN_VALUE = WebNtfyEvtConfMaint @IssNo,@EventSchId,@NewEventSchId OUT,@EventTypeID,@EventPlanId," +
                                                                        "@ShortDescp,@Scope,@Sts,@ParamInd,@RefTo,@RefKey,@CntEvtOccur,@EvtOccurType,@UserId,@ChannelInd,@DefaultInd,@NtfyEventTbl,@NtfyEventRcptTbl", parameters);

                var resultCode    = parameters.Where(x => x.ParameterName == "@RETURN_VALUE").FirstOrDefault().Value;
                var newEventSchId = parameters.Where(x => x.ParameterName == "@NewEventSchId").FirstOrDefault().Value;
                issMessage.Flag = Convert.ToInt32(resultCode);
                issMessage.paraOut.NewEventSchId = Convert.ToInt64(newEventSchId);
                return(issMessage);
            }
        }
Пример #19
0
        protected override void Configure()
        {
            this.CreateMap <CreditAssesOperationDTO, CreditAssesOperation>()
            .ForMember(d => d.DirectDebitInd, m => m.Ignore())
            .ForMember(d => d.BankAcctType, m => m.Ignore())
            .ForMember(d => d.BankName, m => m.Ignore())
            .ForMember(d => d.DepositType, m => m.Ignore())
            .ForMember(d => d.SelectedDirectDebitInd, m => m.MapFrom(src => src.DirectDebitInd))
            .ForMember(d => d.SelectedDepositType, m => m.MapFrom(src => src.DepositType))
            .ForMember(d => d.SelectedBankAcctType, m => m.MapFrom(src => src.BankAcctType != null ? src.BankAcctType : ""))
            .ForMember(d => d.SelectedBankName, m => m.MapFrom(src => src.BankName != null ? src.BankName : ""))
            .ForMember(d => d.BankAcctNo, m => m.MapFrom(src => src.BankAcctNo != null ? src.BankAcctNo : ""))
            .ForMember(d => d.DepositAmt, m => m.MapFrom(src => src.DepositAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.DepositAmt)) : ""))
            .ForMember(d => d.Txnid, m => m.MapFrom(src => src.TxnId))
            .ForMember(d => d.UserId, m => m.MapFrom(src => src.UserId))
            .ForMember(d => d.Creationdt, m => m.MapFrom(src => src.CreationDate.ToString()))
            .ForMember(d => d.BgSerialNo, m => m.MapFrom(src => src.BGSerialNo != null ? src.BGSerialNo : ""))
            .ForMember(d => d.SecurityAmt, m => m.MapFrom(src => src.SecurityDeposit.HasValue ? NumberExtensions.ConverterDecimal(src.SecurityDeposit.Value.ToString()).ToString() : ""))
            .ForMember(d => d.SAPRefNo, m => m.MapFrom(src => src.SAPRefNo != null ? src.SAPRefNo : ""))
            ;
            this.CreateMap <CreditAssesOperation, CreditAssesOperationDTO>()
            .ForMember(d => d.DirectDebitInd, m => m.Ignore())
            .ForMember(d => d.BankAcctType, m => m.Ignore())
            .ForMember(d => d.BankName, m => m.Ignore())
            .ForMember(d => d.CorpCd, m => m.Ignore())
            .ForMember(d => d.DepositType, m => m.Ignore())
            .ForMember(d => d.DepositFromDate, m => m.Ignore())
            .ForMember(d => d.DepositToDate, m => m.Ignore())
            .ForMember(d => d.EffToDate, m => m.Ignore())
            .ForMember(d => d.EffFromDate, m => m.Ignore())
            .ForMember(d => d.AcctNo, m => m.MapFrom(src => src.acctNo))
            .ForMember(d => d.TxnId, m => m.MapFrom(src => src.Txnid))
            .ForMember(d => d.DepositInd, m => m.MapFrom(src => src.DirectDebitInd == true ? "Y" : "N"))
            .ForMember(d => d.DepositType, m => m.MapFrom(src => src.SelectedDepositType))
            .ForMember(d => d.ValidityDate, m => m.MapFrom(src => DateTime.ParseExact(src.ValidityDate, "dd/MM/yyyy", null)))
            .ForMember(d => d.BankAcctType, m => m.MapFrom(src => src.SelectedBankAcctType))
            .ForMember(d => d.BankName, m => m.MapFrom(src => src.SelectedBankName))
            .ForMember(d => d.DepositAmt, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.DepositAmt)))
            .ForMember(d => d.BGSerialNo, m => m.MapFrom(src => src.BankBranchCode))
            .ForMember(d => d.EffFromDate, m => m.MapFrom(src => DateTime.ParseExact(src.DepositFromDate, "dd/MM/yyyy", null)))
            .ForMember(d => d.EffToDate, m => m.MapFrom(src => DateTime.ParseExact(src.DepositToDate, "dd/MM/yyyy", null)))
            .ForMember(d => d.BGSerialNo, m => m.MapFrom(src => src.BankBranchCode))
            .ForMember(d => d.NIRD, m => m.MapFrom(src => DateTime.ParseExact(src.NRID, "dd/MM/yyyy", null)))
            .ForMember(d => d.Remark, m => m.MapFrom(src => src.remarks))
            .ForMember(d => d.SecurityDeposit, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.SecurityAmt)))
            ;
            this.CreateMap <GeneralInfoDTO, GeneralInfoModel>()
            .ForMember(d => d.PlasticType, m => m.Ignore())
            .ForMember(d => d.SIC, m => m.Ignore())
            .ForMember(d => d.CustomerGroup, m => m.Ignore())
            .ForMember(d => d.BusnEstablishment, m => m.Ignore())
            .ForMember(d => d.AccountType, m => m.Ignore())
            .ForMember(d => d.LangId, m => m.Ignore())
            .ForMember(d => d.TradingArea, m => m.Ignore())
            .ForMember(d => d.SelectedAccountType, m => m.MapFrom(src => src.AccountType))
            .ForMember(d => d.SelectedPlasticType, m => m.MapFrom(src => src.PlasticType))
            .ForMember(d => d.AccountName, m => m.MapFrom(src => src.AccountName))
            .ForMember(d => d.SelectedCompanyType, m => m.MapFrom(src => src.CmpyType))
            .ForMember(d => d.RegsDate, m => m.MapFrom(src => src.RegsDate.HasValue ? NumberExtensions.DateConverter(src.RegsDate) :""))
            .ForMember(d => d.SelectedSIC, m => m.MapFrom(src => src.SIC))
            .ForMember(d => d.SapNo, m => m.MapFrom(src => src.CustomerNo))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.DateTimeConverter(src.CreationDate)))
            .ForMember(d => d.BlockedDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.BlockedDate)))
            .ForMember(d => d.SelectedCorpName, m => m.MapFrom(src => src.CorpCd))
            .ForMember(d => d.SelectedClientClass, m => m.MapFrom(src => src.TermsofPayment))
            .ForMember(d => d.selectedClientType, m => m.MapFrom(src => src.CustomerGroup))
            .ForMember(d => d.SelectedBusnEstablishment, m => m.MapFrom(src => src.BusnEstablishment))
            .ForMember(d => d.SourceCode, m => m.MapFrom(src => src.SrcCd))
            .ForMember(d => d.SourceRefNo, m => m.MapFrom(src => src.SrcRefNo))
            .ForMember(d => d.SelectedAcctSts, m => m.MapFrom(src => src.Sts))
            .ForMember(d => d.TerminatedDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.TerminatedDate)))
            .ForMember(d => d.SelectedReasonCode, m => m.MapFrom(src => src.ReasonCd))
            .ForMember(d => d.OvrStatusTaggedByUserId, m => m.MapFrom(src => src.OverrideStsUserId))
            .ForMember(d => d.SelectedOvrStatus, m => m.MapFrom(src => src.OverrideSts))
            .ForMember(d => d.OvrExpDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.OverrideStsExpiry)))
            .ForMember(d => d.OvrStartDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.OverrideStsStart)))
            .ForMember(d => d.ApplId, m => m.MapFrom(src => src.ApplId.HasValue? Convert.ToString(src.ApplId) : null))
            .ForMember(d => d.CaptDate, m => m.MapFrom(src => src.CreationDate.HasValue ? NumberExtensions.DateTimeConverter(src.CaptDate) : ""))
            .ForMember(d => d.LoyaltyCardNo, m => m.MapFrom(src => src.LoyaltyCardNo.HasValue? Convert.ToString(src.LoyaltyCardNo) : null))
            .ForMember(d => d.SelectedBusnCategory, m => m.MapFrom(src => src.Industry))
            .ForMember(d => d.SelectedSaleTerritory, m => m.MapFrom(src => src.SalesGroup))
            .ForMember(d => d.SelectedPaymentTerm, m => m.MapFrom(src => src.PymtTerms.HasValue ?  Convert.ToString(src.PymtTerms) : null))
            .ForMember(d => d.ApplCreationDate, m => m.MapFrom(src => NumberExtensions.DateTimeConverter(src.CaptDate)))
            .ForMember(d => d.CutOff, m => m.MapFrom(src => Convert.ToString(src.CutOff)))
            .ForMember(d => d.SelectedCurrentStatus, m => m.MapFrom(src => src.Sts))
            .ForMember(d => d.SelectedLangId, m => m.MapFrom(src => src.LangId))
            .ForMember(d => d.CompanyEmbName, m => m.MapFrom(src => src.CmpyEmbName))
            .ForMember(d => d.ContactPerson, m => m.MapFrom(src => src.FamilyName))
            .ForMember(d => d.AuthSignatory, m => m.MapFrom(src => src.AuthName))
            .ForMember(d => d.SelectedTradingArea, m => m.MapFrom(src => src.TradingArea))
            ;
            this.CreateMap <GeneralInfoModel, GeneralInfoDTO>()
            .ForMember(d => d.PlasticType, m => m.Ignore())
            .ForMember(d => d.SIC, m => m.Ignore())
            .ForMember(d => d.CustomerGroup, m => m.Ignore())
            .ForMember(d => d.BusnEstablishment, m => m.Ignore())
            .ForMember(d => d.AccountType, m => m.Ignore())
            .ForMember(d => d.LangId, m => m.Ignore())
            .ForMember(d => d.TradingArea, m => m.Ignore())
            .ForMember(d => d.CreationDate, m => m.Ignore())
            .ForMember(d => d.SIC, m => m.MapFrom(src => src.SelectedSIC))
            .ForMember(d => d.CustomerNo, m => m.MapFrom(src => src.SapNo))
            .ForMember(d => d.RegsDate, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.RegsDate)))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.ConvertToDatetimeDB2(src.CreationDate)))
            .ForMember(d => d.BlockedDate, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.BlockedDate)))
            .ForMember(d => d.CorpCd, m => m.MapFrom(src => src.SelectedCorpName))
            .ForMember(d => d.TermsofPayment, m => m.MapFrom(src => src.SelectedClientClass))
            .ForMember(d => d.CustomerGroup, m => m.MapFrom(src => src.selectedClientType))
            .ForMember(d => d.BusnEstablishment, m => m.MapFrom(src => src.SelectedBusnEstablishment))
            .ForMember(d => d.SrcCd, m => m.MapFrom(src => src.SourceCode))
            .ForMember(d => d.SrcRefNo, m => m.MapFrom(src => src.SourceRefNo))
            .ForMember(d => d.Sts, m => m.MapFrom(src => src.SelectedAcctSts))
            .ForMember(d => d.TerminatedDate, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.TerminatedDate)))
            .ForMember(d => d.ReasonCd, m => m.MapFrom(src => src.SelectedReasonCode))
            .ForMember(d => d.OverrideStsUserId, m => m.MapFrom(src => src.OvrStatusTaggedByUserId))
            .ForMember(d => d.OverrideSts, m => m.MapFrom(src => src.SelectedOvrStatus))
            .ForMember(d => d.OverrideStsExpiry, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.OvrExpDate)))
            .ForMember(d => d.ApplId, m => m.MapFrom(src => Convert.ToInt32(src.ApplId)))
            .ForMember(d => d.CaptDate, m => m.MapFrom(src => NumberExtensions.ConvertToDatetimeDB2(src.ApplCreationDate)))
            .ForMember(d => d.LoyaltyCardNo, m => m.MapFrom(src => Convert.ToInt64(src.LoyaltyCardNo)))
            .ForMember(d => d.Industry, m => m.MapFrom(src => src.SelectedBusnCategory))
            .ForMember(d => d.SalesGroup, m => m.MapFrom(src => src.SelectedSaleTerritory))
            .ForMember(d => d.AccountType, m => m.MapFrom(src => src.SelectedAccountType))
            .ForMember(d => d.CutOff, m => m.MapFrom(src => Convert.ToByte(src.CutOff)))
            .ForMember(d => d.PymtTerms, m => m.MapFrom(src => Convert.ToInt32(src.SelectedPaymentTerm)))
            .ForMember(d => d.ReconAcct, m => m.MapFrom(src => src.CustSvcId))
            .ForMember(d => d.OverrideStsStart, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.OvrStartDate)))
            .ForMember(d => d.LangId, m => m.MapFrom(src => src.SelectedLangId))
            .ForMember(d => d.CmpyEmbName, m => m.MapFrom(src => src.CompanyEmbName))
            .ForMember(d => d.CmpyType, m => m.MapFrom(src => src.SelectedCompanyType))
            .ForMember(d => d.FamilyName, m => m.MapFrom(src => src.ContactPerson))
            .ForMember(d => d.AuthName, m => m.MapFrom(src => src.AuthSignatory))
            .ForMember(d => d.TradingArea, m => m.MapFrom(src => src.SelectedTradingArea))
            .ForMember(d => d.PlasticType, m => m.MapFrom(src => src.SelectedPlasticType))
            ;

            this.CreateMap <FinancialInfoDTO, FinancialInfoModel>()
            .ForMember(d => d.TaxCategory, m => m.Ignore())
            .ForMember(d => d.CycNo, m => m.Ignore())
            .ForMember(d => d.StmtType, m => m.Ignore())
            .ForMember(d => d.StmtInd, m => m.Ignore())
            .ForMember(d => d.PaymtMethod, m => m.Ignore())
            .ForMember(d => d.BankAcctType, m => m.Ignore())
            .ForMember(d => d.BankName, m => m.Ignore())
            .ForMember(d => d.RiskCategory, m => m.Ignore())
            .ForMember(d => d.AcctNo, m => m.MapFrom(src => src.AcctNo))
            .ForMember(d => d.TaxId, m => m.MapFrom(src => src.TaxId))
            .ForMember(d => d.LatePaymtCharge, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.StopLPC)))
            .ForMember(d => d.SelectedDunningCd, m => m.MapFrom(src => Convert.ToString(src.DunCd)))
            .ForMember(d => d.CredtAllowanceFact, m => m.MapFrom(src => src.AllowanceFactor.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.AllowanceFactor)) : null))
            .ForMember(d => d.AccrdInterest, m => m.MapFrom(src => src.AccruedInterestAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.AccruedInterestAmt)) : null))
            .ForMember(d => d.AccrdCrdtUsg, m => m.MapFrom(src => src.AccruedCreditUsageAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.AccruedCreditUsageAmt)) : null))
            .ForMember(d => d.PromPaymtRebate, m => m.MapFrom(src => src.PromptPaymtRebate.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.PromptPaymtRebate)) : null))
            .ForMember(d => d.PPRGracePeriod, m => m.MapFrom(src => NumberExtensions.ConvertInt(src.PromptPaymtRebateTerms)))
            .ForMember(d => d.pprExpiry, m => m.MapFrom(src => NumberExtensions.DateConverter(src.PromptPaymtRebateExpiry)))
            .ForMember(d => d.LitreLimitPerTxn, m => m.MapFrom(src => src.LitLimitPerTxn.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.LitLimitPerTxn)) : null))
            .ForMember(d => d.AmtLimitPerTxn, m => m.MapFrom(src => src.AmtLimitPerTxn.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.AmtLimitPerTxn)) : null))
            .ForMember(d => d.SelectedCycNo, m => m.MapFrom(src => Convert.ToString(src.CycNo)))
            .ForMember(d => d.SelectedStmtType, m => m.MapFrom(src => src.StmtType))
            .ForMember(d => d.SelectedStmtInd, m => m.MapFrom(src => string.IsNullOrEmpty(src.StmtInd) ? "0" : src.StmtInd))
            .ForMember(d => d.StmtDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.StmtDate)))
            .ForMember(d => d.SelectedPaymtMethod, m => m.MapFrom(src => src.PaymtMethod))
            .ForMember(d => d.PaymtTerm, m => m.MapFrom(src => src.PymtTerms))
            .ForMember(d => d.GracePeriod, m => m.MapFrom(src => src.GracePeriod.HasValue?Convert.ToInt32(src.GracePeriod) : 0))
            .ForMember(d => d.DirectDebitInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.DirectDebitInd)))
            .ForMember(d => d.SelectedBankAcctType, m => m.MapFrom(src => src.BankAcctType))
            .ForMember(d => d.selectedBankName, m => m.MapFrom(src => src.BankName))
            .ForMember(d => d.BankAcctNo, m => m.MapFrom(src => src.BankAcctNo))
            .ForMember(d => d.BankBranchCD, m => m.MapFrom(src => src.BankBranchCd))
            .ForMember(d => d.PayeeCd, m => m.MapFrom(src => src.PayeeCd))
            .ForMember(d => d.SelectedTaxCategory, m => m.MapFrom(src => src.TaxCategory))
            .ForMember(d => d.WriteoffDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.WriteOffDate)))
            .ForMember(d => d.LastPaymtType, m => m.MapFrom(src => src.LastPaymtRecvType))
            .ForMember(d => d.LastPaymtReceived, m => m.MapFrom(src => src.LastPaymtRecvAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.LastPaymtRecvAmt)) : null))
            .ForMember(d => d.LastPaymtDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.LastPaymtDate)))
            .ForMember(d => d.InvoiceBillingIndicator, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.InvBillInd)))
            .ForMember(d => d.PayAdviceBillingIndicator, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.PymtInd)))
            .ForMember(d => d.VehiclePerformanceReportInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.VehPerfRptInd)))
            .ForMember(d => d.SelectedAssessmentType, m => m.MapFrom(src => src.SecuredCreditLine))
            .ForMember(d => d.SelectedRiskCategory, m => m.MapFrom(src => src.RiskCategory))
            .ForMember(d => d.CreditLimit, m => m.MapFrom(src => src.CreditLimit.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.CreditLimit)) : null))
            .ForMember(d => d.WithholdingTaxInd, m => m.MapFrom(src => NumberExtensions.BoolConverter(src.Ewt)))
            .ForMember(d => d.SelectedAssignCollector, m => m.MapFrom(src => src.Owner))
            .ForMember(d => d._skds, m => m.ResolveUsing(model => new SKDS()
            {
                SKDSNo         = model.SKDSNo,
                SKDSLitreQuota = model.SKDSQuota.HasValue? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", model.SKDSQuota)) : "",
                EffFromDate    = NumberExtensions.DateConverter(model.SKDSFromDate),
                EffToDate      = NumberExtensions.DateConverter(model.SKDSToDate),
                SKDSRate       = model.SKDSRate.HasValue ?  NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", model.SKDSRate)) : "",
                SKDSDocXref    = model.SKDSRef
            }))
            ;

            this.CreateMap <FinancialInfoModel, FinancialInfoDTO>()
            .ForMember(d => d.TaxCategory, m => m.Ignore())
            .ForMember(d => d.CycNo, m => m.Ignore())
            .ForMember(d => d.StmtType, m => m.Ignore())
            .ForMember(d => d.StmtInd, m => m.Ignore())
            .ForMember(d => d.PaymtMethod, m => m.Ignore())
            .ForMember(d => d.BankAcctType, m => m.Ignore())
            .ForMember(d => d.BankName, m => m.Ignore())
            .ForMember(d => d.RiskCategory, m => m.Ignore())
            .ForMember(d => d.AcctNo, m => m.MapFrom(src => src.AcctNo))
            .ForMember(d => d.TaxId, m => m.MapFrom(src => src.TaxId))
            .ForMember(d => d.StopLPC, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.LatePaymtCharge)))
            .ForMember(d => d.DunCd, m => m.MapFrom(src => Convert.ToByte(src.SelectedDunningCd)))
            .ForMember(d => d.AllowanceFactor, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.CredtAllowanceFact)))
            .ForMember(d => d.AccruedInterestAmt, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.AccrdInterest)))
            .ForMember(d => d.AccruedCreditUsageAmt, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.AccrdCrdtUsg)))
            .ForMember(d => d.PromptPaymtRebate, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.PromPaymtRebate)))
            .ForMember(d => d.PromptPaymtRebateTerms, m => m.MapFrom(src => Convert.ToByte(src.PPRGracePeriod)))
            .ForMember(d => d.LitLimitPerTxn, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.LitreLimitPerTxn)))
            .ForMember(d => d.AmtLimitPerTxn, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.AmtLimitPerTxn)))
            .ForMember(d => d.PromptPaymtRebateExpiry, m => m.MapFrom(src => src.pprExpiry))
            .ForMember(d => d.CycNo, m => m.MapFrom(src => Convert.ToByte(src.SelectedCycNo)))
            .ForMember(d => d.StmtType, m => m.MapFrom(src => src.SelectedStmtType))
            .ForMember(d => d.StmtInd, m => m.MapFrom(src => src.SelectedStmtInd))
            .ForMember(d => d.StmtDate, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.StmtDate)))
            .ForMember(d => d.PaymtMethod, m => m.MapFrom(src => src.SelectedPaymtMethod))
            .ForMember(d => d.PymtTerms, m => m.MapFrom(src => src.PaymtTerm))
            .ForMember(d => d.GracePeriod, m => m.MapFrom(src => Convert.ToByte(src.GracePeriod)))
            .ForMember(d => d.DirectDebitInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.DirectDebitInd)))
            .ForMember(d => d.BankAcctType, m => m.MapFrom(src => src.SelectedBankAcctType))
            .ForMember(d => d.BankName, m => m.MapFrom(src => src.selectedBankName))
            .ForMember(d => d.BankBranchCd, m => m.MapFrom(src => src.BankBranchCD))
            .ForMember(d => d.TaxCategory, m => m.MapFrom(src => src.SelectedTaxCategory))
            .ForMember(d => d.PayeeCd, m => m.MapFrom(src => src.PayeeCd))
            .ForMember(d => d.WriteOffDate, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.WriteoffDate)))
            .ForMember(d => d.LastPaymtRecvType, m => m.MapFrom(src => src.LastPaymtType))
            .ForMember(d => d.LastPaymtRecvAmt, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.LastPaymtReceived)))
            .ForMember(d => d.LastPaymtDate, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.LastPaymtDate)))
            .ForMember(d => d.InvBillInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.InvoiceBillingIndicator)))
            .ForMember(d => d.PymtInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.PayAdviceBillingIndicator)))
            .ForMember(d => d.VehPerfRptInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.VehiclePerformanceReportInd)))
            .ForMember(d => d.SecuredCreditLine, m => m.MapFrom(src => src.SelectedAssessmentType))
            .ForMember(d => d.RiskCategory, m => m.MapFrom(src => src.SelectedRiskCategory))
            .ForMember(d => d.CreditLimit, m => m.MapFrom(src => NumberExtensions.ConvertDecimalToDb(src.CreditLimit)))
            .ForMember(d => d.Ewt, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.WithholdingTaxInd)))
            ;

            this.CreateMap <CostCentreDTO, CostCentre>()
            .ForMember(d => d.SelectedCostCentre, m => m.MapFrom(src => src.CostCentre))
            ;
            this.CreateMap <CostCentre, CostCentreDTO>()
            .ForMember(d => d.CostCentre, m => m.MapFrom(src => src.SelectedCostCentre))
            ;

            this.CreateMap <CreditLimitHistoryDTO, CreditLimitHistory>()
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.DateTimeConverter(src.CreationDate)))
            .ForMember(d => d.AcctNo, m => m.MapFrom(src => src.AccountNo))
            .ForMember(d => d.From, m => m.MapFrom(src => !string.IsNullOrEmpty(src.From) ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.From)) : ""))
            .ForMember(d => d.To, m => m.MapFrom(src => !string.IsNullOrEmpty(src.To) ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.To)) : ""))
            .ForMember(d => d.DepositType, m => m.MapFrom(src => src.DepositType))
            .ForMember(d => d.UserId, m => m.MapFrom(src => src.UserId))
            ;
            this.CreateMap <EventLoggerDTO, EventLogger>()
            .ForMember(d => d.EventType, m => m.Ignore())
            .ForMember(d => d.ReasonCd, m => m.Ignore())
            .ForMember(d => d.SelectedEventType, m => m.MapFrom(src => src.EventType))
            .ForMember(d => d.RefKey, m => m.MapFrom(src => src.ReferenceKey))
            .ForMember(d => d.SelectedReasonCode, m => m.MapFrom(src => src.ReasonCd))
            .ForMember(d => d.ReminderDatetime, m => m.MapFrom(src => NumberExtensions.DateConverter(src.Reminder)))
            .ForMember(d => d.refDoc, m => m.MapFrom(src => src.RefDocument))
            .ForMember(d => d.ClosedDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.ClosedDate)))
            .ForMember(d => d.acctNo, m => m.MapFrom(src => src.AcctNo))
            .ForMember(d => d.sysInd, m => m.MapFrom(src => src.SysInd))
            .ForMember(d => d.Description, m => m.MapFrom(src => src.Descp))
            .ForMember(d => d.SelectedEventSts, m => m.MapFrom(src => src.Status))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.CreationDate)))
            ;
            this.CreateMap <EventLogger, EventLoggerDTO>()
            .ForMember(d => d.EventType, m => m.Ignore())
            .ForMember(d => d.ReasonCd, m => m.Ignore())
            .ForMember(d => d.EventType, m => m.MapFrom(src => src.SelectedEventType))
            .ForMember(d => d.EventId, m => m.MapFrom(src => src.EventId))
            .ForMember(d => d.ReferenceKey, m => m.MapFrom(src => src.RefKey))
            .ForMember(d => d.ReasonCd, m => m.MapFrom(src => src.SelectedReasonCode))
            .ForMember(d => d.Reminder, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.ReminderDatetime)))
            .ForMember(d => d.RefDocument, m => m.MapFrom(src => src.refDoc))
            .ForMember(d => d.ClosedDate, m => m.MapFrom(src => NumberExtensions.DateConverterDB(src.ClosedDate)))
            .ForMember(d => d.AcctNo, m => m.MapFrom(src => src.acctNo))
            .ForMember(d => d.SysInd, m => m.MapFrom(src => src.sysInd))
            .ForMember(d => d.UserId, m => m.MapFrom(src => src.UserId))
            .ForMember(d => d.RefDocument, m => m.MapFrom(src => src.refDoc))
            .ForMember(d => d.Descp, m => m.MapFrom(src => src.Description))
            .ForMember(d => d.Status, m => m.MapFrom(src => src.SelectedEventSts))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.CreationDate)))
            ;
            this.CreateMap <TempCreditCtrlDTO, TempCreditCtrlModel>()
            .ForMember(d => d.AllowCreditLimit, m => m.MapFrom(src => src.CreditLimit.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.CreditLimit)) : null))
            .ForMember(d => d.ExpDateFrom, m => m.MapFrom(src => NumberExtensions.DateConverter(src.EffDateFrom)))
            .ForMember(d => d.ExpDateTo, m => m.MapFrom(src => NumberExtensions.DateConverter(src.EffDateTo)))
            ;

            this.CreateMap <UpToDateBalDTO, UpToDateBal>()
            .ForMember(d => d.AcctType, m => m.MapFrom(src => CustomMapperExtensions.MapIEnumerableToList(src.AcctType)))
            .ForMember(d => d.SelectedAccountType, m => m.MapFrom(src => src.AccountType))
            .ForMember(d => d.CreditLimit, m => m.MapFrom(src => src.CreditLimit.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.CreditLimit)) : null))
            .ForMember(d => d.OpeningBal, m => m.MapFrom(src => src.OpeningBalance.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.OpeningBalance)) : null))
            .ForMember(d => d.InstantAmt, m => m.MapFrom(src => src.InstantAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.InstantAmt)) : null))
            .ForMember(d => d.ClosingBal, m => m.MapFrom(src => src.ClosingBalance.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.ClosingBalance)) : null))
            .ForMember(d => d.TempCreditLimit, m => m.MapFrom(src => src.TempCreditLimit.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TempCreditLimit)) : null))
            .ForMember(d => d.TotalCreditLimit, m => m.MapFrom(src => src.TotalCreditLimit.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TotalCreditLimit)) : null))
            .ForMember(d => d.OnlineAmt, m => m.MapFrom(src => src.OnlineAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.OnlineAmt)) : null))
            .ForMember(d => d.AvailableCredLimit, m => m.MapFrom(src => src.AvailableCredit.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.AvailableCredit)) : null))
            .ForMember(d => d.QuotaLimit, m => m.MapFrom(src => src.QuotaLimit.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.QuotaLimit)) : null))
            .ForMember(d => d.QuotaUsage, m => m.MapFrom(src => src.QuotaUsage.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.QuotaUsage)) : null))
            .ForMember(d => d.OfflineAmt, m => m.MapFrom(src => src.OfflineAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.OfflineAmt)) : null))
            .ForMember(d => d.BatchAmt, m => m.MapFrom(src => src.BatchAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.BatchAmt)) : null))
            ;
            this.CreateMap <FinancilInfoItemDTO, FinancilInfoItemsList>()
            .ForMember(d => d.TxnCd, m => m.MapFrom(src => src.TxnCd.HasValue ? Convert.ToString(src.TxnCd) : ""))
            .ForMember(d => d.TxnAmt, m => m.MapFrom(src => src.TxnAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TxnAmt)) : null))
            ;
            this.CreateMap <ProductDiscountDTO, ProductDiscount>()
            .ForMember(d => d.ProdDiscType, m => m.Ignore())
            .ForMember(d => d.PlanId, m => m.Ignore())
            .ForMember(d => d.Id, m => m.MapFrom(src => Convert.ToString(src.Id)))
            .ForMember(d => d.SelectedProdCd, m => m.MapFrom(src => src.ProdGroup))
            .ForMember(d => d.SelectedProdDiscType, m => m.MapFrom(src => src.ProdDiscType))
            .ForMember(d => d.ProdDiscDescp, m => m.MapFrom(src => src.ProdDiscDescp))
            .ForMember(d => d.SelectedPlanId, m => m.MapFrom(src => Convert.ToString(src.PlanId)))
            .ForMember(d => d.EffDateFrom, m => m.MapFrom(src => NumberExtensions.DateConverter(src.EffDate)))
            .ForMember(d => d.CreatedBy, m => m.MapFrom(src => src.UserId))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.CreationDate)))
            .ForMember(d => d.ProdCdDescp, m => m.MapFrom(src => src.ProductDescp))
            .ForMember(d => d.EffDateTo, m => m.MapFrom(src => NumberExtensions.DateConverter(src.EffEndDate)))
            ;
            this.CreateMap <ProductDiscount, ProductDiscountDTO>()
            .ForMember(d => d.ProdDiscType, m => m.Ignore())
            .ForMember(d => d.PlanId, m => m.Ignore())
            .ForMember(d => d.Id, m => m.MapFrom(src => Convert.ToInt64(src.Id)))
            .ForMember(d => d.ProdGroup, m => m.MapFrom(src => src.SelectedProdCd))
            .ForMember(d => d.PlanId, m => m.MapFrom(src => Convert.ToInt32(src.SelectedPlanId)))
            .ForMember(d => d.ProdDiscType, m => m.MapFrom(src => src.SelectedProdDiscType))
            .ForMember(d => d.EffDate, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.EffDateFrom)))
            .ForMember(d => d.UserId, m => m.MapFrom(src => src.CreatedBy))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.CreationDate)))
            .ForMember(d => d.ProductDescp, m => m.MapFrom(src => src.ProdCdDescp))
            .ForMember(d => d.EffEndDate, m => m.MapFrom(src => NumberExtensions.ConvertDatetimeDB(src.EffDateTo)))
            .ForMember(d => d.OnlineInd, m => m.MapFrom(src => NumberExtensions.ConvertBoolDB(src.OnlineIndicator)))
            ;
            this.CreateMap <AcctBalanceSelectAmountDTO, OnlineTransaction>()
            .ForMember(d => d.TxnAmt, m => m.MapFrom(src => src.TxnAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TxnAmt)) : null))
            .ForMember(d => d.BillingAmt, m => m.MapFrom(src => src.BillingAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.BillingAmt)) : null))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.DateTimeConverter(src.CreationDate)))
            .ForMember(d => d.TxnDate, m => m.MapFrom(src => NumberExtensions.DateTimeConverter(src.TxnDate)))
            .ForMember(d => d.DueDate, m => m.MapFrom(src => NumberExtensions.DateTimeConverter(src.DueDate)))
            .ForMember(d => d.TxnId, m => m.MapFrom(src => Convert.ToString(src.TxnId)))
            .ForMember(d => d.Ids, m => m.MapFrom(src => Convert.ToString(src.Ids)))
            .ForMember(d => d.CardNo, m => m.MapFrom(src => Convert.ToString(src.CardNo)))
            ;
            this.CreateMap <PaymentTxnDTO, PaymentTxn>()
            .ForMember(d => d.PyTxnCd, m => m.Ignore())
            .ForMember(d => d.TxnType, m => m.Ignore())
            .ForMember(d => d.Affiliate, m => m.Ignore())
            .ForMember(d => d.Sts, m => m.Ignore())
            .ForMember(d => d.AppvCd, m => m.Ignore())
            .ForMember(d => d.SelectedTxnType, m => m.MapFrom(src => src.TxnType))
            .ForMember(d => d.AcctNo, m => m.MapFrom(src => src.AccountNo))
            .ForMember(d => d.CheqNo, m => m.MapFrom(src => src.ChequeNo))
            .ForMember(d => d.selectedOwner, m => m.MapFrom(src => src.Owner))
            .ForMember(d => d.TxnDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.TxnDate)))
            .ForMember(d => d.TotAmnt, m => m.MapFrom(src => src.TxnAmount.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TxnAmount)) : null))
            .ForMember(d => d.displayTotAmnt, m => m.MapFrom(src => src.TxnAmount.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TxnAmount)) : null))
            .ForMember(d => d.BillingTxnAmt, m => m.MapFrom(src => src.BillingAmount.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.BillingAmount)) : null))
            .ForMember(d => d.Descp, m => m.MapFrom(src => src.TxnDescription))
            .ForMember(d => d.StsDescp, m => m.MapFrom(src => src.Status))
            .ForMember(d => d.DueDt, m => m.MapFrom(src => NumberExtensions.DateConverter(src.DueDate)))
            .ForMember(d => d.BookingDt, m => m.MapFrom(src => NumberExtensions.DateConverter(src.BookingDate)))
            .ForMember(d => d.Totpts, m => m.MapFrom(src => src.Pts.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.Pts)) : null))
            .ForMember(d => d.SelectedSts, m => m.MapFrom(src => src.Sts))
            .ForMember(d => d.SelectedTxnCd, m => m.MapFrom(src => Convert.ToString(src.TxnCd)))
            .ForMember(d => d.SelectedAppvCd, m => m.MapFrom(src => src.AppvCd))
            .ForMember(d => d.PyTxnId, m => m.MapFrom(src => src.TxnId))
            .ForMember(d => d.WithHeldUnsettleId, m => m.MapFrom(src => src.WUId.HasValue? src.WUId : 0))
            .ForMember(d => d.CreationDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.CreationDate)))
            .ForMember(d => d.AppRemarks, m => m.MapFrom(src => src.AppvRemarks))
            ;
            this.CreateMap <BillingItemDTO, BillingItem>()
            .ForMember(d => d.TxnCategory, m => m.Ignore())
            .ForMember(d => d.Sts, m => m.Ignore())
            .ForMember(d => d.Level, m => m.MapFrom(src => src.Level))
            .ForMember(d => d.TxnId, m => m.MapFrom(src => src.TxnId))
            .ForMember(d => d.ClosedDate, m => m.MapFrom(src => src.CloseAt))
            .ForMember(d => d.Descp, m => m.MapFrom(src => src.Descp))
            .ForMember(d => d.TxnDate, m => m.MapFrom(src => NumberExtensions.DateConverter(src.TxnDate)))
            .ForMember(d => d.DisplayBillingTxnAmt, m => m.MapFrom(src => src.BillingAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.BillingAmt)) : null))
            .ForMember(d => d.SettledAmt, m => m.MapFrom(src => src.SettledAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.SettledAmt)) : null))
            .ForMember(d => d.DisplaySettledAmt, m => m.MapFrom(src => src.SettledAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.SettledAmt)) : null))
            .ForMember(d => d.SettledDate, m => m.MapFrom(src => src.SettledDate))
            .ForMember(d => d.TxnCd, m => m.MapFrom(src => src.TxnCd))
            .ForMember(d => d.RefId, m => m.MapFrom(src => src.RefId))
            .ForMember(d => d.SelectedSts, m => m.MapFrom(src => src.Sts))
            .ForMember(d => d.TarBalance, m => m.MapFrom(src => src.TARBalance.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TARBalance)) : null))
            .ForMember(d => d.TotalTxnAmount, m => m.MapFrom(src => src.TotalBillingTxnAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TotalBillingTxnAmt)) : null))
            .ForMember(d => d.TotalSettledAmt, m => m.MapFrom(src => src.TotalSettledAmt.HasValue ? NumberExtensions.CustomNumberFormat(String.Format("{0:0.00}", src.TotalSettledAmt)) : null))
            .ForMember(d => d._CreationDatenUserId, m => m.ResolveUsing(model => new CreationDatenUserId()
            {
                UserId = model.UserId, CreationDate = CardTrend.Common.Extensions.NumberExtensions.DateConverter(model.CreationDate)
            }))
            ;
        }