public int UpdateEducationSubject(ApplicantEduSubject subject)
{
using (var entities = new atmEntities())
{
var exist = (from a in entities.tblApplicantEduSubjects where a.EduSubjectId == subject.EduSubjectId select a).SingleOrDefault();
if (null != exist)
{
exist.ApplicantEduId = subject.ApplicantEduId;
exist.CreatedBy = subject.CreatedBy;
exist.CreatedDt = subject.CreatedDt;
exist.Grade = subject.Grade;
exist.GradeCd = !string.IsNullOrWhiteSpace(subject.GradeCd) ? subject.GradeCd.Trim() : subject.GradeCd;
exist.SubjectCd = subject.SubjectCd;
exist.LastModifiedBy = subject.LastModifiedBy;
exist.LastModifiedDt = DateTime.Now;
entities.SaveChanges();
return exist.EduSubjectId;
}
}
return 0;
}
public int SaveEducationSubject(ApplicantEduSubject subject)
{
using (var entities = new atmEntities())
{
var exist = (from a in entities.tblApplicantEduSubjects where a.ApplicantEduId == subject.ApplicantEduId && a.SubjectCd == subject.SubjectCd select a).SingleOrDefault();
if (null != exist)
{
subject.EduSubjectId = exist.EduSubjectId;
return UpdateEducationSubject(subject);
}
if (subject.EduSubjectId != 0) { return UpdateEducationSubject(subject); }
var s = new tblApplicantEduSubject
{
ApplicantEduId = subject.ApplicantEduId,
CreatedBy = subject.CreatedBy,
CreatedDt = subject.CreatedDt,
Grade = subject.Grade,
GradeCd = !string.IsNullOrWhiteSpace(subject.GradeCd) ? subject.GradeCd.Trim() : subject.GradeCd,
SubjectCd = subject.SubjectCd,
LastModifiedBy = subject.LastModifiedBy,
LastModifiedDt = subject.LastModifiedDt
};
entities.tblApplicantEduSubjects.Add(s);
if (entities.SaveChanges() > 0)
return s.EduSubjectId;
}
return 0;
}
