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