Csharp: bind data with the Enterprise Library object, csharpenterprise

Csharp: bind data with the Enterprise Library object, csharpenterprise
 

Enterprise Library: https://msdn.microsoft.com/en-us/library/ff648951.aspx

/// <Summary> /// whether the record exists /// </summary> /// <param name = "ReportID"> </param> /// <returns> </returns> public bool Exists (string ReportID) {Database db = DatabaseFactory. createDatabase (); StringBuilder strSql = new StringBuilder (); strSql. append ("select count (1) from BookPlaceList where BookPlaceID = @ BookPlaceID"); DbCommand dbCommand = db. getSqlStringCommand (strSql. toString (); db. addInParameter (db Command, "BookPlaceID", DbType. ansiString, ReportID); int cmdresult; object obj = db. executeScalar (dbCommand); if (Object. equals (obj, null) | (Object. equals (obj, System. DBNull. value) {cmdresult = 0;} else {cmdresult = int. parse (obj. toString ();} if (cmdresult = 0) {return false;} else {return true ;}} /// <summary> /// Add a data entry // </summary> /// <param name = "model"> </param> public int Add (BookPlaceListInfo model) {int I = 0; StringBuilder strSql = new StringBuilder (); strSql. append ("insert into BookPlaceList ("); strSql. append ("BookPlaceName, BookPlaceCode, BookPlaceParent)"); strSql. append ("values ("); strSql. append ("@ BookPlaceName, @ BookPlaceCode, @ BookPlaceParent)"); Database db = DatabaseFactory. createDatabase (); DbCommand dbCommand = db. getSqlStringCommand (strSql. toString ()); Db. addInParameter (dbCommand, "BookPlaceName", DbType. string, model. bookPlaceName); db. addInParameter (dbCommand, "BookPlaceCode", DbType. string, model. bookPlaceCode); db. addInParameter (dbCommand, "BookPlaceParent", DbType. int32, model. bookPlaceParent); I = db. executeNonQuery (dbCommand); return I ;} /// <summary> /// update a data record /// </summary> /// <param name = "model"> </param> /// <returns> </returns> public Int Update (BookPlaceListInfo model) {int I = 0; StringBuilder strSql = new StringBuilder (); strSql. append ("update BookPlaceList set"); strSql. append ("BookPlaceName = @ BookPlaceName,"); strSql. append ("BookPlaceCode = @ BookPlaceCode,"); strSql. append ("BookPlaceParent = @ BookPlaceParent,"); strSql. append ("where BookPlaceID = @ BookPlaceID"); Database db = DatabaseFactory. createDatabase (); DbCommand dbCom Mand = db. getSqlStringCommand (strSql. toString (); db. addInParameter (dbCommand, "BookPlaceID", DbType. int32, model. bookPlaceID); db. addInParameter (dbCommand, "BookPlaceName", DbType. string, model. bookPlaceName); db. addInParameter (dbCommand, "BookPlaceCode", DbType. string, model. bookPlaceCode); db. addInParameter (dbCommand, "BookPlaceParent", DbType. int32, model. bookPlaceParent); I = db. executeNonQuer Y (dbCommand); return I ;} /// <summary> ///// </summary> /// <param name = "ReportID"> </param> /// <returns> </returns> public int Delete (string ReportID) {int I = 0; StringBuilder strSql = new StringBuilder (); strSql. append ("delete BookPlaceList"); strSql. append ("where bookPlaceID = @ bookPlaceID"); Database db = DatabaseFactory. createDatabase (); DbCommand dbCommand = db. getSqlStringCommand (strSq L. toString (); db. addInParameter (dbCommand, "bookPlaceID", DbType. ansiString, ReportID); I = db. executeNonQuery (dbCommand); return I ;} /// <summary> /// obtain the data list /// </summary> /// <param name = "strWhere"> </param> /// <returns> </returns> public DataSet GetList (string strWhere) {StringBuilder strSql = new StringBuilder (); strSql. append ("select *"); strSql. append ("FROM BookPlaceList"); if (strWhere. Trim ()! = "") {StrSql. append ("where" + strWhere);} Database db = DatabaseFactory. createDatabase (); return db. executeDataSet (CommandType. text, strSql. toString ();} // <summary> // obtain the data list (more efficient than DataSet, recommended) // using Microsoft. practices. enterpriseLibrary. data; // using Microsoft. practices. enterpriseLibrary. data. SQL; // </summary> /// <param name = "strWhere"> </param> /// <returns> </returns> public List <BookPlaceListInfo> GetListArray (string strWhere) {StringBuilder strSql = new StringBuilder (); strSql. append ("select *"); strSql. append ("FROM BookPlaceList"); if (strWhere. trim ()! = "") {StrSql. append ("where" + strWhere);} List <BookPlaceListInfo> list = new List <BookPlaceListInfo> (); Database db = DatabaseFactory. createDatabase (); using (IDataReader dataReader = db. executeReader (CommandType. text, strSql. toString () {while (dataReader. read () {list. add (ReaderBind (dataReader) ;}} return list ;}/// <summary> /// get an object entity /// </summary> public BookPlaceListInfo GetMode L (string bookPlaceID) {StringBuilder strSql = new StringBuilder (); strSql. append ("select * from BookPlaceList"); strSql. append ("where bookPlaceID = @ bookPlaceID"); Database db = DatabaseFactory. createDatabase (); DbCommand dbCommand = db. getSqlStringCommand (strSql. toString (); db. addInParameter (dbCommand, "bookPlaceID", DbType. ansiString, bookPlaceID); BookPlaceListInfo model = null; using (IData Reader dataReader = db. executeReader (dbCommand) {if (dataReader. read () {model = ReaderBind (dataReader) ;}} return model ;} /// <summary> // bind the object to data /// </summary> /// <param name = "dataReader"> </param> // <returns> </returns> private BookPlaceListInfo ReaderBind (IDataReader dataReader) {BookPlaceListInfo bookPlaceList = new BookPlaceListInfo (); // 1. // object ojb; // ojb = dataReader ["BookPla CeID "]; // if (ojb! = Null & ojb! = DBNull. Value) // {// bookPlaceList. BookPlaceID = (int) ojb; //} // ojb = dataReader ["BookPlaceName"]; // if (ojb! = Null & ojb! = DBNull. Value) // {// bookPlaceList. BookPlaceName = (string) ojb; //} // 2. bookPlaceList. BookPlaceID = (! Object. Equals (dataReader ["BookPlaceID"], null ))? (Int) dataReader ["BookPlaceID"]: 0; bookPlaceList. BookPlaceName = (! Object. Equals (dataReader ["BookPlaceName"], null ))? (String) dataReader ["BookPlaceName"]: ""; bookPlaceList. BookPlaceCode = (! Object. Equals (dataReader ["BookPlaceCode"], null ))? (String) dataReader ["BookPlaceCode"]: ""; bookPlaceList. BookPlaceParent = (! Object. Equals (dataReader ["BookPlaceParent"], null ))? (Int) dataReader ["BookPlaceParent"]: 0; return bookPlaceList ;}

Http://www.codeproject.com/Articles/12035/Updating-a-DataSet-with-Multiple-Tables-using-Ente

// Dbcommandwrapper
// Database myDatabase = DatabaseFactory. CreateDatabase ();
// DBCommandWrapper myCommand = myDatabase. GetStoredProcCommandWrapper ("sp_ConsignedItemsInsert ");