// To Add The User Personal Information into Student Table
public int AddStudentPersonalInfo(StudentModel model, string UserName)
{
using (var context = new HallAutomationSystemEntities())
{
int RoomId = GetRoomId(model.RoomNumber);
if (RoomId == 0) /// If Room Number is not valid
{
return(0);
}
RoomInformation roomInformation = new RoomInformation();
roomInformation.UpdateRoom(RoomId, -1);
Student student = new Student()
{
StudentName = model.StudentName,
FatherName = model.FatherName,
MotherName = model.MotherName,
MobileNumber = model.MobileNumber,
RoomId = RoomId,
UserId = GetUserId(UserName)
};
context.Student.Add(student);
context.SaveChanges();
AccountInformation accountInformation = new AccountInformation();
accountInformation.AddAccount(UserName, student.StudentId);
return(student.StudentId);
}
}
// Student data update from UpdateController
public bool UpdateStudent(StudentUpdateModel model)
{
using (var context = new HallAutomationSystemEntities())
{
var student = context.Student.FirstOrDefault(x => x.StudentId == model.StudentId);
RoomInformation roomInformation = new RoomInformation();
roomInformation.UpdateRoom((int)student.RoomId, 1);
if (student != null)
{
student.StudentName = model.StudentName;
student.FatherName = model.FatherName;
student.MotherName = model.MotherName;
student.MobileNumber = model.MobileNumber;
student.RoomId = (int)GetRoomId(model.RoomNumber);
}
roomInformation.UpdateRoom((int)student.RoomId, -1);
context.SaveChanges();
return(true);
}
}