public ActionResult InternationalManagerFinalConfirm(string term = null)
{
//if (Session["UserCmsInfo"] == null)
//{
// return RedirectToAction("LoginCMS", "Account", new { lang = "fa" });
//}
var selectedTerm = string.IsNullOrEmpty(term) ? currentTerm : term;
var convertedTerm = $"{selectedTerm.Substring(0, 2)}{selectedTerm.Substring(6, 1)}";
var terms = _requestService.FetchAll().Select(s => s.Term).Distinct().OrderByDescending(o => o).ToList();
var allTerms = new List <RequestStatusDTO>();
terms.ForEach(f => allTerms.Add(new RequestStatusDTO()
{
ID = f.ToString(), DispalyName = f.ToString()
}));
ViewBag.Terms = new SelectList(allTerms, "ID", "DispalyName", selectedTerm);
var newStudentsList = _newStudentService.FetchAll().Where(w => w.term == int.Parse(convertedTerm))//term is 3 degits
.Select(s => new NewStudentViewModel
{
StudentCode = s.stcode,
RequestId = s.RequestId?.ToString() ?? "",
FirstName = s.name,
LastName = s.family,
FatherName = s.namep,
FeildIdSazman = s.idreshSazman,
//FeildTitle = "---",
GraduateLevel = s.magh,
GraduateLevelTitle = EnumsPersianTitles.GetSidaLevelTitle(s.magh),
BirthDate = s.year_tav?.ToString() ?? "--"
}).ToList();
var model = (from ns in newStudentsList
join s in _sidaFieldService.FetchAll() on ns.FeildIdSazman equals s.CodeSazman into sidaFields
from sf in sidaFields.DefaultIfEmpty()
select new NewStudentViewModel()
{
StudentCode = ns.StudentCode,
RequestId = ns.RequestId?.ToString() ?? "",
FirstName = ns.FirstName,
LastName = ns.LastName,
FatherName = ns.FatherName,
FeildIdSazman = ns.FeildIdSazman,
FeildTitle = sf == null ? "---" : sf.SidaFieldName,
GraduateLevel = ns.GraduateLevel,
GraduateLevelTitle = EnumsPersianTitles.GetSidaLevelTitle(ns.GraduateLevel),
BirthDate = ns.BirthDate?.ToString() ?? "--"
}).ToList();
return(View(model));
}
public ActionResult GetNewStudetByParams(string term = null, string studentCode = null, string filter = null)
{
try
{
var selectedTerm = string.IsNullOrEmpty(term) ? currentTerm : term;
var convertedTerm = $"{selectedTerm.Substring(0, 2)}{selectedTerm.Substring(6, 1)}";
var studentList = _newStudentService.FetchAll().Where(w => w.term == int.Parse(convertedTerm));
if (!string.IsNullOrEmpty(studentCode) && Helpers.IsNumeric(studentCode))
{
var student = studentList.Where(w => w.stcode == studentCode).Select(s => new NewStudentViewModel
{
StudentCode = s.stcode,
RequestId = s.RequestId?.ToString() ?? "",
FirstName = s.name,
LastName = s.family,
FatherName = s.namep,
FeildIdSazman = s.idreshSazman,
//FeildTitle = "---",
GraduateLevel = s.magh,
GraduateLevelTitle = EnumsPersianTitles.GetSidaLevelTitle(s.magh),
BirthDate = s.year_tav?.ToString() ?? "--"
}).FirstOrDefault();
var sidaField = _sidaFieldService.FindOne(s => s.CodeSazman == student.FeildIdSazman);
var model = new NewStudentViewModel
{
StudentCode = student.StudentCode,
RequestId = student.RequestId?.ToString() ?? "",
FirstName = student.FirstName,
LastName = student.LastName,
FatherName = student.FatherName,
FeildIdSazman = student.FeildIdSazman,
FeildTitle = sidaField == null ? "---" : sidaField.SidaFieldName,
GraduateLevel = student.GraduateLevel,
GraduateLevelTitle = EnumsPersianTitles.GetSidaLevelTitle(student.GraduateLevel),
BirthDate = student.BirthDate?.ToString() ?? "--",
};
return(PartialView("_NewStudentDetails", model));
}
else
{
if (!string.IsNullOrEmpty(filter?.Trim()))
{
var trimedFilter = filter.Trim();
if (Helpers.IsNumeric(trimedFilter))//studentCode or requestId or codeSazman
{
var model = (from ns in studentList
join s in _sidaFieldService.FetchAll() on ns.idreshSazman equals s.CodeSazman //into sidaFields
//from sf in sidaFields.DefaultIfEmpty()
where (
(!string.IsNullOrEmpty(ns.stcode?.Trim()) && ns.stcode.Trim() == trimedFilter) ||
(!string.IsNullOrEmpty(ns.RequestId?.ToString().Trim()) && ns.RequestId.ToString().Trim() == trimedFilter) ||
(!string.IsNullOrEmpty(ns.idreshSazman.Trim()) && ns.idreshSazman.Trim() == trimedFilter)
)
select new NewStudentViewModel()
{
StudentCode = ns.stcode,
RequestId = ns.RequestId?.ToString() ?? "",
FirstName = ns.name,
LastName = ns.family,
FatherName = ns.namep,
FeildIdSazman = ns.idreshSazman,
//FeildTitle = sf == null ? "---" : sf.SidaFieldName,
FeildTitle = s == null ? "---" : s.SidaFieldName,
GraduateLevel = ns.magh,
GraduateLevelTitle = EnumsPersianTitles.GetSidaLevelTitle(ns.magh),
BirthDate = ns.date_tav?.ToString() ?? "--"
}).ToList();
return(PartialView("_NewStudentList", model));
}
else //name or family or field or fathername
{
var model = (from ns in studentList
join s in _sidaFieldService.FetchAll() on ns.idreshSazman equals s.CodeSazman //into sidaFields
where (
(!string.IsNullOrEmpty(ns.name) && Helpers.ToPersianLetters(ns.name.ToLower()).Contains(Helpers.ToPersianLetters(trimedFilter.ToLower()))) ||
(!string.IsNullOrEmpty(ns.family) && Helpers.ToPersianLetters(ns.family.ToLower()).Contains(Helpers.ToPersianLetters(trimedFilter.ToLower()))) ||
(!string.IsNullOrEmpty(ns.namep) && Helpers.ToPersianLetters(ns.namep.ToLower()).Contains(Helpers.ToPersianLetters(trimedFilter.ToLower()))) ||
(!string.IsNullOrEmpty(s.SidaFieldName) && Helpers.ToPersianLetters(s.SidaFieldName.ToLower()).Contains(Helpers.ToPersianLetters(trimedFilter.ToLower())))
//|| (!string.IsNullOrEmpty(sf.SidaFieldName) && Helpers.ToPersianLetters(sf.SidaFieldName).Contains(Helpers.ToPersianLetters(trimedFilter)))
)
select new NewStudentViewModel()
{
StudentCode = ns.stcode,
RequestId = ns.RequestId?.ToString() ?? "",
FirstName = ns.name,
LastName = ns.family,
FatherName = ns.namep,
FeildIdSazman = ns.idreshSazman,
//FeildTitle = sf == null ? "---" : sf.SidaFieldName,
FeildTitle = s == null ? "---" : s.SidaFieldName,
GraduateLevel = ns.magh,
GraduateLevelTitle = EnumsPersianTitles.GetSidaLevelTitle(ns.magh),
BirthDate = ns.date_tav?.ToString() ?? "--"
}).ToList();
return(PartialView("_NewStudentList", model));
}
}
else
{
var model = (from ns in studentList
join s in _sidaFieldService.FetchAll() on ns.idreshSazman equals s.CodeSazman //into sidaFields
//from sf in sidaFields.DefaultIfEmpty()
select new NewStudentViewModel()
{
StudentCode = ns.stcode,
RequestId = ns.RequestId?.ToString() ?? "",
FirstName = ns.name,
LastName = ns.family,
FatherName = ns.namep,
FeildIdSazman = ns.idreshSazman,
//FeildTitle = sf == null ? "---" : sf.SidaFieldName,
FeildTitle = s == null ? "---" : s.SidaFieldName,
GraduateLevel = ns.magh,
GraduateLevelTitle = EnumsPersianTitles.GetSidaLevelTitle(ns.magh),
BirthDate = ns.date_tav?.ToString() ?? "--"
}).ToList();
return(PartialView("_NewStudentList", model));
}
}
}
catch (Exception x)
{
throw x;
}
}