public JsonResult GetLeadschildren(string centerId, string programId, int reqPage, int pgSize, int skipRow, string searchText = "") { List <LeadsChildren> leadsChildrenlist = new List <LeadsChildren>(); ChildrenInfoClass childInfo = new ChildrenInfoClass(); try { CenterAnalysisParameters leadsParam = new CenterAnalysisParameters { CenterId = (centerId == "0") ? 0 : Convert.ToInt64(EncryptDecrypt.Decrypt64(centerId)), ProgramId = (programId == "0") ? 0 : Convert.ToInt64(EncryptDecrypt.Decrypt64(programId.ToString())), Skip = skipRow, Take = pgSize, RequestedPage = reqPage, SearchText = searchText }; childInfo = new ERSEAData().GetLeadsChildrenData(leadsParam); } catch (Exception ex) { clsError.WriteException(ex); } return(Json(childInfo, JsonRequestBehavior.AllowGet)); }
public ActionResult GETChildrenByCenter(string centerId, string classRoomId, string programId, int reqPage = 0, int pgSize = 0, int skipRow = 0, string searchText = "") { ChildrenInfoClass childrenInfo = new ChildrenInfoClass(); try { CenterAnalysisParameters CenterAnalysisParameters = new CenterAnalysisParameters { CenterId = (centerId == "0") ? 0 : Convert.ToInt64(EncryptDecrypt.Decrypt64(centerId)), ProgramId = (programId == "0") ? 0 : Convert.ToInt64(EncryptDecrypt.Decrypt64(programId.ToString())), ClassRoomId = (classRoomId == "0" || classRoomId == "")?0:Convert.ToInt64(EncryptDecrypt.Decrypt64(classRoomId)), Skip = skipRow, Take = pgSize, RequestedPage = reqPage, SearchText = searchText }; childrenInfo = new ERSEAData().GetChildrenByCenter(CenterAnalysisParameters); } catch (Exception ex) { clsError.WriteException(ex); } return(Json(childrenInfo, JsonRequestBehavior.AllowGet)); }
public ActionResult GETChildrenByCenter(string CenterID, string programId) { ChildrenInfoClass childrenInfo = new ChildrenInfoClass(); try { var centerId = EncryptDecrypt.Decrypt64(CenterID); var AgencyId = Session["AgencyID"].ToString(); ERSEAData centerlist = new ERSEAData(); long programID = (programId == "0") ? 0 : Convert.ToInt64(EncryptDecrypt.Decrypt64(programId.ToString())); childrenInfo = centerlist.GetChildrenByCenter(centerId, AgencyId, programID); } catch (Exception ex) { clsError.WriteException(ex); } return(Json(childrenInfo, JsonRequestBehavior.AllowGet)); }
public ActionResult GetChildrenByClassRoom(string centerId, string classroomId, string programId, int reqPage = 0, int pgSize = 0, int skipRow = 0) { List <ChildrenInfo> children_List = new List <ChildrenInfo>(); ChildrenInfoClass childInfoClass = new ChildrenInfoClass(); try { CenterAnalysisParameters getchildClassParameter = new CenterAnalysisParameters { CenterId = (centerId == "0") ? 0 : Convert.ToInt64(EncryptDecrypt.Decrypt64(centerId)), ProgramId = (programId == "0") ? 0 : Convert.ToInt64(EncryptDecrypt.Decrypt64(programId.ToString())), Skip = skipRow, Take = pgSize, RequestedPage = reqPage, ClassRoomId = (classroomId == "0" || classroomId == "") ? 0 : Convert.ToInt64(EncryptDecrypt.Decrypt64(classroomId)) }; childInfoClass = new ERSEAData().GetChildrenByClassRoom(getchildClassParameter); } catch (Exception ex) { clsError.WriteException(ex); } return(Json(childInfoClass, JsonRequestBehavior.AllowGet)); }
public ActionResult DownloadERSEAReport(string centerId, string programId, string reportFor, bool isAllCenter) { try { ChildrenInfoClass infoModel = new ChildrenInfoClass(); List <SelectListItem> parentNameList = new List <SelectListItem>(); Export export = new Export(); Response.Clear(); Response.Buffer = true; Response.Charset = ""; Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; //Response.AddHeader("content-disposition", "attachment;filename=ERSEA Status Report " + DateTime.Now.ToString("MM/dd/yyyy") + ".xlsx"); CenterAnalysisParameters parameters = new CenterAnalysisParameters { CenterId = (centerId == "0") ? 0 : Convert.ToInt64(EncryptDecrypt.Decrypt64(centerId)), ProgramId = (programId == "0") ? 0 : Convert.ToInt64(EncryptDecrypt.Decrypt64(programId.ToString())), RequestedPage = 1, SearchText = "", Take = 500, Skip = 0 }; switch (reportFor) { case "#FosterDisplaymodal": Response.AddHeader("content-disposition", "attachment;filename=Enrolled Client Report " + DateTime.Now.ToString("MM/dd/yyyy") + ".xlsx"); infoModel = new ERSEAData().GetChildrenByCenter(parameters); break; case "#EnrolledModal": Response.AddHeader("content-disposition", "attachment;filename=Enrolled Client Report " + DateTime.Now.ToString("MM/dd/yyyy") + ".xlsx"); infoModel = new ERSEAData().GetEnrolledChildrenData(parameters); break; case "#WithdrawnModal": Response.AddHeader("content-disposition", "attachment;filename=Withdrawn Client Report " + DateTime.Now.ToString("MM/dd/yyyy") + ".xlsx"); infoModel = new ERSEAData().GetWithdrawnChildList(parameters); break; case "#DroppedModal": Response.AddHeader("content-disposition", "attachment;filename=Dropped Client Report " + DateTime.Now.ToString("MM/dd/yyyy") + ".xlsx"); infoModel = new ERSEAData().GetDroppedChildList(parameters); break; case "#WaitingModal": Response.AddHeader("content-disposition", "attachment;filename=Waiting Client Report " + DateTime.Now.ToString("MM/dd/yyyy") + ".xlsx"); infoModel = new ERSEAData().GetWatitingChildrenData(parameters); break; case "#ReturningModal": Response.AddHeader("content-disposition", "attachment;filename=Returning Client Report " + DateTime.Now.ToString("MM/dd/yyyy") + ".xlsx"); infoModel = new ERSEAData().GetReturningChildren(parameters); break; case "#GraduatingModal": Response.AddHeader("content-disposition", "attachment;filename=Graduating Client Report " + DateTime.Now.ToString("MM/dd/yyyy") + ".xlsx"); infoModel = new ERSEAData().GetGraduatingChildrenData(parameters); break; case "#OverIncomeModal": Response.AddHeader("content-disposition", "attachment;filename=Over Income Client Report " + DateTime.Now.ToString("MM/dd/yyyy") + ".xlsx"); infoModel = new ERSEAData().GetOverIncomeChildrenData(out parentNameList, parameters); break; case "#FosterModal": Response.AddHeader("content-disposition", "attachment;filename=Foster Client Report " + DateTime.Now.ToString("MM/dd/yyyy") + ".xlsx"); infoModel = new ERSEAData().GetFosterChildData(parameters); break; case "#HomeLessModal": Response.AddHeader("content-disposition", "attachment;filename=Homeless Client Report " + DateTime.Now.ToString("MM/dd/yyyy") + ".xlsx"); infoModel = new ERSEAData().GetHomelessChildrenData(parameters); break; case "#ExternalLeadsModal": Response.AddHeader("content-disposition", "attachment;filename=External Leads Report " + DateTime.Now.ToString("MM/dd/yyyy") + ".xlsx"); infoModel = new ERSEAData().GetLeadsChildrenData(parameters); break; } System.IO.MemoryStream ms = export.ExportERSEACenterAnalysisReport(reportFor, infoModel, parentNameList, isAllCenter); ms.WriteTo(Response.OutputStream); Response.Flush(); Response.End(); return(View()); // return File(fullPath, "application/vnd.ms-excel", file); } catch (Exception Ex) { clsError.WriteException(Ex); return(Json("Error occurred please try again.")); } }