Export Data to QIF Format using Asp.net

we required QifApi.dll for exporting to QIF format , the below code is exporting to basic transaction format

Download  Dll

protected void btnQIF_Click(object sender, EventArgs e)
{
Response.ContentType = “application/qif”;
Response.AddHeader(“content-disposition”, “attachment;filename=PurchaseOrderDetails.qif”);
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);

GridView gridview1 = new GridView();
gridview1.AllowPaging = false;

//This GetOrders method returns all records from Database which Contain Various Columns
DataSet ds = objOrderRegistratonController.GetOrders();
DataView view = new DataView(ds.Tables[0]);

//In this datatable we fetch only required columns from dataview
DataTable table = view.ToTable(true, “BCEmailAddress”, “BCFirstName”, “BCLastName”, “PurchaseOrderNo”, “BCSchoolDistrict”);

//This create directory of name “QIF” if it is not present
if (!Directory.Exists(Server.MapPath(DNNCompatibilityBridge.ModuleBasePath(this)) + “QIF”))
Directory.CreateDirectory(Server.MapPath(DNNCompatibilityBridge.ModuleBasePath(this)) + “QIF”);

HttpContext context = HttpContext.Current;
string tempOutputFile = Server.MapPath(“/DesktopModules/MPPR-mpprcms_OrderRegistraton/QIF/” + Guid.NewGuid().ToString() + “.qif”);
//context.Server.MapPath(“.”) + @”\output\” + Guid.NewGuid().ToString() + “.qif”;
// this.TemplateSourceDirectory + “/QIF/” + Guid.NewGuid().ToString() + “.qif”;

QifDom qd = new QifDom();

context.Response.Clear();

for (int i = 0; i < table.Rows.Count; i++)
{
BasicTransaction bt = new BasicTransaction();

foreach (DataColumn column in table.Columns)
{
if (column.ColumnName == “BCEmailAddress”)
{
bt.Category = (table.Rows[i][“BCEmailAddress”].ToString());
}

if (column.ColumnName == “BCFirstName”)
{
bt.Payee = (table.Rows[i][“BCFirstName”].ToString());
}
bt.Date = System.DateTime.Now;

if (column.ColumnName == “BCLastName”)
{
bt.ClearedStatus = table.Rows[i][“BCLastName”].ToString();
}

if (column.ColumnName == “PurchaseOrderNo”)
{
bt.Number = (table.Rows[i][“PurchaseOrderNo”].ToString());
}

if (column.ColumnName == “BCSchoolDistrict”)
{
bt.Memo = table.Rows[i][“BCSchoolDistrict”].ToString();
}

}

qd.BankTransactions.Add(bt);
}

qd.Export(tempOutputFile);

Response.WriteFile(tempOutputFile);
// File.Delete(tempOutputFile);
Response.End();

}