public ActionResult AddSession(mst_session mst)
{
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
String query = "select count(*) from mst_session where session_active = 'Y'";
int id = con.ExecuteScalar <int>(query);
if (id > 0)
{
ModelState.AddModelError(String.Empty, "Admission is already open in other session");
return(View());
}
if (mst.session_end_date < System.DateTime.Now.AddMinutes(dateTimeOffSet) && mst.session_active == "Y")
{
ModelState.AddModelError(String.Empty, "You cannot open admission in expired session");
return(View(mst));
}
mst_sessionMain mstMain = new mst_sessionMain();
mstMain.AddSession(mst);
return(RedirectToAction("AllSessionList"));
}
}
public ActionResult EditSession(mst_session mst)
{
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
string query = "select session_finalize from mst_session where session = @session";
string id1 = con.ExecuteScalar <string>(query, new { session = mst.session });
if (id1 != mst.session_finalize && id1 == "Y")
{
ModelState.AddModelError(String.Empty, "Session already finalized cannot change.");
mst.session_finalize = "Y";
return(View(mst));
}
query = "select session_active from mst_session where session = @session";
id1 = con.ExecuteScalar <string>(query, new { session = mst.session });
if (id1 != mst.session_finalize && id1 == "N")
{
ModelState.AddModelError(String.Empty, "Session already closed cannot change.");
mst.session_active = "N";
return(View(mst));
}
if (mst.session_end_date < System.DateTime.Now.AddMinutes(dateTimeOffSet) && mst.session_active == "Y")
{
ModelState.AddModelError(String.Empty, "Session " + mst.session + " already expire you cannot change");
return(View(mst));
}
mst_sessionMain stdMain = new mst_sessionMain();
stdMain.EditSession(mst);
return(RedirectToAction("AllSessionList"));
}
}
public void pdfClassAssignment(int class_id, int section_id, int month_no, string session)
{
using (MemoryStream ms = new MemoryStream())
{
using (Document doc = new Document(PageSize.A4.Rotate()))
{
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
string query = @"SELECT
b.subject_name,
a.subject_id,
CONCAT(IFNULL(c.FirstName, ''),
' ',
IFNULL(c.LastName, '')) teacher_name
FROM
mst_class_subject_teacher a,
mst_subject b,
emp_profile c
WHERE
a.session = b.session
AND a.subject_id = b.subject_id
AND a.class_id = @class_id
AND a.session = @session
AND a.section_id = @section_id
AND a.subject_teacher_id = c.user_id";
IEnumerable <class_subject> class_subject = con.Query <class_subject>(query, new { class_id = class_id, session = session, section_id = section_id });
query = @"SELECT
CONCAT('Class: ',
class_name,
' ',
'Section: ',
section_name) class_name
FROM
mst_section a,
mst_class b
WHERE
a.session = b.session
AND a.class_id = b.class_id
AND a.session = @session
AND b.class_id = @class_id
AND a.section_id = @section_id";
string class_name = con.Query <string>(query, new { class_id = class_id, session = session, section_id = section_id }).SingleOrDefault();
PdfWriter writer = PdfWriter.GetInstance(doc, ms);
// writer.PageEvent = new PDFFooter();
doc.Open();
PdfPTable pt = new PdfPTable(10);
pt.WidthPercentage = 90;
// string imageURL = "E:\\HPS\\logo.jpg";
string imageURL = System.Web.Hosting.HostingEnvironment.MapPath("/images/logo.jpg");
Image jpg = Image.GetInstance(imageURL);
jpg.ScaleAbsolute(60f, 60f);
imageURL = System.Web.Hosting.HostingEnvironment.MapPath("/images/cbse.png");
Image cbse = Image.GetInstance(imageURL);
cbse.ScaleAbsolute(60f, 60f);
PdfPCell _cell;
Chunk text;
Phrase ph;
_cell = new PdfPCell(cbse);
_cell.Border = 0;
_cell.Border = Rectangle.NO_BORDER;
_cell.PaddingBottom = 5;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
pt.AddCell(_cell);
text = new Chunk(SchoolName, FontFactory.GetFont("Areal", 24));
ph = new Phrase();
ph.Add(text);
ph.Add("\n");
ph.Add("\n");
text = new Chunk("(" + Affiliation + ")", FontFactory.GetFont("Areal", 12));
ph.Add(text);
_cell = new PdfPCell(ph);
_cell.Colspan = 8;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
_cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
_cell.PaddingBottom = 5;
//_cell.BackgroundColor = BaseColor.LIGHT_GRAY;
pt.AddCell(_cell);
ph = new Phrase();
_cell = new PdfPCell(jpg);
_cell.Border = 0;
_cell.Border = Rectangle.NO_BORDER;
_cell.PaddingBottom = 5;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
pt.AddCell(_cell);
ph = new Phrase();
text = new Chunk("\n", FontFactory.GetFont("Areal", 12));
ph.Add(text);
_cell = new PdfPCell(ph);
_cell.Colspan = 10;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
_cell.Border = iTextSharp.text.Rectangle.TOP_BORDER;
_cell.PaddingBottom = 5;
//_cell.BackgroundColor = BaseColor.LIGHT_GRAY;
pt.AddCell(_cell);
mst_sessionMain sess = new mst_sessionMain();
mst_session mst = sess.getStartEndDate(session);
int year = 0;
if (month_no == 1 || month_no == 2 || month_no == 3)
{
year = mst.session_end_date.Year;
}
else
{
year = mst.session_start_date.Year;
}
ph = new Phrase();
text = new Chunk("Date-wise Assignment Chart for the Month of " + CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(month_no) + " " + year.ToString() + " " + class_name, FontFactory.GetFont("Areal", 15));
ph.Add(text);
_cell = new PdfPCell(ph);
_cell.Colspan = 10;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
_cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
_cell.PaddingBottom = 5;
//_cell.BackgroundColor = BaseColor.LIGHT_GRAY;
pt.AddCell(_cell);
ph = new Phrase();
text = new Chunk("\n", FontFactory.GetFont("Areal", 12));
ph.Add(text);
_cell = new PdfPCell(ph);
_cell.Colspan = 10;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
_cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
_cell.PaddingBottom = 5;
//_cell.BackgroundColor = BaseColor.LIGHT_GRAY;
pt.AddCell(_cell);
doc.Add(pt);
var date_list = getAllDates(year, month_no);
pt = new PdfPTable(date_list.Count() + 12);
pt.WidthPercentage = 95f;
doc.Add(pt);
var startOfMonth = new DateTime(year, month_no, 1);
var endOfMonth = startOfMonth.AddMonths(1).AddDays(-1);
query = @"SELECT
subject_id,work_type,DAY(work_date) day
FROM
mst_class_notebook
WHERE
class_id = @class_id AND session = @session
AND work_date BETWEEN @startOfMonth AND @endOfMonth
AND section_id = @section_id";
IEnumerable <mst_class_notebook> CW_HW = con.Query <mst_class_notebook>(query, new { session = session, class_id = class_id, section_id = section_id, startOfMonth = startOfMonth, endOfMonth = endOfMonth });
foreach (class_subject dtt in class_subject)
{
ph = new Phrase();
text = new Chunk("Teacher Name", FontFactory.GetFont("Areal", 8));
ph.Add(text);
_cell = new PdfPCell(ph);
_cell.Colspan = 5;
_cell.BackgroundColor = BaseColor.LIGHT_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
_cell.VerticalAlignment = Element.ALIGN_MIDDLE;
pt.AddCell(_cell);
ph = new Phrase();
text = new Chunk("Subject Name", FontFactory.GetFont("Areal", 8));
ph.Add(text);
_cell = new PdfPCell(ph);
_cell.Colspan = 4;
_cell.BackgroundColor = BaseColor.LIGHT_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
_cell.VerticalAlignment = Element.ALIGN_MIDDLE;
pt.AddCell(_cell);
ph = new Phrase();
text = new Chunk("W.Type", FontFactory.GetFont("Areal", 8));
ph.Add(text);
_cell = new PdfPCell(ph);
_cell.Colspan = 3;
_cell.BackgroundColor = BaseColor.LIGHT_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
_cell.VerticalAlignment = Element.ALIGN_MIDDLE;
pt.AddCell(_cell);
for (int i = 0; i <= date_list.Count() - 1; i++)
{
ph = new Phrase();
text = new Chunk(date_list[i].Day.ToString(), FontFactory.GetFont("Areal", 8));
ph.Add(text);
ph.Add("\n");
text = new Chunk(date_list[i].DayOfWeek.ToString().Substring(0, 1), FontFactory.GetFont("Areal", 8));
ph.Add(text);
_cell = new PdfPCell(ph);
_cell.BackgroundColor = BaseColor.LIGHT_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
pt.AddCell(_cell);
}
ph = new Phrase();
text = new Chunk(dtt.teacher_name, FontFactory.GetFont("Areal", 8));
ph.Add(text);
_cell = new PdfPCell(ph);
_cell.Colspan = 5;
_cell.Rowspan = 2;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
_cell.VerticalAlignment = Element.ALIGN_MIDDLE;
pt.AddCell(_cell);
ph = new Phrase();
text = new Chunk(dtt.subject_name, FontFactory.GetFont("Areal", 8));
ph.Add(text);
_cell = new PdfPCell(ph);
_cell.Colspan = 4;
_cell.Rowspan = 2;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
_cell.VerticalAlignment = Element.ALIGN_MIDDLE;
pt.AddCell(_cell);
ph = new Phrase();
text = new Chunk("C.W", FontFactory.GetFont("Areal", 8));
ph.Add(text);
_cell = new PdfPCell(ph);
_cell.Colspan = 3;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
pt.AddCell(_cell);
for (int i = 0; i <= date_list.Count() - 1; i++)
{
var check = (from e in CW_HW where e.day == i + 1 where e.subject_id == dtt.subject_id where e.work_type == "CW" select e).ToList();
if (check.Count() > 0)
{
ph = new Phrase();
if (System.DateTime.Now >= startOfMonth && System.DateTime.Now <= endOfMonth)
{
if (i <= System.DateTime.Now.Day - 1)
{
text = new Chunk("Y", FontFactory.GetFont("Areal", 8, BaseColor.BLACK));
}
else
{
text = new Chunk("", FontFactory.GetFont("Areal", 8, BaseColor.BLACK));
}
}
else
{
text = new Chunk("Y", FontFactory.GetFont("Areal", 8, BaseColor.BLACK));
}
ph.Add(text);
_cell = new PdfPCell(ph);
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
pt.AddCell(_cell);
}
else
{
ph = new Phrase();
if (System.DateTime.Now >= startOfMonth && System.DateTime.Now <= endOfMonth)
{
if (i <= System.DateTime.Now.Day - 1)
{
text = new Chunk("N", FontFactory.GetFont("Areal", 8, BaseColor.RED));
}
else
{
text = new Chunk("", FontFactory.GetFont("Areal", 8, BaseColor.RED));
}
}
else
{
text = new Chunk("N", FontFactory.GetFont("Areal", 8, BaseColor.RED));
}
ph.Add(text);
_cell = new PdfPCell(ph);
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
pt.AddCell(_cell);
}
}
ph = new Phrase();
text = new Chunk("H.W", FontFactory.GetFont("Areal", 8));
ph.Add(text);
_cell = new PdfPCell(ph);
_cell.Colspan = 3;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
pt.AddCell(_cell);
for (int i = 0; i <= date_list.Count() - 1; i++)
{
var check = (from e in CW_HW where e.day == i + 1 where e.subject_id == dtt.subject_id where e.work_type == "HW" select e).ToList();
if (check.Count() > 0)
{
ph = new Phrase();
if (System.DateTime.Now >= startOfMonth && System.DateTime.Now <= endOfMonth)
{
if (i <= System.DateTime.Now.Day - 1)
{
text = new Chunk("Y", FontFactory.GetFont("Areal", 8, BaseColor.BLACK));
}
else
{
text = new Chunk("", FontFactory.GetFont("Areal", 8, BaseColor.BLACK));
}
}
else
{
text = new Chunk("Y", FontFactory.GetFont("Areal", 8, BaseColor.BLACK));
}
ph.Add(text);
_cell = new PdfPCell(ph);
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
pt.AddCell(_cell);
}
else
{
ph = new Phrase();
if (System.DateTime.Now >= startOfMonth && System.DateTime.Now <= endOfMonth)
{
if (i <= System.DateTime.Now.Day - 1)
{
text = new Chunk("N", FontFactory.GetFont("Areal", 8, BaseColor.RED));
}
else
{
text = new Chunk("", FontFactory.GetFont("Areal", 8, BaseColor.RED));
}
}
else
{
text = new Chunk("N", FontFactory.GetFont("Areal", 8, BaseColor.RED));
}
ph.Add(text);
_cell = new PdfPCell(ph);
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
pt.AddCell(_cell);
}
}
ph = new Phrase();
text = new Chunk("\n", FontFactory.GetFont("Areal", 8));
ph.Add(text);
_cell = new PdfPCell(ph);
_cell.Colspan = date_list.Count() + 12;
_cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
pt.AddCell(_cell);
}
doc.Add(pt);
doc.Close();
byte[] bytes = ms.ToArray();
ms.Close();
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ContentType = "application/pdf";
HttpContext.Current.Response.AddHeader("Content-Disposition", "inline; filename=comparative_result.pdf");
HttpContext.Current.Response.ContentType = "application/pdf";
HttpContext.Current.Response.Buffer = true;
HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
HttpContext.Current.Response.BinaryWrite(bytes);
HttpContext.Current.Response.End();
HttpContext.Current.Response.Close();
}
}
}
}
