Esempio n. 1
0
        public static List <NotificationSubscriberXEventTypeDataModel> GetEntityList(NotificationSubscriberXEventTypeDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails)
        {
            const string sql = @"dbo.NotificationSubscriberXEventTypeSearch ";

            var parameters =
                new
            {
                AuditId = requestProfile.AuditId
                , NotificationSubscriberXEventTypeId = dataQuery.NotificationSubscriberXEventTypeId
                , ReturnAuditInfo          = returnAuditInfo
                , ApplicationId            = dataQuery.ApplicationId
                , NotificationSubscriberId = dataQuery.NotificationSubscriberId
                , NotificationEventTypeId  = dataQuery.NotificationEventTypeId
                , CreatedDateId            = dataQuery.CreatedDateId
                , CreatedTimeId            = dataQuery.CreatedTimeId
                , ApplicationMode          = requestProfile.ApplicationModeId
            };

            List <NotificationSubscriberXEventTypeDataModel> result;

            using (var dataAccess = new DataAccessBase(DataStoreKey))
            {
                result = dataAccess.Connection.Query <NotificationSubscriberXEventTypeDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList();
            }

            return(result);
        }
Esempio n. 2
0
        private static string Save(NotificationSubscriberXEventTypeDataModel data, RequestProfile requestProfile, string action)
        {
            var sql = "EXEC ";

            switch (action)
            {
            case "Create":
                sql += "dbo.NotificationSubscriberXEventTypeInsert  " +
                       " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
                       ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId);
                break;

            case "Update":
                sql += "dbo.NotificationSubscriberXEventTypeUpdate  " +
                       " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
                       ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId);
                break;

            default:
                break;
            }

            sql = sql + ", " + ToSQLParameter(data, NotificationSubscriberXEventTypeDataModel.DataColumns.NotificationSubscriberXEventTypeId) +
                  ", " + ToSQLParameter(data, NotificationSubscriberXEventTypeDataModel.DataColumns.NotificationSubscriberId) +
                  ", " + ToSQLParameter(data, NotificationSubscriberXEventTypeDataModel.DataColumns.NotificationEventTypeId);

            return(sql);
        }
Esempio n. 3
0
        public static DataTable Search(NotificationSubscriberXEventTypeDataModel data, RequestProfile requestProfile)
        {
            var list = GetEntityList(data, requestProfile, 0);

            var table = list.ToDataTable();

            return(table);
        }
Esempio n. 4
0
        public static DataTable DoesExist(NotificationSubscriberXEventTypeDataModel data, RequestProfile requestProfile)
        {
            var sql = "EXEC dbo.NotificationSubscriberXEventTypeSearch " +
                      " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
                      ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
                      ", " + ToSQLParameter(data, NotificationSubscriberXEventTypeDataModel.DataColumns.NotificationSubscriberXEventTypeId);


            var oDT = new Framework.Components.DataAccess.DBDataTable("NotificationSubscriberXEventType.DoesExist", sql, DataStoreKey);

            return(oDT.DBTable);
        }
Esempio n. 5
0
        public static void Delete(NotificationSubscriberXEventTypeDataModel dataQuery, RequestProfile requestProfile)
        {
            const string sql = @"dbo.NotificationSubscriberXEventTypeDelete ";

            var parameters =
                new
            {
                AuditId = requestProfile.AuditId
                , NotificationSubscriberXEventTypeId = dataQuery.NotificationSubscriberXEventTypeId
                , NotificationSubscriberId           = dataQuery.NotificationSubscriberId
                , NotificationEventTypeID            = dataQuery.NotificationEventTypeId
            };

            using (var dataAccess = new DataAccessBase(DataStoreKey))
            {
                dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure);
            }
        }
Esempio n. 6
0
        public static void Update(NotificationSubscriberXEventTypeDataModel data, RequestProfile requestProfile)
        {
            var sql = Save(data, requestProfile, "Update");

            Framework.Components.DataAccess.DBDML.RunSQL("NotificationSubscriberXEventType.Update", sql, DataStoreKey);
        }
Esempio n. 7
0
        public static string ToSQLParameter(NotificationSubscriberXEventTypeDataModel data, string dataColumnName)
        {
            var returnValue = "NULL";

            switch (dataColumnName)
            {
            case NotificationSubscriberXEventTypeDataModel.DataColumns.NotificationSubscriberXEventTypeId:
                if (data.NotificationSubscriberXEventTypeId != null)
                {
                    returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, NotificationSubscriberXEventTypeDataModel.DataColumns.NotificationSubscriberXEventTypeId, data.NotificationSubscriberXEventTypeId);
                }
                else
                {
                    returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, NotificationSubscriberXEventTypeDataModel.DataColumns.NotificationSubscriberXEventTypeId);
                }
                break;

            case NotificationSubscriberXEventTypeDataModel.DataColumns.NotificationSubscriberId:
                if (data.NotificationSubscriberId != null)
                {
                    returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, NotificationSubscriberXEventTypeDataModel.DataColumns.NotificationSubscriberId, data.NotificationSubscriberId);
                }
                else
                {
                    returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, NotificationSubscriberXEventTypeDataModel.DataColumns.NotificationSubscriberId);
                }
                break;

            case NotificationSubscriberXEventTypeDataModel.DataColumns.NotificationEventTypeId:
                if (data.NotificationEventTypeId != null)
                {
                    returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, NotificationSubscriberXEventTypeDataModel.DataColumns.NotificationEventTypeId, data.NotificationEventTypeId);
                }
                else
                {
                    returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, NotificationSubscriberXEventTypeDataModel.DataColumns.NotificationEventTypeId);
                }
                break;

            case NotificationSubscriberXEventTypeDataModel.DataColumns.CreatedTimeId:
                if (data.CreatedTimeId != null)
                {
                    returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, NotificationSubscriberXEventTypeDataModel.DataColumns.CreatedTimeId, data.CreatedTimeId);
                }
                else
                {
                    returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, NotificationSubscriberXEventTypeDataModel.DataColumns.CreatedTimeId);
                }
                break;

            case NotificationSubscriberXEventTypeDataModel.DataColumns.NotificationSubscriber:
                if (!string.IsNullOrEmpty(data.NotificationSubscriber))
                {
                    returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, NotificationSubscriberXEventTypeDataModel.DataColumns.NotificationSubscriber, data.NotificationSubscriber);
                }
                else
                {
                    returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, NotificationSubscriberXEventTypeDataModel.DataColumns.NotificationSubscriber);
                }
                break;

            case NotificationSubscriberXEventTypeDataModel.DataColumns.NotificationEventType:
                if (!string.IsNullOrEmpty(data.NotificationEventType))
                {
                    returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, NotificationSubscriberXEventTypeDataModel.DataColumns.NotificationEventType, data.NotificationEventType);
                }
                else
                {
                    returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, NotificationSubscriberXEventTypeDataModel.DataColumns.NotificationEventType);
                }
                break;
            }

            return(returnValue);
        }
Esempio n. 8
0
        public static NotificationSubscriberXEventTypeDataModel GetDetails(NotificationSubscriberXEventTypeDataModel data, RequestProfile requestProfile)
        {
            var list = GetEntityList(data, requestProfile, 1);

            return(list.FirstOrDefault());
        }