public void UpdateAssistBookTrainType(AssistBookTrainType obj)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_ASSIST_BOOK_TRAIN_TYPE_U";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_assist_book_id", DbType.Int32, obj.AssistBookID);
db.AddInParameter(dbCommand, "p_traintype_id", DbType.Int32, obj.TrainTypeID);
db.ExecuteNonQuery(dbCommand);
}
public IList <AssistBookTrainType> GetAssistBookTrainTypeByBookID(int bookID)
{
IList <AssistBookTrainType> objList = new List <AssistBookTrainType>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_ASSIST_BOOK_TRAIN_TYPE_G";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_assist_book_id", DbType.Int32, bookID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
AssistBookTrainType obj = CreateModelObject(dataReader);
objList.Add(obj);
}
}
return(objList);
}
public void UpdateAssistBookTrainType(AssistBookTrainType bookTrainType)
{
dal.UpdateAssistBookTrainType(bookTrainType);
}
public void AddAssistBookTrainType(AssistBookTrainType bookTrainType)
{
dal.AddAssistBookTrainType(bookTrainType);
}
