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); }
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); }
public static DataTable Search(NotificationSubscriberXEventTypeDataModel data, RequestProfile requestProfile) { var list = GetEntityList(data, requestProfile, 0); var table = list.ToDataTable(); return(table); }
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); }
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); } }
public static void Update(NotificationSubscriberXEventTypeDataModel data, RequestProfile requestProfile) { var sql = Save(data, requestProfile, "Update"); Framework.Components.DataAccess.DBDML.RunSQL("NotificationSubscriberXEventType.Update", sql, DataStoreKey); }
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); }
public static NotificationSubscriberXEventTypeDataModel GetDetails(NotificationSubscriberXEventTypeDataModel data, RequestProfile requestProfile) { var list = GetEntityList(data, requestProfile, 1); return(list.FirstOrDefault()); }