Пример #1
0
        public DataTable GetRequestDataForExport(string requestType, int cardType, string branchCode)
        {
            List<SqlParameter> parameters = new List<SqlParameter>();
            parameters.Add(new SqlParameter("@RequestType", requestType));
            parameters.Add(new SqlParameter("@CardTypeId", cardType));
            parameters.Add(new SqlParameter("@BranchCode", branchCode));

            var data = DatabaseGateway.GetDataUsingStoredProcedure("sp_ExportData", parameters);
            return data;
        }
Пример #2
0
        public static List <RequestVM> GetLinkedAccounts(string CardNo, string AccountNo)
        {
            List <RequestVM> result = new List <RequestVM>();

            try
            {
                List <SqlParameter> parameters = new List <SqlParameter>();
                parameters.Add(new SqlParameter("@CardNo", CardNo));
                parameters.Add(new SqlParameter("@AccountNo", AccountNo));

                var data = DatabaseGateway.GetDataUsingStoredProcedure("sp_LinkedAccounts", parameters);
                result = data.Rows.Count > 0 ? DAL.ReflectionHelper.CreateGenericListFromDataTable <RequestVM>(data) : null;
                return(result);
            }
            catch (Exception ec)
            {
                throw ec;
            }
        }
Пример #3
0
        public List <tbl_Card_Charges> GetCardCharges(string AccountCode, int CardTypeID, string RegionCode, string Frequency, string IsReplacement)
        {
            List <tbl_Card_Charges> data  = new List <tbl_Card_Charges>();
            List <SqlParameter>     param = new List <SqlParameter>();

            param.Add(new SqlParameter("@AccountCode", AccountCode));
            param.Add(new SqlParameter("@CardTypeID", CardTypeID));
            param.Add(new SqlParameter("@RegionCode", RegionCode));
            param.Add(new SqlParameter("@Frequency", Frequency));
            param.Add(new SqlParameter("@IsReplacement", IsReplacement));
            try
            {
                DataTable dt = DatabaseGateway.GetDataUsingStoredProcedure("sp_GetCardCharges", param);
                return(ReflectionHelper.CreateGenericListFromDataTable <tbl_Card_Charges>(dt));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }