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