public DataTableFilterModel GetParemeterTypeList(DataTableFilterModel filter)
{
var data = _context.tblParameterTypes.AsQueryable();
var info = data.Select(model => new ParameterTypeViewModel
{
Id = model.Id,
Name = model.Name,
IsActive = model.IsActive
}).AsEnumerable();
var totalCount = info.Count();
if (!string.IsNullOrWhiteSpace(filter.search.value))
{
info = info.Where(d => !string.IsNullOrEmpty(d.Name) && d.Name.ToLower().Contains(filter.search.value.ToLower()));
}
var o = filter.order[0];
var name = filter.columns[filter.order[0].column].data;
if (o.dir == "asc")
{
info = info.OrderBy(x => x.GetType().GetProperty(name).GetValue(x));
}
else
{
info = info.OrderByDescending(x => x.GetType().GetProperty(name).GetValue(x));
}
var filteredCount = info.Count();
filter.recordsTotal = totalCount;
filter.recordsFiltered = filteredCount;
filter.data = info.Skip(filter.start).Take(filter.length).ToList();
return(filter);
}
public ActionResult GetCandidateList(DataTableFilterModel filter)
{
try
{
DataTableFilterModel dataFilter = _perforamnce.GetCandidateList(filter);
return(Json(new { draw = filter.draw, recordsFiltered = dataFilter.recordsFiltered, recordsTotal = dataFilter.recordsTotal, data = dataFilter.data },
JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{ }
return(Json(new { }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetParameterList(DataTableFilterModel filter, int ParameterTypeId)
{
try
{
DataTableFilterModel dataFilter = _parameterTypeService.GetParemeterList(filter, ParameterTypeId);
return(Json(new { draw = filter.draw, recordsFiltered = dataFilter.recordsFiltered, recordsTotal = dataFilter.recordsTotal, data = dataFilter.data },
JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{ }
return(Json(new { }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetAddmissionList(DataTableFilterModel filter)
{
try
{
DataTableFilterModel dataFilter = addmissionService.GetApprovedStudentList(filter);
return(Json(new { draw = filter.draw, recordsFiltered = dataFilter.recordsFiltered, recordsTotal = dataFilter.recordsTotal, data = dataFilter.data },
JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
}
return(Json(new { }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetCallCenterRemarks(DataTableFilterModel filter, int RegNo)
{
try
{
DataTableFilterModel dataFilter = callCenterInfoService.GetCallCenterRemarkList(filter, RegNo);
return(Json(new { draw = filter.draw, recordsFiltered = dataFilter.recordsFiltered, recordsTotal = dataFilter.recordsTotal, data = dataFilter.data },
JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
}
return(Json(new { }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetFeeTypeDetailsList(DataTableFilterModel filter)
{
try
{
DataTableFilterModel dataFilter = feeCollectionService.GetFeeTypeDetailList(filter);
return(Json(new { draw = filter.draw, recordsFiltered = dataFilter.recordsFiltered, recordsTotal = dataFilter.recordsTotal, data = dataFilter.data },
JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
}
return(Json(new { }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetBatchListinfo(DataTableFilterModel filter)
{
try
{
DataTableFilterModel dataFilter = _adminService.GetAdmissionBatchListinfo(filter);
return(Json(new { draw = filter.draw, recordsFiltered = dataFilter.recordsFiltered, recordsTotal = dataFilter.recordsTotal, data = dataFilter.data },
JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
}
return(Json(new { }, JsonRequestBehavior.AllowGet));
}
public ActionResult WithdrawalCandidateList(DataTableFilterModel filter)
{
try
{
int currDate = Convert.ToInt32(Session["CurrentYear"]);
DataTableFilterModel dataFilter = registerService.GetWithdrawalCandidateList(filter, currDate);
return(Json(new { draw = filter.draw, recordsFiltered = dataFilter.recordsFiltered, recordsTotal = dataFilter.recordsTotal, data = dataFilter.data },
JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
}
return(Json(new { }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetRagisterList(DataTableFilterModel filter, string Tag = null)
{
try
{
int currDate = Convert.ToInt32(Session["CurrentYear"]);
Session["filter"] = Newtonsoft.Json.JsonConvert.SerializeObject(filter);
DataTableFilterModel dataFilter = registerService.GetProjectList(filter, currDate, Tag);
return(Json(new { draw = filter.draw, recordsFiltered = dataFilter.recordsFiltered, recordsTotal = dataFilter.recordsTotal, data = dataFilter.data },
JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
}
return(Json(new { }, JsonRequestBehavior.AllowGet));
}
public DataTableFilterModel GetCallCenterRemarkList(DataTableFilterModel filter, int RegNo)
{
var info = _context.CallCenterRemarks.Where(c => c.RegistrationNo == RegNo).Select(model => new CallCenterRemarkViewModel()
{
Id = model.Id,
Remarks = model.Remarks,
EnteredByName = model.UserLogin.Fname + " " + model.UserLogin.LName,
EnteredDate = model.EnteredDate
}).AsEnumerable();
var totalCount = info.Count();
if (!string.IsNullOrWhiteSpace(filter.search.value))
{
info = info.Where(d => (d.Remarks.ToLower().Contains(filter.search.value.ToLower()) || d.EnteredByName.ToLower().Contains(filter.search.value.ToLower()) || d.EnteredDate.ToString().ToLower().Contains(filter.search.value.ToLower())));
}
var o = filter.order[0];
var name = filter.columns[filter.order[0].column].data;
if (o.dir == "asc")
{
info = info.OrderBy(x => x.GetType().GetProperty(name).GetValue(x));
}
else
{
info = info.OrderByDescending(x => x.GetType().GetProperty(name).GetValue(x));
}
var filteredCount = info.Count();
filter.recordsTotal = totalCount;
filter.recordsFiltered = filteredCount;
var dataFilter = info.Skip(filter.start).Take(filter.length).ToList();
foreach (var i in dataFilter)
{
i.CreateDate = i.EnteredDate.ToString("dd-MM-yyyy");
}
filter.data = dataFilter;
return(filter);
}
public DataTableFilterModel GetFeeTypeDetailList(DataTableFilterModel filter)
{
var data = _context.ptaFeeTypeDetails
.Select(a => new FeeTypeDetailViewModel
{
Id = a.Id,
FeeTypeName = a.ptaFeeType.Name,
Amount = a.Amount,
SessionName = a.SessionMaster.SessionName,
CourseName = a.CourseMaster.CourseName,
IsActive = a.IsActive
}).AsEnumerable();
var totalCount = data.Count();
if (!string.IsNullOrWhiteSpace(filter.search.value))
{
data = data.Where(d => (d.FeeTypeName.ToLower().Contains(filter.search.value.ToLower()) || d.SessionName.ToLower().Contains(filter.search.value.ToLower()) || (!string.IsNullOrEmpty(d.CourseName) && d.CourseName.ToLower().Contains(filter.search.value.ToLower()))));
}
var o = filter.order[0];
var name = filter.columns[filter.order[0].column].data;
if (o.dir == "asc")
{
data = data.OrderBy(x => x.GetType().GetProperty(name).GetValue(x));
}
else
{
data = data.OrderByDescending(x => x.GetType().GetProperty(name).GetValue(x));
}
var filteredCount = data.Count();
filter.recordsTotal = totalCount;
filter.recordsFiltered = filteredCount;
var dataFilter = data.Skip(filter.start).Take(filter.length).ToList();
filter.data = dataFilter;
return(filter);
}
public DataTableFilterModel GetUsers(DataTableFilterModel filter)
{
var data = db.users.Select(c => new
{
ProfileImage = c.profile_pic,
Name = c.first_name,
Email = c.email,
Password = c.password,
Status = c.is_active == true && c.is_delete == false ? "Active" : "Deactive",
CreatedDate = c.created_date,
RoleID = c.role_id,
})
.AsEnumerable();
var totalCount = data.Count();
if (!string.IsNullOrWhiteSpace(filter.search.value))
{
data = data.Where(d => (!string.IsNullOrEmpty(d.Name)) && d.Name.ToLower().Contains(filter.search.value.ToLower()) && d.RoleID == 1);
}
var o = filter.order[0];
var name = filter.columns[filter.order[0].column].data;
if (o.dir == "asc")
{
data = data.OrderBy(x => x.GetType().GetProperty(name).GetValue(x));
}
else
{
data = data.OrderByDescending(x => x.GetType().GetProperty(name).GetValue(x));
}
var filteredCount = data.Count();
filter.recordsTotal = totalCount;
filter.recordsFiltered = filteredCount;
filter.data = data.Skip(filter.start).Take(filter.length).ToList();
return(filter);
}
public DataTableFilterModel GetAdmissionBatchListinfo(DataTableFilterModel filter)
{
var data = _context.BatchMasters.Where(a => a.IsActive)
.Select(a => new
{
Id = a.Id,
Name = a.Name,
ActiveStr = a.IsActive ? "Yes" : "No",
BatchStartDate = a.DateOfStart,
BatchEndDate = a.DateOfEnd
}).ToList().Select(item => new RoleViewModel
{
Id = item.Id,
Name = item.Name,
ActiveStr = item.ActiveStr,
BatchStartDate = item.BatchStartDate,
BatchEndDate = item.BatchEndDate,
Year = Convert.ToInt32(item.Name.Split(' ')[1])
}).OrderBy(s => s.Year).AsEnumerable();
var totalCount = data.Count();
if (!string.IsNullOrWhiteSpace(filter.search.value))
{
data = data.Where(d => d.Name.ToString().ToLower().Contains(filter.search.value.ToLower()) || d.ActiveStr.ToLower().Contains(filter.search.value.ToLower()));
}
//var o = filter.order[0];
//var name = filter.columns[filter.order[0].column].data;
//if (o.dir == "asc")
// data = data.OrderBy(x => x.GetType().GetProperty(name).GetValue(x));
//else
// data = data.OrderByDescending(x => x.GetType().GetProperty(name).GetValue(x));
var filteredCount = data.Count();
filter.recordsTotal = totalCount;
filter.recordsFiltered = filteredCount;
filter.data = data.Skip(filter.start).Take(filter.length).ToList();
return(filter);
}
//=========================================================================================================
public DataTableFilterModel GetScreenningReportList(DataTableFilterModel filter, int SessionYr)
{
var data = _context.RegistrationMasters.Where(r => r.IsActive).AsQueryable();
data = data.Where(d => d.PaymentStatus || d.IsConsultantCandidate || d.IsHRCandidate);
if (SessionYr > 0)
data = data.Where(d => d.SessionMaster.SessionYr == SessionYr);
var info = data.Select(model => new RegistrationViewModel()
{
Id = model.Id,
DOB = model.DOB,
Email = model.Email.ToLower(),
Gender = model.Gender == "M" ? "Male" : "Female",
Mobile = model.Mobile,
PaymentStatus = model.PaymentStatus,
RegistartionNo = model.RegistartionNo,
RegistrationDate = model.RegistrationDate,
Fname = model.Fname,
Lname = model.Lname,
PaymentStatusStr = (model.IsConsultantCandidate ? "Consultent Candidate" : (model.IsHRCandidate ? "HR Candidate" : (model.PaymentStatus ? "Success" : "Pending"))),
IsScreenningClear = model.IsScreenningClear,
IsMedicalClear = model.IsMedicalClear,
CourseName = model.CourseMaster.CourseName,
MedicalRemark = model.MedicalRemark != null ? model.MedicalRemark : "",
IsStandBy = model.IsStandBy,
IsConsultantCandidate = model.IsConsultantCandidate,
IsHRCandidate = model.IsHRCandidate,
IsMedicalStandBy = model.IsMedicalStandBy,
CourseId = model.CourseId,
SessionId = model.SessionId,
IsFeePayStandBy = model.IsFeePayStandBy,
SourceOfCandidate = model.SourceOfCandidate != null ? model.SourceOfCandidate : "Empty",
ModOfPayment = model.ModOfPayment,
IsFeePayment = model.FeeDetails.Where(f => f.IsActive && f.FeeTypeDetail.FeeType.Name == "Admission").FirstOrDefault().FeePaymentDetails.Where(fpd => fpd.IsActive).FirstOrDefault().FeeCollections.Count > 0 ? true : false,
MedicalStatus = model.AddmissionMasters.Count > 0 ? model.AddmissionMasters.FirstOrDefault().MedicalDetails.FirstOrDefault().MedicalStatus : "",
AddMissionId = model.AddmissionMasters.Count > 0 ? model.AddmissionMasters.FirstOrDefault().Id : 0,
BatchName = model.AddmissionMasters.Count > 0 ? model.AddmissionMasters.FirstOrDefault().AddmissionDetails.FirstOrDefault().BatchMaster.Name : "",
BatchId = model.AddmissionMasters.Count > 0 ? model.AddmissionMasters.FirstOrDefault().AddmissionDetails.FirstOrDefault().BatchId.Value : 0
}).AsEnumerable();
if (!string.IsNullOrWhiteSpace(filter.columns[7].search.value) && filter.columns[7].search.value != "")
{
int batch = Convert.ToInt32(filter.columns[7].search.value);
info = info.Where(t => t.BatchId == batch);
if (string.IsNullOrWhiteSpace(filter.search.value))
info = info.Where(t => !t.IsStandBy && t.IsScreenningClear == true);
}
if (!string.IsNullOrWhiteSpace(filter.columns[9].search.value))
info = info.Where(t => t.CourseName == filter.columns[9].search.value);
if (!string.IsNullOrWhiteSpace(filter.columns[10].search.value))
{
if (filter.columns[10].search.value == "Selected")
info = info.Where(t => t.IsStandBy == false && t.IsScreenningClear == true);
else if (filter.columns[10].search.value == "Rejected")
info = info.Where(t => t.IsScreenningClear == false && t.IsStandBy == false);
else if (filter.columns[10].search.value == "Stand-By")
info = info.Where(t => t.IsStandBy == true);
else if (filter.columns[10].search.value == "Withdrwan")
info = info.Where(t => t.MedicalStatus == "Withdrawn");
else
info = info.Where(t => !t.IsScreenningClear == null);
}
if (!string.IsNullOrWhiteSpace(filter.search.value))
{
info = info.Where(d => (d.RegistartionNo.ToString().ToLower().Contains(filter.search.value.ToLower()) || (!string.IsNullOrEmpty(d.StudentName) && d.StudentName.ToLower().Contains(filter.search.value.ToLower())) || (!string.IsNullOrEmpty(d.Email) && d.Email.ToLower().Contains(filter.search.value.ToLower())) || (!string.IsNullOrEmpty(d.PaymentStatusStr) && d.PaymentStatusStr.ToString().ToLower().Contains(filter.search.value.ToLower())) || (!string.IsNullOrEmpty(d.Mobile) && d.Mobile.ToString().ToLower().Contains(filter.search.value.ToLower())) || (!string.IsNullOrEmpty(d.BatchName) && d.BatchName.ToString().ToLower().Contains(filter.search.value.ToLower()))));
}
var o = filter.order[0];
var name = filter.columns[filter.order[0].column].data;
if (o.dir == "asc")
info = info.OrderBy(x => x.GetType().GetProperty(name).GetValue(x));
else
info = info.OrderByDescending(x => x.GetType().GetProperty(name).GetValue(x));
if (!string.IsNullOrWhiteSpace(filter.columns[8].search.value))
info = info.Where(t => t.CourseName == filter.columns[8].search.value);
if (!string.IsNullOrWhiteSpace(filter.columns[5].search.value) && filter.columns[5].search.value != "" && !string.IsNullOrWhiteSpace(filter.columns[6].search.value) && filter.columns[6].search.value != "")
{
DateTime fromDate = DateTime.ParseExact(filter.columns[5].search.value, "dd/MM/yyyy", CultureInfo.InvariantCulture).Date;
DateTime toDate = DateTime.ParseExact(filter.columns[6].search.value, "dd/MM/yyyy", CultureInfo.InvariantCulture).Date;
info = info.Where(t => t.RegistrationDate.HasValue && t.RegistrationDate.Value.Date >= fromDate && t.RegistrationDate.Value.Date <= toDate);
}
filter.recordsFiltered = info.Count();
var dataFilter = filter.length > 0 ? info.Skip(filter.start).Take(filter.length).ToList() : info.ToList();
string[] RegList = dataFilter.Select(i => i.Email.ToLower()).ToArray();
if (RegList.Length > 0)
{
foreach (var item in dataFilter)
{
item.DateOfBirthNew = item.DateOfBirth;
}
}
filter.data = dataFilter;
return filter;
}
public DataTableFilterModel GetCallCenterInfoList(DataTableFilterModel filter, int SessionYr)
{
var data = _context.RegistrationMasters.Where(r => r.IsActive).AsQueryable();
//data = data.Where(r => r.AddmissionMasters.Any() && r.AddmissionMasters.FirstOrDefault().IsActive && (!r.IsMedicalClear.HasValue || r.IsMedicalClear.Value) && r.AddmissionMasters.FirstOrDefault().AddmissionDetails.FirstOrDefault().BatchId != 19);
data = data.Where(r => r.AddmissionMasters.Any() && (r.FeeDetails.Any() || !r.IsMedicalClear.HasValue || r.IsMedicalClear.Value) && ((r.AddmissionMasters.FirstOrDefault().AddmissionDetails.FirstOrDefault().BatchId == 19 && r.FeeDetails.Any()) || (r.AddmissionMasters.FirstOrDefault().IsActive&& r.AddmissionMasters.FirstOrDefault().AddmissionDetails.FirstOrDefault().BatchId != 19)));
if (SessionYr > 0)
{
data = data.Where(d => d.AddmissionMasters.FirstOrDefault().AddmissionDetails.FirstOrDefault().BatchMaster.DateOfStart.Value.Year == SessionYr);
}
var info = data.Select(model => new RegistrationViewModel()
{
Id = model.Id,
DOB = model.DOB,
Email = model.Email,
Gender = model.Gender == "M" ? "Male" : "Female",
Mobile = model.Mobile,
PaymentStatus = model.PaymentStatus,
RegistartionNo = model.RegistartionNo,
RegistrationDate = model.RegistrationDate,
Fname = model.Fname,
Lname = model.Lname,
//DateOfBirth = "",
CourseId = model.CourseId,
SessionId = model.SessionId,
PaymentDate = model.PaymentDate,
PaymentStatusStr = model.PaymentStatus ? "Success" : "Failed",
IsScreenningClear = model.IsScreenningClear,
IsMedicalClear = model.IsMedicalClear,
IsFeePayment = _context.FeeDetails.Where(f => f.IsActive && f.RegistrationNo == model.RegistartionNo && f.FeeTypeDetail.FeeType.Name == "Admission").FirstOrDefault().FeePaymentDetails.Where(fpd => fpd.IsActive).FirstOrDefault().FeeCollections.Any(), // _context.FIN_FeeReceiptMaster.Any(f => f.RegNo == model.RegistartionNo),
IsRefunded = _context.FIN_FeeRefundMaster.Any(f => f.RegNo == model.RegistartionNo),
CourseName = model.CourseMaster.CourseName,
AddMissionId = _context.AddmissionMasters.Any(a => a.RegistrationNo == model.RegistartionNo) ? _context.AddmissionMasters.Where(a => a.RegistrationNo == model.RegistartionNo).FirstOrDefault().Id : 0,
IsFeePayStandBy = model.IsFeePayStandBy,
BatchName = _context.AddmissionMasters.Any(a => a.RegistrationNo == model.RegistartionNo) ? _context.AddmissionDetails.Where(a => a.AddmissionMaster.RegistrationNo == model.RegistartionNo).FirstOrDefault().BatchMaster.Name : "",
BatchId = _context.AddmissionMasters.Any(a => a.RegistrationNo == model.RegistartionNo) ? _context.AddmissionDetails.Where(a => a.AddmissionMaster.RegistrationNo == model.RegistartionNo).FirstOrDefault().BatchId.Value : 0,
RefundStatus = model.FeeDetails.Any() ? (model.FeeDetails.FirstOrDefault().FeeTypeDetail.Amount == _context.PartWisePayments.Where(p => p.FeeCollection.FeePaymentDetail.FeeDetail.IsActive && p.FeeCollection.FeePaymentDetail.FeeDetail.RegistrationNo == model.RegistartionNo).Sum(s => s.Amount) ? "success" : (_context.FeeCollections.Where(f => f.FeePaymentDetail.FeeDetail.IsActive && f.FeePaymentDetail.FeeDetail.RegistrationNo == model.RegistartionNo).Sum(s => s.Amount) > 0 ? "orange" : "")) : ""
//RefundStatus = model.FeeDetails.Any() ? (model.FeeDetails.FirstOrDefault().FeePaymentDetails.FirstOrDefault().FeeCollections.OrderByDescending(a => a.Id).FirstOrDefault().Amount == model.FeeDetails.FirstOrDefault().FeePaymentDetails.FirstOrDefault().FeeCollections.OrderByDescending(a => a.Id).FirstOrDefault().PartWisePayments.Sum(s => s.Amount) ? "success" : (model.FeeDetails.FirstOrDefault().FeePaymentDetails.FirstOrDefault().FeeCollections.OrderByDescending(a => a.Id).FirstOrDefault().PartWisePayments.Sum(s => s.Amount) > 0 ? "orange" : "")) : ""
}).Where(result => result.IsScreenningClear.HasValue && result.IsScreenningClear.Value).AsEnumerable();
var totalCount = info.Count();
if (!string.IsNullOrWhiteSpace(filter.search.value))
{
info = info.Where(d => (d.RegistartionNo.ToString().ToLower().Contains(filter.search.value.ToLower()) || (!string.IsNullOrEmpty(d.StudentName) && d.StudentName.ToLower().Contains(filter.search.value.ToLower())) || (!string.IsNullOrEmpty(d.Email) && d.Email.ToString().ToLower().Contains(filter.search.value.ToLower())) || (!string.IsNullOrEmpty(d.Mobile) && d.Mobile.ToString().ToLower().Contains(filter.search.value.ToLower())) || (!string.IsNullOrEmpty(d.PaymentStatusStr) && d.PaymentStatusStr.ToString().ToLower().Contains(filter.search.value.ToLower())) || (!string.IsNullOrEmpty(d.BatchName) && d.BatchName.ToString().ToLower().Contains(filter.search.value.ToLower()))));
}
var o = filter.order[0];
var name = filter.columns[filter.order[0].column].data;
if (o.dir == "desc")
{
info = info.OrderByDescending(x => x.GetType().GetProperty(name).GetValue(x));
}
else
{
info = info.OrderBy(x => x.GetType().GetProperty(name).GetValue(x));
}
if (!string.IsNullOrWhiteSpace(filter.columns[7].search.value))
{
int batch = Convert.ToInt32(filter.columns[7].search.value);
info = info.Where(t => t.BatchId == batch);
}
if (!string.IsNullOrWhiteSpace(filter.columns[8].search.value))
{
info = info.Where(t => t.CourseName == filter.columns[8].search.value);
}
if (!string.IsNullOrWhiteSpace(filter.columns[11].search.value))
{
if (filter.columns[11].search.value == "Fully")
{
info = info.Where(t => t.RefundStatus == "success");
}
else if (filter.columns[11].search.value == "Partially")
{
var sss = info.ToList();
info.Where(t => t.RefundStatus == "orange" && t.RefundStatus != "success" && t.RefundStatus != "");
var ss = info.ToList();
}
else if (filter.columns[11].search.value == "Unpaid")
{
info.Where(t => t.RefundStatus == "" && t.RefundStatus != "orange" && t.RefundStatus != "success");
}
}
var filteredCount = info.Count();
filter.recordsTotal = totalCount;
filter.recordsFiltered = filteredCount;
var dataFilter = info.Skip(filter.start).Take(filter.length).ToList();
//foreach (var i in dataFilter)
//{
// i.DateOfBirth = i.DOB.HasValue ? i.DOB.Value.ToString("dd-MM-yyyy") : "";
// i.RegisterDate = i.RegistrationDate.HasValue? i.RegistrationDate.Value.ToString("dd-MM-yyyy") : "";
//}
filter.data = dataFilter;
return(filter);
}
public IHttpActionResult GetUsersMasterList(DataTableFilterModel filter)
{
var _data = new UserRepository().GetUsers(filter);
return(Ok(_data));
}
public DataTableFilterModel GetCandidateList(DataTableFilterModel filter)
{
var info = _context.AddmissionMasters.Where(a => a.IsActive && a.AddmissionDetails.FirstOrDefault().BatchMaster.IsActive&& a.AddmissionDetails.FirstOrDefault().BatchMaster.Name != "Batch 0").Select(item => new RegistrationViewModel
{
Id = item.Id,
RegistartionNo = item.RegistrationNo,
Fname = item.Fname + (string.IsNullOrEmpty(item.Lname) ? "" : (" " + item.Lname)), //+ " " + item.Lname,
Email = item.Email,
Mobile = item.MobileNo,
CourseName = item.CourseMaster.CourseName,
BatchName = item.AddmissionDetails.FirstOrDefault().BatchMaster.Name,
AdmissionDate = item.AddmissionDate.Value,
IsResistrationHistory = item.BatchHistoryDetails.Any(),
PerformanceCardList = _context.tblPerformanceEntryMasters.Where(t => t.RegistrationNo == item.RegistrationNo && t.BatchId == item.AddmissionDetails.FirstOrDefault().BatchId).Select(i => new PerformanceCardListDetail
{
ReviewId = i.ReviewId,
WeeklyTermId = i.tblWeeklyReviewMaster,
ReviewName = i.tblReviewMaster.Name,
WeeklyTermName = i.tblWeeklyReviewMaster1.Name,
AcceptMidTerm = i.tblGetTermAcceptancyByCandidates.Where(t => i.ReviewId == 2 && t.Accept.HasValue && t.Accept.Value).Any(),
AcceptEndTerm = i.tblGetTermAcceptancyByCandidates.Where(t => i.ReviewId == 3 && t.Accept.HasValue && t.Accept.Value).Any()
}).ToList()
}).AsEnumerable();
var totalCount = info.Count();
if (!string.IsNullOrWhiteSpace(filter.columns[7].search.value) && !string.IsNullOrWhiteSpace(filter.columns[8].search.value))
{
DateTime ToDate = DateTime.ParseExact(filter.columns[7].search.value, "dd/MM/yyyy", CultureInfo.InvariantCulture);
DateTime FromDate = DateTime.ParseExact(filter.columns[8].search.value, "dd/MM/yyyy", CultureInfo.InvariantCulture);
if (ToDate > FromDate)
{
info = info.Where(t => t.AdmissionDate >= FromDate && t.AdmissionDate <= ToDate);
}
}
if (!string.IsNullOrWhiteSpace(filter.search.value))
{
info = info.Where(d => !string.IsNullOrEmpty(d.Fname) && d.Fname.ToLower().Contains(filter.search.value.ToLower()));
}
if (!string.IsNullOrWhiteSpace(filter.columns[5].search.value))
{
info = info.Where(t => t.CourseName == filter.columns[5].search.value);
}
if (!string.IsNullOrWhiteSpace(filter.columns[6].search.value))
{
info = info.Where(t => t.BatchName == filter.columns[6].search.value);
}
var ss = info.ToList();
var o = filter.order[0];
var name = filter.columns[filter.order[0].column].data;
if (o.dir == "asc")
{
info = info.OrderBy(x => x.GetType().GetProperty(name).GetValue(x));
}
else
{
info = info.OrderByDescending(x => x.GetType().GetProperty(name).GetValue(x));
}
var filteredCount = info.Count();
filter.recordsTotal = totalCount;
filter.recordsFiltered = filteredCount;
filter.data = info.Skip(filter.start).Take(filter.length).ToList();
return(filter);
}
public ActionResult Export(ExportDataViewModel Model)
{
DataTableFilterModel filter = new DataTableFilterModel();
DataTable dt = new DataTable("Grid");
dt.Columns.AddRange(new DataColumn[12] {
new DataColumn("Sr.No"),
new DataColumn("Reg.No"),
new DataColumn("Student Name"),
new DataColumn("Email"),
new DataColumn("Mobile"),
new DataColumn("DOB"),
new DataColumn("Gender"),
new DataColumn("Payment"),
new DataColumn("Course"),
new DataColumn("Batch"),
new DataColumn("Reg.Date"),
new DataColumn("Screening")
});
int currDate = Convert.ToInt32(Session["CurrentYear"]);
var ScreenningData = registerService.GetScreenningExportData(Model, currDate);
if (ScreenningData.Count() > 0)
{
int i = 1;
if (Model.IsSelected == "Stand-By")
{
foreach (var item in ScreenningData)
{
dt.Rows.Add(i, item.RegistartionNo, item.StudentName, item.Email, item.Mobile, item.DOBStr, item.Gender, item.PaymentStatusStr, item.CourseName, item.BatchName, item.RegisterDate, Model.IsSelected);
i++;
}
}
else
{
foreach (var item in ScreenningData)
{
dt.Rows.Add(i, item.RegistartionNo, item.StudentName, item.Email, item.Mobile, item.DOBStr, item.Gender, item.PaymentStatusStr, item.CourseName, item.BatchName, item.RegisterDate, item.ScreenningStatus);
i++;
}
}
}
string handle = Guid.NewGuid().ToString();
using (XLWorkbook wb = new XLWorkbook())
{
wb.Worksheets.Add(dt);
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment;filename= EmployeeReport.xlsx");
using (MemoryStream stream = new MemoryStream())
{
wb.SaveAs(stream);
stream.Position = 0;
TempData["handle"] = stream.ToArray();
}
}
string FileName = "ScreeningAllCandidateList";
if (Model.IsSelected == "Pending")
{
FileName = "ScreeningPendingCandidateList";
}
else if (Model.IsSelected == "Selected")
{
FileName = "ScreeningSelectedCandidateList";
}
else if (Model.IsSelected == "Rejected")
{
FileName = "ScreeningRejectedCandidateList";
}
else if (Model.IsSelected == "Stand-By")
{
FileName = "ScreeningStandByCandidateList";
}
return(Json(FileName, JsonRequestBehavior.AllowGet));
}
public DataTableFilterModel GetSSAReportList(DataTableFilterModel filter, int SessionYr)
{
RegistrationService rs = new RegistrationService();
var info = _context.AddmissionMasters.Where(w => w.IsActive && w.AddmissionDetails.FirstOrDefault().BatchId != 19).
Select(item => new ClientReportViewModel
{
Id = item.Id,
BatchId = item.AddmissionDetails.FirstOrDefault().BatchId.Value,
BatchName = item.AddmissionDetails.FirstOrDefault().BatchMaster.Name,
InterViewDate = item.RegistrationMaster.ScreeningTests.FirstOrDefault().ScreeningDate,
Gender = item.Gender,
Fname = item.Fname,
Lname = item.Lname,
DOB = item.DOB,
AdmissionDate = item.AddmissionDate,
Addresee1 = item.AddressDetails.FirstOrDefault().CopAddress,
Addresee2 = item.AddressDetails.FirstOrDefault().CopCity,
Addresee3 = item.AddressDetails.FirstOrDefault().CopState,
PinCode = item.AddressDetails.FirstOrDefault().CopZip,
Contact = item.MobileNo,
Email = item.Email,
Designation = "TCC",
DepartMent = "IFSD",
Location = "GGN",
MedicalCenter = item.MedicalDetails.FirstOrDefault().MedicalCenter,
MedicalStatus = item.MedicalDetails.FirstOrDefault().MedicalStatus,
MDate = item.MedicalDetails.FirstOrDefault().MedicalDate,
FDate = item.MedicalDetails.FirstOrDefault().FitnessDate,
JDate = item.MedicalDetails.FirstOrDefault().DateOfJoining,
CourseName = item.CourseMaster.CourseName,
CourseId = item.CourseId,
IsValidPassport = item.IsValidPassport,
SessionYr = item.AddmissionDetails.FirstOrDefault().SessionMaster.SessionYr
}).AsEnumerable();
//var info = ((_context.AddmissionMasters.Join(_context.CourseMasters,
// am => am.CourseId, cm => cm.Id, (am, cm) => new { am, cm })).Join(
// (_context.AddmissionDetails.Join(_context.BatchMasters, ad => ad.BatchId,
// bm => bm.Id, (ad, bm) => new { ad, bm }).Where(a => a.bm.IsActive).Join(
// _context.SessionMasters, comb => comb.ad.SessionId, sm => sm.Id,
// (comb, sm) => new { comb, sm }).Where(i => i.sm.IsActive).Join
// (_context.AddressDetails.DefaultIfEmpty(), combined => combined.comb.ad.AddmissionId,
// add => add.AddmissionId, (combined, add) => new
// {
// AdmissionId = combined.comb.ad.AddmissionId,
// AdmissionActive = combined.comb.ad.AddmissionMaster.IsActive,
// BatchId = combined.comb.bm.Id,
// SessionId = combined.sm.Id,
// SessionYr = combined.sm.SessionYr,
// BatchName = combined.comb.bm.Name,
// SessionName = combined.sm.SessionName,
// SessionActive = combined.sm.IsActive,
// Address1 = add.CopAddress,
// Address2 = add.CopCity,
// Address3 = add.CopState,
// Pincode = add.CopZip,
// ValidPassport = combined.comb.ad.AddmissionMaster.IsValidPassport,
// MedicalCenter = combined.comb.ad.AddmissionMaster.MedicalDetails.FirstOrDefault().MedicalCenter,
// MedicalStatus = combined.comb.ad.AddmissionMaster.MedicalDetails.FirstOrDefault().MedicalStatus,
// MedicalDate = combined.comb.ad.AddmissionMaster.MedicalDetails.FirstOrDefault().MedicalDate,
// FitnessDate = combined.comb.ad.AddmissionMaster.MedicalDetails.FirstOrDefault().FitnessDate,
// JoiningDate = combined.comb.ad.AddmissionMaster.MedicalDetails.FirstOrDefault().DateOfJoining
// }).Where(i => i.AdmissionActive && i.SessionActive && i.BatchId != 19)), info1 => info1.am.Id, info2 => info2.AdmissionId,
// (info1, info2) => new { info1, info2 })).Join(_context.ScreeningTests,
// res1 => res1.info1.am.RegistrationNo, res2 => res2.RegistrationId,
// (res1, res2) => new { res1 = res1, res2 = res2 }).GroupBy(g => g.res1.info1.am.Id).Select(item => new ClientReportViewModel
// {
// Id = item.FirstOrDefault().res1.info1.am.Id,
// BatchId = item.FirstOrDefault().res1.info2.BatchId,
// BatchName = item.FirstOrDefault().res1.info2.BatchName,
// InterViewDate = item.FirstOrDefault().res2.ScreeningDate,
// Gender = item.FirstOrDefault().res1.info1.am.Gender,
// Fname = item.FirstOrDefault().res1.info1.am.Fname,
// Lname = item.FirstOrDefault().res1.info1.am.Lname,
// DOB = item.FirstOrDefault().res1.info1.am.DOB,
// AdmissionDate = item.FirstOrDefault().res1.info1.am.AddmissionDate,
// Addresee1 = item.FirstOrDefault().res1.info2.Address1,
// Addresee2 = item.FirstOrDefault().res1.info2.Address2,
// Addresee3 = item.FirstOrDefault().res1.info2.Address3,
// PinCode = item.FirstOrDefault().res1.info2.Pincode,
// Contact = item.FirstOrDefault().res1.info1.am.MobileNo,
// Email = item.FirstOrDefault().res1.info1.am.Email,
// Designation = "TCC",
// DepartMent = "IFSD",
// Location = "GGN",
// MedicalCenter = item.FirstOrDefault().res1.info2.MedicalCenter,
// MedicalStatus = item.FirstOrDefault().res1.info2.MedicalStatus,
// MDate = item.FirstOrDefault().res1.info2.MedicalDate,
// FDate = item.FirstOrDefault().res1.info2.FitnessDate,
// JDate = item.FirstOrDefault().res1.info2.JoiningDate,
// CourseName = item.FirstOrDefault().res1.info1.am.CourseMaster.CourseName,
// CourseId = item.FirstOrDefault().res1.info1.am.CourseId,
// IsValidPassport = item.FirstOrDefault().res1.info2.ValidPassport,
// SessionYr = item.FirstOrDefault().res1.info2.SessionYr
// }).AsEnumerable();
if (SessionYr > 0)
info = info.Where(d => d.SessionYr == SessionYr);
var totalCount = info.Count();
if (!string.IsNullOrWhiteSpace(filter.search.value))
info = info.Where(d => (!string.IsNullOrEmpty(d.FullName) && d.FullName.ToLower().Contains(filter.search.value.ToLower())) || (!string.IsNullOrEmpty(d.Email) && d.Email.ToLower().Contains(filter.search.value.ToLower())) || (!string.IsNullOrEmpty(d.Contact) && d.Contact.ToLower().Contains(filter.search.value.ToLower())));
if (!string.IsNullOrWhiteSpace(filter.columns[6].search.value))
{
int yr = Convert.ToInt32(filter.columns[6].search.value);
info = info.Where(t => t.AdmissionDate.Value.Year == yr);
if (!string.IsNullOrWhiteSpace(filter.columns[7].search.value))
{
int mon = Convert.ToInt32(filter.columns[7].search.value);
info = info.Where(t => t.AdmissionDate.Value.Year == yr && t.AdmissionDate.Value.Month == mon);
}
}
if (!string.IsNullOrWhiteSpace(filter.columns[2].search.value) && filter.columns[2].search.value != "" && !string.IsNullOrWhiteSpace(filter.columns[3].search.value) && filter.columns[3].search.value != "")
{
DateTime fromDate = DateTime.ParseExact(filter.columns[2].search.value, "dd/MM/yyyy", CultureInfo.InvariantCulture).Date;
DateTime toDate = DateTime.ParseExact(filter.columns[3].search.value, "dd/MM/yyyy", CultureInfo.InvariantCulture).Date;
info = info.Where(t => t.AdmissionDate.Value.Date >= fromDate && t.AdmissionDate.Value.Date <= toDate);
}
if (!string.IsNullOrWhiteSpace(filter.columns[14].search.value))
{
var courseArr = filter.columns[14].search.value.Split(',');
if (courseArr.Length > 0)
info = info.Where(t => courseArr.Any(c => c == t.CourseId.ToString()));
}
if (!string.IsNullOrWhiteSpace(filter.columns[1].search.value))
{
var batchArr = filter.columns[1].search.value.Split(',');
if (batchArr.Length > 0)
info = info.Where(t => batchArr.Any(c => c == t.BatchId.ToString()));
}
if (!string.IsNullOrWhiteSpace(filter.columns[10].search.value))
info = info.Where(t => t.Addresee3 == filter.columns[10].search.value);
var o = filter.order[0];
var name = filter.columns[filter.order[0].column].data;
if (o.dir == "asc")
info = info.OrderBy(x => x.GetType().GetProperty(name).GetValue(x));
else
info = info.OrderByDescending(x => x.GetType().GetProperty(name).GetValue(x));
var filteredCount = info.Count();
filter.recordsTotal = totalCount;
filter.recordsFiltered = filteredCount;
var dataFilter = info.Skip(filter.start).Take(filter.length).ToList();
foreach (var i in dataFilter)
{
i.Title = i.Gender == "M" ? "Mr" : "Ms";
//i.DateOfBirth = i.DOB.HasValue ? i.DOB.Value.ToString("dd/MM/yyyy") : "";
//i.DateOfInterView = i.InterViewDate.ToString("dd/MM/yyyy");
if (i.DOB.HasValue)
i.DateOfBirth = i.DOB.Value.Day.ToString().PadLeft(2, '0') + "/" + i.DOB.Value.Month.ToString().PadLeft(2, '0') + "/" + i.DOB.Value.Year;
i.DateOfInterView = i.InterViewDate.Day.ToString().PadLeft(2, '0') + "/" + i.InterViewDate.Month.ToString().PadLeft(2, '0') + "/" + i.InterViewDate.Year;
if (i.MDate.HasValue)
i.MedicalDate = i.MDate.Value.Day.ToString().PadLeft(2, '0') + "/" + i.MDate.Value.Month.ToString().PadLeft(2, '0') + "/" + i.MDate.Value.Year;
if (i.FDate.HasValue)
i.FitnessDate = i.FDate.Value.Day.ToString().PadLeft(2, '0') + "/" + i.FDate.Value.Month.ToString().PadLeft(2, '0') + "/" + i.FDate.Value.Year;
if (i.JDate.HasValue)
i.JoiningDate = i.JDate.Value.Day.ToString().PadLeft(2, '0') + "/" + i.JDate.Value.Month.ToString().PadLeft(2, '0') + "/" + i.JDate.Value.Year;
i.NOC_PP = i.IsValidPassport ? "Passport" : "";
i.Age = rs.CalculateYourAge(i.DOB);
}
filter.data = dataFilter;
return filter;
}
