public async Task <IActionResult> StudentsByAccountant(string SearchStudentClassId, int pg = 1)
{
try
{
if (String.IsNullOrEmpty(SearchStudentClassId))
{
ViewBag.ddlClasses = _classesServ.dropdown_Class();
ViewBag.searchRequest = false;
var model = new StudentsByAccountantVM()
{
_Students = null,
SearchStudentClassId = null
};
return(View("StudentsByAccountant", model));
}
else
{
var result = new SearchStudentsByClass()
{
WebRootPath = _he.WebRootPath,
SearchStudentClassId = SearchStudentClassId
};
var SearchStudentsByClass = await Task.Run(() => _studentsServ.SearchStudentsByClass(result));
ViewBag.ddlClasses = _classesServ.dropdown_Class();
ViewBag.ddlGenders = _GendersServ.Dropdown_Genders();
var list = new List <StudentsByAccountantVM_Students>();
foreach (var item in SearchStudentsByClass._Students.ToList())
{
var temp = new StudentsByAccountantVM_Students()
{
Id = item.Id,
ClassId = item.ClassId,
ClassName = item.ClassName,
GenderId = item.GenderId,
GenderName = item.GenderName,
RegistrationNo = item.RegistrationNo,
FirstName = item.FirstName,
LastName = item.LastName,
StudentName = item.StudentName,
FatherName = item.FatherName,
MotherName = item.MotherName,
ParentsName = item.ParentsName,
CurrentClassName = item.CurrentClassName,
CurrentYear = item.CurrentYear,
IP300X200 = item.IP300X200,
AdmittedYear = item.AdmittedYear,
PresentAddress = item.PresentAddress,
PermanentAddress = item.PermanentAddress,
DOB = item.DOB,
IsActive = item.IsActive,
AddedBy = item.AddedBy = 0,
AddedDate = DateTime.Now,
ModifiedBy = 0,
ModifiedDate = DateTime.Now,
DataType = null
};
list.Add(temp);
}
;
#region "Paging"
const int pageSize = 5;
if (pg < 1)
{
pg = 1;
}
int recsCount = list.Count();
var pager = new Pager(recsCount, pg, pageSize);
int recSkip = (pg - 1) * pageSize;
var data = list.Skip(recSkip).Take(pager.PageSize).ToList();
this.ViewBag.Pager = pager;
var model = new StudentsByAccountantVM()
{
ClassName = SearchStudentsByClass.SearchStudentClassName,
_Students = data,
SearchStudentClassId = SearchStudentClassId
};
#endregion "Paging"
return(View("StudentsByAccountant", model));
}
}
catch
{
return(BadRequest());
}
}
public async Task <IActionResult> StudentsaddDetails(string SearchStudentClassId)
{
try
{
var result = new SearchStudentsByClass()
{
WebRootPath = _he.WebRootPath,
SearchStudentClassId = SearchStudentClassId
};
var SearchStudentsByClass = await Task.Run(() => _studentsServ.SearchStudentsByClass(result));
ViewBag.ddlClasses = _classesServ.dropdown_Class();
ViewBag.ddlGenders = _GendersServ.Dropdown_Genders();
var list = new List <Vm_Students>();
foreach (var item in SearchStudentsByClass._Students.ToList())
{
var temp = new Vm_Students()
{
Id = item.Id,
ClassId = item.ClassId,
ClassName = item.ClassName,
GenderId = item.GenderId,
GenderName = item.GenderName,
RegistrationNo = item.RegistrationNo,
RollNO = item.RollNO,
CurrentClassId = item.CurrentClassId,
CurrentClassName = item.CurrentClassName,
CurrentYear = DateTime.Now,
FirstName = item.FirstName,
LastName = item.LastName,
StudentName = item.StudentName,
FatherName = item.FatherName,
MotherName = item.MotherName,
ParentsName = item.ParentsName,
IP300X200 = item.IP300X200,
AdmittedYear = item.AdmittedYear,
PresentAddress = item.PresentAddress,
PermanentAddress = item.PermanentAddress,
DOB = item.DOB,
IsActive = item.IsActive,
AddedBy = item.AddedBy = 0,
AddedDate = DateTime.Now,
ModifiedBy = 0,
ModifiedDate = DateTime.Now,
DataType = null
};
list.Add(temp);
}
;
var model = new IndexStudentsListVM()
{
ClassName = SearchStudentsByClass.SearchStudentClassName,
_Students = list,
SearchStudentClassId = SearchStudentClassId
};
return(View("StudentsaddDetails", model));
}
catch
{
return(BadRequest());
}
}
public async Task <IActionResult> SearchStudentsClassByAccountant(string SearchStudentClassId)
{
try
{
if (String.IsNullOrEmpty(SearchStudentClassId))
{
var model = new StudentsByAccountantVM()
{
_Students = null,
SearchStudentClassId = null
};
return(View("StudentsByAccountant", model));
}
else
{
var result = new SearchStudentsByClass()
{
SearchStudentClassId = SearchStudentClassId
};
var SearchStudentsByClass = await Task.Run(() => _studentsServ.SearchStudentsByClass(result));
ViewBag.ddlClasses = _classesServ.dropdown_Class();
ViewBag.ddlGenders = _GendersServ.Dropdown_Genders();
var list = new List <StudentsByAccountantVM_Students>();
foreach (var item in SearchStudentsByClass._Students.ToList())
{
var temp = new StudentsByAccountantVM_Students()
{
Id = item.Id,
ClassId = item.ClassId,
ClassName = item.ClassName,
GenderId = item.GenderId,
GenderName = item.GenderName,
RegistrationNo = item.RegistrationNo,
FirstName = item.FirstName,
LastName = item.LastName,
StudentName = item.StudentName,
FatherName = item.FatherName,
MotherName = item.MotherName,
ParentsName = item.ParentsName,
IP300X200 = item.IP300X200,
AdmittedYear = item.AdmittedYear,
PresentAddress = item.PresentAddress,
PermanentAddress = item.PermanentAddress,
DOB = item.DOB,
IsActive = item.IsActive,
AddedBy = item.AddedBy = 0,
AddedDate = DateTime.Now,
ModifiedBy = 0,
ModifiedDate = DateTime.Now,
DataType = null
};
list.Add(temp);
}
;
var model = new StudentsByAccountantVM()
{
_Students = list,
SearchStudentClassId = SearchStudentClassId
};
return(View("StudentsByAccountant", model));
}
}
catch
{
return(BadRequest());
}
}
public SearchStudentsByClass SearchStudentsByClass(SearchStudentsByClass obj)
{
var model = (dynamic)null;
try
{
var studentsList = _studentsRepo.GetAll().ToList();
var ClassList = _classesRepo.GetAll().ToList();
var GendersList = _GendersRepo.GetAll().ToList();
var StudentPromotionsList = _StudentPromotionsRepo.GetAll().ToList();
// if (obj.SearchStudentCurrentClassId== "All class")
if (obj.SearchStudentClassId == "All class")
{
var query = (from _students in studentsList
join _studentPrmotion in StudentPromotionsList on _students.Id equals _studentPrmotion?.StudentId
join _Classes in ClassList on _students?.ClassId equals _Classes?.Id
where _studentPrmotion.ClassId == _students.ClassId
join _Genders in GendersList on _students?.GenderId equals _Genders?.Id
select new { _studentPrmotion, _Classes, _Genders, _students }).ToList();
var list = new List <SearchStudentsByClass_Students>();
foreach (var item in query)
{
var getStudent = (from stu in studentsList
where stu.RegistrationNo == item._students.RegistrationNo
join cls in ClassList on stu.ClassId equals cls.Id
select new { stu, cls }).SingleOrDefault();
string path = string.IsNullOrEmpty(item._students.IP300X200) ? "" : item._students.IP300X200;
var temp = new SearchStudentsByClass_Students()
{
Id = item._students.Id,
ClassId = item._students.ClassId,
ClassName = getStudent.cls.Name,
GenderId = item._students.GenderId,
RegistrationNo = item._students.RegistrationNo,
CurrentYear = DateTime.Now,
CurrentClassName = currentYearClassName(item._students.Id),
GenderName = item._Genders.Name,
FirstName = item._students.FirstName,
RollNO = item._studentPrmotion.RollNo,
LastName = item._students.LastName,
StudentName = item._students.FirstName + " " + item._students.LastName,
FatherName = item._students.FatherName,
MotherName = item._students.MotherName,
ParentsName = item._students.FatherName + " " + item._students.MotherName,
IP300X200 = _commonServ.CommImage_WrapperDefaultImage(path, obj.WebRootPath, item._students.GenderId),
AdmittedYear = item._students.AdmittedYear,
PresentAddress = item._students.PresentAddress,
PermanentAddress = item._students.PermanentAddress,
DOB = item._students.DOB,
IsActive = item._studentPrmotion.IsActive,
AddedBy = 0,
AddedDate = DateTime.Now,
ModifiedBy = 0,
ModifiedDate = DateTime.Now,
DataType = null
};
list.Add(temp);
}
;
model = new SearchStudentsByClass()
{
_Students = list,
// SearchStudentClassName = obj.SearchStudentClassId
SearchStudentClassName = obj.SearchStudentClassId
};
}
else
{
Int64 SearchStudentClassId = Convert.ToInt64(obj.SearchStudentClassId);
var query = (from _students in studentsList
join _studentPrmotion in StudentPromotionsList on _students.Id equals _studentPrmotion?.StudentId
join _Classes in ClassList on _students?.ClassId equals _Classes?.Id
where _students.ClassId == SearchStudentClassId && _studentPrmotion.ClassId == _students.ClassId
join _Genders in GendersList on _students?.GenderId equals _Genders?.Id
select new { _studentPrmotion, _Classes, _Genders, _students }).ToList();
var test = (from c in ClassList
where c.Id == SearchStudentClassId
select c).SingleOrDefault();
var list = new List <SearchStudentsByClass_Students>();
foreach (var item in query)
{
var getStudent = (from stu in studentsList
where stu.RegistrationNo == item._students.RegistrationNo
join cls in ClassList on stu.ClassId equals cls.Id
select new { stu, cls }).SingleOrDefault();
string path = string.IsNullOrEmpty(item._students.IP300X200) ? "" : item._students.IP300X200;
var temp = new SearchStudentsByClass_Students()
{
Id = item._students.Id,
ClassId = item._students.ClassId,
ClassName = getStudent.cls.Name,
GenderId = item._students.GenderId,
RegistrationNo = item._students.RegistrationNo,
CurrentYear = DateTime.Now,
CurrentClassName = currentYearClassName(item._students.Id),
GenderName = item._Genders.Name,
FirstName = item._students.FirstName,
LastName = item._students.LastName,
StudentName = item._students.FirstName + " " + item._students.LastName,
FatherName = item._students.FatherName,
MotherName = item._students.MotherName,
ParentsName = item._students.FatherName + " " + item._students.MotherName,
IP300X200 = _commonServ.CommImage_WrapperDefaultImage(path, obj.WebRootPath, item._students.GenderId),
AdmittedYear = item._students.AdmittedYear,
PresentAddress = item._students.PresentAddress,
PermanentAddress = item._students.PermanentAddress,
DOB = item._students.DOB,
IsActive = item._studentPrmotion.IsActive,
AddedBy = 0,
AddedDate = DateTime.Now,
ModifiedBy = 0,
ModifiedDate = DateTime.Now,
DataType = null
};
list.Add(temp);
}
;
model = new SearchStudentsByClass()
{
_Students = list,
SearchStudentClassName = test.Name
};
}
}
catch (Exception e)
{
var test = e.Message;
}
return(model);
}
