public void TaxReport(int memberID)
{
string FileName = string.Format("{0}","ContributionTaxFile.pdf");
// var path = Path.Combine(Server.MapPath("~/public_html/ClientFiles"), FileName);
var path = Path.Combine(Server.MapPath("~/App_Data/ClientFiles"), FileName);
bool exist = System.IO.File.Exists(string.Format("{0}", path));
if (exist)
{
System.IO.File.Delete(string.Format("{0}", path));
//System.IO.File.Delete(@"C:\test.txt");
}
member member = MemberRepository.GetMemberByID(memberID);
Document doc = new Document(iTextSharp.text.PageSize.LETTER, 10, 10, 42, 35);
PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream(path, FileMode.Create));
doc.Open();
//image
picture icon = PictureRepository.GetLetterHeadImage();
if (icon != null)
{
iTextSharp.text.Image image = iTextSharp.text.Image.GetInstance(icon.ImageData);
//image.ScalePercent(50f);
//image.SetAbsolutePosition(doc.PageSize.Width - 36f - 72f, doc.PageSize.Height - 36f - 216.6f);
image.ScaleToFit(250f, 250f);
// image.Border = iTextSharp.text.Rectangle.BOX;
// image.BorderColor = iTextSharp.text.BaseColor.GREEN;
// image.BorderWidth = 5f;
doc.Add(image);
}
//get contribution data
//ministry ministry =
string ChurchName = ConstantRepository.GetConstantByName("Church Name").Value1;
string ChurchAddress = ConstantRepository.GetConstantByName("Church Address").Value1;
string ChurchPhone = ConstantRepository.GetConstantByName("Church Phone").Value1;
constant signature1 = ConstantRepository.GetConstantByName("TaxSignature1");
constant signature2 = ConstantRepository.GetConstantByName("TaxSignature2");
Paragraph data;
data = new Paragraph(string.Format("{0}\n", ChurchName));
doc.Add(data);
data = new Paragraph(string.Format("{0}\n", ChurchAddress));
doc.Add(data);
data = new Paragraph(string.Format("{0}\n", ChurchPhone));
doc.Add(data);
data = new Paragraph(Environment.NewLine);
doc.Add(data);
data = new Paragraph("Member Contribution Tax Statement");
doc.Add(data);
data = new Paragraph(Environment.NewLine);
doc.Add(data);
string memberTitle = SpouseRepository.JointTitheTitle(memberID);
data = new Paragraph(string.Format("For: {0}", memberTitle));
doc.Add(data);
data = new Paragraph(Environment.NewLine);
doc.Add(data);
int ContributionYear = DateTime.Today.Year;
DateTime BeginDate = Convert.ToDateTime("1/1/" + ContributionYear.ToString());
DateTime EndDate = Convert.ToDateTime("12/31/" + ContributionYear.ToString());
int thiteID = ConstantRepository.GetConstantByName("Tithes").constantID;
int offeringID = ConstantRepository.GetConstantByName("Offering").constantID;
decimal TithesTotal = ContributionRepository.GetContributionByMemberCategoryRange(memberID, thiteID, BeginDate, EndDate).Sum(e => e.Amount);
decimal OfferingTotal = ContributionRepository.GetContributionByMemberCategoryRange(memberID, offeringID, BeginDate, EndDate).Sum(e => e.Amount);
decimal Totalcontribution = ContributionRepository.GetContributionByMemberDateRange(memberID,BeginDate, EndDate).Sum(e => e.Amount);
decimal OthersTotal = Totalcontribution - TithesTotal - OfferingTotal;
data = new Paragraph(string.Format("Tithes: {0:c}", TithesTotal));
doc.Add(data);
data = new Paragraph(string.Format("Offerings: {0:c}", OfferingTotal));
doc.Add(data);
data = new Paragraph(string.Format("Others: {0:c}", OthersTotal));
doc.Add(data);
data = new Paragraph(string.Format("-----------------------------------"));
doc.Add(data);
data = new Paragraph(string.Format("Total: {0:c}", Totalcontribution));
doc.Add(data);
data = new Paragraph(Environment.NewLine);
doc.Add(data);
data = new Paragraph(string.Format("-----------------------------------"));
doc.Add(data);
if (signature1.Value1 != "")
{
data = new Paragraph(string.Format("Signed: {0} ({1})", signature1.Value2, signature1.Value1));
doc.Add(data);
}
data = new Paragraph(Environment.NewLine);
doc.Add(data);
if (signature2.Value1 != "")
{
data = new Paragraph(string.Format("-----------------------------------"));
doc.Add(data);
data = new Paragraph(string.Format("Signed: {0} ({1})", signature2.Value2, signature2.Value1));
doc.Add(data);
}
doc.Close();
//document doc = DocumentRepository.GetDocumentByID(DocumentID);
//string path = AppDomain.CurrentDomain.BaseDirectory + "App_Data/ClientFiles/";
path = AppDomain.CurrentDomain.BaseDirectory + "App_Data/ClientFiles/";
// path = AppDomain.CurrentDomain.BaseDirectory + "public_html/ClientFiles/";
Response.ContentType = "application/pdf";
Response.AddHeader("Content-Disposition", @"filename=""IT Report.xls""");
Response.TransmitFile(@path + FileName);
//Response.TransmitFile(FileName);
}
public void TaxReport2(int memberID, int Year)
{
try
{
string FileName = string.Format("{0}", "ContributionTaxFile.pdf");
// var path = Path.Combine(Server.MapPath("~/public_html/ClientFiles"), FileName);
var path = Path.Combine(Server.MapPath("~/App_Data/ClientFiles"), FileName);
bool exist = System.IO.File.Exists(string.Format("{0}", path));
if (exist)
{
System.IO.File.Delete(string.Format("{0}", path));
//System.IO.File.Delete(@"C:\test.txt");
}
member member = MemberRepository.GetMemberByID(memberID);
Document doc = new Document(iTextSharp.text.PageSize.LETTER, 70, 40, 42, 35);
PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream(path, FileMode.Create));
doc.Open();
//image
//picture icon = PictureRepository.GetLetterHeadImage();
//if ((icon != null) || (DisplayLog0 == "Yes"))
//{
// iTextSharp.text.Image image = iTextSharp.text.Image.GetInstance(icon.ImageData);
// image.ScaleToFit(250f, 250f);
// doc.Add(image);
//}
//get contribution data
//ministry ministry =
string ChurchName = ConstantRepository.GetConstantByName("Church Name").Value1;
string ChurchAddress = ConstantRepository.GetConstantByName("Church Address").Value1;
string ChurchPhone = ConstantRepository.GetConstantByName("Church Phone").Value1;
string DisplayLog0 = ConstantRepository.GetConstantByName("Tax ChurchPicture").Value1;
string DisplayChurchHeading = ConstantRepository.GetConstantByName("Tax ChurchAddress").Value1;
constant signature1 = ConstantRepository.GetConstantByName("TaxSignature1");
constant signature2 = ConstantRepository.GetConstantByName("TaxSignature2");
Font fdefault = FontFactory.GetFont("Arial", 18, Font.NORMAL, BaseColor.BLACK);
Paragraph data;
//Add space
string text = @"
";
data = new Paragraph(string.Format("{0}", text));
doc.Add(data);
if (DisplayChurchHeading == "Yes")
{
data = new Paragraph(string.Format("{0}\n", ChurchName), fdefault);
doc.Add(data);
fdefault = FontFactory.GetFont("Arial", 12, Font.NORMAL, BaseColor.BLACK);
data = new Paragraph(string.Format("{0}\n", ChurchAddress), fdefault);
doc.Add(data);
data = new Paragraph(string.Format("{0}\n", ChurchPhone), fdefault);
doc.Add(data);
data = new Paragraph(Environment.NewLine);
data.SpacingAfter = 15;
doc.Add(data);
}
else
{
data = new Paragraph();
data.SpacingAfter = 25;
doc.Add(data);
}
fdefault = FontFactory.GetFont("Arial", 18, Font.BOLD, BaseColor.BLACK);
data = new Paragraph(Year.ToString() + " Member Contribution Tax Statement", fdefault);
data.SpacingBefore = 35;
doc.Add(data);
data = new Paragraph(Environment.NewLine);
data.SpacingAfter = 15;
doc.Add(data);
string memberTitle = SpouseRepository.JointTitheTitle(memberID);
data = new Paragraph(string.Format("Dear {0},", memberTitle));
data.SpacingAfter = 3;
doc.Add(data);
text = @"Thanks for your financial support to the " + ChurchName + ". The Pastor and leaders of the church truly appreciate your contributions and pray the Lord bless you and keep You. Amen.";
fdefault = FontFactory.GetFont("Arial", 14, Font.NORMAL, BaseColor.BLACK);
data = new Paragraph(string.Format("{0}", text, fdefault));
data.SpacingAfter = 25;
doc.Add(data);
data = new Paragraph(Environment.NewLine);
doc.Add(data);
int ContributionYear = Year; // DateTime.Today.Year;
DateTime BeginDate = Convert.ToDateTime("1/1/" + ContributionYear.ToString());
DateTime EndDate = Convert.ToDateTime("12/31/" + ContributionYear.ToString());
int thiteID = ConstantRepository.GetConstantByName("Tithes").constantID;
int offeringID = ConstantRepository.GetConstantByName("Offering").constantID;
decimal TithesTotal = ContributionRepository.GetContributionByMemberCategoryRange(memberID, thiteID, BeginDate, EndDate).Sum(e => e.Amount);
decimal OfferingTotal = ContributionRepository.GetContributionByMemberCategoryRange(memberID, offeringID, BeginDate, EndDate).Sum(e => e.Amount);
decimal Totalcontribution = ContributionRepository.GetContributionByMemberDateRange(memberID, BeginDate, EndDate).Sum(e => e.Amount);
decimal OthersTotal = Totalcontribution - TithesTotal - OfferingTotal;
Font fdefault2 = FontFactory.GetFont("Arial", 18, Font.BOLD, BaseColor.BLACK);
data = new Paragraph(string.Format("Tithes: {0:c}", TithesTotal, fdefault2));
doc.Add(data);
data = new Paragraph(string.Format("Offerings: {0:c}", OfferingTotal, fdefault2));
doc.Add(data);
data = new Paragraph(string.Format("Others: {0:c}", OthersTotal, fdefault2));
doc.Add(data);
data = new Paragraph(string.Format("--------------------------------------------"));
doc.Add(data);
data = new Paragraph(string.Format("Total: {0:c}", Totalcontribution, fdefault2));
doc.Add(data);
data = new Paragraph(Environment.NewLine);
doc.Add(data);
//Add space
text = @"
";
data = new Paragraph(string.Format("{0}", text));
doc.Add(data);
data.SpacingBefore = 25;
data = new Paragraph(string.Format("--------------------------------------------"));
doc.Add(data);
if (signature1.Value1 != "")
{
fdefault = FontFactory.GetFont("Arial", 10, Font.ITALIC, BaseColor.RED);
data = new Paragraph(string.Format("Signed: {0} ({1})", signature1.Value2, signature1.Value1, fdefault2));
doc.Add(data);
}
data.SpacingBefore = 5;
data = new Paragraph(Environment.NewLine);
doc.Add(data);
//Add space
text = @"
";
data = new Paragraph(string.Format("{0}", text));
doc.Add(data);
if (signature2.Value1 != "")
{
fdefault = FontFactory.GetFont("Arial", 10, Font.ITALIC, BaseColor.RED);
data = new Paragraph(string.Format("--------------------------------------------"));
doc.Add(data);
data = new Paragraph(string.Format("Signed: {0} ({1})", signature2.Value2, signature2.Value1, fdefault2));
doc.Add(data);
}
doc.Close();
//document doc = DocumentRepository.GetDocumentByID(DocumentID);
//string path = AppDomain.CurrentDomain.BaseDirectory + "App_Data/ClientFiles/";
path = AppDomain.CurrentDomain.BaseDirectory + "App_Data/ClientFiles/";
// path = AppDomain.CurrentDomain.BaseDirectory + "public_html/ClientFiles/";
Response.ContentType = "application/pdf";
Response.AddHeader("Content-Disposition", @"filename=""IT Report.xls""");
Response.TransmitFile(@path + FileName);
//Response.TransmitFile(FileName);
}
catch (Exception ex)
{
TempData["Message2"] = string.Format("Error printing tax report.");
}
}