public IActionResult DeleteStudent(StudentInfoVM a)
{
StudentInfo e = context.StudentInfo.Where(s => s.StudentId == a.StudentId).FirstOrDefault();
context.StudentInfo.Remove(e);
context.SaveChanges();
return(RedirectToAction("StudentList"));
}
public ActionResult StudentInfo(int studentId)
{
StudentInfoVM vm = new StudentInfoVM();
var studentInfo = studentInfoBll.GetStudentInfo(studentId);
if (studentInfo == null || studentInfo.Bst_SchoolId != CurrentUser.School.Bsl_Id)
{
return(RedirectToAction("Index"));
}
vm.StudentInfo = studentInfo;
return(View(vm));
}
public IActionResult UpdateStudent(StudentInfoVM a)
{
StudentInfo stt = new StudentInfo()
{
StudentId = a.StudentId,
StudentName = a.StudentName,
Class = a.Class,
Section = a.Section
};
context.StudentInfo.Update(stt);
context.SaveChanges();
return(View());
}
public IActionResult DeleteStudent(int id)
{
StudentInfo d = context.StudentInfo.Where(s => s.StudentId == id).FirstOrDefault();
if (d != null)
{
StudentInfoVM st = new StudentInfoVM()
{
StudentId = d.StudentId,
StudentName = d.StudentName,
Class = d.Class,
Section = d.Section
};
return(View(st));
}
return(NotFound());
}
public IActionResult UpdateStudent(int id)
{
StudentInfo d = context.StudentInfo.Where(s => s.StudentId == id).FirstOrDefault();
var ab = context.DistrictInfo.ToList();
ViewBag.DistrictList = new SelectList(ab, "DistrictInfoId", "DistrictName");
StudentInfoVM st = new StudentInfoVM()
{
StudentId = d.StudentId,
StudentName = d.StudentName,
Class = d.Class,
Section = d.Section,
DistrictInfoId = d.DistrictInfoId
};
return(View(st));
}
public IActionResult Edit(StudentInfoVM vm)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState.GetErrorJson()));
}
else
{
vm.DoEdit(false);
if (!ModelState.IsValid)
{
return(BadRequest(ModelState.GetErrorJson()));
}
else
{
return(Ok(vm.Entity));
}
}
}
public IActionResult StudentList()
{
//List<StudentInfo> studentlist = context.StudentInfo.ToList();
//var s = new List<StudentInfoVM>();
var studentlist = context.StudentInfo.ToList();
var districtlist = context.DistrictInfo.ToList();
var s = new List <StudentInfoVM>();
if (studentlist != null && districtlist != null)
{
var queryResult = from a in studentlist
join b in districtlist
on a.DistrictInfoId equals b.DistrictInfoId
select new
{
StudentId = a.StudentId,
StudentName = a.StudentName,
Class = a.Class,
Section = a.Section,
DistrictInfoId = b.DistrictInfoId,
DistrictName = b.DistrictName
};
int count = 1;
foreach (var item in queryResult)
{
StudentInfoVM b = new StudentInfoVM()
{
StudentId = item.StudentId,
StudentName = item.StudentName,
Class = item.Class,
Section = item.Section,
DistrictName = item.DistrictName
};
b.Serial = count;
count++;
s.Add(b);
}
return(View(s));
}
return(View());
}
public IActionResult AddStudent(StudentInfoVM a)
{
if (ModelState.IsValid)
{
StudentInfo b = new StudentInfo()
{
StudentId = a.StudentId,
StudentName = a.StudentName,
Class = a.Class,
Section = a.Section,
DistrictInfoId = a.DistrictInfoId
};
context.StudentInfo.Add(b);
context.SaveChanges();
ModelState.Clear();
ViewBag.Message = "You have added " + a.StudentName;
}
var ab = context.DistrictInfo.ToList();
ViewBag.DistrictList = new SelectList(ab, "DistrictInfoId", "DistrictName");
return(View());
}
public void CreateTest()
{
StudentInfoVM vm = _controller.Wtm.CreateVM <StudentInfoVM>();
StudentInfo v = new StudentInfo();
v.ID = 97;
v.Code = "lK6DLi";
v.Name = "9NPwc";
v.CellPhone = "dMC2o1oD2";
v.ZipCode = "Wjntc4";
v.EmContacts = "Jvy3jjC";
v.EmConPhone = "7FC9poO7e";
v.SchoolInfoId = AddSchoolInfo();
v.MajorInfoId = AddMajorInfo();
v.PhotoId = AddPhoto();
v.GradeClassId = AddGradeClass();
vm.Entity = v;
var rv = _controller.Add(vm);
Assert.IsInstanceOfType(rv, typeof(OkObjectResult));
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var data = context.Set <StudentInfo>().Find(v.ID);
Assert.AreEqual(data.ID, 97);
Assert.AreEqual(data.Code, "lK6DLi");
Assert.AreEqual(data.Name, "9NPwc");
Assert.AreEqual(data.CellPhone, "dMC2o1oD2");
Assert.AreEqual(data.ZipCode, "Wjntc4");
Assert.AreEqual(data.EmContacts, "Jvy3jjC");
Assert.AreEqual(data.EmConPhone, "7FC9poO7e");
Assert.AreEqual(data.CreateBy, "user");
Assert.IsTrue(DateTime.Now.Subtract(data.CreateTime.Value).Seconds < 10);
}
}
public IActionResult StudentDetails(int id)
{
StudentInfo a = context.StudentInfo.Where(s => s.StudentId == id).FirstOrDefault();
var studentlist = context.StudentInfo.ToList();
var districtlist = context.DistrictInfo.ToList();
if (a != null && districtlist != null)
{
var q = (from c in districtlist
join d in studentlist
on c.DistrictInfoId equals d.DistrictInfoId
where d.DistrictInfoId == a.DistrictInfoId
select new
{
Section = a.Section,
Class = a.Class,
StudentName = a.StudentName,
StudentId = a.StudentId,
DisName = c.DistrictName
}).FirstOrDefault();
StudentInfoVM studentInfoVM = new StudentInfoVM()
{
Section = q.Section,
Class = q.Class,
StudentName = q.StudentName,
StudentId = q.StudentId,
DistrictName = q.DisName
};
return(View(studentInfoVM));
}
else
{
return(NotFound());
}
}
public void EditTest()
{
StudentInfo v = new StudentInfo();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
v.ID = 97;
v.Code = "lK6DLi";
v.Name = "9NPwc";
v.CellPhone = "dMC2o1oD2";
v.ZipCode = "Wjntc4";
v.EmContacts = "Jvy3jjC";
v.EmConPhone = "7FC9poO7e";
v.SchoolInfoId = AddSchoolInfo();
v.MajorInfoId = AddMajorInfo();
v.PhotoId = AddPhoto();
v.GradeClassId = AddGradeClass();
context.Set <StudentInfo>().Add(v);
context.SaveChanges();
}
StudentInfoVM vm = _controller.Wtm.CreateVM <StudentInfoVM>();
var oldID = v.ID;
v = new StudentInfo();
v.ID = oldID;
v.Code = "jhjph";
v.Name = "BezCb";
v.CellPhone = "q8ksam";
v.ZipCode = "O5kEW";
v.EmContacts = "nSgp7";
v.EmConPhone = "fcYUZiDK";
vm.Entity = v;
vm.FC = new Dictionary <string, object>();
vm.FC.Add("Entity.ID", "");
vm.FC.Add("Entity.Code", "");
vm.FC.Add("Entity.Name", "");
vm.FC.Add("Entity.CellPhone", "");
vm.FC.Add("Entity.ZipCode", "");
vm.FC.Add("Entity.EmContacts", "");
vm.FC.Add("Entity.EmConPhone", "");
vm.FC.Add("Entity.SchoolInfoId", "");
vm.FC.Add("Entity.MajorInfoId", "");
vm.FC.Add("Entity.PhotoId", "");
vm.FC.Add("Entity.GradeClassId", "");
var rv = _controller.Edit(vm);
Assert.IsInstanceOfType(rv, typeof(OkObjectResult));
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var data = context.Set <StudentInfo>().Find(v.ID);
Assert.AreEqual(data.Code, "jhjph");
Assert.AreEqual(data.Name, "BezCb");
Assert.AreEqual(data.CellPhone, "q8ksam");
Assert.AreEqual(data.ZipCode, "O5kEW");
Assert.AreEqual(data.EmContacts, "nSgp7");
Assert.AreEqual(data.EmConPhone, "fcYUZiDK");
Assert.AreEqual(data.UpdateBy, "user");
Assert.IsTrue(DateTime.Now.Subtract(data.UpdateTime.Value).Seconds < 10);
}
}
public ActionResult FindResult(int sessionId, int studentClassId, int assignRollId)
{
try
{
List <ResultVM> resultList = new List <ResultVM>();
List <StudentInfoVM> infoList = new List <StudentInfoVM>();
List <StudentResultVM> studentResult = new List <StudentResultVM>();
var session = db.Session.Where(x => x.Id == sessionId).Select(x => x.Name).FirstOrDefault();
var className = db.StudentClass.Where(x => x.Id == studentClassId).Select(x => x.ClassName.Name).FirstOrDefault();
var roll = db.AssignRoll.Where(x => x.SessionId == sessionId && x.StudentClassId == studentClassId).Select(s => s.Roll).FirstOrDefault();
#region retrieve & bind studentInfo
var studentInfo = db.Admission.Where(x => x.SessionId == sessionId && x.StudentClassId == studentClassId).Select(s => new
{
StudentName = s.Student.Name,
FatherName = s.Student.FatherName,
MotherName = s.Student.MotherName,
BirtDate = s.Student.DateOfBirth,
Session = session,
Shift = s.StudentClass.Shift.Name,
Section = s.StudentClass.Section.Name,
GroupName = s.Group.Name,
ClassName = className,
Roll = roll
}).ToList();
foreach (var item in studentInfo)
{
StudentInfoVM vm = new StudentInfoVM();
vm.StudentName = item.StudentName;
vm.FatherName = item.FatherName;
vm.MotherName = item.MotherName;
vm.BirtDate = item.BirtDate;
vm.Session = item.Session;
vm.Shift = item.Shift;
vm.Section = item.Section;
vm.GroupName = item.GroupName;
vm.ClassName = item.ClassName;
vm.Roll = item.Roll;
infoList.Add(vm);
}
#endregion
#region retrieve & bind studentResult
var result = db.ExamMark.Where(x => x.SessionId == sessionId && x.StudentClassId == studentClassId && x.AssignRollId == assignRollId)
.Select(s => new
{
subjectCode = s.Course.Code,
subjectName = s.Course.Name,
Theory = s.Theory,
Mcq = s.Mcq,
Practical = s.Practical,
Total = s.Total,
Grade = s.Grade,
}).ToList();
foreach (var item in result)
{
ResultVM vm = new ResultVM();
vm.SubjectCode = item.subjectCode;
vm.SubjectName = item.subjectName;
vm.Theory = item.Theory;
vm.Mcq = item.Mcq;
vm.Practical = item.Practical;
vm.Total = item.Total;
vm.Grade = item.Grade;
resultList.Add(vm);
}
#endregion
StudentResultVM Sr = new StudentResultVM
{
ResultVM = resultList,
StudentInfoVM = infoList
};
studentResult.Add(Sr);
#region send viewBag
var studentClass = db.StudentClass.Select(c => new
{
Id = c.Id,
Name = c.ClassName.Name + " || " + c.Shift.Name + " ||" + c.Section.Name
}).OrderBy(o => o.Name).ToList();
ViewBag.SessionId = new SelectList(db.Session, "Id", "Name");
ViewBag.StudentClassId = new SelectList(studentClass, "Id", "Name");
ViewBag.AssignRollId = new SelectList(db.AssignRoll, "Id", "Roll");
#endregion
return(View(studentResult));
}
catch (Exception ex)
{
return(null);
}
}
