private Boolean Insert(Database db)
{
BookType booktype = new BookType();
try
{
db.Command.CommandType = CommandType.StoredProcedure;
db.Command.CommandText = "tblBookTypeINSERT";
base.Initialize(db.Command, Guid.Empty);
db.Command.Parameters.Add("@ID", SqlDbType.UniqueIdentifier).Value = _ID;
db.Command.Parameters.Add("@Type", SqlDbType.VarChar).Value = _Type;
db.ExecuteNonQueryWithTransaction();
base.Initialize(db.Command);
return(true);
}
catch (Exception ex)
{
throw;
}
}
public BookTypeList GetAll()
{
_list.Clear();
Database db = new Database("Books");
db.Command.CommandType = System.Data.CommandType.StoredProcedure;
db.Command.CommandText = "tblBookTypeGETALL";
DataTable dt = db.ExecuteQuery();
//dgvStudent.DataSource = dt;
foreach (DataRow dr in dt.Rows)
{
BookType s = new BookType();
s.Initialize(dr);
s.InitializeBusinessData(dr);
s.IsDirty = false;
s.IsNew = false;
s.evtIsSavable += new IsSavableHandler(s_evtIsSavable);
_list.Add(s);
}
return(this);
}
private Boolean Insert(Database db)
{
BookType booktype = new BookType();
try
{
db.Command.CommandType = CommandType.StoredProcedure;
db.Command.CommandText = "tblBookTypeINSERT";
base.Initialize(db.Command, Guid.Empty);
db.Command.Parameters.Add("@ID", SqlDbType.UniqueIdentifier).Value = _ID;
db.Command.Parameters.Add("@Type", SqlDbType.VarChar).Value = _Type;
db.ExecuteNonQueryWithTransaction();
base.Initialize(db.Command);
return true;
}
catch (Exception ex)
{
throw;
}
}