private Int64 Update(MDSupplierAddressTypeEntity mDSupplierAddressTypeEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.MDSupplierAddressType_SET";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd);
AddFilterExpressionParameter(cmd, filterExpression);
Database.AddInParameter(cmd, "@SupplierAddressTypeID", DbType.Int64, mDSupplierAddressTypeEntity.SupplierAddressTypeID);
Database.AddInParameter(cmd, "@Name", DbType.String, mDSupplierAddressTypeEntity.Name);
Database.AddInParameter(cmd, "@Description", DbType.String, mDSupplierAddressTypeEntity.Description);
Database.AddInParameter(cmd, "@IsRemoved", DbType.Boolean, mDSupplierAddressTypeEntity.IsRemoved);
using (IDataReader reader = Database.ExecuteReader(cmd))
{
returnCode = GetReturnCodeFromParameter(cmd);
switch (returnCode)
{
case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
{
throw new ArgumentException("MDSupplierAddressTypeEntity already exists. Please specify another MDSupplierAddressTypeEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("MDSupplierAddressTypeEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("MDSupplierAddressTypeEntity already exists. Please specify another MDSupplierAddressTypeEntity.");
}
}
}
}
return(returnCode);
}
Int64 IMDSupplierAddressTypeFacade.Delete(MDSupplierAddressTypeEntity mDSupplierAddressTypeEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateMDSupplierAddressTypeDataAccess().Delete(mDSupplierAddressTypeEntity, filterExpression, option, reqTran));
}
Int64 IMDSupplierAddressTypeFacade.Add(MDSupplierAddressTypeEntity mDSupplierAddressTypeEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateMDSupplierAddressTypeDataAccess().Add(mDSupplierAddressTypeEntity, option, reqTran));
}
