public bool Compare(T_CourseAndSubject value) { using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString)) { return(dc.T_CourseAndSubjects.Where(x => x.CourseCode == value.CourseCode && x.CourseDescription == value.CourseDescription && x.Description == value.Description && x.SubjectCode == value.SubjectCode && x.Unit == value.Unit).FirstOrDefault() == null ? true : false); } }
public void Save(T_CourseAndSubject value) { T_CourseAndSubject valueupdate = new T_CourseAndSubject(); using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString)) { dc.T_CourseAndSubjects.InsertOnSubmit(value); dc.SubmitChanges(); } }
public void Delete(T_CourseAndSubject value) { //T_CourseAndSubject valuedelete = new T_CourseAndSubject(); using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString)) { var valuedelete = dc.T_CourseAndSubjects.Where(x => x.CourseCode == value.CourseCode && x.CourseDescription == value.CourseDescription).ToList(); dc.T_CourseAndSubjects.DeleteAllOnSubmit(valuedelete); dc.SubmitChanges(); } }