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