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 string BuildDocFileName(string ext, int id = -1)
{
int nextKey = 0;
if (id < 0)
{
clsDataGetter dg = new clsDataGetter(db.Database.Connection.ConnectionString);
nextKey = dg.GetScalarInteger("SELECT MAX(pKey) FROM Documents WHERE DistKey=" + GlobalVariables.DistNumber);
nextKey += 1;
}
else
{
nextKey = id;
}
return "document_" + GlobalVariables.DistNumber + "_" + nextKey.ToString() + ext;
}
private static string LookupEmail(string type,bool isDistrict)
{
Dist23Data db = new Dist23Data();
clsDataGetter dg = new clsDataGetter(db.Database.Connection.ConnectionString);
string sql = "SELECT email FROM contacts c ";
sql += "INNER JOIN ContactPosition cp ON cp.contactID = c.pKey ";
sql += "INNER JOIN positions p ON p.pKey = cp.PositionID ";
sql += "INNER JOIN groups g ON g.pKey = cp.GroupID ";
sql += "WHERE positionName = '" + type + "' ";
sql += "AND g.DistKey = " + GlobalVariables.DistKey;
if (isDistrict)
sql += " AND g.isDistrict = 1";
string email = dg.GetScalarString(sql);
return email;
}
