public Book Save(Database db, Guid userID) { _UserID = userID; Boolean result = true; if (base.IsNew == true && IsSavable() == true) { result = Insert(db); UserBook ub = new UserBook(); ub.UserID = userID; _UserBooks = new UserBookList(); _UserBooks.List.Add(ub); } else if (base.Deleted == true) { result = Delete(db); } else if (base.IsNew == false && IsSavable() == true) { result = Update(db); } base.IsDirty = false; base.IsNew = false; if (result == true && _UserBooks != null && _UserBooks.IsSavable() == true) { result = _UserBooks.Save(db, userID, base.ID); } return(this); }
public UserBookList GetByUserID(Guid UserID) { Database db = new Database("Books"); try { db.Command.CommandType = CommandType.StoredProcedure; db.Command.CommandText = "tblUserBookGETBYUSERID"; db.Command.Parameters.Add("@UserID", SqlDbType.UniqueIdentifier).Value = UserID; DataTable dt = db.ExecuteQuery(); //dgvStudent.DataSource = dt; foreach (DataRow dr in dt.Rows) { UserBook s = new UserBook(); s.Initialize(dr); s.InitializeBusinessData(dr); s.IsDirty = false; s.IsNew = false; s.evtIsSavable += new IsSavableHandler(s_evtIsSavable); _list.Add(s); } return(this); } catch (Exception ex) { throw; } }
private Boolean Insert(Database db) { UserBook userbook = new UserBook(); try { db.Command.Parameters.Clear(); db.Command.CommandType = CommandType.StoredProcedure; db.Command.CommandText = "tblUserBookINSERT"; base.Initialize(db.Command, Guid.Empty); db.Command.Parameters.Add("@BookID", SqlDbType.UniqueIdentifier).Value = _BookID; db.Command.Parameters.Add("@UserID", SqlDbType.UniqueIdentifier).Value = _UserID; db.ExecuteNonQueryWithTransaction(); base.Initialize(db.Command); return(true); } catch (Exception ex) { throw; } }
public UserBookList GetAll() { _list.Clear(); Database db = new Database("Books"); db.Command.CommandType = System.Data.CommandType.StoredProcedure; db.Command.CommandText = "tblUserBookGETALL"; DataTable dt = db.ExecuteQuery(); //dgvStudent.DataSource = dt; foreach (DataRow dr in dt.Rows) { UserBook s = new UserBook(); s.Initialize(dr); s.InitializeBusinessData(dr); s.IsDirty = false; s.IsNew = false; s.evtIsSavable += new IsSavableHandler(s_evtIsSavable); _list.Add(s); } return(this); }