/// <summary> /// @author : TrungMT /// @CreateDate:04/07/2008 /// @Description: retrieve 1 AdvProperties with Properties_Code /// </summary> /// <param name="pstrPropertiesCode">string</param> public DataSet Retrieves(string pstrPropertiesCode) { PrAdvProperties AdvProperties = new PrAdvProperties(Connection); try { Open(); return AdvProperties.Search(pstrPropertiesCode); } catch (Exception exp) { throw exp; } finally { Close(); } }
/// <summary> /// @author : TrungMT /// @CreateDate:04/07/2008 /// @Description: Insert 1 AdvProperties and return AdvProperties_id auto increment /// </summary> public int Add(AdvProperties pAdvProperties) { PrAdvProperties AdvProperties = new PrAdvProperties(Connection); int intAdvPropertiesID = -1; try { Open(); intAdvPropertiesID = AdvProperties.Create(pAdvProperties); Commit(); } catch (Exception exp) { Rollback(); throw exp; } finally { Close(); } return intAdvPropertiesID; }
/// <summary> /// @author : TrungMT /// @CreateDate:04/07/2008 /// @Description: Delete 1 AdvProperties with AdvProperties_id /// </summary> public int Delete(AdvProperties pAdvProperties) { PrAdvProperties AdvProperties = new PrAdvProperties(Connection); int intRowAffected = 0; try { Open(); intRowAffected = AdvProperties.Delete(pAdvProperties); Commit(); } catch (Exception exp) { Rollback(); throw exp; } finally { Close(); } return intRowAffected; }
/// <summary> /// @author : TrungMT /// @CreateDate:04/07/2008 /// @Description: Update 1 AdvProperties with AdvProperties_id /// </summary> public int Update(DataRowCollection prowsAdvProperties) { PrAdvProperties AdvProperties = new PrAdvProperties(Connection); int intRowAffected = 0; try { Open(); AdvProperties properties = new AdvProperties(); foreach (DataRow row in prowsAdvProperties) AdvProperties.Update(row); Commit(); } catch (Exception exp) { Rollback(); throw exp; } finally { Close(); } return intRowAffected; }