public static bool GetDelStatus(int ProfileId)
{
TDayDataSet tDayDataSet = new TDayDataSet();
TDayDataSetTableAdapters.ProfilesTableAdapter ProfilesTableAdapter = new TDayDataSetTableAdapters.ProfilesTableAdapter();
ProfilesTableAdapter.FillAll(tDayDataSet.Profiles);
DataRow Row = tDayDataSet.Profiles.FindByProfileId(ProfileId);
return (bool)Row["DelStatus"];
}
public static string GetName(int ProfileId)
{
TDayDataSet tDayDataSet = new TDayDataSet();
TDayDataSetTableAdapters.ProfilesTableAdapter ProfilesTableAdapter = new TDayDataSetTableAdapters.ProfilesTableAdapter();
ProfilesTableAdapter.FillAll(tDayDataSet.Profiles);
DataRow Row = tDayDataSet.Profiles.FindByProfileId(ProfileId);
return Row["Name"].ToString();
}
public static int GetCategory(int ProfileId)
{
TDayDataSet tDayDataSet = new TDayDataSet();
TDayDataSetTableAdapters.ProfilesTableAdapter ProfilesTableAdapter = new TDayDataSetTableAdapters.ProfilesTableAdapter();
ProfilesTableAdapter.FillAll(tDayDataSet.Profiles);
DataRow Row = tDayDataSet.Profiles.FindByProfileId(ProfileId);
return (int)Row["Category"];
}
public static void PrintTransportation(string Day)
{
TDayDataSet tDayDataSet = new TDayDataSet();
TDayDataSetTableAdapters.TransportationTableAdapter transportationTableAdapter = new TDayDataSetTableAdapters.TransportationTableAdapter();
TDayDataSetTableAdapters.ProfilesTableAdapter profilesTableAdapter = new TDayDataSetTableAdapters.ProfilesTableAdapter();
try
{
if (File.Exists(System.Windows.Forms.Application.UserAppDataPath + @"\Transportation.pdf")) { File.Delete(System.Windows.Forms.Application.UserAppDataPath + @"\Transportation.pdf"); }
}
catch (IOException)
{
string Proc = GetFileProcessName("Transportation.pdf");
if (File.Exists(System.Windows.Forms.Application.UserAppDataPath + @"\Transportation.pdf")) { File.Delete(System.Windows.Forms.Application.UserAppDataPath + @"\Transportation.pdf"); }
}
FileStream FS = new FileStream(System.Windows.Forms.Application.UserAppDataPath + @"\Transportation.pdf", FileMode.CreateNew);
var Doc = new iTextSharp.text.Document(PageSize.A4.Rotate(), 20, 20, 20, 20);
PdfWriter.GetInstance(Doc, FS);
Doc.Open();
PdfPTable table;
if (Day == "Master")
{
table = new PdfPTable(20);
table.HorizontalAlignment = Element.ALIGN_LEFT;
table.WidthPercentage = 100;
AddHeader(table, "Transportation", 20, new BaseColor(Color.DimGray), new BaseColor(Color.WhiteSmoke));
AddHeader(table, Day, 16, new BaseColor(Color.DimGray), new BaseColor(Color.White));
transportationTableAdapter.Fill(tDayDataSet.Transportation);
AddPriviewCell(table, "Numb", 1);
AddPriviewCell(table, "Name", 4);
AddPriviewCell(table, "Category", 2);
AddPriviewCell(table, "Address", 4);
AddPriviewCell(table, "Phone", 2);
AddPriviewCell(table, "HD#", 2);
AddPriviewCell(table, "Mon", 1);
AddPriviewCell(table, "Tue", 1);
AddPriviewCell(table, "Wed", 1);
AddPriviewCell(table, "Thu", 1);
AddPriviewCell(table, "Fri", 1);
//AddPriviewCell(table, "Comment", 1);
}
else
{
table = new PdfPTable(15);
table.HorizontalAlignment = Element.ALIGN_LEFT;
table.WidthPercentage = 100;
AddHeader(table, "Transportation", 20, new BaseColor(Color.DimGray), new BaseColor(Color.WhiteSmoke));
AddHeader(table, Day, 16, new BaseColor(Color.DimGray), new BaseColor(Color.White));
transportationTableAdapter.Fill(tDayDataSet.Transportation);
AddPriviewCell(table, "Numb", 1);
AddPriviewCell(table, "Name", 4);
AddPriviewCell(table, "Category", 2);
AddPriviewCell(table, "Address", 4);
AddPriviewCell(table, "Phone", 2);
AddPriviewCell(table, "HD#", 2);
}
int Counter = 1;
foreach (DataRow Row in tDayDataSet.Transportation)
{
switch (Day)
{
case "Master":
AddPriviewCell(table, Counter.ToString(), 1);
AddPriviewCell(table, ProfileProvider.GetName((int)Row["ProfileId"]), 4);
AddPriviewCell(table, Row["Category"].ToString(), 2);
AddPriviewCell(table, Row["Adress"].ToString(), 4);
AddPriviewCell(table, Row["Phone"].ToString(), 2);
AddPriviewCell(table, Row["HandyDARTNumber"].ToString(), 2);
AddValueCell(table, (bool)Row["Monday"], true, 1);
AddValueCell(table, (bool)Row["Tuesday"], true, 1);
AddValueCell(table, (bool)Row["Wednesday"], true, 1);
AddValueCell(table, (bool)Row["Thursday"], true, 1);
AddValueCell(table, (bool)Row["Friday"], true, 1);
//AddPriviewCell(table, Row["Comments"].ToString(), 1);
Counter++;
break;
case "Monday":
if ((bool)Row["Monday"])
{
AddPriviewCell(table, Counter.ToString(), 1);
AddPriviewCell(table, ProfileProvider.GetName((int)Row["ProfileId"]), 4);
AddPriviewCell(table, Row["Category"].ToString(), 2);
AddPriviewCell(table, Row["Adress"].ToString(), 4);
AddPriviewCell(table, Row["Phone"].ToString(), 2);
AddPriviewCell(table, Row["HandyDARTNumber"].ToString(), 2);
Counter++;
}
break;
case "Tuesday":
if ((bool)Row["Tuesday"])
{
AddPriviewCell(table, Counter.ToString(), 1);
AddPriviewCell(table, ProfileProvider.GetName((int)Row["ProfileId"]), 4);
AddPriviewCell(table, Row["Category"].ToString(), 2);
AddPriviewCell(table, Row["Adress"].ToString(), 4);
AddPriviewCell(table, Row["Phone"].ToString(), 2);
AddPriviewCell(table, Row["HandyDARTNumber"].ToString(), 2);
Counter++;
}
break;
case "Wednesday":
if ((bool)Row["Wednesday"])
{
AddPriviewCell(table, Counter.ToString(), 1);
AddPriviewCell(table, ProfileProvider.GetName((int)Row["ProfileId"]), 4);
AddPriviewCell(table, Row["Category"].ToString(), 2);
AddPriviewCell(table, Row["Adress"].ToString(), 4);
AddPriviewCell(table, Row["Phone"].ToString(), 2);
AddPriviewCell(table, Row["HandyDARTNumber"].ToString(), 2);
Counter++;
}
break;
case "Thursday":
if ((bool)Row["Thursday"])
{
AddPriviewCell(table, Counter.ToString(), 1);
AddPriviewCell(table, ProfileProvider.GetName((int)Row["ProfileId"]), 4);
AddPriviewCell(table, Row["Category"].ToString(), 2);
AddPriviewCell(table, Row["Adress"].ToString(), 4);
AddPriviewCell(table, Row["Phone"].ToString(), 2);
AddPriviewCell(table, Row["HandyDARTNumber"].ToString(), 2);
Counter++;
}
break;
case "Friday":
if ((bool)Row["Friday"])
{
AddPriviewCell(table, Counter.ToString(), 1);
AddPriviewCell(table, ProfileProvider.GetName((int)Row["ProfileId"]), 4);
AddPriviewCell(table, Row["Category"].ToString(), 2);
AddPriviewCell(table, Row["Adress"].ToString(), 4);
AddPriviewCell(table, Row["Phone"].ToString(), 2);
AddPriviewCell(table, Row["HandyDARTNumber"].ToString(), 2);
Counter++;
}
break;
}
}
Doc.Add(table);
Doc.Close();
Process.Start(System.Windows.Forms.Application.UserAppDataPath + @"\Transportation.pdf");
}
public static void PrintAttendance(Day _CurrentDay)
{
TDayDataSet tDayDataSet = new TDayDataSet();
TDayDataSetTableAdapters.DaysTableAdapter daysTableAdapter = new TDayDataSetTableAdapters.DaysTableAdapter();
TDayDataSetTableAdapters.ProfilesTableAdapter profilesTableAdapter = new TDayDataSetTableAdapters.ProfilesTableAdapter();
try
{
if (File.Exists(System.Windows.Forms.Application.UserAppDataPath + @"\Attendance_" + _CurrentDay.Date.Day.ToString() + ".pdf")) { File.Delete(System.Windows.Forms.Application.UserAppDataPath + @"\Attendance_" + _CurrentDay.Date.Day.ToString() + ".pdf"); }
}
catch (IOException)
{
string Proc = GetFileProcessName("Attendance_" + _CurrentDay.Date.Day.ToString() + ".pdf");
if (File.Exists(System.Windows.Forms.Application.UserAppDataPath + @"\Attendance_" + _CurrentDay.Date.Day.ToString() + ".pdf")) { File.Delete(System.Windows.Forms.Application.UserAppDataPath + @"\Attendance_" + _CurrentDay.Date.Day.ToString() + ".pdf"); }
}
FileStream FS = new FileStream(System.Windows.Forms.Application.UserAppDataPath + @"\Attendance_" + _CurrentDay.Date.Day.ToString()
+ ".pdf", FileMode.CreateNew);
var Doc = new iTextSharp.text.Document(PageSize.A4.Rotate(), 20, 20, 20, 20);
PdfWriter.GetInstance(Doc, FS);
Doc.Open();
PdfPTable table = new PdfPTable(14);
table.HorizontalAlignment = Element.ALIGN_LEFT;
table.WidthPercentage = 100;
AddHeader(table, "Attendance", 20, new BaseColor(Color.DimGray), new BaseColor(Color.WhiteSmoke));
AddHeader(table, _CurrentDay.Date.DayOfWeek + " " + _CurrentDay.Date.ToShortDateString(), 16, new BaseColor(Color.DimGray), new BaseColor(Color.White));
daysTableAdapter.Fill(tDayDataSet.Days, _CurrentDay.Date);
int Counter = 0;
int TotalLC = 0;
double TotalLCP = 0;
double TotalTOP = 0;
double TotalMisoP = 0;
double TotalVan = 0;
double TotalP = 0;
double TotalRTP = 0;
double TotalBFT = 0;
double TotalT = 0;
AddHeader(table, "Billed Clients", 12, new BaseColor(Color.DimGray), new BaseColor(Color.WhiteSmoke));
AddPriviewCell(table, "Numb", 1);
AddPriviewCell(table, "Name", 3);
AddPriviewCell(table, "A", 1);
AddPriviewCell(table, "LC", 1);
AddPriviewCell(table, "L$", 1);
AddPriviewCell(table, "TO$", 1);
AddPriviewCell(table, "Miso$", 1);
AddPriviewCell(table, "P$", 1);
AddPriviewCell(table, "Van", 1);
AddPriviewCell(table, "RT", 1);
AddPriviewCell(table, "BFT", 1);
AddPriviewCell(table, "Total", 1);
foreach (DataRow Row in tDayDataSet.Days)
{
if (ProfileProvider.GetCategory((int)Row["ProfileId"]) == 1)
{
AddPriviewCell(table, Counter.ToString(), 1);
AddPriviewCell(table, ProfileProvider.GetName((int)Row["ProfileId"]), 3);
AddValueCell(table, (bool)Row["Attendance"], true, 1);
AddValueCell(table, (bool)Row["Lunch"], true, 1);
if ((bool)Row["Lunch"]) { TotalLC++; }
AddPriviewCell(table, Row["LunchPrice"].ToString(), 1);
TotalLCP += Convert.ToDouble(Row["LunchPrice"]);
AddPriviewCell(table, Row["TakeOutPrice"].ToString(), 1);
TotalTOP += Convert.ToDouble(Row["TakeOutPrice"]);
AddPriviewCell(table, Row["MiscellaneousPrice"].ToString(), 1);
TotalMisoP += Convert.ToDouble(Row["MiscellaneousPrice"]);
if (ProfileProvider.GetCategory((int)Row["ProfileId"]) == 1)
{
AddPriviewCell(table, Row["ProgramPrice"].ToString(), 1);
TotalP += Convert.ToDouble(Row["ProgramPrice"]);
AddPriviewCell(table, Row["VanPrice"].ToString(), 1);
TotalVan += Convert.ToDouble(Row["VanPrice"]);
AddPriviewCell(table, Row["RoundTripPrice"].ToString(), 1);
TotalRTP += Convert.ToDouble(Row["RoundTripPrice"]);
AddPriviewCell(table, Row["BookOfTickets"].ToString(), 1);
TotalBFT += Convert.ToDouble(Row["BookOfTickets"]);
}
else
{
AddPriviewCell(table, "", 1, new BaseColor(Color.WhiteSmoke));
TotalP += Convert.ToDouble(Row["ProgramPrice"]);
AddPriviewCell(table, "", 1, new BaseColor(Color.WhiteSmoke));
TotalVan += Convert.ToDouble(Row["VanPrice"]);
AddPriviewCell(table, "", 1, new BaseColor(Color.WhiteSmoke));
TotalRTP += Convert.ToDouble(Row["RoundTripPrice"]);
AddPriviewCell(table, "", 1, new BaseColor(Color.WhiteSmoke));
TotalBFT += Convert.ToDouble(Row["BookOfTickets"]);
}
AddPriviewCell(table, Row["Total"].ToString(), 1);
Counter++;
}
}
AddPriviewCell(table, "", 1);
AddPriviewCell(table, "Total:", 3);
AddPriviewCell(table, Counter.ToString(), 1);
AddPriviewCell(table, TotalLC.ToString(), 1);
AddPriviewCell(table, TotalLCP.ToString("0.00"), 1);
AddPriviewCell(table, TotalTOP.ToString("0.00"), 1);
AddPriviewCell(table, TotalMisoP.ToString("0.00"), 1);
AddPriviewCell(table, TotalP.ToString("0.00"), 1);
AddPriviewCell(table, TotalVan.ToString("0.00"), 1);
AddPriviewCell(table, TotalRTP.ToString("0.00"), 1);
AddPriviewCell(table, TotalBFT.ToString("0.00"), 1);
AddPriviewCell(table, (TotalLCP + TotalMisoP + TotalTOP + TotalVan + TotalP + TotalRTP + TotalBFT).ToString("0.00"), 1);
AddHeader(table, "Staff/Volunteers", 12, new BaseColor(Color.DimGray), new BaseColor(Color.WhiteSmoke));
AddPriviewCell(table, "Numb", 1);
AddPriviewCell(table, "Name", 3);
AddPriviewCell(table, "A", 1);
AddPriviewCell(table, "LC", 1);
AddPriviewCell(table, "L$", 1);
AddPriviewCell(table, "TO$", 1);
AddPriviewCell(table, "Miso$", 1);
AddPriviewCell(table, "P$", 1);
AddPriviewCell(table, "Van", 1);
AddPriviewCell(table, "RT", 1);
AddPriviewCell(table, "BFT", 1);
AddPriviewCell(table, "Total", 1);
Counter = 0;
TotalLC = 0;
TotalLCP = 0;
TotalTOP = 0;
TotalMisoP = 0;
TotalVan = 0;
TotalP = 0;
TotalRTP = 0;
TotalBFT = 0;
TotalT = 0;
foreach (DataRow Row in tDayDataSet.Days)
{
if (ProfileProvider.GetCategory((int)Row["ProfileId"]) != 1)
{
AddPriviewCell(table, Counter.ToString(), 1);
AddPriviewCell(table, ProfileProvider.GetName((int)Row["ProfileId"]), 3);
AddValueCell(table, (bool)Row["Attendance"], true, 1);
AddValueCell(table, (bool)Row["Lunch"], true, 1);
if ((bool)Row["Lunch"]) { TotalLC++; }
AddPriviewCell(table, Row["LunchPrice"].ToString(), 1);
TotalLCP += Convert.ToDouble(Row["LunchPrice"]);
AddPriviewCell(table, Row["TakeOutPrice"].ToString(), 1);
TotalTOP += Convert.ToDouble(Row["TakeOutPrice"]);
AddPriviewCell(table, Row["MiscellaneousPrice"].ToString(), 1);
TotalMisoP += Convert.ToDouble(Row["MiscellaneousPrice"]);
if (ProfileProvider.GetCategory((int)Row["ProfileId"]) == 1)
{
AddPriviewCell(table, Row["ProgramPrice"].ToString(), 1);
TotalP += Convert.ToDouble(Row["ProgramPrice"]);
AddPriviewCell(table, Row["VanPrice"].ToString(), 1);
TotalVan += Convert.ToDouble(Row["VanPrice"]);
AddPriviewCell(table, Row["RoundTripPrice"].ToString(), 1);
TotalRTP += Convert.ToDouble(Row["RoundTripPrice"]);
AddPriviewCell(table, Row["BookOfTickets"].ToString(), 1);
TotalBFT += Convert.ToDouble(Row["BookOfTickets"]);
}
else
{
AddPriviewCell(table, "", 1, new BaseColor(Color.WhiteSmoke));
TotalP += Convert.ToDouble(Row["ProgramPrice"]);
AddPriviewCell(table, "", 1, new BaseColor(Color.WhiteSmoke));
TotalVan += Convert.ToDouble(Row["VanPrice"]);
AddPriviewCell(table, "", 1, new BaseColor(Color.WhiteSmoke));
TotalRTP += Convert.ToDouble(Row["RoundTripPrice"]);
AddPriviewCell(table, "", 1, new BaseColor(Color.WhiteSmoke));
TotalBFT += Convert.ToDouble(Row["BookOfTickets"]);
}
AddPriviewCell(table, Row["Total"].ToString(), 1);
Counter++;
}
}
AddPriviewCell(table, "", 1);
AddPriviewCell(table, "Total:", 3);
AddPriviewCell(table, Counter.ToString(), 1);
AddPriviewCell(table, TotalLC.ToString(), 1);
AddPriviewCell(table, TotalLCP.ToString("0.00"), 1);
AddPriviewCell(table, TotalTOP.ToString("0.00"), 1);
AddPriviewCell(table, TotalMisoP.ToString("0.00"), 1);
AddPriviewCell(table, "", 1, new BaseColor(Color.WhiteSmoke));
AddPriviewCell(table, "", 1, new BaseColor(Color.WhiteSmoke));
AddPriviewCell(table, "", 1, new BaseColor(Color.WhiteSmoke));
AddPriviewCell(table, "", 1, new BaseColor(Color.WhiteSmoke));
AddPriviewCell(table, (TotalLCP + TotalMisoP + TotalTOP + TotalVan + TotalP + TotalRTP + TotalBFT).ToString("0.00"), 1);
//********************
TotalLC = 0;
TotalLCP = 0;
TotalTOP = 0;
TotalMisoP = 0;
TotalVan = 0;
TotalP = 0;
TotalRTP = 0;
TotalBFT = 0;
TotalT = 0;
foreach (DataRow Row in tDayDataSet.Days)
{
if ((bool)Row["Lunch"]) { TotalLC++; }
TotalLCP += Convert.ToDouble(Row["LunchPrice"]);
TotalTOP += Convert.ToDouble(Row["TakeOutPrice"]);
TotalMisoP += Convert.ToDouble(Row["MiscellaneousPrice"]);
if (ProfileProvider.GetCategory((int)Row["ProfileId"]) == 1)
{
TotalP += Convert.ToDouble(Row["ProgramPrice"]);
TotalVan += Convert.ToDouble(Row["VanPrice"]);
TotalRTP += Convert.ToDouble(Row["RoundTripPrice"]);
TotalBFT += Convert.ToDouble(Row["BookOfTickets"]);
}
else
{
TotalP += Convert.ToDouble(Row["ProgramPrice"]);
TotalVan += Convert.ToDouble(Row["VanPrice"]);
TotalRTP += Convert.ToDouble(Row["RoundTripPrice"]);
TotalBFT += Convert.ToDouble(Row["BookOfTickets"]);
}
}
//******************
TotalT += TotalLCP + TotalMisoP + TotalTOP + TotalVan + TotalP + TotalRTP + TotalBFT;
AddPriviewCell(table, "", 1);
AddPriviewCell(table, "GrandTotal:", 3);
AddPriviewCell(table, tDayDataSet.Days.Rows.Count.ToString(), 1);
AddPriviewCell(table, TotalLC.ToString(), 1);
AddPriviewCell(table, TotalLCP.ToString("0.00"), 1);
AddPriviewCell(table, TotalTOP.ToString("0.00"), 1);
AddPriviewCell(table, TotalMisoP.ToString("0.00"), 1);
AddPriviewCell(table, TotalP.ToString("0.00"), 1);
AddPriviewCell(table, TotalVan.ToString("0.00"), 1);
AddPriviewCell(table, TotalRTP.ToString("0.00"), 1);
AddPriviewCell(table, TotalBFT.ToString("0.00"), 1);
AddPriviewCell(table, TotalT.ToString("0.00"), 1);
Doc.Add(table);
Doc.Close();
Process.Start(System.Windows.Forms.Application.UserAppDataPath + @"\Attendance_" + _CurrentDay.Date.Day.ToString() + ".pdf");
}
