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; }