/// <summary> /// @author : TrungMT /// @CreateDate:04/07/2008 /// @Description: Delete 1 AdvProperties with AdvProperties_id /// </summary> /// <param name="pAdvProperties">AdvProperties</param> public int Delete(AdvProperties pAdvProperties) { IDbDataParameter[] parameters = { MakeParameter("@Property_Code", DbType.String, 20), }; parameters[0].Value = pAdvProperties.PropertyCode; int rowAffected = 0; RunProcedure("sp_ADV_Properties_DELETE", parameters, out rowAffected); return rowAffected; }
/// <summary> /// @author : TrungMT /// @CreateDate:04/07/2008 /// @Description: Create new AdvProperties and return AdvProperties id auto increment /// </summary> /// <param name="pAdvProperties">AdvProperties</param> public int Create(AdvProperties pAdvProperties) { IDbDataParameter[] parameters = { MakeParameter("@Property_Code", DbType.String, 20), MakeParameter("@Property_Value", DbType.String, 2000), MakeParameter("@Description", DbType.String, 400), }; parameters[0].Value = pAdvProperties.PropertyCode; parameters[1].Value = pAdvProperties.PropertyValue; parameters[2].Value = pAdvProperties.Desciption; int rowAffected = 0; RunProcedure("sp_ADV_Properties_INSERT", parameters, out rowAffected); return rowAffected; }
/// <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; }