Example #1
0
 protected void btnSubmit_Click(object sender, EventArgs e)
 {
     if (!Page.IsValid)
         return;
     var dt1 = DateTime.Parse(FromDate.Text); // todo: tryparse here
     var dt2 = DateTime.Parse(ToDate.Text);
     Response.Clear();
     Response.Buffer = true;
     Response.ContentType = "text/plain";
     Response.AddHeader("Content-Disposition", "attachment;filename=GLTRN2000.txt");
     var ctl = new BundleModel();
     var q = ctl.GetGLExtract(dt1, dt2);
     var GLBundlePrefix = DbUtil.Db.Setting("GLBundlePrefix", "CM");
     foreach (var i in q)
     {
         Response.Write(
             "\"00000\",\"001{0}{1:00}{2}{3}\",\"000\",\"{4:MMddyy}\",\"{5}\",\"\",\"{6}0000{7}\",\"{8:00000000000}\",\"\"\r\n"
             .Fmt(i.Fund, i.Month, GLBundlePrefix, i.HeaderId.PadLeft(5, '0'), i.ContributionDate, i.FundName, i.FundDept, i.FundAcct, i.Amount * 100));
     }
     Response.Flush();
     Response.Close();
 }