本文整理汇总了C#中DBFunctions.addadmssion方法的典型用法代码示例。如果您正苦于以下问题:C# DBFunctions.addadmssion方法的具体用法?C# DBFunctions.addadmssion怎么用?C# DBFunctions.addadmssion使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DBFunctions
的用法示例。
在下文中一共展示了DBFunctions.addadmssion方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Printmeritlist_Click
protected void Printmeritlist_Click(object sender, EventArgs e)
{
string html = System.IO.File.ReadAllText(Server.MapPath("MeritList.html"));
DBFunctions db = new DBFunctions();
string candidtes = "";
var applicants = db.generatemeritlist(int.Parse(Dropdownprogramme.SelectedValue));
CollegeERPDBEntities db1 = new CollegeERPDBEntities();
var result1 = db1.Candidate_tbl.Join(db1.Batches_table,
c => c.ID,
a => a.ID,
(c, a) => new { a.ID }).ToList();
foreach (var app in applicants)
{
//<tr class="blue-background"><th>Name</th><th>Address</th><th>Cut Off Points</th><th>Programme</th><th>Gender</th><th>Email</th><th>Phone</th><th>Status</th><th>Action</th></tr>
int Year = Convert.ToInt16(app.AdmissionYear);
candidtes += "<tr><td>" + app.Name + "</td><td>" + app.CuttoffPoints + "</td><td>" + app.Gender + "</td><td>" + app.Email + "</td><td>" + app.Phone + "</td></tr>";
}
db.addadmssion(applicants);
Byte[] bytes;
html = html.Replace("{Programme}", applicants.FirstOrDefault().Program_tbl.ProgramName);
html = html.Replace("{year}", DateTime.Now.Year.ToString());
html= html.Replace("{CandidateList}", candidtes);
using (var ms = new MemoryStream())
{
var doc = new Document();
doc = new Document(PageSize.A4, 30, 30, 30, 30);
var writer = PdfWriter.GetInstance(doc, ms);
doc.Open();
doc.NewPage();
var example_html = html;
using (var htmlWorker = new iTextSharp.text.html.simpleparser.HTMLWorker(doc))
{
using (var sr = new StringReader(example_html))
{
htmlWorker.Parse(sr);
}
}
doc.Close();
bytes = ms.ToArray();
}
long milliseconds = (DateTime.Now.Ticks / TimeSpan.TicksPerMillisecond) / 1000;
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ContentType = "application/pdf";
HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + milliseconds +"MeritList.pdf");
HttpContext.Current.Response.Buffer = true;
HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
HttpContext.Current.Response.BinaryWrite(bytes);
HttpContext.Current.Response.End();
HttpContext.Current.Response.Close();
}