public void core()
{
DateTime now = DateTime.Now;
var oneweekAffter = now.AddDays(7);
DateTime day = DateTime.Today;
int offset = day.DayOfWeek - DayOfWeek.Monday;
DateTime lastmonday = Convert.ToDateTime(day.AddDays(-offset - 7));
string monday = lastmonday.ToString("MM-dd-yyyy");
string path = "";
// monday = ("12-14-2015");
Anviz_Data_BaseEntities_test_jose dc = new Anviz_Data_BaseEntities_test_jose();
var client = new MongoClient();
var db = client.GetDatabase("admin");
var collection = db.GetCollection<infoDept>("managers");
var document = db.GetCollection<Getreport>("managers");
var leads = from l in document.AsQueryable<Getreport>()
select l.deptID;
var test = from d in collection.AsQueryable<infoDept>()
select d.Id_Dept;
var all = from e in dc.Userinfoes select new GetPeople { userid = e.Userid, name = e.Name, email = e.Address };
string folder = @"C:\\Pdf\\Asistance_Report_" + monday;
Console.WriteLine("Conecting with Mongodb................................");
Thread.Sleep(2300);
try
{
if (test.Count() <= 1)
{
Console.WriteLine("Error!!!: cannot conect with MongoDb .................");
Console.ReadLine();
return;
}
}
catch (Exception e)
{
Console.WriteLine("Error!!!: cannot conect with MongoDb "+e+".................");
Console.ReadLine();
return;
}
Console.WriteLine("status conection::: success with MongoDb................................");
Console.WriteLine("Conecting with Mssql................................");
Thread.Sleep(2300);
try{
var whynot = all.Count() <= 1;
}
catch (Exception e)
{
Console.WriteLine("Error!!!: cannot conect with Mssql!!!! ................................");
Console.WriteLine(e);
Console.ReadLine();
return;
}
Console.WriteLine("status conection::: success with Mssql................................");
path = @"C:\\Pdf\\Asistance_Report_" + monday + "\\Depts\\";
bool folderExists = Directory.Exists((folder));
if (!folderExists)
Directory.CreateDirectory((folder));
folderExists = Directory.Exists((folder));
folderExists = Directory.Exists((path));
if (!folderExists)
Directory.CreateDirectory((path));
folderExists = Directory.Exists((path));
CreatePdf(test, collection, monday, true, path);
foreach (var items in test)
{
var managers = collection
.Find(a => a.Id_Dept == items)
.ToListAsync()
.Result;
foreach (var i in managers)
{
string[] sub_managers = i.Name;
List<Getreport> get = new List<Getreport>(i.GetReport);
path = @"C:\\Pdf\\Asistance_Report_" + monday + "\\SubDepts";
foreach (var sub in get)
{
// allPDF(monday, sub.deptID, sub.subdept, monday);
Console.WriteLine("CreateReportforSubDept" + sub.subdept + "...........................................");
CreatePdf(sub.subdept, sub.deptID, monday, true, path);
sendEmail(monday, sub.subName, sub.subdept, sub.subEmail, "\\SubDepts\\");
}
for (int y = 0; y < sub_managers.Length; y++)
{
// allPDF(monday, sub.deptID, sub.subdept, monday);
// sendEmail(monday, i.Name[y], sub.subdept,i.correo[y]);
// sendEmail(monday, sub.subName, sub.subdept,sub.subEmail);
// allPDF(monday, i.Id_Dept, i.Nombre_Dept, monday);
// sendEmail(monday, i.Name[y], i.Nombre_Dept,i.correo[y]);
sendEmail(monday, i.Name[y], "All" + i.Nombre_Dept, i.correo[y], "\\Depts\\");
//if (oneweekAffter.Month != now.Month)
//{
// Console.WriteLine("ultimo lunes ................................");
//}
//else
//{
// Console.WriteLine(" no es el ultimo lunes b................................");
//}
}
}
}
sendEmail(monday, "Flor de Liz Reyes", "LNO-HN", "*****@*****.**", "\\Depts\\");
sendEmail(monday, "Flor de Liz Reyes", "LNO-HN", "*****@*****.**", "\\Depts\\");
path = @"C:\\Pdf\\Asistance_Report_" + monday + "\\Employes\\";
foreach (var items in all)
{
CreatePdf(items.name, items.userid, monday, false, path);
sendEmail(monday, items.name, items.name, items.email, "\\Employes\\");
}
}
public PdfPTable archive(PdfPTable table, int deptID, string subdept, string dates, bool type)
{
List<test> all = new List<test>();
List<test> listWeek1 = new List<test>();
List<test> listWeek2 = new List<test>();
List<test> listWeek3 = new List<test>();
List<test> listWeek4 = new List<test>();
List<test> potato = new List<test>();
PdfPCell cell = new PdfPCell();
PdfPCell cell2 = new PdfPCell();
PdfPCell cellName = new PdfPCell();
PdfPCell cellMonday = new PdfPCell();
PdfPCell cellTuesday = new PdfPCell();
PdfPCell cellWednesday = new PdfPCell();
PdfPCell cellThursday = new PdfPCell();
PdfPCell cellfriday = new PdfPCell();
PdfPCell cellsaturday = new PdfPCell();
PdfPCell cellsunday = new PdfPCell();
Array[] list = { };
iTextSharp.text.Font georgia = FontFactory.GetFont("georgia", 14f);
georgia.Color = iTextSharp.text.BaseColor.BLUE;
iTextSharp.text.Font labels = FontFactory.GetFont("georgia", 14f);
labels.Color = iTextSharp.text.BaseColor.WHITE;
iTextSharp.text.Font Headers = FontFactory.GetFont("georgia", 18f);
Headers.Color = iTextSharp.text.BaseColor.BLACK;
PdfPTable table2 = new PdfPTable(24);
table.TotalWidth = 5000f;
float[] widths = new float[] { 1300f, 1300, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f };
table.SetWidths(widths);
DateTime week2 = Convert.ToDateTime(dates).AddDays(-7);
DateTime week3 = Convert.ToDateTime(dates).AddDays(-14);
DateTime week4 = Convert.ToDateTime(dates).AddDays(-21);
// var init = Convert.ToInt32(deptID.ToString());
using (Anviz_Data_BaseEntities_test_jose dc = new Anviz_Data_BaseEntities_test_jose())
//using (Anviz_Data_BaseEntities2 dc = new Anviz_Data_BaseEntities2())
{
// all = (from e in dc).ToList();
if (type == true)
{
all = (from e in dc.sp_matrix_weekdays(deptID, dates)
select new test
{
Nombre = e.name,
FechaEntradaMonday = e.Hora_de_LLegada_Lunes,
SensorInMonday = e.Lugar_de_Marcaje_Llegada_Lunes,
FechaSalidaMonday = e.Hora_de_salida_Lunes,
SensorOutMonday = e.Lugar_de_Marcaje_Salida_Lunes,
HorasMonday = e.Monday,
FechaEntradaTuesday = e.Hora_de_LLegada_Martes,
SensorInTuesday = e.Lugar_de_Marcaje_Llegada_Martes,
FechaSalidaTuesday = e.Hora_de_salida_Martes,
SensorOutTuesday = e.Lugar_de_Marcaje_Salida_Martes,
HorasTuesday = e.Tuesday,
FechaEntradaWendnsday = e.Hora_de_LLegada_Miercoles,
SensorInWednesday = e.Lugar_de_Marcaje_Llegada_Miercoles,
FechaSalidaWendnsday = e.Hora_de_salida_Miercoles,
SensorOutWednesday = e.Lugar_de_Marcaje_Salida_Miercoles,
HorasWendnsday = e.Wednsday,
FechaEntradaThursday = e.Hora_de_LLegada_Jueves,
SensorInThursday = e.Lugar_de_Marcaje_Llegada_Jueves,
FechaSalidaThursday = e.Hora_de_salida_Jueves,
SensorOutThursday = e.Lugar_de_Marcaje_Salida_Jueves,
HorasThursday = e.Thursday,
FechaEntradaFriday = e.Hora_de_LLegada_Viernes,
SensorInFriday = e.Lugar_de_Marcaje_Llegada_Viernes,
FechaSalidaFriday = e.Hora_de_salida_Viernes,
SensorOutFriday = e.Lugar_de_Marcaje_Salida_Viernes,
HorasFriday = e.Friday,
FechaEntradaSaturday = e.Hora_de_LLegada_Sabado,
SensorInSaturday = e.Lugar_de_Marcaje_Llegada_Sabado,
FechaSalidaSaturday = e.Hora_de_salida_Sabado,
SensorOutSaturday = e.Lugar_de_Marcaje_Llegada_Sabado1,
HorasSaturday = e.Saturday,
FechaEntradaSunday = e.Hora_de_LLegada_Domingo,
SensorInSunday = e.Lugar_de_Marcaje_Llegada_Domingo,
FechaSalidaSunday = e.Hora_de_salida_Domingo,
SensorOutSunday = e.Lugar_de_Marcaje_Llegada_Domingo1,
HorasSunday = e.Sunday,
}).ToList();
}
else
{
all = (from e in dc.GetEmployes(deptID, dates)
select new test
{
Nombre = e.name,
FechaEntradaMonday = e.Hora_de_LLegada_Lunes,
SensorInMonday = e.Lugar_de_Marcaje_Llegada_Lunes,
FechaSalidaMonday = e.Hora_de_salida_Lunes,
SensorOutMonday = e.Lugar_de_Marcaje_Salida_Lunes,
HorasMonday = e.Monday,
FechaEntradaTuesday = e.Hora_de_LLegada_Martes,
SensorInTuesday = e.Lugar_de_Marcaje_Llegada_Martes,
FechaSalidaTuesday = e.Hora_de_salida_Martes,
SensorOutTuesday = e.Lugar_de_Marcaje_Salida_Martes,
HorasTuesday = e.Tuesday,
FechaEntradaWendnsday = e.Hora_de_LLegada_Miercoles,
SensorInWednesday = e.Lugar_de_Marcaje_Llegada_Miercoles,
FechaSalidaWendnsday = e.Hora_de_salida_Miercoles,
SensorOutWednesday = e.Lugar_de_Marcaje_Salida_Miercoles,
HorasWendnsday = e.Wednsday,
FechaEntradaThursday = e.Hora_de_LLegada_Jueves,
SensorInThursday = e.Lugar_de_Marcaje_Llegada_Jueves,
FechaSalidaThursday = e.Hora_de_salida_Jueves,
SensorOutThursday = e.Lugar_de_Marcaje_Salida_Jueves,
HorasThursday = e.Thursday,
FechaEntradaFriday = e.Hora_de_LLegada_Viernes,
SensorInFriday = e.Lugar_de_Marcaje_Llegada_Viernes,
FechaSalidaFriday = e.Hora_de_salida_Viernes,
SensorOutFriday = e.Lugar_de_Marcaje_Salida_Viernes,
HorasFriday = e.Friday,
FechaEntradaSaturday = e.Hora_de_LLegada_Sabado,
SensorInSaturday = e.Lugar_de_Marcaje_Llegada_Sabado,
FechaSalidaSaturday = e.Hora_de_salida_Sabado,
SensorOutSaturday = e.Lugar_de_Marcaje_Llegada_Sabado1,
HorasSaturday = e.Saturday,
FechaEntradaSunday = e.Hora_de_LLegada_Domingo,
SensorInSunday = e.Lugar_de_Marcaje_Llegada_Domingo,
FechaSalidaSunday = e.Hora_de_salida_Domingo,
SensorOutSunday = e.Lugar_de_Marcaje_Llegada_Domingo1,
HorasSunday = e.Sunday,
}).ToList();
}
}
DateTime date = Convert.ToDateTime(dates);
//PdfPCell june = new PdfPCell(new Phrase("Cell 2",georgia));
cell2 = new PdfPCell(new Phrase(subdept, Headers));
cell2.HorizontalAlignment = Element.ALIGN_CENTER;
cell2.BackgroundColor = new iTextSharp.text.BaseColor(245, 92, 24);
cell2.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
cell2.Colspan = 24;
table.AddCell(cell2);
PdfPCell nombre = new PdfPCell(new Phrase("Name", labels));
nombre.BackgroundColor = new iTextSharp.text.BaseColor(89, 89, 89);
nombre.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
nombre.BorderWidthRight = 1;
nombre.Rowspan = 2;
nombre.Colspan = 2;
nombre.HorizontalAlignment = 1;
nombre.VerticalAlignment = 1;
table.AddCell(nombre);
PdfPCell june = new PdfPCell(new Phrase("Monday " + "\n" + Convert.ToDateTime(date).ToShortDateString().ToString(), Headers));
june.BorderWidthRight = 1;
june.HorizontalAlignment = 1;
june.BackgroundColor = new iTextSharp.text.BaseColor(247, 150, 70);
june.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
june.Colspan = 3;
table.AddCell(june);
june = new PdfPCell(new Phrase("Tuesday " + "\n" + Convert.ToDateTime(date).AddDays(1).ToShortDateString(), Headers));
june.BorderWidthRight = 1;
june.BackgroundColor = new iTextSharp.text.BaseColor(247, 150, 70);
june.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
june.HorizontalAlignment = 1;
june.Colspan = 3;
table.AddCell(june);
june = new PdfPCell(new Phrase("Wednesday " + "\n" + Convert.ToDateTime(date).AddDays(2).ToShortDateString(), Headers));
june.BorderWidthRight = 1;
june.BackgroundColor = new iTextSharp.text.BaseColor(247, 150, 70);
june.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
june.HorizontalAlignment = 1;
june.Colspan = 3;
table.AddCell(june);
june = new PdfPCell(new Phrase("Thursday " + "\n" + Convert.ToDateTime(date).AddDays(3).ToShortDateString(), Headers));
june.BorderWidthRight = 1;
june.BackgroundColor = new iTextSharp.text.BaseColor(247, 150, 70);
june.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
june.HorizontalAlignment = 1;
june.Colspan = 3;
table.AddCell(june);
june = new PdfPCell(new Phrase("Friday " + "\n" + Convert.ToDateTime(date).AddDays(4).ToShortDateString(), Headers));
june.BorderWidthRight = 1;
june.BackgroundColor = new iTextSharp.text.BaseColor(247, 150, 70);
june.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
june.HorizontalAlignment = 1;
june.Colspan = 3;
table.AddCell(june);
june = new PdfPCell(new Phrase("Saturday " + "\n" + Convert.ToDateTime(date).AddDays(5).ToShortDateString(), Headers));
june.BorderWidthRight = 1;
june.BackgroundColor = new iTextSharp.text.BaseColor(247, 150, 70);
june.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
june.HorizontalAlignment = 1;
june.Colspan = 3;
table.AddCell(june);
june = new PdfPCell(new Phrase("Sunday " + "\n" + Convert.ToDateTime(date).AddDays(6).ToShortDateString(), Headers));
june.BorderWidthRight = 1;
june.BackgroundColor = new iTextSharp.text.BaseColor(247, 150, 70);
june.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
june.HorizontalAlignment = 1;
june.Colspan = 3;
table.AddCell(june);
june = new PdfPCell(new Phrase("Weekly Hours Worked", labels));
june.BorderWidthRight = 1;
june.Rowspan = 2;
june.HorizontalAlignment = 1;
june.BackgroundColor = new iTextSharp.text.BaseColor(89, 89, 89);
june.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
table.AddCell(june);
PdfPCell In = new PdfPCell();
PdfPCell OUT = new PdfPCell();
PdfPCell second = new PdfPCell();
for (var y = 0; y <= 6; y++)
{
In = new PdfPCell(new Phrase("In", labels));
In.BackgroundColor = new iTextSharp.text.BaseColor(89, 89, 89);
In.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
In.HorizontalAlignment = 1;
table.AddCell(In);
OUT = new PdfPCell(new Phrase("Out", labels));
OUT.BackgroundColor = new iTextSharp.text.BaseColor(89, 89, 89);
OUT.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
OUT.HorizontalAlignment = 1;
table.AddCell(OUT);
second = new PdfPCell(new Phrase("Worked Hours", labels));
second.BackgroundColor = new iTextSharp.text.BaseColor(89, 89, 89);
second.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
second.BorderWidthRight = 1;
second.HorizontalAlignment = 1;
table.AddCell(second);
}
foreach (var item in all)
{
cellName.Phrase = new Phrase(item.Nombre);
cellName.HorizontalAlignment = 1;
cellName.Colspan = 2;
cellName.BorderWidthRight = 1;
table.AddCell(cellName);
//For Monday
if(item.SensorInMonday == 99)
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaEntradaMonday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(0, 247, 255);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
else
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaEntradaMonday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
if(item.SensorOutMonday == 99)
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaSalidaMonday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(0, 247, 255);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
else
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaSalidaMonday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
cellMonday = new PdfPCell(new Phrase((item.HorasMonday).ToString()));
cellMonday.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cellMonday.BorderWidthRight = 1;
cellMonday.HorizontalAlignment = 1;
table.AddCell(cellMonday);
//For Tuesday
if(item.SensorInTuesday == 99)
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaEntradaTuesday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(0, 247, 255);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
else
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaEntradaTuesday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
if(item.SensorOutTuesday == 99)
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaSalidaTuesday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(0, 247, 255);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
else
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaSalidaTuesday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
cellTuesday = new PdfPCell(new Phrase((item.HorasTuesday).ToString()));
cellTuesday.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cellTuesday.BorderWidthRight = 1;
cellTuesday.HorizontalAlignment = 1;
table.AddCell(cellTuesday);
//For Wednesday
if (item.SensorInWednesday == 99)
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaEntradaWendnsday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(0, 247, 255);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
else
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaEntradaWendnsday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
if(item.SensorOutWednesday == 99)
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaSalidaWendnsday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(0, 247, 255);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
else
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaSalidaWendnsday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
cellWednesday = new PdfPCell(new Phrase((item.HorasWendnsday).ToString()));
cellWednesday.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cellWednesday.BorderWidthRight = 1;
cellWednesday.HorizontalAlignment = 1;
table.AddCell(cellWednesday);
//For Thursday
if(item.SensorInThursday == 99)
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaEntradaThursday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(0, 247, 255);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
else
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaEntradaThursday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
if(item.SensorOutThursday == 99)
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaSalidaThursday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(0, 247, 255);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
else
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaSalidaThursday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
cellThursday = new PdfPCell(new Phrase((item.HorasThursday).ToString()));
cellThursday.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cellThursday.BorderWidthRight = 1;
cellThursday.HorizontalAlignment = 1;
table.AddCell(cellThursday);
//For Friday
if(item.SensorInFriday == 99)
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaEntradaFriday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(0, 247, 255);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
else
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaEntradaFriday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
if(item.SensorOutFriday == 99)
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaSalidaFriday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(0, 247, 255);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
else
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaSalidaFriday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
cellfriday = new PdfPCell(new Phrase((item.HorasFriday).ToString()));
cellfriday.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cellfriday.BorderWidthRight = 1;
cellfriday.HorizontalAlignment = 1;
table.AddCell(cellfriday);
//For Saturday
if(item.SensorInSaturday == 99)
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaEntradaSaturday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(0, 247, 255);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
else
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaEntradaSaturday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
if(item.SensorOutSaturday == 99)
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaSalidaSaturday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(0, 247, 255);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
else
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaSalidaSaturday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
cellsaturday = new PdfPCell(new Phrase((item.HorasSaturday).ToString()));
cellsaturday.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cellsaturday.BorderWidthRight = 1;
cellsaturday.HorizontalAlignment = 1;
table.AddCell(cellsaturday);
//For Sunday
if (item.SensorInSunday == 99)
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaEntradaSunday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(0, 247, 255);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
else
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaEntradaSunday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
if (item.SensorOutSunday == 99)
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaSalidaSunday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(0, 247, 255);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
else
{
cell.Phrase = new Phrase(Convert.ToDateTime(item.FechaSalidaSunday).ToShortTimeString().ToString());
cell.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cell.HorizontalAlignment = 1;
table.AddCell(cell);
}
cellsunday = new PdfPCell(new Phrase((item.HorasSunday).ToString()));
cellsunday.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cellsunday.BorderWidthRight = 1;
cellsunday.HorizontalAlignment = 1;
table.AddCell(cellsunday);
cell.Phrase = new Phrase(Convert.ToString(Convert.ToDecimal(item.HorasMonday) + Convert.ToDecimal(item.HorasTuesday) + Convert.ToDecimal(item.HorasWendnsday) + Convert.ToDecimal(item.HorasThursday) + Convert.ToDecimal(item.HorasFriday) + Convert.ToDecimal(item.HorasSaturday) + Convert.ToDecimal(item.HorasSunday)));
cell.HorizontalAlignment = 1;
table.AddCell(cell);
//table.Rows.Add(cell);
//
}
/*Add legend to Table */
cell2 = new PdfPCell(new Phrase(""));
cell2.HorizontalAlignment = Element.ALIGN_CENTER;
cell2.BackgroundColor = new iTextSharp.text.BaseColor(255, 255, 255);
cell2.BorderColor = new iTextSharp.text.BaseColor(255, 255, 255);
cell2.Colspan = 24;
table.AddCell(cell2);
cell2 = new PdfPCell(new Phrase(""));
cell2.HorizontalAlignment = Element.ALIGN_CENTER;
cell2.BackgroundColor = new iTextSharp.text.BaseColor(255, 255, 255);
cell2.BorderColor = new iTextSharp.text.BaseColor(255, 255, 255);
cell2.Colspan = 24;
table.AddCell(cell2);
cell2 = new PdfPCell(new Phrase("Color Key"));
cell2.HorizontalAlignment = Element.ALIGN_CENTER;
cell2.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cell2.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
cell2.Colspan = 24;
table.AddCell(cell2);
cell2 = new PdfPCell(new Phrase("Remote Authentication"));
cell2.HorizontalAlignment = Element.ALIGN_CENTER;
cell2.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cell2.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
cell2.Colspan = 12;
table.AddCell(cell2);
cell2 = new PdfPCell(new Phrase(""));
cell2.HorizontalAlignment = Element.ALIGN_CENTER;
cell2.BackgroundColor = new iTextSharp.text.BaseColor(0, 247, 255);
cell2.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
cell2.Colspan = 12;
table.AddCell(cell2);
cell2 = new PdfPCell(new Phrase("OnSite Authentication"));
cell2.HorizontalAlignment = Element.ALIGN_CENTER;
cell2.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cell2.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
cell2.Colspan = 12;
table.AddCell(cell2);
cell2 = new PdfPCell(new Phrase(""));
cell2.HorizontalAlignment = Element.ALIGN_CENTER;
cell2.BackgroundColor = new iTextSharp.text.BaseColor(242,242,242);
cell2.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
cell2.Colspan = 12;
table.AddCell(cell2);
return table;
}
public PdfPTable ArchiveSpin4(PdfPTable table, int deptID, string subdept, string dates, bool type)
{
List<test> all = new List<test>();
PdfPCell cell = new PdfPCell();
PdfPCell cell2 = new PdfPCell();
PdfPCell cellName = new PdfPCell();
PdfPCell cellMonday = new PdfPCell();
PdfPCell cellTuesday = new PdfPCell();
PdfPCell cellWednesday = new PdfPCell();
PdfPCell cellThursday = new PdfPCell();
PdfPCell cellfriday = new PdfPCell();
PdfPCell cellsaturday = new PdfPCell();
PdfPCell cellsunday = new PdfPCell();
Array[] list = { };
iTextSharp.text.Font georgia = FontFactory.GetFont("georgia", 14f);
georgia.Color = iTextSharp.text.BaseColor.BLUE;
iTextSharp.text.Font labels = FontFactory.GetFont("georgia", 14f);
labels.Color = iTextSharp.text.BaseColor.WHITE;
iTextSharp.text.Font Headers = FontFactory.GetFont("georgia", 18f);
Headers.Color = iTextSharp.text.BaseColor.BLACK;
List<test> concat = new List<test>();
PdfPTable table2 = new PdfPTable(24);
table.TotalWidth = 5000f;
float[] widths = new float[] { 1300f, 1300, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f, 1300f };
table.SetWidths(widths);
DateTime week2 = Convert.ToDateTime(dates).AddDays(-7);
DateTime week3 = Convert.ToDateTime(dates).AddDays(-14);
DateTime week4 = Convert.ToDateTime(dates).AddDays(-21);
DateTime week1 = Convert.ToDateTime(dates);
List<test> listWeek1 = new List<test>();
List<test> listWeek2 = new List<test>();
List<test> listWeek3 = new List<test>();
List<test> listWeek4 = new List<test>();
List<test> potato = new List<test>();
// var init = Convert.ToInt32(deptID.ToString());
int count = -7;
for (int i = 0; i < 3; i++)
{
using (Anviz_Data_BaseEntities_test_jose dc = new Anviz_Data_BaseEntities_test_jose())
{
// all = (from e in dc).ToList();
if (type == true)
{
listWeek1 = (from e in dc.sp_matrix_weekdays(deptID, (week1.ToString("MM-dd-yyyy"))) select new test { Nombre = e.name, FechaEntradaMonday = e.Hora_de_LLegada_Lunes, FechaSalidaMonday = e.Hora_de_salida_Lunes, HorasMonday = e.Monday, FechaEntradaTuesday = e.Hora_de_LLegada_Martes, FechaSalidaTuesday = e.Hora_de_salida_Martes, HorasTuesday = e.Tuesday, FechaEntradaWendnsday = e.Hora_de_LLegada_Miercoles, FechaSalidaWendnsday = e.Hora_de_salida_Miercoles, HorasWendnsday = e.Wednsday, FechaEntradaThursday = e.Hora_de_LLegada_Jueves, FechaSalidaThursday = e.Hora_de_salida_Jueves, HorasThursday = e.Thursday, FechaEntradaFriday = e.Hora_de_LLegada_Viernes, FechaSalidaFriday = e.Hora_de_salida_Viernes, HorasFriday = e.Friday, FechaEntradaSaturday = e.Hora_de_LLegada_Sabado, FechaSalidaSaturday = e.Hora_de_salida_Sabado, HorasSaturday = e.Saturday, FechaEntradaSunday = e.Hora_de_LLegada_Domingo, FechaSalidaSunday = e.Hora_de_salida_Domingo, HorasSunday = e.Sunday }).ToList();
listWeek2 = (from e in dc.sp_matrix_weekdays(deptID, (week2.ToString("MM-dd-yyyy"))) select new test { Nombre = e.name, FechaEntradaMonday = e.Hora_de_LLegada_Lunes, FechaSalidaMonday = e.Hora_de_salida_Lunes, HorasMonday = e.Monday, FechaEntradaTuesday = e.Hora_de_LLegada_Martes, FechaSalidaTuesday = e.Hora_de_salida_Martes, HorasTuesday = e.Tuesday, FechaEntradaWendnsday = e.Hora_de_LLegada_Miercoles, FechaSalidaWendnsday = e.Hora_de_salida_Miercoles, HorasWendnsday = e.Wednsday, FechaEntradaThursday = e.Hora_de_LLegada_Jueves, FechaSalidaThursday = e.Hora_de_salida_Jueves, HorasThursday = e.Thursday, FechaEntradaFriday = e.Hora_de_LLegada_Viernes, FechaSalidaFriday = e.Hora_de_salida_Viernes, HorasFriday = e.Friday, FechaEntradaSaturday = e.Hora_de_LLegada_Sabado, FechaSalidaSaturday = e.Hora_de_salida_Sabado, HorasSaturday = e.Saturday, FechaEntradaSunday = e.Hora_de_LLegada_Domingo, FechaSalidaSunday = e.Hora_de_salida_Domingo, HorasSunday = e.Sunday }).ToList();
listWeek3 = (from e in dc.sp_matrix_weekdays(deptID, (week3.ToString("MM-dd-yyyy"))) select new test { Nombre = e.name, FechaEntradaMonday = e.Hora_de_LLegada_Lunes, FechaSalidaMonday = e.Hora_de_salida_Lunes, HorasMonday = e.Monday, FechaEntradaTuesday = e.Hora_de_LLegada_Martes, FechaSalidaTuesday = e.Hora_de_salida_Martes, HorasTuesday = e.Tuesday, FechaEntradaWendnsday = e.Hora_de_LLegada_Miercoles, FechaSalidaWendnsday = e.Hora_de_salida_Miercoles, HorasWendnsday = e.Wednsday, FechaEntradaThursday = e.Hora_de_LLegada_Jueves, FechaSalidaThursday = e.Hora_de_salida_Jueves, HorasThursday = e.Thursday, FechaEntradaFriday = e.Hora_de_LLegada_Viernes, FechaSalidaFriday = e.Hora_de_salida_Viernes, HorasFriday = e.Friday, FechaEntradaSaturday = e.Hora_de_LLegada_Sabado, FechaSalidaSaturday = e.Hora_de_salida_Sabado, HorasSaturday = e.Saturday, FechaEntradaSunday = e.Hora_de_LLegada_Domingo, FechaSalidaSunday = e.Hora_de_salida_Domingo, HorasSunday = e.Sunday }).ToList();
listWeek4 = (from e in dc.sp_matrix_weekdays(deptID, (week4.ToString("MM-dd-yyyy"))) select new test { Nombre = e.name, FechaEntradaMonday = e.Hora_de_LLegada_Lunes, FechaSalidaMonday = e.Hora_de_salida_Lunes, HorasMonday = e.Monday, FechaEntradaTuesday = e.Hora_de_LLegada_Martes, FechaSalidaTuesday = e.Hora_de_salida_Martes, HorasTuesday = e.Tuesday, FechaEntradaWendnsday = e.Hora_de_LLegada_Miercoles, FechaSalidaWendnsday = e.Hora_de_salida_Miercoles, HorasWendnsday = e.Wednsday, FechaEntradaThursday = e.Hora_de_LLegada_Jueves, FechaSalidaThursday = e.Hora_de_salida_Jueves, HorasThursday = e.Thursday, FechaEntradaFriday = e.Hora_de_LLegada_Viernes, FechaSalidaFriday = e.Hora_de_salida_Viernes, HorasFriday = e.Friday, FechaEntradaSaturday = e.Hora_de_LLegada_Sabado, FechaSalidaSaturday = e.Hora_de_salida_Sabado, HorasSaturday = e.Saturday, FechaEntradaSunday = e.Hora_de_LLegada_Domingo, FechaSalidaSunday = e.Hora_de_salida_Domingo, HorasSunday = e.Sunday }).ToList();
var y = week2.Year;
var Lr3 = listWeek1.Concat(listWeek2).Concat(listWeek3).Concat(listWeek4).ToList();
if (y % 4 == 0 && (y % 100 != 0 || y % 400 == 0) && DateTime.Today.Month==3)
{
DateTime week5 = Convert.ToDateTime(dates).AddDays(-28);
List<test> listWeek5 = (from e in dc.sp_matrix_weekdays(deptID, (week5.ToString("MM-dd-yyyy"))) select new test { Nombre = e.name, FechaEntradaMonday = e.Hora_de_LLegada_Lunes, FechaSalidaMonday = e.Hora_de_salida_Lunes, HorasMonday = e.Monday, FechaEntradaTuesday = e.Hora_de_LLegada_Martes, FechaSalidaTuesday = e.Hora_de_salida_Martes, HorasTuesday = e.Tuesday, FechaEntradaWendnsday = e.Hora_de_LLegada_Miercoles, FechaSalidaWendnsday = e.Hora_de_salida_Miercoles, HorasWendnsday = e.Wednsday, FechaEntradaThursday = e.Hora_de_LLegada_Jueves, FechaSalidaThursday = e.Hora_de_salida_Jueves, HorasThursday = e.Thursday, FechaEntradaFriday = e.Hora_de_LLegada_Viernes, FechaSalidaFriday = e.Hora_de_salida_Viernes, HorasFriday = e.Friday, FechaEntradaSaturday = e.Hora_de_LLegada_Sabado, FechaSalidaSaturday = e.Hora_de_salida_Sabado, HorasSaturday = e.Saturday, FechaEntradaSunday = e.Hora_de_LLegada_Domingo, FechaSalidaSunday = e.Hora_de_salida_Domingo, HorasSunday = e.Sunday }).ToList();
Lr3 = Lr3.Concat(listWeek5).ToList();
}
foreach (var row in Lr3)
{
int index = potato.FindIndex(a => a.Nombre == row.Nombre);
if (!(index >= 0))
{
potato.Add(row);
}
else
{
var tomato = potato[index];
decimal? tempHoursi = (row.HorasMonday.Equals(null) ? 0:row.HorasMonday);
decimal? tempHoursi2 =(row.HorasTuesday.Equals(null) ? 0:row.HorasTuesday) ;
decimal? tempHoursi3 = (row.HorasWendnsday.Equals(null) ? 0 : row.HorasWendnsday);
decimal? tempHoursi4 = (row.HorasThursday.Equals(null) ? 0:row.HorasThursday);
decimal? tempHoursi5 = (row.HorasFriday.Equals(null) ? 0:row.HorasFriday);
decimal? tempHoursi6 = (row.HorasSaturday.Equals(null) ? 0:row.HorasSaturday);
decimal? tempHoursi7 = (row.HorasSunday.Equals(null) ? 0:row.HorasSunday);
decimal? tempHours2 = (tomato.HorasMonday.Equals(null) ?0:tomato.HorasMonday) + tempHoursi;
decimal? tempHours3 = (tomato.HorasTuesday.Equals(null) ?0:tomato.HorasTuesday)+ tempHoursi2;
decimal? tempHours4 = (tomato.HorasWendnsday.Equals(null) ?0:tomato.HorasWendnsday) + tempHoursi3;
decimal? tempHours5 = (tomato.HorasThursday.Equals(null) ?0:tomato.HorasThursday) + tempHoursi4;
decimal? tempHours6 = (tomato.HorasFriday.Equals(null) ?0:tomato.HorasFriday) + tempHoursi5;
decimal? tempHours7 = (tomato.HorasSaturday.Equals(null) ?0:tomato.HorasSaturday) + tempHoursi6;
decimal? tempHours8 = (tomato.HorasSunday.Equals(null) ?0:tomato.HorasSunday) + tempHoursi7;
tomato.HorasMonday = tempHours2;
tomato.HorasTuesday = tempHours3;
tomato.HorasWendnsday = tempHours4;
tomato.HorasThursday = tempHours5;
tomato.HorasFriday = tempHours6;
tomato.HorasSaturday = tempHours7;
tomato.HorasSunday = tempHours8;
potato[index] = tomato;
}
all = potato;
}
// WorkingHoursPerDay = (from i in dc.sp_GetWorkingHoursPerDay(1, Convert.ToDateTime("08-13-2015").AddDays(w)) select new WorkingPerDay { Name = i.Name, HourInput = i.horaEntrada, HourOutput = i.horasalida, workingHours = Convert.ToInt32(i.horaTrabajada) }).ToList();
// list[w] = WorkingHoursPerDay.ToList().ToArray();
}/*
else
{
all = (from e in dc.GetEmployes(deptID, dates) select new test { Nombre = e.name, FechaEntradaMonday = e.Hora_de_LLegada_Lunes, FechaSalidaMonday = e.Hora_de_salida_Lunes, HorasMonday = e.Monday, FechaEntradaTuesday = e.Hora_de_LLegada_Martes, FechaSalidaTuesday = e.Hora_de_salida_Martes, HorasTuesday = e.Tuesday, FechaEntradaWendnsday = e.Hora_de_LLegada_Miercoles, FechaSalidaWendnsday = e.Hora_de_salida_Miercoles, HorasWendnsday = e.Wednsday, FechaEntradaThursday = e.Hora_de_LLegada_Jueves, FechaSalidaThursday = e.Hora_de_salida_Jueves, HorasThursday = e.Thursday, FechaEntradaFriday = e.Hora_de_LLegada_Viernes, FechaSalidaFriday = e.Hora_de_salida_Viernes, HorasFriday = e.Friday, FechaEntradaSaturday = e.Hora_de_LLegada_Sabado, FechaSalidaSaturday = e.Hora_de_salida_Sabado, HorasSaturday = e.Saturday, FechaEntradaSunday = e.Hora_de_LLegada_Domingo, FechaSalidaSunday = e.Hora_de_salida_Domingo, HorasSunday = e.Sunday }).ToList();
}*/
}
DateTime datee = Convert.ToDateTime(dates);
DateTime back = Convert.ToDateTime(datee.AddDays(-count));
count = count - 7;
dates = back.ToString();
}
DateTime date = Convert.ToDateTime(dates);
//PdfPCell june = new PdfPCell(new Phrase("Cell 2",georgia));
cell2 = new PdfPCell(new Phrase(subdept, Headers));
cell2.HorizontalAlignment = Element.ALIGN_CENTER;
cell2.BackgroundColor = new iTextSharp.text.BaseColor(245, 92, 24);
cell2.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
cell2.Colspan = 24;
table.AddCell(cell2);
PdfPCell nombre = new PdfPCell(new Phrase("Name", labels));
nombre.BackgroundColor = new iTextSharp.text.BaseColor(89, 89, 89);
nombre.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
nombre.BorderWidthRight = 1;
nombre.Rowspan = 2;
nombre.Colspan = 2;
nombre.HorizontalAlignment = 1;
nombre.VerticalAlignment = 1;
table.AddCell(nombre);
PdfPCell june = new PdfPCell(new Phrase("Monday " + "\n"));
june.BorderWidthRight = 1;
june.HorizontalAlignment = 1;
june.BackgroundColor = new iTextSharp.text.BaseColor(247, 150, 70);
june.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
june.Colspan = 3;
table.AddCell(june);
june = new PdfPCell(new Phrase("Tuesday " + "\n" ));
june.BorderWidthRight = 1;
june.BackgroundColor = new iTextSharp.text.BaseColor(247, 150, 70);
june.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
june.HorizontalAlignment = 1;
june.Colspan = 3;
table.AddCell(june);
june = new PdfPCell(new Phrase("Wednesday " + "\n" ));
june.BorderWidthRight = 1;
june.BackgroundColor = new iTextSharp.text.BaseColor(247, 150, 70);
june.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
june.HorizontalAlignment = 1;
june.Colspan = 3;
table.AddCell(june);
june = new PdfPCell(new Phrase("Thursday " + "\n" ));
june.BorderWidthRight = 1;
june.BackgroundColor = new iTextSharp.text.BaseColor(247, 150, 70);
june.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
june.HorizontalAlignment = 1;
june.Colspan = 3;
table.AddCell(june);
june = new PdfPCell(new Phrase("Friday " + "\n" ));
june.BorderWidthRight = 1;
june.BackgroundColor = new iTextSharp.text.BaseColor(247, 150, 70);
june.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
june.HorizontalAlignment = 1;
june.Colspan = 3;
table.AddCell(june);
june = new PdfPCell(new Phrase("Saturday " + "\n" ));
june.BorderWidthRight = 1;
june.BackgroundColor = new iTextSharp.text.BaseColor(247, 150, 70);
june.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
june.HorizontalAlignment = 1;
june.Colspan = 3;
table.AddCell(june);
june = new PdfPCell(new Phrase("Sunday " + "\n" ));
june.BorderWidthRight = 1;
june.BackgroundColor = new iTextSharp.text.BaseColor(247, 150, 70);
june.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
june.HorizontalAlignment = 1;
june.Colspan = 3;
table.AddCell(june);
june = new PdfPCell(new Phrase("Monthly Hours Worked", labels));
june.BorderWidthRight = 1;
june.Rowspan = 2;
june.HorizontalAlignment = 1;
june.BackgroundColor = new iTextSharp.text.BaseColor(89, 89, 89);
june.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
table.AddCell(june);
PdfPCell In = new PdfPCell();
PdfPCell OUT = new PdfPCell();
PdfPCell second = new PdfPCell();
for (var y = 0; y <= 6; y++)
{
second = new PdfPCell(new Phrase("Worked Hours", labels));
second.BackgroundColor = new iTextSharp.text.BaseColor(89, 89, 89);
second.BorderColor = new iTextSharp.text.BaseColor(0, 0, 0);
second.BorderWidthRight = 1;
second.HorizontalAlignment = 1;
second.Colspan = 3;
table.AddCell(second);
}
foreach (var item in all)
{
cellName.Phrase = new Phrase(item.Nombre);
cellName.HorizontalAlignment = 1;
cellName.Colspan = 2;
cellName.BorderWidthRight = 1;
table.AddCell(cellName);
cellMonday = new PdfPCell(new Phrase((item.HorasMonday).ToString()));
cellMonday.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cellMonday.BorderWidthRight = 1;
cellMonday.HorizontalAlignment = 1;
cellMonday.Colspan = 3;
table.AddCell(cellMonday);
cellTuesday = new PdfPCell(new Phrase((item.HorasTuesday).ToString()));
cellTuesday.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cellTuesday.BorderWidthRight = 1;
cellTuesday.HorizontalAlignment = 1;
cellTuesday.Colspan = 3;
table.AddCell(cellTuesday);
cellWednesday = new PdfPCell(new Phrase((item.HorasWendnsday).ToString()));
cellWednesday.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cellWednesday.BorderWidthRight = 1;
cellWednesday.HorizontalAlignment = 1;
cellWednesday.Colspan = 3;
table.AddCell(cellWednesday);
cellThursday = new PdfPCell(new Phrase((item.HorasThursday).ToString()));
cellThursday.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cellThursday.BorderWidthRight = 1;
cellThursday.HorizontalAlignment = 1;
cellThursday.Colspan = 3;
table.AddCell(cellThursday);
cellfriday = new PdfPCell(new Phrase((item.HorasFriday).ToString()));
cellfriday.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cellfriday.BorderWidthRight = 1;
cellfriday.HorizontalAlignment = 1;
cellfriday.Colspan = 3;
table.AddCell(cellfriday);
cellsaturday = new PdfPCell(new Phrase((item.HorasSaturday).ToString()));
cellsaturday.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cellsaturday.BorderWidthRight = 1;
cellsaturday.HorizontalAlignment = 1;
cellsaturday.Colspan = 3;
table.AddCell(cellsaturday);
cellsunday = new PdfPCell(new Phrase((item.HorasSunday).ToString()));
cellsunday.BackgroundColor = new iTextSharp.text.BaseColor(242, 242, 242);
cellsunday.BorderWidthRight = 1;
cellsunday.HorizontalAlignment = 1;
cellsunday.Colspan = 3;
table.AddCell(cellsunday);
cell.Phrase = new Phrase(Convert.ToString(Convert.ToDecimal(item.HorasMonday) + Convert.ToDecimal(item.HorasTuesday) + Convert.ToDecimal(item.HorasWendnsday) + Convert.ToDecimal(item.HorasThursday) + Convert.ToDecimal(item.HorasFriday) + Convert.ToDecimal(item.HorasSaturday) + Convert.ToDecimal(item.HorasSunday)));
cell.HorizontalAlignment = 1;
table.AddCell(cell);
//table.Rows.Add(cell);
//
}
return table;
}
