Int64 IOTIssueAssignedResourceDataAccess.Add(OTIssueAssignedResourceEntity oTIssueAssignedResourceEntity, DatabaseOperationType option, TransactionRequired reqTran)
        {
            try
            {
                long retValues = -99;

                switch (reqTran)
                {
                case TransactionRequired.No:
                {
                    retValues = Add(oTIssueAssignedResourceEntity, option);
                    break;
                }

                case TransactionRequired.Yes:
                {
                    retValues = AddTran(oTIssueAssignedResourceEntity, option);
                    break;
                }

                default:
                {
                    retValues = -99;
                    break;
                }
                }

                return(retValues);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        private Int64 UpdateTran(OTIssueAssignedResourceEntity oTIssueAssignedResourceEntity, String filterExpression, DatabaseOperationType option)
        {
            long         returnCode = -99;
            const string SP         = "dbo.OTIssueAssignedResource_SET";

            Database db = DatabaseFactory.CreateDatabase();

            using (DbCommand cmd = db.GetStoredProcCommand(SP))
            {
                AddOptionParameter(cmd, option, db);
                AddOutputParameter(cmd, db);
                AddFilterExpressionParameter(cmd, filterExpression, db);

                db.AddInParameter(cmd, "@IssueAssignedResourceID", DbType.Int64, oTIssueAssignedResourceEntity.IssueAssignedResourceID);
                db.AddInParameter(cmd, "@IssueID", DbType.Int64, oTIssueAssignedResourceEntity.IssueID);
                db.AddInParameter(cmd, "@ResourceID", DbType.Int64, oTIssueAssignedResourceEntity.ResourceID);
                db.AddInParameter(cmd, "@StartDate", DbType.DateTime, oTIssueAssignedResourceEntity.StartDate);
                db.AddInParameter(cmd, "@EndDate", DbType.DateTime, oTIssueAssignedResourceEntity.EndDate);
                db.AddInParameter(cmd, "@IssueAssignTypeID", DbType.Int64, oTIssueAssignedResourceEntity.IssueAssignTypeID);
                db.AddInParameter(cmd, "@Remarks", DbType.String, oTIssueAssignedResourceEntity.Remarks);

                DbConnection connection = db.CreateConnection();
                connection.Open();
                DbTransaction transaction = connection.BeginTransaction();

                try
                {
                    using (IDataReader reader = db.ExecuteReader(cmd, transaction))
                    {
                        returnCode = GetReturnCodeFromParameter(cmd);
                    }

                    if (returnCode > 0)
                    {
                        transaction.Commit();
                    }
                    else
                    {
                        throw new ArgumentException("Error Code." + returnCode.ToString());
                    }
                }
                catch (Exception ex)
                {
                    transaction.Rollback();
                    throw ex;
                }
                finally
                {
                    transaction.Dispose();
                    connection.Close();
                    connection = null;
                }
            }

            return(returnCode);
        }
        private Int64 Update(OTIssueAssignedResourceEntity oTIssueAssignedResourceEntity, String filterExpression, DatabaseOperationType option)
        {
            long         returnCode = -99;
            const string SP         = "dbo.OTIssueAssignedResource_SET";

            using (DbCommand cmd = Database.GetStoredProcCommand(SP))
            {
                AddOptionParameter(cmd, option);
                AddOutputParameter(cmd);
                AddFilterExpressionParameter(cmd, filterExpression);

                Database.AddInParameter(cmd, "@IssueAssignedResourceID", DbType.Int64, oTIssueAssignedResourceEntity.IssueAssignedResourceID);
                Database.AddInParameter(cmd, "@IssueID", DbType.Int64, oTIssueAssignedResourceEntity.IssueID);
                Database.AddInParameter(cmd, "@ResourceID", DbType.Int64, oTIssueAssignedResourceEntity.ResourceID);
                Database.AddInParameter(cmd, "@StartDate", DbType.DateTime, oTIssueAssignedResourceEntity.StartDate);
                Database.AddInParameter(cmd, "@EndDate", DbType.DateTime, oTIssueAssignedResourceEntity.EndDate);
                Database.AddInParameter(cmd, "@IssueAssignTypeID", DbType.Int64, oTIssueAssignedResourceEntity.IssueAssignTypeID);
                Database.AddInParameter(cmd, "@Remarks", DbType.String, oTIssueAssignedResourceEntity.Remarks);

                using (IDataReader reader = Database.ExecuteReader(cmd))
                {
                    returnCode = GetReturnCodeFromParameter(cmd);

                    switch (returnCode)
                    {
                    case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
                    {
                        throw new ArgumentException("OTIssueAssignedResourceEntity already exists. Please specify another OTIssueAssignedResourceEntity.");
                    }

                    case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
                    {
                        throw new ArgumentException("OTIssueAssignedResourceEntity data already updated from different session.");
                    }

                    case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
                    {
                        throw new ArgumentException("OTIssueAssignedResourceEntity already exists. Please specify another OTIssueAssignedResourceEntity.");
                    }
                    }
                }
            }

            return(returnCode);
        }
 Int64 IOTIssueAssignedResourceFacade.Delete(OTIssueAssignedResourceEntity oTIssueAssignedResourceEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran)
 {
     return(DataAccessFactory.CreateOTIssueAssignedResourceDataAccess().Delete(oTIssueAssignedResourceEntity, filterExpression, option, reqTran));
 }
 Int64 IOTIssueAssignedResourceFacade.Add(OTIssueAssignedResourceEntity oTIssueAssignedResourceEntity, DatabaseOperationType option, TransactionRequired reqTran)
 {
     return(DataAccessFactory.CreateOTIssueAssignedResourceDataAccess().Add(oTIssueAssignedResourceEntity, option, reqTran));
 }