public override void Delete(BaseEntity entity)
{
Person u = entity as Person;
GroupUserDB gudb = new GroupUserDB();
GroupUserList gul = new GroupUserList();
gul = gudb.SelectByPerson(u);
foreach (GroupUser g in gul)
{
gudb.Delete(g);
}
CommentsDB cdb = new CommentsDB();
CommentsList lc = cdb.CommentsByPerson(u);
foreach (Comments c in lc)
{
cdb.Delete(c);
}
MsgsDB mdb = new MsgsDB();
MsgsList ml = new MsgsList();
ml = mdb.MsgsBySender(u);
foreach (Msgs m in ml)
{
mdb.Delete(m);
}
base.Delete(entity);
}
public MsgsList SelectAll()
{
ml = new MsgsList();
cmd.CommandText = "SELECT * From Msgs";
ml = new MsgsList(base.Select());
return(ml);
}
public MsgsList MsgsBySender(Person p)
{
ml = new MsgsList();
cmd.Parameters.Clear();
cmd.CommandText = "SELECT * From Msgs WHERE Sender =@p";
cmd.Parameters.Add(new OleDbParameter("@p", p.ID));
ml = new MsgsList(base.Select());
return(ml);
//if (lcomments == null)
//{
// CommentsDB db = new CommentsDB();
// lcomments = db.SelectAll();
//}
//CommentsList com = new CommentsList(lcomments.FindAll(c => c.Creator == p));
}
public Msgs SelectByID(int id)
{
ml = new MsgsList();
cmd.Parameters.Clear();
cmd.CommandText = "SELECT * From Msgs WHERE ID =@id";
cmd.Parameters.Add(new OleDbParameter("@id", id));
ml = new MsgsList(base.Select());
if (ml.Count == 1)
{
return(ml[0]);
}
else
{
return(null);
}
}
