public ActionResult Index()
{
StudentMasterViewModel objStudentMasterViewModel = new StudentMasterViewModel();
objStudentMasterViewModel.ListOfExams = (from obj in objStudentDBEntities.Exams
select new SelectListItem()
{
Text = obj.ExamName,
Value = obj.ExamId.ToString()
}).ToList();
objStudentMasterViewModel.ListOfSubjects = (from obj in objStudentDBEntities.Subjects
select new SelectListItem()
{
Text = obj.SubjectName,
Value = obj.SubjectId.ToString()
}).ToList();
return(View(objStudentMasterViewModel));
}
// GET: Home
public ActionResult Index()
{
StudentMasterViewModel objMasterViewModel = new StudentMasterViewModel();
objMasterViewModel.ListOfExams = (from obj in objStudentDBEntities.Exams
select new SelectListItem()
{
Text = obj.ExamName,
Value = obj.ExamId.ToString()
}).ToList();
objMasterViewModel.ListOfSubject = (from obj in objStudentDBEntities.Subjects
select new SelectListItem()
{
Text = obj.SubjectName,
Value = obj.SubjectId.ToString()
}).ToList();
List <StudentModel> listOfStudentModel = (
from objStu in objStudentDBEntities.StudentMasters
join
objExam in objStudentDBEntities.Exams on objStu.ExamId equals objExam.ExamId
select new StudentModel()
{
ClassName = objStu.ClassName,
RollNumber = objStu.RollNumber,
StudentId = objStu.StudentId,
StudentName = objStu.Name,
ExamName = objExam.ExamName
}).ToList();
objMasterViewModel.ListOfStudentModels = listOfStudentModel;
return(View(objMasterViewModel));
}
public StudentMasterViewModel AddAndUpdateStudentMaster(StudentMasterViewModel vmModel)
{
try
{
if (vmModel.ID > 0)
{
var record = _db.StudentMasters.OrderByDescending(x => x.ID).Where(x => x.ID == vmModel.ID).FirstOrDefault();
record.Name = vmModel.Name;
record.FatherName = vmModel.FatherName;
record.Address = vmModel.Address;
record.PhoneNo = vmModel.PhoneNo;
record.Email = vmModel.Email;
record.DOB = vmModel.DOB;
record.Gender = vmModel.Gender;
_db.SaveChanges();
}
else
{
StudentMaster _StudentMaster = new StudentMaster();
_StudentMaster.Name = vmModel.Name;
_StudentMaster.FatherName = vmModel.FatherName;
_StudentMaster.Address = vmModel.Address;
_StudentMaster.PhoneNo = vmModel.PhoneNo;
_StudentMaster.Email = vmModel.Email;
_StudentMaster.DOB = vmModel.DOB;
_StudentMaster.Gender = vmModel.Gender;
_db.StudentMasters.Add(_StudentMaster);
_db.SaveChanges();
vmModel.ID = _StudentMaster.ID;
}
}
catch (Exception ex)
{
}
return(vmModel);
}
protected void Submit_Click(object sender, EventArgs e)
{
StudentMasterViewModel vmModel = new StudentMasterViewModel();
vmModel.Name = Name.Text;
vmModel.FatherName = FatherName.Text;
vmModel.Address = Address.InnerText;
vmModel.PhoneNo = PhoneNumber.Text;
vmModel.Email = Email.Text;
vmModel.DOB = Convert.ToDateTime(DOB.Text);
vmModel.Gender = GenderList.Text;
if (HiddenField1.Value != "")
{
vmModel.ID = Convert.ToInt32(HiddenField1.Value);
}
vmModel = iStudentMasterService.AddAndUpdateStudentMaster(vmModel);
if (vmModel.ID > 0)
{
Response.Write("<script>alert('Record saved successfully')</script>");
Response.Redirect("Student.aspx");
}
bindGrid();
}
