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;
}