public void UpdateItem(SubjectItem t) { using (IDataContext ctx = DataContext.Instance()) { var rep = ctx.GetRepository <SubjectItem>(); rep.Update(t); } }
//insert on subject public void CreateSubject(SubjectItem t) { using (IDataContext ctx = DataContext.Instance()) { var rep = ctx.GetRepository <SubjectItem>(); rep.Insert(t); } }
public void DeleteItem(SubjectItem t) { using (IDataContext ctx = DataContext.Instance()) { var rep = ctx.GetRepository<SubjectItem>(); rep.Delete(t); } }
//insert on subject public void CreateSubject(SubjectItem t) { using (IDataContext ctx = DataContext.Instance()) { var rep = ctx.GetRepository<SubjectItem>(); rep.Insert(t); } }
public SubjectItem GetSubject(int SubjectId) { SubjectItem subitem = new SubjectItem(); using (IDataContext ctx = DataContext.Instance()) { var rec = ctx.ExecuteQuery <SubjectItem>(CommandType.TableDirect, "select * from SubjectItems where subjectid=" + SubjectId); foreach (var val in rec) { subitem.Subject = val.Subject; subitem.Mother = val.Mother; subitem.Order = val.Order; } } return(subitem); }
public SubjectItem GetSubject(int SubjectId) { SubjectItem subitem = new SubjectItem(); using (IDataContext ctx = DataContext.Instance()) { var rec = ctx.ExecuteQuery<SubjectItem>(CommandType.TableDirect, "select * from SubjectItems where subjectid="+SubjectId); foreach (var val in rec) { subitem.Subject = val.Subject; subitem.Mother = val.Mother; subitem.Order = val.Order ; } } return subitem; }