private Int64 Add(MDApprovalRuleEntity mDApprovalRuleEntity, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.MDApprovalRule_SET";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd);
AddNullPrimaryKeyParameter(cmd, "ApprovalRuleID");
Database.AddInParameter(cmd, "@ApprovalRuleName", DbType.String, mDApprovalRuleEntity.ApprovalRuleName);
Database.AddInParameter(cmd, "@Description", DbType.String, mDApprovalRuleEntity.Description);
Database.AddInParameter(cmd, "@IsRemoved", DbType.Boolean, mDApprovalRuleEntity.IsRemoved);
using (IDataReader reader = Database.ExecuteReader(cmd))
{
returnCode = GetReturnCodeFromParameter(cmd);
switch (returnCode)
{
case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
{
throw new ArgumentException("MDApprovalRuleEntity already exists. Please specify another MDApprovalRuleEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("MDApprovalRuleEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("MDApprovalRuleEntity already exists. Please specify another MDApprovalRuleEntity.");
}
}
}
}
return(returnCode);
}
private Int64 Delete(MDApprovalRuleEntity mDApprovalRuleEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.MDApprovalRule_SET";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd);
AddFilterExpressionParameter(cmd, filterExpression);
using (IDataReader reader = Database.ExecuteReader(cmd))
{
returnCode = GetReturnCodeFromParameter(cmd);
switch (returnCode)
{
case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
{
throw new ArgumentException("MDApprovalRuleEntity already exists. Please specify another MDApprovalRuleEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("MDApprovalRuleEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("MDApprovalRuleEntity already exists. Please specify another MDApprovalRuleEntity.");
}
}
}
}
return(returnCode);
}
protected void btnAddNew_Click(object sender, EventArgs e)
{
_ApprovalRuleID = 0;
_MDApprovalRuleEntity = new MDApprovalRuleEntity();
PrepareInitialView();
}
Int64 IMDApprovalRuleFacade.Delete(MDApprovalRuleEntity mDApprovalRuleEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateMDApprovalRuleDataAccess().Delete(mDApprovalRuleEntity, filterExpression, option, reqTran));
}
Int64 IMDApprovalRuleFacade.Add(MDApprovalRuleEntity mDApprovalRuleEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateMDApprovalRuleDataAccess().Add(mDApprovalRuleEntity, option, reqTran));
}
