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 JsonResult GetgeometryByCounty(string County)
{
string geometry = string.Empty;
try
{
geometry = new ERSEAData().GetgeometryByCounty(County);
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(Json(geometry, JsonRequestBehavior.AllowGet));
}
public ActionResult InsertGeoJsonZipcode(string zipcode, string geometry)
{
bool Result = false;
try
{
Result = new ERSEAData().SaveGeoJsonZipcode(zipcode, geometry);
}
catch (Exception Ex)
{
clsError.WriteException(Ex);
}
return(Json(Result));
}
public JsonResult GetChartDataByZipCode(string zipcode)
{
CommunityAssessment communityassment = new FingerprintsModel.CommunityAssessment();
try
{
communityassment = new ERSEAData().GetChartDetailsDataByZip(zipcode);
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(Json(communityassment, JsonRequestBehavior.AllowGet));
}
public ActionResult GetZipcodesbystateandCity(string searchcity, string searchstate)
{
List <ZipByStateandCity> ZipcodestateCitylist = new List <ZipByStateandCity>();
City_State cityState = new City_State();
try
{
ZipcodestateCitylist = new ERSEAData().zipcodebycityandState(out cityState, searchcity, searchstate);
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(Json(new { ZipcodestateCitylist, cityState }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetZipcodesbystate(string searchText)
{
List <ZipcodebyState> Zipcodestatelist = new List <ZipcodebyState>();
ERSEAData zipcodeList = new ERSEAData();
try
{
Zipcodestatelist = zipcodeList.zipcodebyState(searchText);
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(Json(new { Zipcodestatelist }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetLeadschildren(string centerID)
{
List <LeadsChildren> leadsChildrenlist = new List <LeadsChildren>();
try
{
long CenterID = Convert.ToInt64(EncryptDecrypt.Decrypt64(centerID));
leadsChildrenlist = new ERSEAData().GetLeadsChildrenData(CenterID, new Guid(Session["AgencyId"].ToString()));
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(Json(leadsChildrenlist, JsonRequestBehavior.AllowGet));
}
public JsonResult GetChildrenImage(string enc_clientId)
{
SelectListItem item = new SelectListItem();
try
{
long clientId = Convert.ToInt64(EncryptDecrypt.Decrypt64(enc_clientId));
item = new ERSEAData().GetChildrenImageData(clientId);
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(Json(item, JsonRequestBehavior.AllowGet));
}
public JsonResult GetGraduatingChildren(string centerId, string programId)
{
List <ChildrenInfo> graduatingList = new List <ChildrenInfo>();
try
{
long centerID = Convert.ToInt64(EncryptDecrypt.Decrypt64(centerId));
long programID = (programId == "0") ? 0 : Convert.ToInt64(EncryptDecrypt.Decrypt64(programId));
graduatingList = new ERSEAData().GetGraduatingChildrenData(centerID, programID, new Guid(Session["AgencyId"].ToString()));
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(Json(graduatingList, JsonRequestBehavior.AllowGet));
}
public JsonResult GetFosterChild(string centerId, string programID)
{
List <FosterChild> fosterchildList = new List <FosterChild>();
try
{
long centerID = Convert.ToInt64(EncryptDecrypt.Decrypt64(centerId));
long programId = (programID == "0") ? 0 : Convert.ToInt64(EncryptDecrypt.Decrypt64(programID));
Guid userId = new Guid(Session["UserID"].ToString());
Guid AgencyId = new Guid(Session["AgencyId"].ToString());
fosterchildList = new ERSEAData().GetFosterChildData(centerID, programId, userId, AgencyId);
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(Json(fosterchildList, JsonRequestBehavior.AllowGet));
}
public JsonResult GetGraduatingChildByProgram(string programTypeID)
{
List <SelectListItem> gradChildList = new List <SelectListItem>();
long totalGradcount = 0;
try
{
long dec_ProgramId = programTypeID == "0" ? 0 : Convert.ToInt64(EncryptDecrypt.Decrypt64(programTypeID));
Guid agencyId = new Guid(Session["AgencyId"].ToString());
gradChildList = new ERSEAData().GetGradChildDataByProgram(out totalGradcount, dec_ProgramId, agencyId);
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(Json(new { gradChildList, totalGradcount }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetOverIncomeChildren(string centerId, string programId)
{
List <ChildrenInfo> overIncomeChildList = new List <ChildrenInfo>();
List <SelectListItem> ParentList = new List <SelectListItem>();
try
{
long programID = (programId == "0") ? 0 : Convert.ToInt64(EncryptDecrypt.Decrypt64(programId));
long centerID = Convert.ToInt64(EncryptDecrypt.Decrypt64(centerId));
overIncomeChildList = new ERSEAData().GetOverIncomeChildrenData(out ParentList, centerID, programID, new Guid(Session["AgencyId"].ToString()));
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(Json(new { overIncomeChildList, ParentList }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetHomelessChildren(string centerId, string programId)
{
List <HomelessChildren> homeLessChilren = new List <HomelessChildren>();
try
{
long programID = (programId == "0") ? 0 : Convert.ToInt64(EncryptDecrypt.Decrypt64(programId));
long centerID = Convert.ToInt64(EncryptDecrypt.Decrypt64(centerId));
ERSEAData homelessList = new ERSEAData();
homeLessChilren = new ERSEAData().GetHomelessChildrenData(centerID, programID, new Guid(Session["AgencyId"].ToString()));
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(Json(homeLessChilren, 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 JsonResult GetDroppedChildren(string centerId, string programId)
{
List <WaitingChildren> dropped = new List <WaitingChildren>();
JavaScriptSerializer js = new JavaScriptSerializer();
string jsonData = string.Empty;
try
{
long centerID = Convert.ToInt64(EncryptDecrypt.Decrypt64(centerId));
long programID = (programId == "0") ? 0 : Convert.ToInt64(EncryptDecrypt.Decrypt64(programId));
dropped = new ERSEAData().GetDroppedChildList(centerID, programID, new Guid(Session["AgencyId"].ToString()));
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(Json(dropped, JsonRequestBehavior.AllowGet));
}
public ActionResult GetChildrenByClassRoom(string CenterId, string classroomId, string programId)
{
List <ChildrenInfo> children_List = new List <ChildrenInfo>();
try
{
long dec_CenterId = Convert.ToInt64(EncryptDecrypt.Decrypt64(CenterId));
long dec_ClassRoomId = (classroomId == "0") ? 0 : Convert.ToInt64(EncryptDecrypt.Decrypt64(classroomId));
long dec_ProgramId = (programId == "0") ? 0 : Convert.ToInt64(EncryptDecrypt.Decrypt64(programId));
Guid AgencyId = new Guid(Session["AgencyID"].ToString());
children_List = new ERSEAData().GetChildrenByClassRoom(dec_CenterId, AgencyId, dec_ClassRoomId, dec_ProgramId);
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(Json(children_List, JsonRequestBehavior.AllowGet));
}
public JsonResult GetCenterAnalysisList(string programId)
{
List <SelectListItem> programList = new List <SelectListItem>();
List <CenterAnalysis> centerAnalysisList = new List <FingerprintsModel.CenterAnalysis>();
CenterAnalysisPercentage calcAnalysis = new CenterAnalysisPercentage();
try
{
Guid userId = new Guid(Session["UserID"].ToString());
Guid AgencyId = new Guid(Session["AgencyId"].ToString());
long dec_ProgramId = programId == "0" ? 0 : Convert.ToInt64(EncryptDecrypt.Decrypt64(programId));
centerAnalysisList = new ERSEAData().GetCenterAnalysisList(out calcAnalysis, out programList, userId, AgencyId, dec_ProgramId);
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(Json(new { centerAnalysisList, calcAnalysis, programList }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetWorkShopAnalysis(long centerId)
{
List <WorkShopAnalysis> workshopList = new List <WorkShopAnalysis>();
List <SelectListItem> centerList = new List <SelectListItem>();
bool isLink = false;
try
{
Guid AgencyId = new Guid(Session["AgencyId"].ToString());
Guid userId = new Guid(Session["UserID"].ToString());
Guid roleId = new Guid(Session["RoleId"].ToString());
workshopList = new ERSEAData().GetWorkshopAnalysisList(out centerList, AgencyId, roleId, userId, centerId);
isLink = (Session["RoleId"].ToString() == "b4d86d72-0b86-41b2-adc4-5ccce7e9775b");
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(Json(new { workshopList, centerList, isLink }, 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."));
}
}
public ERSEADashBoard GetERSEADashboard()
{
ERSEADashBoard obj = new ERSEADashBoard();
try
{
//get the Json filepath
//string file = Server.MapPath("~/Content/JSON/us_census_zipcode.json");E:\Pandian\Git Repository\Fingerprints-Production\Fingerprints\Views\ERSEA\ADAByCenter.cshtml
//deserialize JSON from file
//var Json = System.IO.File.ReadAllText(file);
List <ApplicationEnrollment> lstApplication = new List <ApplicationEnrollment>();
List <ADA> lstADA = new List <ADA>();
List <CityName> lstCityName = new List <CityName>();
int firstMonth = 0;
new ERSEAData().GetApplicationEnrollmentBasedonZip(ref lstApplication, Session["AgencyID"].ToString());
// obj = new ERSEAData().GetADABasedonCenter(ref lstADA, ref firstMonth, Session["AgencyID"].ToString());
obj = new ERSEAData().GetADABasedonCenter(ref lstADA, ref firstMonth);
new ERSEAData().GetCityName(ref lstCityName);
// var firstnM = Enum.GetName(typeof(Month), 0);
if (lstApplication.Count() > 0)
{
foreach (ApplicationEnrollment objEnroll in lstApplication)
{
Object city = lstCityName.Where(a => a.Zipcode.Contains(objEnroll.ZipCode)).Select(a => a.City).FirstOrDefault();
Object primarycity = lstCityName.Where(a => a.Zipcode.Contains(objEnroll.ZipCode)).Select(a => a.PrimaryCity).FirstOrDefault();
if (city != null || primarycity != null)
{
if (primarycity != null)
{
objEnroll.CityName = primarycity.ToString();
}
else
{
objEnroll.CityName = city.ToString();
}
}
}
}
obj.lstApplication = lstApplication;
int count = (obj.listADA.Count() > 0) ? obj.listADA.Count() * 100 : 0;
if (count > 0)
{
obj.TotalADA.Jan = Math.Round((obj.listADA.Sum(a => a.Jan) / count) * 100, 1, MidpointRounding.ToEven);
obj.TotalADA.Feb = Math.Round((obj.listADA.Sum(a => a.Feb) / count) * 100, 1, MidpointRounding.ToEven);
obj.TotalADA.Mar = Math.Round((obj.listADA.Sum(a => a.Mar) / count) * 100, 1, MidpointRounding.ToEven);
obj.TotalADA.Apr = Math.Round((obj.listADA.Sum(a => a.Apr) / count) * 100, 1, MidpointRounding.ToEven);
obj.TotalADA.May = Math.Round((obj.listADA.Sum(a => a.May) / count) * 100, 1, MidpointRounding.ToEven);
obj.TotalADA.Jun = Math.Round((obj.listADA.Sum(a => a.Jun) / count) * 100, 1, MidpointRounding.ToEven);
obj.TotalADA.Jul = Math.Round((obj.listADA.Sum(a => a.Jul) / count) * 100, 1, MidpointRounding.ToEven);
obj.TotalADA.Aug = Math.Round((obj.listADA.Sum(a => a.Aug) / count) * 100, 1, MidpointRounding.ToEven);
obj.TotalADA.Sep = Math.Round((obj.listADA.Sum(a => a.Sep) / count) * 100, 1, MidpointRounding.ToEven);
obj.TotalADA.Oct = Math.Round((obj.listADA.Sum(a => a.Oct) / count) * 100, 1, MidpointRounding.ToEven);
obj.TotalADA.Nov = Math.Round((obj.listADA.Sum(a => a.Nov) / count) * 100, 1, MidpointRounding.ToEven);
obj.TotalADA.Dec = Math.Round((obj.listADA.Sum(a => a.Dec) / count) * 100, 1, MidpointRounding.ToEven);
}
// decimal total = (obj.TotalADA.Jan + obj.TotalADA.Feb + obj.TotalADA.Mar + obj.TotalADA.Apr + obj.TotalADA.May + obj.TotalADA.Jun + obj.TotalADA.Jul + obj.TotalADA.Aug + obj.TotalADA.Sep + obj.TotalADA.Oct + obj.TotalADA.Nov + obj.TotalADA.Dec); //0643
//decimal total = (lstADA.Sum(a => a.Jan) + lstADA.Sum(a => a.Feb) + lstADA.Sum(a => a.Mar) + lstADA.Sum(a => a.Apr) + lstADA.Sum(a => a.May) + lstADA.Sum(a => a.Jun) + lstADA.Sum(a => a.Jul) + lstADA.Sum(a => a.Aug) + lstADA.Sum(a => a.Sep) + lstADA.Sum(a => a.Oct) + lstADA.Sum(a => a.Nov) + lstADA.Sum(a => a.Dec));
if (count == 0)
{
}
// ViewBag.OverAllPercentage = Math.Round((total / (300)) * 100, 0);
// obj.OverAllPercentage = Math.Round((total / (12)), 0); //0643
obj.OverAllApplication = lstApplication.Sum(a => a.Application);
obj.OverAllEnrollment = lstApplication.Sum(a => a.Enrollment);
obj.OverAllWithdrawn = lstApplication.Sum(a => a.Withdrawn);
obj.OverAllDropped = lstApplication.Sum(a => a.Dropped);
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
// return View(obj);
return(obj);
}