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