/// <summary>
/// This function is used to Add and Update student
/// </summary>
/// <param name="studentExtend"></param>
public void SaveStudents(StudentExt studentExtend)
{
using (var context = new dbTIREntities())
{
using (var dbContextTransaction = context.Database.BeginTransaction())
{
try
{
tblStudent newtblStudent = new tblStudent()
{
FirstName = studentExtend.FirstName,
MiddleName = studentExtend.MiddleName,
LastName = studentExtend.LastName,
DistrictId = studentExtend.DistrictId,
StateId = studentExtend.StateId,
LocalId = studentExtend.LocalId,
LineageId = studentExtend.LineageId == -1 ? null : studentExtend.LineageId,
RaceId = studentExtend.RaceId == -1 ? null : studentExtend.RaceId,
GenderId = studentExtend.GenderId,
BirthDate = studentExtend.BirthDate,
HomeLanguageId = studentExtend.HomeLanguageId == -1 ? null : studentExtend.HomeLanguageId,
NativeLanguageId = studentExtend.NativeLanguageId == -1 ? null : studentExtend.NativeLanguageId,
ChangeDatetime = DateTime.Now
};
if (studentExtend.StudentId == 0)
{
context.tblStudents.Add(newtblStudent);
}
else
{
newtblStudent.StudentId = studentExtend.StudentId;
context.tblStudents.Add(newtblStudent);
context.Entry(newtblStudent).State = EntityState.Modified;
}
context.SaveChanges();
tblStudentSchoolYear newtblStudentSchoolYear = new tblStudentSchoolYear()
{
StudentId = newtblStudent.StudentId,
SchoolYearId = studentExtend.SchoolYearId,
ServingSchoolId = studentExtend.ServingSchoolId,
GradeLevel = studentExtend.GradeLevel,
StateId = studentExtend.StateId,
LocalId = studentExtend.LocalId,
LepIndicator = studentExtend.LepIndicator,
IepIndicator = studentExtend.IepIndicator,
FrlIndicator = studentExtend.FrlIndicator,
EnrollmentDate = studentExtend.EnrollmentDate,
ChangeDateTIme = DateTime.Now,
Hispanic = studentExtend.Hispanic
};
if (studentExtend.StudentSchoolYearId == 0)
{
context.tblStudentSchoolYears.Add(newtblStudentSchoolYear);
}
else
{
newtblStudentSchoolYear.StudentSchoolYearId = studentExtend.StudentSchoolYearId;
context.tblStudentSchoolYears.Add(newtblStudentSchoolYear);
context.Entry(newtblStudentSchoolYear).State = EntityState.Modified;
}
context.SaveChanges();
dbContextTransaction.Commit();
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
throw ex;
}
}
}
}
/// <summary>
/// This function is used to Add and Update student
/// </summary>
/// <param name="studentExtend"></param>
public void SaveStudents(StudentExt studentExtend)
{
using (var context = new dbTIREntities())
{
using (var dbContextTransaction = context.Database.BeginTransaction())
{
try
{
tblStudent newtblStudent = new tblStudent()
{
FirstName = studentExtend.FirstName,
MiddleName = studentExtend.MiddleName,
LastName = studentExtend.LastName,
DistrictId = studentExtend.DistrictId,
StateId = studentExtend.StateId,
LocalId = studentExtend.LocalId,
LineageId = studentExtend.LineageId == -1 ? null : studentExtend.LineageId,
RaceId = studentExtend.RaceId == -1 ? null : studentExtend.RaceId,
GenderId = studentExtend.GenderId,
BirthDate = studentExtend.BirthDate,
HomeLanguageId = studentExtend.HomeLanguageId == -1 ? null : studentExtend.HomeLanguageId,
NativeLanguageId = studentExtend.NativeLanguageId == -1 ? null : studentExtend.NativeLanguageId,
ChangeDatetime = DateTime.Now
};
if (studentExtend.StudentId == 0)
{
context.tblStudents.Add(newtblStudent);
}
else
{
newtblStudent.StudentId = studentExtend.StudentId;
context.tblStudents.Add(newtblStudent);
context.Entry(newtblStudent).State = EntityState.Modified;
}
context.SaveChanges();
tblStudentSchoolYear newtblStudentSchoolYear = new tblStudentSchoolYear()
{
StudentId = newtblStudent.StudentId,
SchoolYearId = studentExtend.SchoolYearId,
ServingSchoolId = studentExtend.ServingSchoolId,
GradeLevel = studentExtend.GradeLevel,
StateId = studentExtend.StateId,
LocalId = studentExtend.LocalId,
LepIndicator = studentExtend.LepIndicator,
IepIndicator = studentExtend.IepIndicator,
FrlIndicator = studentExtend.FrlIndicator,
EnrollmentDate = studentExtend.EnrollmentDate,
ChangeDateTIme = DateTime.Now,
Hispanic = studentExtend.Hispanic
};
if (studentExtend.StudentSchoolYearId == 0)
{
context.tblStudentSchoolYears.Add(newtblStudentSchoolYear);
}
else
{
newtblStudentSchoolYear.StudentSchoolYearId = studentExtend.StudentSchoolYearId;
context.tblStudentSchoolYears.Add(newtblStudentSchoolYear);
context.Entry(newtblStudentSchoolYear).State = EntityState.Modified;
}
context.SaveChanges();
dbContextTransaction.Commit();
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
throw ex;
}
}
}
}
