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