public static void MakeMeetingPDF()
{
dg = new clsDataGetter("Data Source = 184.168.194.75; Initial Catalog = aaphones2; Persist Security Info = True; User ID = billwilson12; Password = keepitsimple62");
SqlDataReader dr = dg.GetDataReader("EXEC sp_GetMeetingsPrint");
MakePDFForm(@"D:\My Documents\Projects\dist23mvc\Dist23MVC\Dist23MVC\upload\district_23_template.pdf", @"D:\My Documents\Projects\dist23mvc\Dist23MVC\Dist23MVC\upload\district_23101.pdf", dr);
dg.KillReader(dr);
dr = dg.GetDataReader("EXEC sp_GetMeetingsPrint");
FillPDFForm(@"D:\My Documents\Projects\dist23mvc\Dist23MVC\Dist23MVC\upload\district_23101.pdf", @"D:\My Documents\Projects\dist23mvc\Dist23MVC\Dist23MVC\upload\district_23curr.pdf", dr);
dg.KillReader(dr);
}
private void LoadAccessLevels()
{
string sql = "SELECT * FROM AccessLevels";
using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr))
{
System.Data.SqlClient.SqlDataReader dr = dg.GetDataReader(sql);
while (dr.Read())
{
string alStr = dr["accessLevelID"].ToString() + " - " + dr["accDesc"].ToString();
lbAccessLevels.Items.Add(alStr);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dr = dg.GetDataReader("SELECT TOP(1) * FROM SiteConfig WHERE DistKey=" + Session["DistKey"].ToString());
if (dr.Read())
{
tbBannerTitle.Text = dr["BannerTitle"].ToString();
tbBannerSubTitle.Text = dr["BannerSubTitle"].ToString();
tbHotlinePh.Text = dr["HotlinePh"].ToString();
tbAltHotline.Text = dr["AltHotline"].ToString();
tbAltHotlineMsg.Text = dr["AltHotlineMsg"].ToString();
}
}
}